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 Top 10 Ticket Types Year To Date
by  LGuth   Go to last post Go to first unread
Last post: 7/10/2019 8:37:48 PM(UTC)
Lansweeper Fonts
by  Spectrum  
Go to last post Go to first unread
Last post: 6/25/2019 11:24:19 AM(UTC)
Action Powershell script for WOL on VLAN
by  psmail   Go to last post Go to first unread
Last post: 5/30/2019 12:00:43 AM(UTC)
Action Schedule Reboot using AT and psshutdown with time input
by  spatchE  
Go to last post Go to first unread
Last post: 5/21/2019 5:35:46 PM(UTC)
Action Open users local Temp directory
by  studerje   Go to last post Go to first unread
Last post: 5/14/2019 7:24:24 PM(UTC)
Lansweeper CMD- CFI MS Update remover 2
by  Rodney Stowell   Go to last post Go to first unread
Last post: 4/18/2019 6:55:01 PM(UTC)
Action Skype User
by  cctech  
Go to last post Go to first unread
Last post: 4/18/2019 4:14:54 PM(UTC)