Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Caputuring Application Serial Numbers with Altiris Inventory Solution for Windows

Created: 22 Apr 2008 • Updated: 22 Apr 2008 • 6 comments
vortex0007's picture
0 0 Votes
Login to vote

I'm always surprised to find how few customers take advantage of Altiris Inventory Solution's ability to inventory an application's installed serial number. This information can be invaluable when trying to tie copies of applications installed in your environment back to software license agreements.

Each time Altiris Inventory Solution scans are run, the serial numbers for installed applications are captured and stored in the Inv_AeX_OS_Add_Remove_Programs table.

It is impossible for us to list every single application that will report back a serial number properly, but testing in large environments has revealed at least 500 business applications that return this information properly, including most of the business applications from Microsoft, Adobe.

The following SQL query can be run against the Altiris database to find out which applications in your environment will have this information:

Use altiris
Select distinct [Name], Version, [Product ID] 
From Inv_AeX_OS_Add_Remove_Programs 
Where [Product ID] != ''

Armed with this information, you can use this to create better contracts and gain more visibility into the applications in your environment.

Comments 6 CommentsJump to latest comment

acallahan's picture

Thank You so very much! This report provided me the exact data I needed.

0
Login to vote
SK's picture

App Man's Windows Installer Agent is also very good at reporting the ProductID, especially as Microsoft changed its location for Office 2003, which Inventory Solutions HW Inventory fails to bring in.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

0
Login to vote
DeborahKahmke's picture

This is great! I have passed it along to our team who does software footprinting!

-d

Deborah Kahmke

+2
Login to vote
wlindy27's picture

This is amazing! I will probably use this tomorrow at work!

+4
Login to vote
lone_ranger's picture

When I run this report I get a bunch or MS OneNote Installs and all have the same version 12.0.4518.1014 but all have different product IDs? If I remember correctly, the Product ID is the unique identifier for the product. So why do I have so many product IDs for MS OneNote 12.0.4518.1014?

0
Login to vote
haroldvm89's picture

Will this work on Altiris version 7.1 or 7.5?

0
Login to vote