I am seeing this error when running the script as an admin locally on a workstation.PS C:\itcu> .\Remove_old_java_versions.ps1Cannot index into a null array.At C:\itcu\Remove_old_java_versions.ps1:71 char:35+ $appGUID = $app.Properties[ <<<< "...
I did it like this:Select Top 1000000 Case tblSoftwareUni.Approved When 1 Then 'Approved' When 2 Then 'Denied' Else 'Unclassified' End As Status, COUNT(*) As TotalFrom tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.Ass...