/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Report on Custom Inventory

10/26/2016 874 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

 
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