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… Читать далее »