Client Management Suite

 View Only
Back to Library

Need help with a Query (Inventory) 

Nov 07, 2006 09:48 AM

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

Statistics
0 Favorited
4 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Pascal KOTTE
Mar 26, 2010 01:52 PM

Please, see & vote this Idea:

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

Migration User
Feb 27, 2008 05:00 PM

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

Migration User
Dec 21, 2006 12:15 PM

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.

Migration User
Dec 20, 2006 01:50 PM

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!

Migration User
Nov 27, 2006 07:03 AM

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

Migration User
Nov 08, 2006 04:22 AM

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

Scott Hardie
Nov 07, 2006 12:59 PM

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

Related Entries and Links

No Related Resource entered.