Pages

Monday 29 May 2017

Installed Software Inventory from Remote Machine - Output in CSV (Excel) format

Hello,
This is build to collect Installed Software Inventory from Remote Machine.
You need to Enter Server names in server.txt file to collect the details from multiple servers.
This will work on  Windows 2003/2008, Win7 machines.
Software details will be collect from remote machine registry values.

Diffrent verion with HTML output at - 

Diffrent verion with CSV output at - 

PowerShell
Edit|Remove

Soft-Inventory $Comp | select ComputerName, Name, Publisher, InstallDate, `
EstimatedSize, Version, Wow6432Node | 
Sort-Object @{Expression={$_.InstallDate};Ascending=$True}` 
         | Export-Csv -Path  $filename   -NoTypeInformation 
                                                            
All server's software details in same spreadsheet.
Replace the below  from line number 104 in main attached file.
PowerShell
Edit|Remove

################################################################################################ 
 $date = get-date -uformat "%m-%d-%Y-%H:%M" # To get a current date. 
 $filename = ($SCRIPT_PARENT + "\_SoftwareReport.csv") 
 $vUserName = (Get-Item env:\username).Value 
 $vComputerName = (Get-Item env:\Computername).Value 
 
 ############################################# 
 write-Host "Getting software information.($Comp)" -ForegroundColor Magenta -BackgroundColor White  
  
 Soft-Inventory $Comp | select ComputerName, Name, Publisher, InstallDate, EstimatedSize, Version, Wow6432Node | 
Sort-Object @{Expression={$_.InstallDate};Ascending=$True}` 
         | Export-Csv -Path  $filename   -NoTypeInformation -Append 
                                                             
 write-Host "file is saved in $filename" -ForegroundColor Cyan 
 } 
 #invoke-Expression "$filename"  
  
#@================Code End=====================
Here is the output view of the script.

No comments:

Post a Comment

Installed Software Inventory from Remote Machine - Output in CSV (Excel) format

Hello, This is build to collect Installed Software Inventory from Remote Machine. You need to Enter Server names in server.txt file to co...