cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee

In this month's Pro Tips, I do a deep dive into the improved Patch Tuesday audit and provide extra resources on how to create a dashboard for monitoring your Windows updates deployments. You can find it in the blog post.

 

4 Comments
Dee
Engaged Sweeper II

Great video, thanks for sharing. 😁

I loved the section on charts. Is there anyway to just display all servers in the patch chart and reboot chart, rather than everything (workstations and servers) ? 

I have tried playing around with the below, but no joy 😕

Case
When tblComputersystem.Domainrole > 1 Then 'Server'

Esben_D
Lansweeper Employee
Lansweeper Employee

just adding a "and tblComputersystem.Domainrole > 1" to the end of the "where" clause at the bottom of the query should work

Dee
Engaged Sweeper II

Perfect! Thanks again 😁

AndyPalmerCTC
Engaged Sweeper II

Hi,
This is really useful and I have immediately setup a new 'Patch Tuesday' tab with the report and charts...

However it's become clear that you need to update the whole chart code each month (as you'd expect to do with the main report) and replace the top-and-tail code to make each chart work.

I think it's implied in your text but just leaving it alone fails to enumerate that months data and thus the two charts don't reflect the report - is there any way to fed from the report data, or make the charts work in another way so we don't have to replace all that code each month?

Great job as always though!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now