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,
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
