‎02-25-2022 03:45 PM - last edited on ‎06-30-2023 03:35 PM by ErikT
As part of the Pro Tips #16 blog post I created a deployment package that deploys a PowerShell script that takes storage type data and stores it into registry keys.
If you want to know more about it, you can visit the blog post. You can download the Powershell Script here (right click, save link as...).
Below you can also find a report that you can use to deploy the script to all devices that do not have the registry keys scanned yet:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select tblAssets.AssetID
From tblAssets Inner Join tblRegistry On tblAssets.AssetID =
tblRegistry.AssetID
Where tblRegistry.Regkey Like '%System\HDD' And
tblRegistry.Valuename = '0') And tsysAssetTypes.AssetTypename =
'windows' And tblAssets.Lastseen IS NOT NULL And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now