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.

Posted in SCCM 2007, SCCM 2012, Server 2008 | Leave a comment