Home » Groups » Asset & CMDB

Need help with a Query (Inventory)

Need help with a Query (Inventory)
Filed under: Inventory Solution Inventory
Submitted by m.hennig on 7 November, 2006 - 08:48.

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

3.4
Average: 3.4 (5 votes)

Little bit more info needed

Scott Hardie's picture
Submitted by Scott Hardie on 7 November, 2006 - 11:59.

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

Hi and thanks for the

Submitted by m.hennig on 8 November, 2006 - 03:22.

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

Dell and HP Client Managers

Submitted by Andy Smith on 27 November, 2006 - 06:03.

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

All depends

Submitted by xmoreland on 20 December, 2006 - 12:50.

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!

Custom inventory for other info

Submitted by manofsteel on 21 December, 2006 - 11:15.

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.

Find the data

Submitted by gebhartj on 27 February, 2008 - 16:00.

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