SOLVED SCCM Query to check registry key

[Samad Koskesh]

Hey all, how can I create a query to check a registry key in SCCM 2211 ?
I do not want to do this with Configuration Baseline or CM Pivot

Thanks in advance

 

[EdGonz]

You can write a PowerShell script and run it against the device(s).

Here's a quick sample link: https://www.jonathanmedd.net/2014/02/testing-for-the-presence-of-a-registry-key-and-value.html

 

[Garth]

define query? Do you mean query for a application detection method? OR do you mean inventory ? https://askgarth.com/blog/how-to-use-regkeytomof/

 

[Hackmuss]

Why don't you want to use CMPivot? It does exactly what you're asking very well...

 

[Samad Koskesh]

Why don't you want to use CMPivot? It does exactly what you're asking very well...

I want to be able to have this saved so everytim I run it, it would give me list of all computers that don't have it, can I do this with CM Pivot?

 

[Samad Koskesh]

define query? Do you mean query for a application detection method? OR do you mean inventory ? https://askgarth.com/blog/how-to-use-regkeytomof/

Like how you have different queries for different items, like for example, query to generate all computer that running Windows 10 22H2, I want a query for all computer that do have that key and the ones that don't have it

 

[Youssef Saad]

Like how you have different queries for different items, like for example, query to generate all computer that running Windows 10 22H2, I want a query for all computer that do have that key and the ones that don't have it

There are multiple ways to get registry keys values, using a Configuration Item & Baseline, CMPivot etc.
Can you tell us what is your next step after getting those two outputs?

 

[Hackmuss]

I want to be able to have this saved so everytim I run it, it would give me list of all computers that don't have it, can I do this with CM Pivot?

Sure - you just need to add it as a favourite and it saves it for next time. Input the query, then click the big green '+' icon to save as a favourite and give it a title. Next time you run CMPivot, just click the little white star icon on the toolbar and it shows your favourites list.
Here's the query you need - just change the first line and the property value to reflect the key you are interested in:
Registry('HKLM:\HARDWARE\DESCRIPTION\System\BIOS')
| where Property == 'SystemProductName'