Get List of Installed Software

Try...

Import-Module Activedirectory
$ErrorActionPreference = "SilentlyContinue"

$array = @()

Get-ADComputer -Filter * -SearchBase "OU=Comp,DC=Domain,DC=com" | % {

$pc = $_.Name

If (Test-Connection $pc -Count 2 -Quiet){
    
		Write-Host "Collecting List of Installed Software from $pc"
		
    $UninstallKey="SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall" 
    $reg=[microsoft.win32.registrykey]::OpenRemoteBaseKey('LocalMachine',$pc) 
    $regkey=$reg.OpenSubKey($UninstallKey) 
    $subkeys=$regkey.GetSubKeyNames() 
    
		foreach($key in $subkeys){

        $thisKey=$UninstallKey+"\\"+$key 

        $thisSubKey=$reg.OpenSubKey($thisKey) 

        $array += New-Object PSObject -Property @{
        ComputerName = $pc
	DisplayName = $($thisSubKey.GetValue("DisplayName"))
	Version = $($thisSubKey.GetValue("DisplayVersion"))
        }

    } 
	}
}
$array | ? {$_.DisplayName} | Select  ComputerName,DisplayName,Version | Export-Csv C:\temp\AllSoftlist.csv -NTI
$array | ? {$_.DisplayName} | Group DisplayName,Version -NoElement | Select Name,Count | Export-Csv C:\temp\AllSoftCount.csv -NTI

Select allOpen in new window

Irrylyn --
How's this--using Powershell
http://www.howtogeek.com/165293/how-to-get-a-list-of-software-installed-on-your-pc-with-a-single-command/

jcimarron:

Yes, I came accross that article thank you.  However, my environment has 10k computer systems so this will not be sufficient.

Subsun:

In the tests I did it seems to work very well.  However, a lot of software is left out because it doesn't have all of the software listed that is in 'Programs and Features.'  I believe this is because most of the software is listed under:

HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\

Problem with this is that Windows updates also show up there, so if we were to add that registry key to the script it would return a butt-load of KB's also....  any way to add that other reg location and filter out the updates?  I'm looking for a key or naming convention that matches them all to use as a filter.

It looks like the answer is in the keys.

Keys for system updates or .NET seem to end with the KB#,  for example:

HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{F5B09CFD-F0B2-36AF-8DF4-1DF6B63FC7B4}.KB2737019


Keys for Office applicaiton updates seem to use the same key number and then tag more to it.  For example:

MS Office 2007 key:  HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{90120000-0011-0000-0000-0000000FF1CE}

MS Office 2007 Update:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{90120000-0011-0000-0000-0000000FF1CE}_PROPLUS_{0B7B13E7-52F2-44C8-84BC-5B9C563AA572}

Anyone know how to add the wow6432node uninstall key to this?

I'll take just that and manually remove the KB's/updates if needed.


Maybe to remove the updates, something like Where-Object {not ( $_.AppID -like "KB*") }

footech:  thank you, that is a good point and now that I know how, I will plug it in and try that out.

Subsun:  What you do is art.  I am still floored at how quickly you did that!  And it works beautifully.  I love the addition of the error colors and descriptions if a host could not be reached.  It helps identify those that are offline versus those with configuration issues.  I also see the -notmatch that you used and paired it with $Soft -ne null.  Works great!  Last, I have to commend you for the -Unique addition as it eliminated a lot of duplicates I saw previously.

Well done!

I will do some homework on functions and arrays.  Very useful stuff, but imtimidating!

Glad to hear my solution works for you and has some added value!..  indeed, I learned a lot on EE.. :-)