Month: June 2010

Count of PCs by AD site

SELECT     R.AD_Site_Name0,     Count(SMS_Installed_Sites0) AS ‘Count’ From     v_R_System R     JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID WHERE     R.AD_Site_Name0 = ‘Default-First-Site-Name’ Group By     R.AD_Site_Name0

List of PCs by AD site

SELECT     R.Netbios_Name0,     R.User_Name0,     R.Operating_System_Name_and0,     R.AD_Site_Name0,     IP.IP_Addresses0 From     v_R_System R     JOIN v_RA_System_IPAddresses IP ON R.ResourceID = IP.ResourceID     JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID WHERE     R.AD_Site_Name0 = ‘Default-First-Site-Name’