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