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
