I had to collect the installed software from few computers and i used Belarc Advisor. The fun came when i started to consolidate the data :-)
To make my future life easier, I wrote a PowerShell script that exports a list of the installed programs into .CSV file.
Here it is:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
Clear-Host; $computerName = Get-WMIObject Win32_ComputerSystem | Select-Object -ExpandProperty name; $outputFile = "G:\$computerName.csv"; if (Test-Path $outputFile) { Remove-Item $outputFile; } Add-Content $outputFile "DisplayName¤DisplayVersion¤Publisher¤InstallDate"; $applications = Get-ItemProperty "HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*"; foreach ($application in $applications) { $displayName = $application.DisplayName; $displayVersion = $application.DisplayVersion; $publisher = $application.Publisher; $installDate = $application.InstallDate; if ($displayName -ne $null -or $displayVersion -ne $null -or $publisher -ne $null -or $installDate -ne $null) { Add-Content $outputFile "$displayName¤$displayVersion¤$publisher¤$installDate"; } } |
As usual i use ASCII 164 as delimiter.
Keep it simple :-)