Notification

Icon
Error

Patch Volume Across Fleet - Manager requires Stats

Posted: Thursday, April 22, 2021 8:29:33 AM(UTC)
darren.kimber

darren.kimber

Member Original PosterPosts: 8
0
Like
This issue has been solved! Click here to view the solution
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
Andy.S
#1Andy.S Member Posts: 93  
posted: 5/5/2021 4:03:52 PM(UTC)
Hi Darren,

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

Code:
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.c...-of-years.aspx#post57381
darren.kimber
#2darren.kimber Member Original PosterPosts: 8  
posted: 5/5/2021 11:27:23 PM(UTC)
Originally Posted by: Andy.S Go to Quoted Post
Hi Darren,

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

Code:
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.c...-of-years.aspx#post57381


darren.kimber
#3darren.kimber Member Original PosterPosts: 8  
posted: 5/5/2021 11:29:33 PM(UTC)
Hey Andy.S this is perfect! Really appreciate your work!

Thanks
Darren

Active Discussions

Lansweeper Full asset report with and without ad relationship
by  teddyh2o   Go to last post Go to first unread
Last post: 6/18/2021 8:28:24 PM(UTC)
Report Center Show newly discovered software
by  CyberCitizen  
Go to last post Go to first unread
Last post: 6/16/2021 12:06:21 AM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Charles S.   Go to last post Go to first unread
Last post: 6/15/2021 9:38:26 PM(UTC)
Lansweeper Show Date Without Time
by  RC62N  
Go to last post Go to first unread
Last post: 6/15/2021 9:04:47 PM(UTC)
Lansweeper Windows 10 Version Chart
by  RC62N   Go to last post Go to first unread
Last post: 6/14/2021 6:16:52 PM(UTC)
Lansweeper LSAgent Report
by  brodiemac-too  
Go to last post Go to first unread
Last post: 6/14/2021 5:27:29 PM(UTC)