Как сделать запрос отчёта по жёсткому диску ssd в SCCM Microsoft Endpoint Configuration Manager.
Попросили сделать отчёт по компьютерам где установлен ssd диск. Сделал запрос в базу SCCM.
SELECT DISTINCT cs.Model0 AS 'Model', sys.Name0 AS 'Machine Name', sys.User_Name0 AS 'Last Logged on User', sys.User_Domain0 AS 'Domain', sys.AD_Site_Name0 AS 'AD Site', ld.Name0 AS 'Drive Letter', OS.Caption0 AS OS, CS.Manufacturer0 AS Manufacturer, CS.Model0 AS Model, CPU.Name0 AS CPUName, RAM.TotalPhysicalMemory0 as 'Total Memory', CASE when vdisk.Model0 like '%SSD%' then 'Known SSD Drive' when vdisk.Model0 = 'LITEONIT LF-64M1S' or Vdisk.Model0 ='LITEONIT LFT-128M2S' then 'Known SSD Drive' else vdisk.Model0 END as 'SSD Drive?', REPLACE(CONVERT(varchar, cast(ld.Size0 AS money),1), '.00', '') as 'Total Drive Space on C: in MB', REPLACE(CONVERT(varchar, cast((mem.TotalPhysicalMemory0… Читать далее