PC Info

SELECT  distinct
CS.name0 as ‘Computer Name’,
CS.domain0 as ‘Domain’,
CS.UserName0 as ‘User’,
BIOS.SerialNumber0 as ‘Bios serial’,
SE.SerialNumber0 as ‘System Enclosure serial’,
CS.Manufacturer0 as ‘Manufacturer’,
CS.Model0 as ‘model’,
OS.Caption0 as ‘OS’,
RAA.SMS_Assigned_Sites0 as ‘Site’,
RAM.TotalPhysicalMemory0 as ‘Total Memory’,
Sum(LDisk.Size0) as ‘Hardrive Size’,
Sum(LDisk.FreeSpace0) AS ‘Free Space’,
CPU.CurrentClockSpeed0 as ‘CPU Speed’
from
v_GS_PC_BIOS BIOS,
v_GS_SYSTEM SYS,
v_GS_COMPUTER_SYSTEM CS,
v_GS_OPERATING_SYSTEM OS,
v_RA_System_SMSAssignedSites RAA,
V_GS_X86_PC_MEMORY RAM,
v_GS_Logical_Disk LDisk,
v_GS_Processor CPU,
v_GS_SYSTEM_ENCLOSURE SE
where
BIOS.ResourceID = CS.ResourceID
and OS.ResourceID = CS.ResourceID
AND RAA.ResourceID = CS.ResourceID
and RAM.ResourceID = CS.ResourceID
and LDisk.ResourceID = CS.ResourceID
and CPU.ResourceID = CS.ResourceID
and SE.ResourceID = CS.ResourceID
group by
CS.Name0,
CS.domain0,
CS.Username0,
BIOS.SerialNumber0,
SE.SerialNumber0,
CS.Manufacturer0,
CS.Model0,
OS.Caption0,
RAA.SMS_Assigned_Sites0,
RAM.TotalPhysicalMemory0,
CPU.CurrentClockSpeed0

Leave a Reply

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