Exclude devices from report Windows Update Audit

[Lamsweeper]

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!

[Josha · Accepted solution]

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')

[Lamsweeper]

Thank you much, that worked!! 😁