Custom SCCM Report for patching

Question

Is there a custom SCCM report which can generate details about this -

1. Total compliance
2. Patch wise report
3. Machine wise missing security patches
4. Risk level report
5. Non-Compliance since days/date

Answer 1

Not exactly, but you can refer to this one for inspiration and create your own. https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/mastering-configuration-manager-patch-compliance-reporting/ba-p/1415088

Answer 2

What exactly do you have for a SQL query now? What exactly isn't working for you? Some of what you are looking for already exists as builtin reports.

Answer 3

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/list-of-reports