Find computers on which specific software is NOT installed.

[physh]

Hi,
I've been trying to create a report to find which computers don't have antivirus software installed but I can't figure out how. Has anyone tried that yet?

Thanks

[physh]

Nevermind...

Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Username From dbo.tblComputers Where dbo.tblComputers.Computername Not In (Select dbo.tblsoftware.ComputerName From dbo.tblsoftware Where dbo.tblsoftware.softwareName = '%Anti-Virus%') Order By dbo.tblComputers.Computer