SELECT DISTINCT v_R_System.Name0 ,v_R_System.AD_Site_Name0 ,v_R_System.User_Name0 ,v_R_System.Last_Logon_Timestamp0 ,v_R_System.Operating_System_Name_and0 ,v_R_System.CPUType0 ,v_RA_System_IPAddresses.IP_Addresses0 ,v_RA_System_MACAddresses.MAC_Addresses0 ,v_GS_COMPUTER_SYSTEM.NumberOfProcessors0 ,v_GS_COMPUTER_SYSTEM.SystemType0 ,v_GS_COMPUTER_SYSTEM.Status0 ,v_GS_COMPUTER_SYSTEM.Manufacturer0 ,v_GS_COMPUTER_SYSTEM.Model0 ,v_GS_SYSTEM_ENCLOSURE.SerialNumber0 ,v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 ,v_GS_LastSoftwareScan.LastScanDate ,v_GS_WORKSTATION_STATUS.LastHWScan ,v_GS_PROCESSOR.NumberOfCores0 ,v_GS_PROCESSOR.NumberOfLogicalProcessors0 FROM v_R_System INNER JOIN v_RA_System_IPAddresses ON v_R_System.ResourceID = v_RA_System_IPAddresses.ResourceID INNER JOIN v_RA_System_MACAddresses ON v_R_System.ResourceID = v_RA_System_MACAddresses.ResourceID INNER JOIN v_GS_COMPUTER_SYSTEM ON v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN v_GS_SYSTEM_ENCLOSURE ON v_R_System.ResourceID = v_GS_SYSTEM_ENCLOSURE.ResourceID INNER JOIN v_GS_X86_PC_MEMORY ON v_R_System.ResourceID = v_GS_X86_PC_MEMORY.ResourceID INNER JOIN v_GS_LastSoftwareScan ON v_R_System.ResourceID = v_GS_LastSoftwareScan.ResourceID INNER JOIN v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID = v_GS_WORKSTATION_STATUS.ResourceID INNER JOIN v_GS_PROCESSOR ON v_R_System.ResourceID = v_GS_PROCESSOR.ResourceID where v_R_System.AD_Site_Name0 = @SiteCode ---------------------------------------------------------------------------------------------------------------------------- SELECT distinct v_R_System.AD_Site_Name0 as SIteCode FROM v_R_System order by SiteCode
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)