powershell sort

kenobi421 · 2020-05-05T10:57:58.000Z

I have used the following script to find out programs on a computer from

Use PowerShell to Quickly Find Installed Software - Scripting Blog [archived]

Summary: Learn how to use Windows PowerShell to quickly find installed software on local and remote computers. Microsoft Scripting Guy Ed Wilson here. Guest Blogger Weekend concludes with Marc Carter. The Scripting Wife and I were lucky enough...

O have used the following code

Does anyone know how to sort the data by DisplayName please? I have tried | sort in various locations but nothing happens or it errors

kenobi421 · 2020-05-05T10:59:10.000Z

Code insert for Powershell not working so here is the code:

Use PowerShell to Quickly Find Installed Software - Scripting Blog [archived]

#$computers = Import-Csv “D:\PowerShell\computerlist.csv”

$computers = ‘Test’

$array = @()

foreach($pc in $computers){

$computername=$pc.computername

#Define the variable to hold the location of Currently Installed Programs

$UninstallKey=”SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall”

#Create an instance of the Registry Object and open the HKLM base key

$reg=[microsoft.win32.registrykey]::OpenRemoteBaseKey(‘LocalMachine’,$computername)

#Drill down into the Uninstall key using the OpenSubKey Method

$regkey=$reg.OpenSubKey($UninstallKey)

#Retrieve an array of string that contain all the subkey names

$subkeys=$regkey.GetSubKeyNames()

#Open each Subkey and use GetValue Method to return the required values for each

foreach($key in $subkeys){

$thisKey=$UninstallKey+”\”+$key

$thisSubKey=$reg.OpenSubKey($thisKey)

$obj = New-Object PSObject

$obj | Add-Member -MemberType NoteProperty -Name “ComputerName” -Value $computername

$obj | Add-Member -MemberType NoteProperty -Name “DisplayName” -Value $($thisSubKey.GetValue(“DisplayName”))

$obj | Add-Member -MemberType NoteProperty -Name “DisplayVersion” -Value $($thisSubKey.GetValue(“DisplayVersion”))

$obj | Add-Member -MemberType NoteProperty -Name “InstallLocation” -Value $($thisSubKey.GetValue(“InstallLocation”))

$obj | Add-Member -MemberType NoteProperty -Name “Publisher” -Value $($thisSubKey.GetValue(“Publisher”))

$array += $obj |sort -descending

}

$array | Where-Object { $_.DisplayName } |Sort-Object | select ComputerName, DisplayName, DisplayVersion, Publisher | ft -auto

Neally · 2020-05-05T13:09:21.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2020-05-05T13:17:31.000Z

Marc.W:

Does anyone know how to sort the data by DisplayName please?

like so?

clear-host

$computers = Import-Csv “D:\PowerShell\computerlist.csv”

$data = 
foreach ($pc in $computers) {
    $computername = $pc.computername
    #Define the variable to hold the location of Currently Installed Programs
    $UninstallKey = ”SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall”
    #Create an instance of the Registry Object and open the HKLM base key
    $reg = [microsoft.win32.registrykey]::OpenRemoteBaseKey(‘LocalMachine’, $computername)
    #Drill down into the Uninstall key using the OpenSubKey Method
    $regkey = $reg.OpenSubKey($UninstallKey)
    #Retrieve an array of string that contain all the subkey names
    $subkeys = $regkey.GetSubKeyNames()
    #Open each Subkey and use GetValue Method to return the required values for each

    foreach ($key in $subkeys) {
        $thisKey = $UninstallKey + ”\\” + $key
        $thisSubKey = $reg.OpenSubKey($thisKey)
        $obj = New-Object PSObject
        $obj | Add-Member -MemberType NoteProperty -Name “ComputerName” -Value $computername
        $obj | Add-Member -MemberType NoteProperty -Name “DisplayName” -Value $($thisSubKey.GetValue(“DisplayName”))
        $obj | Add-Member -MemberType NoteProperty -Name “DisplayVersion” -Value $($thisSubKey.GetValue(“DisplayVersion”))
        $obj | Add-Member -MemberType NoteProperty -Name “InstallLocation” -Value $($thisSubKey.GetValue(“InstallLocation”))
        $obj | Add-Member -MemberType NoteProperty -Name “Publisher” -Value $($thisSubKey.GetValue(“Publisher”))
        $obj
    }

}

$data | sort displayname | select ComputerName, DisplayName, DisplayVersion, Publisher | ft -auto

Neally · 2020-05-05T13:19:08.000Z

also, be aware, if you use the ‘format-table -auto’ at the end you can not easily pipe it to e.g. ‘export-csv’ because 'format-table is for eye candy and breaks the object.