SQL Query for Fetching SSCM's Software Update Detailed Report

Swahela Mulla 90 Reputation points
2023-07-31T09:43:12.2533333+00:00

Hello Everyone,

I am looking for assistance in crafting an SQL query to fetch a detailed report on software updates using SSCM (System Center Configuration Manager). I need the following columns in the result:

·       Device Name

·       Patch/Software Updates

·       Patch Status (e.g., Installed, Failed, In Progress)

·       Collection ID

·       OS Name

If there are additional fields available, I'd appreciate including them in the query.

I've been struggling with this query, and any guidance or examples would be greatly appreciated.

Thank you in advance for your help!

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,327 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,255 questions
Microsoft Configuration Manager
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,852 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Garth 5,786 Reputation points
    2023-07-31T10:32:07.5066667+00:00

    What is wrong with the built-in reports? What do you have for a query now? What isn't working with it? Have you looked at the docs? https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager

    1 person found this answer helpful.