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, it is possible you might have to add your specific SSD model to the report.

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

SSD or HDD Installed Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblDiskdrives.Volumename,
  Ceiling(tblDiskdrives.Size / 1024 / 1024 / 1024) As [Max size in GB],
  Ceiling(tblDiskdrives.Freespace / 1024 / 1024 / 1024) As [Free Space in GB],
  tblDiskdrives.FileSystem,
  tblDiskdrives.Description,
  tblDiskdrives.Caption,
  tblDiskdrives.Compressed,
  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],
  tblFloppy.Model,
  tblFloppy.Name,
  tblDiskdrives.DriveType,
  tblFloppy.InterfaceType
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,
  tblDiskdrives.Caption

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting