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 через дизайнер отчетов создается сам отчет.

 

Поделиться ссылкой:

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *

Этот сайт использует Akismet для борьбы со спамом. Узнайте, как обрабатываются ваши данные комментариев.