System Center отчет по оборудованию

SELECT DISTINCT
NA.DNSHostName0 as 'Computer Name',
CS.domain0 as 'Domain',
NA.MACAddress0 as 'MAC Address',
NA.IPAddress0 as 'IP Address',
CS.UserName0 as 'User',
SE.SerialNumber0 as 'System Enclosure serial',
CS.Manufacturer0 as 'Manufacturer',
CS.Model0 as 'Model',
OS.Caption0 as 'OS',
RAA.SMS_Assigned_Sites0 as 'Site',
v_GS_DESKTOP_MONITOR.Name0 as 'Monitor',
v_GS_VIDEO_CONTROLLER.Name0 as 'Video Card',
v_GS_VIDEO_CONTROLLER.AdapterRAM0 as 'Video Memory Hafızası',
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 CPU Speed',
CPU.Name0 as 'CPU Model'
FROM
v_GS_COMPUTER_SYSTEM CS
RIGHT JOIN
v_GS_PC_BIOS BIOS ON BIOS.ResourceID = CS.ResourceID
RIGHT JOIN
v_GS_SYSTEM SYS ON SYS.ResourceID = CS.ResourceID
LEFT JOIN
v_R_User USR ON USR.Unique_User_Name0 = CS.UserName0
RIGHT JOIN
v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = CS.ResourceID
RIGHT JOIN
v_RA_System_SMSAssignedSites RAA ON RAA.ResourceID = CS.ResourceID
RIGHT JOIN
V_GS_X86_PC_MEMORY RAM ON RAM.ResourceID = CS.ResourceID
RIGHT JOIN
v_GS_Logical_Disk LDisk ON LDisk.ResourceID = CS.ResourceID
RIGHT JOIN
v_GS_Processor CPU ON CPU.ResourceID = CS.ResourceID
FULL JOIN
v_GS_SYSTEM_ENCLOSURE SE ON SE.ResourceID = CS.ResourceID
LEFT JOIN
v_GS_NETWORK_ADAPTER_CONFIGUR NA ON NA.ResourceID = CS.ResourceID
LEFT JOIN
v_GS_DESKTOP_MONITOR ON v_GS_DESKTOP_MONITOR.ResourceID = CS.ResourceID
LEFT JOIN
v_GS_VIDEO_CONTROLLER ON v_GS_VIDEO_CONTROLLER.ResourceID = CS.ResourceID
WHERE
LDisk.DriveType0 = 3 AND NA.DNSHostName0 <> 'Null'
GROUP BY
NA.DNSHostName0, CS.domain0, CS.Username0,
SE.SerialNumber0, CS.Manufacturer0, CS.Model0,
OS.Caption0, RAA.SMS_Assigned_Sites0,
RAM.TotalPhysicalMemory0,
CPU.MaxClockSpeed0, CPU.Name0,
NA.MACAddress0, NA.IPAddress0,
v_GS_DESKTOP_MONITOR.Name0,
v_GS_VIDEO_CONTROLLER.Name0,
v_GS_VIDEO_CONTROLLER.AdapterRAM0
ORDER BY
NA.DNSHostName0

Далее в System Center через дизайнер отчетов создается сам отчет.

 

System Center отчет по разрядности ОС

SCCM 2012 R2

select distinct sys.netbios_name0,
case when pr.addresswidth0 = 64 then '64bit OS'
when pr.addresswidth0=32 then '32bit OS'
end as [Разрядность ОС],
case when pr.addresswidth0=32 and pr.DataWidth0=64 then '*'
end as [32-bit OS на x64 processor]
from v_r_system sys
join v_gs_processor pr on sys.resourceid=pr.resourceid
Order by [Разрядность ОС]

Далее сам отчет через дизайнер отчетов с составлением полей.