Patch Volume Across Fleet

[darren_kimber]

Hi, I can't work out how to create a report for the number of patches applied over the past year. This is just a calculation of applied patches on all Windows systems.

Any thoughts?
Appreciate the help!
Darren

[darren_kimber]

Hey Andy.S this is perfect! Really appreciate your work!

Thanks
Darren

[Andy_Sismey · Accepted solution]

Hi Darren,

Is this what you after, so its a count of KB's by KB Install date within 365 Days ?

Select Top 1000000 Count(tblQuickFixEngineering.QFEID) As [Count Of KB's],
  tblQuickFixEngineeringUni.HotFixID
From tblAssets
  Inner Join tblQuickFixEngineering On
    tblAssets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineering.QFEID
Where DateDiff(dd, tblQuickFixEngineering.InstalledOn, GetDate()) / 365.25 < 1
Group By tblQuickFixEngineeringUni.HotFixID

Date code from here :- https://www.lansweeper.com/forum/yaf_postsm57381_All-computers-purchased-within-the-last-X-number-of-years.aspx#post57381

[darren_kimber]

Andy.S wrote:
Hi Darren,

Is this what you after, so its a count of KB's by KB Install date within 365 Days ?

Select Top 1000000 Count(tblQuickFixEngineering.QFEID) As [Count Of KB's],
  tblQuickFixEngineeringUni.HotFixID
From tblAssets
  Inner Join tblQuickFixEngineering On
    tblAssets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineering.QFEID
Where DateDiff(dd, tblQuickFixEngineering.InstalledOn, GetDate()) / 365.25 < 1
Group By tblQuickFixEngineeringUni.HotFixID

Date code from here :- https://www.lansweeper.com/forum/yaf_postsm57381_All-computers-purchased-within-the-last-X-number-of-years.aspx#post57381