/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Custom Inventory Reporting for TEXT registry ?

11/27/2017 575 views
I have a custom inventory which puts out a text 
RegistryValueReturn(HKLM64\SOFTWARE\Intel\Setup and Configuration Software\INTEL-SA-00086 Discovery Tool\System Status, System Risk, TEXT)

Software ID=40012

I would like to report on this text field for all the machines that have this custom inventory.  
I'm not sure exactly how to do this. Any help is appreciated. Thank you
0 Comments   [ + ] Show comments

Comments


All Answers

0
Use the reporting wizard.
Scroll to the very bottom when you need to check the boxes with the items you want in the report.
There you can find the CIR when they are reporting informations and not only a boolean value (iE yes or no; 0 or 1)
Answered 11/28/2017 by: Nico_K
Red Belt

0
If you are interested in writing your own queries, then you need to join to the MACHINE_CUSTOM_INVENTORY table, like this:
LEFT JOIN MACHINE_CUSTOM_INVENTORY MCI on MACHINE.ID = MCI.ID and SOFTWARE_ID = 40012

That will allow you to include the columns from that table. The available columns are:
ID, SOFTWARE_ID, STR_FIELD_VALUE, NUM_FIELD_VALUE, MODIFIED, DATE_FIELD_VALUE, FIELD_VALUE_TYPE

So for a rule that returns text you would want MCI.STR_FIELD_VALUE

Answered 11/28/2017 by: chucksteel
Red 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

View more:

Share

 
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