This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 77%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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!
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
Hi Garth,
Actually, I want one report there I need Device Name, Patch Name, Patch Status, Collection ID and OS related details.
I'm new to SQL so facing some difficulties to join those views,
that you already provided so I'm looking for specific query that will helps me to retrieve all required information.
What error are you getting when you join the SQL views? again, have you looked at the built-in reports?
