select
distinct
R
.Name0,
SAS
.SMS_Assigned_Sites0,
R
.Operating_System_Name_and0,
R
.User_Name0,
R
.Netbios_Name0,
CS
.Manufacturer0,
CS
.Model0,
BIOS
.SerialNumber0,
CS
.NumberOfProcessors0,
Pro
.Manufacturer0,
Pro
.IsMobile0,
Pro
.IsMulticore0,
Pro
.MaxClockSpeed0,
HD
.Size0,
RAM
.TotalPhysicalMemory0,
CS
.SystemType0
from
v_R_System R
inner join dbo.v_RA_System_SMSAssignedSites SAS on SAS.ResourceID = R.ResourceId inner join dbo.v_GS_DISK HD on HD.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceId inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID = R.ResourceId inner join dbo.v_GS_PROCESSOR Pro on Pro.ResourceID = R.ResourceId inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId
order
by
R
.Name0