SQL query to get the registry key exists or not.

Question

Hello All, We are looking for a SQL query to get the data of all devices against the registry key exists or not. "HKLM\SOFTWARE\Microsoft\Office\ClickToRun\Configuration" is the path of the Registry and "VersionToReport" is the Registry Key. We need to have a query to find whether the key is present or not.

Answer 1

Hi, @Manoj Anukonda

Thank you for posting in Microsoft Q&A forum.

If you are using SCCM, it's very simple for us to query registry using CMPivot:

https://www.prajwaldesai.com/query-registry-value-using-cmpivot/

Here is an example how to list all machines that have not a specific registry key:

https://www.systemcenterdudes.com/sccm-cmpivot-query/

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".