cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
darren_kimber
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Andy_Sismey
Champion Sweeper III
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

View solution in original post

3 REPLIES 3
darren_kimber
Engaged Sweeper II
Hey Andy.S this is perfect! Really appreciate your work!

Thanks
Darren
Andy_Sismey
Champion Sweeper III
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
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