Custom Registry Scan / Report builder

[pcrockett]

I have added the following custom registry entry to the "Configuration | Scanned registry keys" area in the GUI Console: HKLM SYSTEM\ControlSet001\Control\Session Manager\Environment\Region which has a value of 'CENTRAL'. I need to create a report that shows which computers in the domain have this registry value.

How do I reference the value to create a report? What table does it go into as a custom registry key? I don't see any new table entries in the table list after the above changes so how do I get to that value to be able to create a report against it?

Do I need to update something else outside of the GUIConsole so that the new registry entry will show up in report builder?

Are there any documents or how tos out there for "How to create a custom report" or "Creating a report from a custom file/registry scan"

I have basic knowledge of SQL but I am struggling with understanding the structure of what's going on in LS when I change something in the GUIConsole. I think I'm missing some major things.

Are there any how to documents out there for Report Builder in general or the creation of queries/reports and their saved file locations/ how to reference custom scan entries?

I've been poking around with this for a day and haven't made much headway. Any guidance would be much appreciated.

[pcrockett]

Ok, it all makes sense now. For some reason I thought it should have been something like tblRegistry.Region.

So to help others in the future who are as new to this as I am, a sample coding to reference a custom scanned registry key would be:
---------------------------------
SELECT *
FROM
TblRegistry
WHERE
Valuename = 'Region'
---------------------------------

or in my case, I wanted to display all systems where the region value = CENTRAL. The code in its basic form:
---------------------------------
SELECT
TblRegistry.computername,
TblRegistry.Lastchanged
FROM
TblRegistry
WHERE
Valuename = 'Region' AND
Value = 'CENTRAL'
---------------------------------

Thanks for your help!

[Hemoco]

Sorry, my mistake you need to use single quotes around 'region'

[pcrockett]

Here it is

[Hemoco]

Could you send me an output of "select * from tblregistry where valuename = Region"

[pcrockett]

Here they are

[Hemoco]

Could you post a screenshot of the management console where you entered the registry key.
Couls you also show the output of the report/query (select * from tblregistry)

[pcrockett]

Thanks for your assistance with this. I posted the screenshot in my original post. The waittime is set to 0 for the registry. I'm also not seeing any new values in the tblRegistry table. I've tried to reference tblRegistry.Region, but it returns an "invalid column error".

[Hemoco]

First take a look at the waittimes : registry
This value is the amount of days when each item is rescanned
1 : every day (24 ) hours
20 : 20 days

Please show a screenshot of the registry key you want to scan (from the console management)

The results of the gathered registry keys is stored in table tblregistry (do you see any entries there?)