Video Screencast Help
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

Q:
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:
Username
Computername
Operating system
OS Service Pack
IE version
Equipment type
Computer model and S/N
Service tag
Memory
Monitor model and S/N
Accessories
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,
Marcel

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
shardie@xcendgroup.com
http://www.xcendgroup.com

James "Scott" Hardie
Security Architect
Security Business Practice
Symantec Corporation
www.symantec.com
__________________________________
Office: (810) 588 9464
Mobile: (810) 588 9464<

-3
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 :-)

Thanks,
Marcel

-1
Login to vote
Andy Smith's picture

Hi

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.

Andy

-1
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!

+3
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.

+1
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...
http://juice.altiris.com/tech-tip/540/finding-table-names

+1
Login to vote
Pascal KOTTE's picture

Please, see & vote this Idea:

https://www-secure.symantec.com/connect/idea/integrate-windows-device-enumeration-string-missing-drivers-drivers-file-name-version

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

+1
Login to vote