SSD report

[Nigel_Proctor]

Hi,

Is there anyway to report on machines that have SSD's installed, we want to be able to report on which machines currently have them installed.

Thanks

Nigel

[Mister_Nobody]

I use this filter

Where (tblFloppy.Model Like 'OCZ%') Or
  (tblFloppy.Model Like 'Kingston S%') Or
  (tblFloppy.Model Like '%Solid State%') Or
  (tblFloppy.Model Like '%SSD%') Or
  (tblFloppy.Model Like '%NVMe%')

[Nigel_Proctor]

Great, thanks for that just what I needed.

[Daniel_B · Accepted solution]

You can filter on SSD drives through the drive model. Please find an example report below:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblFloppy.InterfaceType As [HD interface],
  tblFloppy.Manufacturer As [HD manufacturer],
  tblFloppy.Model As [HD model],
  tblFloppy.Name,
  Cast(Cast(tblFloppy.Size As bigint) / 1024 / 1024 / 1024 As numeric)
  As [HD Size (GB)],
  tblFloppy.SerialNumber
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where (tblFloppy.Model Like '%ssd%' Or tblFloppy.Model Like '%solid-state%') And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblFloppy.Name