SCCM SQL Queries

watsati 20 Reputation points
2023-02-27T16:42:20.1566667+00:00

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.

Microsoft Configuration Manager

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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:

    https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/software-updates-views-configuration-manager

    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.