Report on Custom Inventory
10/26/2016 763 views
I have a Custom Inventory rule setup for a registry key value which looks like this
RegistryValueReturn(HKLM\SOFTWARE\Wow6432Node\CertiTAXCOMWrapper, CertiCalcURL, TEXT)
When I inventory a computer now, under customer inventory for that computer, it shows me the the text
Software ID # is 23220
I would like to run a sql report which would show me the computer name and the value of this customer inventory reg key value.
Can anyone point me to the right direction?
Answer Chosen by the Author
Please log in to answer
I found the answer
Only changed I made was a space in between the =MACHINE_CUSTOM_INVENTORY.ID (space) WHERE SOFTWARE_ID =
http://www.itninja.com/question/custom-inventory-rules-and-reporting (answered by Chuck Steel)
SELECT MACHINE_CUSTOM_INVENTORY.*, MACHINE.NAME FROM ORG1.MACHINE_CUSTOM_INVENTORY JOIN MACHINE on MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID WHERE SOFTWARE_ID = 123456;
There is a space in between ID and WHERE.
Of course you also have to chance the ID= to your software ID value number.
Answered 10/26/2016 by: sam240