SSD or HDD Audit

Find SSD or HDD Details from Computers in Your Network

List all drives in your environment and determine whether they are a solid-state drive or a hard disk drive. Lansweeper always scans drive information from Windows computers and with the report below you can determine whether these drives are SSD or HDD. The report looks at the name of the drive to determine whether the drive is an SSD or HDD. Because there are no set naming conventions, you will have to adjust the report to identify drives that do not contain common keyword in their model name. For a more automated way of detecting whether a drive is a HDD or SSD, you can use the SSD or HDD Powershell Audit.

This audit can then be used to find upgrade candidates for SSDs. Since SSDs increase boot and overall load times of all windows components, they are one of the easiest and most cost-effective ways to improve productivity.

SSD or HDD Installed Query

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  Ceiling(tblDiskdrives.Size / 1024 / 1024 / 1024) As [Max size in GB],
  Ceiling(tblDiskdrives.Freespace / 1024 / 1024 / 1024) As [Free Space in GB],
  Case When (tblFloppy.Model Like '%SSD%' Or
    tblFloppy.Model Like '%Solid State%' Or tblFloppy.Model Like '%mSS%' Or
    tblFloppy.Model Like '%mSATA%' Or tblFloppy.Model Like '%KINGSTON SA400%') Then 'Solid State'
    When (tblFloppy.Model Like '%ST500LM000-1EJ16%') Then 'Solid State Hybrid'
    When (tblFloppy.Model Like '%Virtual%') Then 'Virtual Disk'
    When (tblFloppy.Model Like '%DELL PERC%' Or
    tblFloppy.Model Like '%HP LOGICAL%') Then 'RAID/SCSI/SAS'
    When (tblFloppy.Model Like '%ATA Device%') Then 'Standard ATA'
    Else 'Unknown' End As [Harddisk Type],
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where tblDiskdrives.Caption = 'C:' And tblFloppy.Name Like '%PHYSICALDRIVE0' And
  tblAssetCustom.State = 1 And tblDiskdrives.Freespace > 0 And
  tblDiskdrives.Size > 0
Order By tblAssets.AssetName,

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting