SELECT distinct SYS.resourceid,sys.Netbios_Name0,SYS.User_Domain0, SYS.User_Name0, IP.IP_Addresses0,ASSG.SMS_Installed_Sites0,OS.Caption0,OS.CSDVersion0, PR.Model0,pr.manufacturer0,bi.name0,bi.serialnumber0,me.totalphysicalmemory0,Ne.name0,na.dhcpServer0,disk.model0,disk.Interfacetype0,disk.size0,mo.monitortype0 FROM v_R_System as SYS JOIN v_RA_System_SMSInstalledSites as ASSG on SYS.ResourceID=ASSG.ResourceID JOIN v_RA_System_IPAddresses as IP on SYS.ResourceID=IP.ResourceID JOIN v_gs_operating_system...