SCCM report for hardware specs of all desktops and laptops on the domain
—select * from v_GS_SYSTEM_ENCLOSURE 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(isnull(LDisk.Size0,’0′)) as ‘Hardrive Size’, sum(isnull(LDisk.FreeSpace0,’0′)) AS ‘Free Space’, CPU.MaxClockSpeed0 as ‘Max … Read more