cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
InfraTeam
Engaged Sweeper II
Hello,

Is there a way to use LanSweeper to give what latest version of PowerShell Engine is running on the system? I could have used Registry, but by default servers have v1 and if upgraded will have v3 (for v3/4/5) subkeys within registry. I am looking for devices that have X version of PowerShell. Need to plan PowerShell upgrade internally.

Thanks,

Arun Kumar
3 REPLIES 3
keys_it
Engaged Sweeper III
InfraTeam wrote:
Hello,

Is there a way to use LanSweeper to give what latest version of PowerShell Engine is running on the system? I could have used Registry, but by default servers have v1 and if upgraded will have v3 (for v3/4/5) subkeys within registry. I am looking for devices that have X version of PowerShell. Need to plan PowerShell upgrade internally.

Thanks,

Arun Kumar


In addition to the two registry keys mentioned by YvainP, we noticed that even though a later version of PowerShell was installed, it always had a duplicate value with PowerShell 2.0

We created a report to show the highest version installed.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
Max(tblRegistry.Value) As PowerShellVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblRegistry.Valuename = 'PowerShellVersion' And tblState.Statename = 'Active'
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10),
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname,
tblAssets.SP
Order By tsysIPLocations.IPLocation,
tblAssets.AssetName
YvainP
Engaged Sweeper II
Hi,

You should add theses two registry keys in your custom scanned element.

siversontiger
Engaged Sweeper
Looking for this info as well. Would like to poll our asset's for what Powershell version they're currently running.