Is there a way to do this?

[Cobra7]

Is there any way to get a report of who does not have software instead of who all does?

For example can we see who does not have an anti-virus program? Can we see who does not have Adobe 8.12 so we know who to upgrade?

Pretty much I am looking for a reverse list. Any thoughts?

[Hemoco]

You can create any view you like

Should be something like this:

select computername from tblcomputers where computername not in (select computername from tblsoftware where softwarename = 'somesoftware')