There's a pretty one in here: http://www.madisonusergroup.com/2012/11/28/octobernovember-2012-meeting-notes/
which basically has this as one of the queries inside; it's for an srs report of course, so the resourceid is obtained from a prompt for a computername, to be used in this Dataset. I think for your purposes, you'll want to comment out this: "ANDupd.Severity >0", The report as-is was meant to show security updates not every little thing...but if you comment that out, you'll get the non-security updates too (which aren't expired). Not sure if it's what you mean, tho.. but maybe it is. fyi; NOT my work. Shamelessly stolen from #2, John Nelson. If@ResourceID ISNOTNULLBEGIN -- get update info DECLARE@Updates TABLE ( CI_ID INT, BulletinID VARCHAR(64), ArticleID VARCHAR(64), Title VARCHAR(512), DescriptionVARCHAR(3000), InfoURL VARCHAR(512), Severity INT, IsSuperseded INT, IsExpired INT); INSERTINTO@UpdatesSELECT CI_ID, BulletinID, ArticleID, Title, Description, InfoURL, Severity, IsSuperseded,IsExpired FROM dbo.v_UpdateInfo ui -- get filesizes for update files DECLARE@UpdateFiles TABLE ( CI_ID INT, Size BIGINT); INSERTINTO@UpdateFiles SELECT uc.CI_ID, MAX(FileSize)SizeFROM dbo.CI_ContentFiles cf JOINdbo.v_UpdateContents uc ONcf.Content_ID =uc.Content_ID GROUPBY uc.CI_ID ORDERBYCI_ID SELECT upd.BulletinID, upd.ArticleID, ucs.Status, CASEWHENucs.StatusIN(1,3)THEN'GreenCheck'ELSE'RedX'ENDASStatusImage, sn.StateName, uf.Size asUpdateSize, upd.Severity, upd.IsSuperseded, upd.Title, upd.Description, upd.InfoURLFROM @Updates upd JOIN@UpdateFiles uf ONupd.CI_ID =uf.CI_ID JOINdbo.v_Update_ComplianceStatusAll ucs ONupd.CI_ID =ucs.CI_ID ANDucs.ResourceID =@ResourceID JOINdbo.v_StateNames sn ONucs.Status=sn.StateID ANDsn.TopicType =500 ANDsn.StateID IN(0,2,3)--unknown, required, installed ANDupd.Severity >0 ANDupd.IsExpired =0 ORDERBY BulletinID DESC,ArticleIDEND On Thursday, July 24, 2014 1:06 PM, "HELMS, DAVID C" <[email protected]> wrote: I get asked from time to time to produce a compliance report for a specific server on its overall compliance for ALL patches (security, updates, critical, etc..) released from Microsoft. I thought the simple compliance report for a specific computer would do the trick, but it will only list 1 page of information and nothing more. The arrow below is greyed out and you do not have the ability to see more pages. If I use the Compliance 3 – Update group (per update) report that is comparing to a software group, then it shows me all that is in that group, which is a hell of a lot more than the report below. Is there a simpler way to report this information rather than having to maintain a separate update group to compare against?
