
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2012 08:49 PM
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
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
Labels:
- Labels:
-
Archive
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-13-2012 10:06 PM
I second this one. Could be very useful for doing user hardware audits.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2012 09:13 PM
Great- thanks so much! 🙂

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2012 09:04 PM
You can recreate the report using the information below.
View Name
workstationwithoutantivirus
Report Name
Workstation: All workstations without Anti-virus software
SQL Code
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
