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.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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

Please log in to comment
Answer this question or Comment on this question for clarity
Five Steps for Easier- and More Effective- IT Inventorying
Having an accurate inventory of all your IT assets is critical to ensuring that users are productive and that every dollar is well spent. This white paper outlines five steps that improve inventorying both hardware and software.

Share