Yeah, that's essentially what I am looking for. Only addition to what you have is I'd like to create an SSRS report off of it where 1) it only shows the updates in a specific SUG (prompt for SUG) and 2) the update title is a hyperlink to the InfoURL.
I'll play around with it a bit but wanted to see if anyone had gone down that road before I spent too much time on it. From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, February 19, 2015 11:50 AM To: [email protected] Subject: [mssms] RE: SUG Query/Report Help Are you wanting the description of the software update? Both that and the KB URL are included in the database already. Look in v_UpdateInfo. Here is something quick a threw together. select top 5 BulletinID, ArticleID, IsSuperseded, IsLatest, DatePosted, DateRevised, Title, Description, InfoURL, UpdateType from v_UpdateInfo BulletinID ArticleID IsSuperseded IsLatest DatePosted DateRevised Title Description InfoURL UpdateType 309521 1 1 28:13.0 28:13.0 Windows XP Update Package, October 25, 2001 This update resolves all critical issues that were found in Windows XP between August 2001 and October 2001, and is discussed in Microsoft Knowledge Base (KB) Article Q309521. Among the updates included in this package are several that eliminate security vulnerabilities. Download now to ensure that you have all the latest critical updates for Windows XP. http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/4973.htm 312369 1 1 24:13.0 24:13.0 Critical Update, November 19, 2001 This update resolves the "You May Lose Data or Program Settings After Reinstalling, Repairing, or Upgrading Windows XP" issue in Windows XP, and is discussed in Microsoft Knowledge Base (KB) Article Q312369. If you upgrade, reinstall, or repair the version of Windows XP that was preinstalled by a computer manufacturer, in some cases, you might lose data or program settings. Download now to ensure that you do not lose data or settings in Windows XP. http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5079.htm 311889 1 1 49:52.0 49:52.0 Remote Assistance Connection This update resolves the "Cannot Establish a Remote Assistance Connection" issue in Windows XP, and is discussed in Microsoft Knowledge Base (KB) Article 311889. When you try to establish a Remote Assistance session, you might receive an error message, and be unable to start a Remote Assistance session. Download now to ensure that you can establish a Remote Assistance session successfully. This item has been updated since it was released in October, 2001. If you have already installed this item, it is not necessary to reinstall it. http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5081.htm MS01-059 315000 1 1 39:13.0 39:13.0 Security Update, December 17, 2001 This update resolves the "Unchecked Buffer in Universal Plug and Play Can Lead to System Compromise" security vulnerability in Windows XP. Download now to help prevent a malicious user from compromising your computer or using your computer to compromise another computer's functionality. http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5130.htm 315403 1 1 52:21.0 52:21.0 Critical Update, February 10, 2002 This update addresses the "Stop 0xED on mounting volume on IDE drives" issue in Windows XP, and is discussed in Microsoft Knowledge Base (KB) Article Q315403. Download now to resolve an issue affecting computers with IDE hard drives with caching enabled, that prevents the chkdsk.exe utility from running when your computer restarts. http://www.download.windowsupdate.com/msdownload/update/v3/static/RTF/en/5228.htm Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Thursday, February 19, 2015 11:33 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] SUG Query/Report Help I'm trying to create a report of all updates in a SUG with descriptions of each update that I can provide to management prior to deployment. Something similar to "Management 3 - Updates in a deployment" but I wanted to add the descriptions and the InfoURL to the report. It looks like the v_UpdateInfo view has everything I need, I just want to create a report out of it. Ideally, I'd like it to look something like this but with two additions: 1. The hyperlink of the title would be the InfoURL (ie: http://go.microsoft.com/fwlink/...) associated with the update in the v_UpdateInfo view 2. A 4th column for the description (which in most cases is a generic description but it could help) How hard would that be? Any pointers? Has anyone done something like this before? [cid:[email protected]] Thanks! James Beardsley | Firm Technology Group Dixon Hughes Goodman LLP [cid:8644FC49-D5C9-45AE-B387-04FAFC0CC7A5]<http://www.dhgllp.com/> ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
