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’

Leave a Reply

Your email address will not be published. Required fields are marked *