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: 74  
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 Automatic Follow-Up for Tickets
by  Francis Lee Mondia - Endace   Go to last post Go to first unread
Last post: Yesterday at 11:06:51 PM(UTC)
Lansweeper Can't see devices on Lansweeper
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: Yesterday at 8:33:21 PM(UTC)
Lansweeper LAPS managed password
by  SystemAdmin   Go to last post Go to first unread
Last post: Yesterday at 6:08:42 PM(UTC)
Lansweeper Install Adobe Reader Error
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 2:46:54 PM(UTC)
Lansweeper Stop deployment
by  Tyler M.   Go to last post Go to first unread
Last post: Yesterday at 1:59:22 PM(UTC)
Lansweeper "Out of memory" in errorlog.txt
by  dua  
Go to last post Go to first unread
Last post: Yesterday at 1:00:42 PM(UTC)
Lansweeper Installation issues
by  Troy   Go to last post Go to first unread
Last post: Yesterday at 9:24:54 AM(UTC)
Lansweeper End of Life Asset Report
by  DJ Bradley  
Go to last post Go to first unread
Last post: 5/11/2021 4:09:33 PM(UTC)