SSD or HDD installed

[lstejay]

Hi Forum!

I need a report showing if the primary harddisk is a ssd type or a standard hdd.
This is only importent for laptops where we want to install harddisk encryption.
I tried the Report "Asset: Harddrive S.M.A.R.T. Status" but then I have to build
a lookup for the different HD Models manually and have no information if this is
the boot device or if this is an additional hdd.

TIA, Thomas

[mlachance]

I concur with MikeMc. You'll either need to use keyword filters or a third party process. If you want to begin by using filters, you can use this code as a base and build onto it...

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%') 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

All hard drives that don't fall into one of your defined filters will be marked as "unknown". You will then have to identify what type of drive it is, and add to the filter list.

[DavidNe]

the where clause it not really working for all system with more then 1 Harddrive.

tblDiskdrives.Caption = 'C:' And tblFloppy.Name Like '%PHYSICALDRIVE0'

I have device where 'C:' is '%PHYSICALDRIVE1'
currently i search for a solution to match tblDiskdrives with tblFloppy correctly but i don't find a field which match really. 

[MikeMc · Accepted solution]

As far as I know, Lansweeper does not have a built-in method to detect if a HDD is SSD or not. Many of reports provided by the support staff use keyword specific filters like '%SSD%' or '%Solid State%'. Your best bet is to either inventory your known SSDs and filter your reports based off that list or use a third-party solution to get your list: http://www.lansweeper.com/Forum/yaf_postst12853_Solid-State-Disk-Detector.aspx