RE: [mssms] Report for Software Updates?

2017-01-09 Thread Daniel Ratliff
: 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

RE: [mssms] Report for Software Updates?

2017-01-09 Thread HELMS, DAVID C
...@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 Subject: RE: [mssms] Report for Software Updates? ***This is an EXTERNAL email. Please do not click on a link or open any attachments unless

RE: [mssms] Report for Software Updates?

2017-01-09 Thread Daniel Ratliff
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