→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Lamsweeper
Engaged Sweeper

Dear,

We have several servers that we want to exclude from the Windows update audit report in Lansweeper.
These servers are maintained by an other department inside our company.

We are using the code from:
https://www.lansweeper.com/resources/report/operating-system/last-windows-update-audit/

Would be great if there was a report builder feature inside Lansweeper that was more user friendly 😊

Thank you in advance for your help!

1 ACCEPTED SOLUTION
Josha
Engaged Sweeper III

In that SQL report, there's a "where" clause which is what filters the report to what exactly you want to see.  In the report you linked, this is the filter:

Where tblAssetCustom.State = 1

This filter will only show you active assets.  If you want to hide assets by name you can change it to this: 

Where tblAssetCustom.State = 1 And tblAssets.Assetname not in ('Server1','Server2','Server3','Server4')

  

View solution in original post

2 REPLIES 2
Josha
Engaged Sweeper III

In that SQL report, there's a "where" clause which is what filters the report to what exactly you want to see.  In the report you linked, this is the filter:

Where tblAssetCustom.State = 1

This filter will only show you active assets.  If you want to hide assets by name you can change it to this: 

Where tblAssetCustom.State = 1 And tblAssets.Assetname not in ('Server1','Server2','Server3','Server4')

  

Thank you much, that worked!! 😁

New to Lansweeper?

Try Lansweeper For Free

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

Try Now