Report for SSDs from Samsung

[MSITGW]

Hello,

i want to have a Report about all computers with a hard disk from Samsung.

Unter Computer - Config - Dsik - Diskdrive there is a texfield called "Model"

There I want so search "Samsung%" or "Samsung SSD%"


Thanks for help!

[RCorbeil · Accepted solution]

Based on my inventory, not all Samsung SSDs include "SSD" in the model name, so you're likely best off only filtering for "Samsung" and accepting that you may end up with spinning drives in your results. You can look for other attributes to refine your filter.

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblFloppy.InterfaceType,
  tblFloppy.Model,
  Replace(tblFloppy.Name, '\\.\PHYSICALDRIVE', 'Physical Drive ') As Drive,
  Ceiling(tblFloppy.Size / Power(10, 9)) As [Capacity (GB)],
  Ceiling(tblFloppy.Size / Power(2, 30)) As [Capacity (GiB)]
FROM
  tblAssets
  INNER JOIN tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  INNER JOIN tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
WHERE
  tblAssetCustom.State = 1
  AND tblFloppy.Model Like 'Samsung%'