→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MSITGW
Engaged Sweeper
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!
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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%'

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
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%'