Clients not in SMS

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Clients not in SMS

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Clients not in SMS

Page: [1]

Message

<< Older Topic Newer Topic >>

Clients not in SMS - 8/12/2008 5:56:40 AM

chris.darling

Posts: 37
Score: 0
Joined: 2/13/2007
Status: offline

Hi,

I am looking for some help. Every month I run a basic report (export computers/servers from Active Directory and export the machines from a collection in SMS) and basically compare the 2 spreadsheets. For something so basic takes me a long time.

I know I can run a reoprt of client missing SMS but I only want to include certain OU's not all of my AD

Does anyone else run this type of report?

Post #: 1

RE: Clients not in SMS - 8/12/2008 8:50:41 AM

mlucero

Posts: 792
Score: 36
Joined: 4/1/2005
From: Austin, Texas
Status: offline

Add a line to your query:

where SystemOUName like "YOURDOMAIN.COM/OU/OU/OU/%" etc

Or "=" instead of "like" and then give the exact OU name instead of a wildcard.

< Message edited by mlucero -- 8/12/2008 8:51:19 AM >

_____________________________

Mike Lucero
Austin, Texas

My Blog

(in reply to chris.darling)

Post #: 2

RE: Clients not in SMS - 8/13/2008 4:05:03 AM

chris.darling

Posts: 37
Score: 0
Joined: 2/13/2007
Status: offline

Can someone please post the SQL query to list the machines (based on colelction) that do not have the SMS client installed?

thanks

(in reply to chris.darling)

Post #: 3

RE: Clients not in SMS - 8/13/2008 9:15:58 AM

joemonkey

Posts: 202
Score: 2
Joined: 2/28/2007
From: Kentucky
Status: offline

SQL or WQL? here is the WQL if that's what you meant...

select sms_r_system.ResourceID,sms_r_system.ResourceType,sms_r_system.Name,sms_r_system.SMSUniqueIdentifier,sms_r_system.ResourceDomainORWorkgroup,sms_r_system.Client from sms_r_system where Client = 0 or Client is null

(in reply to chris.darling)

Post #: 4