/build/static/layout/Breadcrumb_cap_w.png
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 MtfNQu.jpeg


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?
Thanks

Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
I found the answer

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;
Only changed I made was a space in between the =MACHINE_CUSTOM_INVENTORY.ID (space) WHERE SOFTWARE_ID =
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
Blue 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