Creating Report Registry value who doesn't exist

[Kinoal]

Hi there,

I'm currently making some report of registry scanning cause we want to verify registry value on our servers for security compliancy.For the momement here is the currently rapport I've created :

Select Top 1000000 tblComputers.ComputerUnique, tblRegistry.Valuename, Web40OSName.OSname, tblRegistry.Value From tblComputers Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername Inner Join Web40OSName

On Web40OSName.Computername = tblComputers.Computername

Where tblRegistry.Valuename = 'MinimumPasswordAge' And (Web40OSName.OSname = 'Win 2003' Or Web40OSName.OSname = 'Win 2008' Or Web40OSName.OSname = 'Win 2008 R2' Or Web40OSName.OSname = 'Win 2003 R2') Or tblRegistry.Valuename = Null

It's working fine but the information missing is to know if the value is existing on the server. Now I know that this valuename exist with this value but I don't know if the Key exist. I want to have a list of all computers who doesn't have this key.

Do you have any idea to help us?

Thanks a lot for your help 🙂

[Hemoco]

You cannot scan for the key, only for the value inside a key.
Is there a default value in this key which is always present?

[Kinoal]

Tell me if I'm not clear enough about my demand 🙂 I can clarify it 🙂