collection help (Full Version)

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



Message

yasif -> collection help (9/17/2008 12:29:55 PM)

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!!



yasif -> RE: collection help (9/17/2008 1:12:47 PM)

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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.203125