SCCM Query for a Collection of Windows Servers

This query will give you a collection of all Windows Server 2008 servers in your SCCM database.

select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, 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.NetbiosName from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like “%Server 6.0%”

Just substitute %Server6.0% in the .OperatingSystemNameandVersion for other versions.  6.1 is R2, etc.

Share
This entry was posted in SCCM 2007, SCCM 2012, Server 2008. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Comments are closed, but you can leave a trackback.