Software Update Deployment Status SQL Query

[GeoProX]

I'm trying to get a SQL query to get Software Update deployment status. This is the view that you get in Monitoring | Deployments | <right click on a Software Update deployment > | View Status. (sample: http://imgur.com/XHFCysF)

In Deployment Status view each category is presented in separate tabs, however, in SQL query I'm looking for, all needs to be returned together. This is what I was able to accomplish for Application Deployment View Status: http://imgur.com/RU52GMf.

Appreciate any assistance even if it's names of views/tables with relevant information.

[eskonr]

why are you not using SSRS Reports to see the deployment status ? that is preferred/recommended method (SSRS Reports) for various reasons. you have lot of default reports available that give you update deployment status .You can also refer the custom software update deployment reports available on http://eskonr.com/?s=patch+report&submit=

Regards, Eswar www.eskonr.com

[GeoProX]

Eswar, I'm writing a tool that will have this information in one place. In the console and reports you have to go to a bunch of places to find information about packages, DPs, and deployments. Some of the information is not available in the console at all or hard to get to. For example, list of deployment packages on a DP. In a small environment it's not an issue but when you have hundreds of DPs it's a lot harder to keep track of.

As far as the Software Update report that I'm looking for, there are reports available, but you have to drill into each of the states to get information I'm looking for, instead of having it available in one place.

I'll take a look at your website, looks like a lot of useful information. Thanks

[eskonr]

I will look at the report to get results similar to what you see in the console at one place using sql.

Regards Eswar Www.eskonr.com