Custom SQL Query - Software not installed and scan ok
I would like to find all workstations without Symantec Antivirus, this query works, except that it also returns any workstation that has failed all scans. I need a query like this that is limited to workstations that have been successfully scanned.
select systeminfo.workstationname from systeminfo where systeminfo.workstationid NOT IN (select sys1.workstationid from systeminfo sys1 left join softwareinfo on sys1.workstationid=softwareinfo.workstationid left join softwarelist on softwareinfo.softwareid=softwarelist.softwareid where softwarelist.softwarename='Symantec AntiVirus')
select systeminfo.workstationname from systeminfo where systeminfo.workstationid NOT IN (select sys1.workstationid from systeminfo sys1 left join softwareinfo on sys1.workstationid=softwareinfo.workstationid left join softwarelist on softwareinfo.softwareid=softwarelist.softwareid where softwarelist.softwarename='Symantec AntiVirus')