/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Custom inventory items and asset reporting

08/20/2012 4924 views

We have a custom inventory item pulling back some data that we'd like to be able to report on.   I can't seem to find the tables where the history is kept.  I've found machine_custom_inventory, but that appears to be replaced on each inventory scan.   What I'm after is some sort of asset history that includes my custom items (or items that I can include)

If there is no custom inventory history, is there a way to add an entry to the asset_history table, that would reflect the change?  This would work well with what I'm trying to do, as the asset_history already tracks startup/shutdown and inventory items.

Answer Summary:
Machine_Custom_Inventory is where the data resides. You will need the ID number of your custom inventory rule. This can be found by enter kboxname.domain.org/adminui. Once there navigate to your custom software and in the address bar you will have ID=" ". This will be your custom ID.
0 Comments   [ + ] Show comments

Comments


All Answers

1

Machine_Custom_Inventory is where the data resides. You will need the ID number of your custom inventory rule. This can be found by enter kboxname.domain.org/adminui. Once there navigate to your custom software and in the address bar you will have ID="   ". This will be your custom ID.

From there you can use something like this. The 5443 will match your custom ID number.

SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=5443

I would start by using the reporting wizard to create what you need. If you can provide the SQL query and then what you want added to it then it will help.

Take a look at these sites. There's a ton of knowledge here.

K1000 KKE's: https://support.software.dell.com/k1000-systems-management-appliance/kb?k=KKE

Answered 08/21/2012 by: dugullett
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ