Custom Inventory Reporting for TEXT registry ?
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
Answers (2)
Please log in to answer
Posted by:
Nico_K
7 years ago
Posted by:
chucksteel
7 years ago
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