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

Need help with a Query (Inventory)

Created: 07 Nov 2006 • Updated: 29 May 2007 • 7 comments
m.hennig's picture
0 0 Votes
Login to vote

Hi all,

I'm new here and have a question about a query.

Does anyone have a tip how I can get all this information:
Operating system
OS Service Pack
IE version
Equipment type
Computer model and S/N
Service tag
Monitor model and S/N
Printer model and S/N
Licensed software installed
Software update
Compaq insight agent
Local administrator

I know that the Standard query is very good and has much information, but how can I get the SN of a Monitor or Battery, for example.

Thanks for your help,

Comments 7 CommentsJump to latest comment

Scott Hardie's picture

What kind of hardware do you have? I am assuming all HP based on your Compaq Insight Agent request but wondered if you had a mix. I can help you create a web report for all that info as I may have some time to do so over the next few days.

James "Scott" Hardie
Vice President of Technology Services

James "Scott" Hardie
Security Architect
Security Business Practice
Symantec Corporation
Office: (810) 588 9464
Mobile: (810) 588 9464<

Login to vote
m.hennig's picture

Hi and thanks for the answer, we have only Dell Machines and older HP machines.

I hope it is not to much work for u:-) I will learn more about Altiris but this tool is so powerful and have so many tools, i must go to more training :-)


Login to vote
Andy Smith's picture


Do you have the Dell Client Manager and HP Client Manager installed in your Altiris infrastructure?

These two add-on solutions extend the inventory information and may include the serial number of the components you require.

Hope that helps.


Login to vote
xmoreland's picture

It all depends on how your data is collected.

I was surprised to find some info that we did not think was being collected. That is what I get for searching through SQL views on a regular basis!

One of my favorite past times these days and it yields ton's of useful information!

Login to vote
manofsteel's picture

The other option is to do a custom inventory to scan the registry, wmi, or ini files to find additional information. if you can find it in one of those locations, you can write a custom inventory to bring it into altiris.

Login to vote
JeffDG's picture

You need to find the tables you're looking for, and the easist way is to look in Resource Explorer.

See this article that I posted a long time ago...

Login to vote
Pascal KOTTE's picture

Please, see & vote this Idea:

~Pascal @ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

Login to vote