HDD vs SSD PowerShell Script Deployment

Posted: Friday, February 25, 2022 3:45:40 PM(UTC)

Esben.D

Member Administration Original PosterPosts: 2,186

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:

Code:

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

Script - Storage TypeDownload Package
Description	Discover the type of storage drives on your Windows assets by storing the data in a regsitry key. Assets are rescanned after deployment. Visit the blog post to learn more about this use case: https://www.lansweeper.com/pro-tips/hdd-or-ssd/
Final Action	Nothing
Max. Duration	15 min(s), 0 hour(s)
Rescan	Yes

Steps

1. Run Powershell Script

Type	Command
Return Codes	0,1641,3010
Success	Stop (Success)
Failure	Stop (Failure)
Command	powershell.exe -executionpolicy bypass -file "{PackageShare}\Scripts\disktype.ps1"