Notification

Icon
Error

AV Audit Report - AV report modification

Posted: Wednesday, July 29, 2020 2:13:52 PM(UTC)
Erny382

Erny382

Member Original PosterPosts: 1
0
Like
Good afternoon all,

Hope you're keeping well?

We have a requirement to confirm that all clients and servers in the business are upto date with the latest version of our AV.

I know Lansweeper has the two reports 'Servers without anti-virus software' and 'workstations without anti-virus software'.

Is it possible to:

A) Have it so that both servers and workstations are included in one report (rather than one for each).
B) Be able to edit the report to update the build number so that it flags up any workstation/server where the build version is no 'XXX'?

Any help would be appreciated.

Ta
Ste
RC62N
#1RC62N Member Posts: 575  
posted: 7/29/2020 5:17:42 PM(UTC)
A) Copy either the server or workstation query and delete
Code:
And tblDomainroles.Domainrolename In (...)

from the WHERE clause.

If you want to know which machines are of which class on your new report, add tblDomainroles.Domainrolename to the list of columns on the report.

B) Assuming the build version you're referring to is the OS build, add tblAssets.BuildNumber to the report. Potentially more usefully, you might prefer tblAssets.Version; that's the 2004, 1909, 1903, 1809, etc. that the versions are better known by.

Active Discussions

Lansweeper Sync information
by  prighi61   Go to last post Go to first unread
Last post: Yesterday at 2:34:06 PM(UTC)
Lansweeper Deleting, removing or hiding default ticket states
by  prighi61  
Go to last post Go to first unread
Last post: Yesterday at 1:16:52 PM(UTC)
Lansweeper Switch Dell S4128 Scan error
by  matteor   Go to last post Go to first unread
Last post: Yesterday at 1:04:03 PM(UTC)
Lansweeper Patch Tuesday report showing wrong results
by  NoZart  
Go to last post Go to first unread
Last post: Yesterday at 11:44:58 AM(UTC)
Lansweeper How do I create a new ticket using the API?
by  prighi61   Go to last post Go to first unread
Last post: Yesterday at 9:36:39 AM(UTC)
Lansweeper IP Location "undefined"
by  Kboyer  
Go to last post Go to first unread
Last post: 9/23/2021 9:25:46 PM(UTC)
Lansweeper Modify root cause list
by  Arno Butter   Go to last post Go to first unread
Last post: 9/23/2021 8:38:25 PM(UTC)
Lansweeper scanning network devices
by  mattscratt  
Go to last post Go to first unread
Last post: 9/23/2021 8:04:43 PM(UTC)