Custom inventory items and asset reporting
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.
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.
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
