collection help

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:

collection help

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

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> collection help

Page: [1]

Message

<< Older Topic Newer Topic >>

collection help - 9/17/2008 12:29:55 PM

yasif

Posts: 8
Score: 0
Joined: 9/15/2008
Status: offline

I am trying to get a collection of just the systems that have the SCCM client installed.
Could someone help me with that? I have tried several of the SMS values, but I keep getting all systems returned.

Thanks!!

Post #: 1

RE: collection help - 9/17/2008 1:12:47 PM

yasif

Posts: 8
Score: 0
Joined: 9/15/2008
Status: offline

I got it!!
select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.ADSiteName, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from SMS_R_System where not SMS_R_System.Client = 1

(in reply to yasif)

Post #: 2