cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nigel_Proctor
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

12 REPLIES 12
Mister_Nobody
Honored Sweeper II
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
Engaged Sweeper
Great, thanks for that just what I needed.
Daniel_B
Lansweeper Alumni
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