Exclude non scanned computers from report

[jaekob]

Hi!

I use this query to list computers without our antivirus:

Select tblcomputers.Computername From tblcomputers Where tblcomputers.Computername Not In (Select dbo.tblSoftware.ComputerName From dbo.tblSoftware Where dbo.tblSoftware.softwareName Like 'Trend Micro OfficeScan Client')

I would like to exclude the computers where the software never has been scanned (we still have some..).

Anyone got any ideas how to do this?

Cheers

[jaekob]

Works great!

Thanks!

[Hemoco]

Select tblcomputers.Computername From tblcomputers Where (tblcomputers.Computername Not In (Select dbo.tblSoftware.ComputerName From dbo.tblSoftware Where dbo.tblSoftware.softwareName Like 'Trend Micro OfficeScan Client')) and (computername in (select computername from tblsoftware))