Report For Process Not Running - Symantec

[mrdaytrade]

This is what I have, but I would like to make a report of computers that are NOT running the smc.exe. What I have here reports back all the computers that have it running. New users here. great product. Thanks.

SELECT dbo.tblComputers.Computername, dbo.tblProcesses.Caption
FROM dbo.tblComputers INNER JOIN
dbo.tblProcesses ON dbo.tblComputers.Computername = dbo.tblProcesses.Computername
WHERE (dbo.tblProcesses.Caption = 'smc.exe')

[Hemoco]

Try something like :

SELECT dbo.tblComputers.Computername
FROM dbo.tblComputers where computername not in (select computername from dbo.tblprocess WHERE (dbo.tblProcesses.Caption = 'smc.exe') )
 

[mrdaytrade]

Excellent! Just had to fix a minor typo. Thank you very much.

SELECT dbo.tblComputers.Computername
FROM dbo.tblComputers where computername not in (select computername from dbo.tblprocesses WHERE (dbo.tblProcesses.Caption = 'smc.exe'))