Hopefully you aren’t still running Windows 2000? https://support.microsoft.com/en-us/kb/279225
Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of HELMS, DAVID C Sent: Monday, January 09, 2017 12:49 PM To: mssms@lists.myitforum.com Subject: RE: [mssms] Report for Software Updates? Thanks Daniel. I saw some older posts talking about not enabling QFE unless you have installed patch Q279225. Something along the lines of inventory cycles taking a long time to complete without the update? Was this just for older systems or is this still valid for all? From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Monday, January 9, 2017 11:34 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] Report for Software Updates? ***This is an EXTERNAL email. Please do not click on a link or open any attachments unless you are confident it is from a trusted source. ________________________________ We use QFE, but note it only shows security related patches, not all hotfixes or 3rd party patches. For all Microsoft patches you can tie into v_Update_ComplianceStatusAll. Something I found in an old query below. select comp.*, ui.BulletinID, ui.ArticleID, ui.Title from v_Update_ComplianceStatusAll comp join v_UpdateInfo ui on comp.CI_ID=ui.CI_ID where ResourceID = (select resourceid from v_r_system where netbios_name0 = 'wkmj029cw9') order by BulletinID, ArticleID, Title For 3rd party patches, if it’s not in v_add_remove_programs or v_gs_installed_software, no idea where you could find it. Daniel Ratliff From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of HELMS, DAVID C Sent: Monday, January 09, 2017 11:03 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] Report for Software Updates? What I am looking for is a report that lists ‘All’ software updates (patches) installed on a machine and the date of installation. I’m unable to find this information in the canned reports in SSRS. Does anyone know where I can find this information to build a custom report or share if you already have? I’ve also read info about a WMI class called Win32_QuickFixEngineering that might be needed. Is this class necessary? Thanks, David 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. 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.
