Throwing a bone.

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

Leave a Reply

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