This SQL Query would help ? DECLARE @PC varchar(8000);SET @PC='PC0001'; select sys.name0 [Computer Name],ui.title from v_updateinfo uiinner join v_UpdateComplianceStatus ucs on ucs.ci_id=ui.ci_idjoin v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_IDjoin v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueIDjoin v_R_System sys on sys.resourceid=ucs.resourceidand ucs.status='3' -- Installedand ui.IsSuperseded!='1'and sys.name0=@PCgroup by sys.name0,ui.title
RegardsEswar Koneti www.eskonr.com From: [email protected] To: [email protected] Subject: RE: [mssms] RE: Installed Update View Date: Mon, 9 May 2016 16:11:40 +0000 Sadly I can’t wait a week so I’ll try Daniel’s idea. From: [email protected] [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Monday, May 9, 2016 10:59 AM To: [email protected] Subject: Re: [mssms] RE: Installed Update View If you can wait a week, John... that'll be one of my demos. Exactly how to write a wql for a specific installed update. On Mon, May 9, 2016 at 9:56 AM, Daniel Ratliff <[email protected]> wrote: I usually go with v_gs_quick_fix_engineering or v_Update_ComplianceStatus. Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Monday, May 09, 2016 10:31 AM To: [email protected] Subject: [mssms] Installed Update View Where the heck is installed updates listed in SQL/WQL now? I can’t seem to find that. I need to create a collection of all devices with KB3139923 installed so I can remove it. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. 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. -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
