Notification

Icon
Error

PowerShell Version Report

Posted: Friday, December 28, 2018 10:38:21 PM(UTC)
keys_it

keys_it

Member Original PosterPosts: 30
0
Like
The following report will allow you to get a list of computer/servers and their current highest version of PowerShell that is installed. The first step before running this report is to setup the following Registry keys for scanning under Scanning > File and Registry Scanning.

keys

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\PowerShellEngine\PowerShellVersion
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\3\PowerShellEngine\PowerShellVersion

Once these are added you can rescan all Windows assets.

Then you can add the following report:

Code:
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
  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

Active Discussions

Lansweeper Trigger deploy when seen
by  bbazian   Go to last post Go to first unread
Last post: Today at 10:31:44 AM(UTC)
Lansweeper More customizable interface
by  Christophe Rahier  
Go to last post Go to first unread
Last post: Today at 9:09:33 AM(UTC)
Lansweeper Update DNS record
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:42:51 AM(UTC)
Lansweeper TeamViewer Custom Action
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:39:48 AM(UTC)
Lansweeper Deployment Java
by  mlachance   Go to last post Go to first unread
Last post: Yesterday at 4:46:38 PM(UTC)
Lansweeper Custom OID Scanning Range
by  tcooper  
Go to last post Go to first unread
Last post: Yesterday at 4:32:59 PM(UTC)
Lansweeper Approved Software
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 4:07:58 PM(UTC)
Lansweeper Scanning targets - ignore assets with LSagent
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 4:01:44 PM(UTC)