All of the supported SQL views are listed here. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager
SCCM SQL Queries

Greetings,
I've been asked to have a look at some custom SCCM reporting that particularly groups all patches by product category. Is there a guide or link to use with the queries?
Thanks.
-
1 additional answer
Sort by: Most helpful
-
AllenLiu-MSFT 24,206 Reputation points Microsoft Vendor
2023-02-28T02:37:45.37+00:00 Hi, @watsati
Thank you for posting in Microsoft Q&A forum.
The software update related views are listed here:
What is your specific need?
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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
-