Quick and Dirty Software Inventory with PsInfo and PowerShell

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Bernd — Mon, 12 Mar 2007 23:40:49 GMT

Hi,

nice thing. But what about removed software? That should be marked as deleted. I did myself something similar but not with Powershell.

I remebered the last output from psinfo -s and diff´ed this with the actual output, so i get all those software which has been deleted from the last run.....

Regards, Bernd.

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

ottoh — Tue, 13 Mar 2007 03:36:09 GMT

Hey Bernd,

That's a good point. I looked that the above database enabled script to see what modifications would need to be made to allow removed applications to be trackable and realized that it will work as is (although I admit, that was not my intention). Every time the script is run, it will add/overwrite entries for the applications with a new time stamp, but it won't delete previous entries for a computer. Therefore one can query for specific computer and see the application audit history.

Thanks for your feedback,

Otto

Software inventory with PsInfo and PowerShell

Nino.Mobile — Thu, 15 Mar 2007 09:02:53 GMT

Sweet! Check out this post from Otto Helweg on using PsInfo and PowerShell (I <3 you, PowerShell,

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Ramon Martinez — Mon, 19 Mar 2007 21:44:13 GMT

I could not run the sample scripts:

error:

PS C:\temp\Pstoolsv2.43> c:\temp\pstoolsv2.43softwareinventory.ps1

File C:\temp\pstoolsv2.43\softwareinventory.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help about_signing" for more details.

At line:1 char:42 + c:\temp\pstoolsv2.43\softwareinventory.ps1 <<<<

PS C:\temp\Pstoolsv2.43>

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

ottoh — Mon, 19 Mar 2007 23:40:52 GMT

Hello Ramon,

The default PowerShell execution policy is to only run "signed" scripts (makes it less likely to be a vehicle for worms). In order to change this, run the following command in PowerShell:

set-executionpolicy remotesigned

Otto

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Erin — Thu, 22 Mar 2007 17:52:11 GMT

This is great! Thanks for this post!

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Ray — Fri, 13 Apr 2007 20:56:19 GMT

I found this info helpful but will show my ignorance on one point. You reference a database in part 2. What did you use to create this database? We are at a small, private college and have SQL Server Express installed there, as well as SQL Server itself. Would the express edition be sufficient for databases of information that would be from or used with Powershell applications?

Also, I am assuming that the database was created beforehand. If the script creates it, which it does not look like it does, how does it do this? If the script does not create the tables or database, but merely updates an existing database, then please ignore this second question.

Thank you in advance.

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

ottoh — Mon, 23 Apr 2007 22:36:29 GMT

Hello Ray,

No, the script does not create the database. It was created beforehand. Since I'm using SQL 2005, I use 'SQL Server Management Studio' to create my database(s) and table(s). This should install with the Client Tools (but might not be available for the 'express' version - never tried that one).

Hope that helps,

Otto

Quick and Dirty Software Inventory with PSINFO and PowerShell

Latest Newsgroup Posts — Tue, 16 Oct 2007 04:18:07 GMT

Tonight I stumbled across this blog and thought it was interesting. [link] I like it so much I think

Powershell: Real Glue!

Austin Osuide's Windows Server and Random Rants Blog — Tue, 16 Oct 2007 15:08:08 GMT

Last Friday Quest software made GA the RC of the ActiveRoles ADcmdlets. This, to me, is another significant

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Yusuf — Tue, 01 Apr 2008 19:49:38 GMT

I have tried the script on a group of 100 servers, but what i find is that while on the powershell screen it loads many applications, i find only a handful actually appear in the database. Could the strip duplicates actually strip duplicates from other servers?

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

Steve Irvine — Tue, 03 Jun 2008 15:38:20 GMT

This can be done natively without pstools. It's all available in wmi.

get-wmiobject -class "win32_Product" -namespace "root\cimv2" -computername sirvine | sort Name | select-object Name,Vendor,Version,Caption | export-csv sirvineaudit.csv

re: Quick and Dirty Software Inventory with PsInfo and PowerShell

jbrightwell — Fri, 13 Jun 2008 22:30:54 GMT

The script does not work for me. It does not recognize the psinfo call made be the script. Below is the error output.

The term './psinfo.exe' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again.

At line 5, position 35

$psinfoOutput = ./psinfo.exe -s Applications \\$computer

Otto Helweg - Management Matters : Quick and Dirty Software Inventory with PsInfo and PowerShell

It's my life... And I live it... — Wed, 11 Mar 2009 10:04:26 GMT

Besides creating a custom WMI report, you could use PSInfo to do something similar I believe. Combine