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
SQL Query for Fetching SSCM's Software Update Detailed Report
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!