Need query for one of the default reports

[magic7502]

Can anyone please provide me with the query syntax for the following report?

Workstation: All Workstations without Anti-virus

(This report is standard with Lansweeper, but somehow it is no longer showing up and I need to recreate it)
Thanks so much!
Mary

[Technut27]

I second this one. Could be very useful for doing user hardware audits.

[magic7502]

Great- thanks so much! 🙂

[Hemoco]

You can recreate the report using the information below.

View Name
workstationwithoutantivirus

Report Name
Workstation: All workstations without Anti-virus software

SQL Code

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblComputers.Description, tblComputers.Lastseen, Web40OSName.Compimage As icon From tblComputers Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where tblComputers.Computername Not In (Select tblSoftware.ComputerName From tblSoftware Cross Join tsysantivirus Where tblSoftware.softwareName Like tsysantivirus.Software) And tblComputersystem.Domainrole < 2 Order By dbo.tblComputers.Computer