Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Need help with a Query (Inventory)

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

Scott Hardie's picture
07
Nov
2006
0 Votes 0
Login to vote

Little bit more info needed

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<

m.hennig's picture
08
Nov
2006
0 Votes 0
Login to vote

Hi and thanks for the

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

Andy Smith's picture
27
Nov
2006
0 Votes 0
Login to vote

Dell and HP Client Managers

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

xmoreland's picture
20
Dec
2006
0 Votes 0
Login to vote

All depends

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!

manofsteel's picture
21
Dec
2006
0 Votes 0
Login to vote

Custom inventory for other info

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.

JeffDG's picture
27
Feb
2008
0 Votes 0
Login to vote

Find the data

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

Pascal.KOTTE at BECHTLE's picture
26
Mar
2010
1 Vote +1
Login to vote