How can I see which computers have a SSD drive?

Products

• IT Management Suite
• IT Management Suite
• Client Management Suite

Issue/Introduction

 Is there a way to identify computers that have a SSD drive?

Environment

ITMS 8.x

Resolution

Windows does not allow a reliable way to collect information about a SSD disks. However we can identify the SSDs from the Inv_HW_Logical_Device data class. You can copy the following query to create your own report:

SELECT   v.[Name] AS [Computer Name],
        cs.[Model] AS [Computer Model],
       hwl.[Model],
        ld.[Device ID] as Drive,
      CAST((ISNULL(ld.[Size (Bytes)], 0)/(1024 * 1024 * 1024)) AS DECIMAL (10, 2)) AS 'Total Disk Space (GB)',
      CAST((ISNULL(ld.[Free Space (Bytes)], 0)/(1024 * 1024 * 1024)) AS DECIMAL (10, 2)) AS 'Free Disk Space (GB)'
  FROM vrm_Computer_item v 
 INNER JOIN Inv_HW_Logical_Device hwl 
    ON v.Guid = hwl._ResourceGuid 
 INNER JOIN vHWComputerSystem cs
    ON cs._ResourceGuid = v.Guid
 INNER JOIN Inv_HW_Logical_Disk ld
    ON ld._ResourceGuid = v.Guid
 WHERE hwl.Model like '%SSD%'