Detect a certain service NOT installed

[jacobsenm]

Hi,

I am struggling finding a way to find all computers that does not have the following service installed:
SMS Agent Host

I need computername, username

Can anyone help ?

[jacobsenm]

Sorry

I have got it figured out:

SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Username,
dbo.tblComputers.Lastseen
FROM
dbo.tblComputers
WHERE
computername NOT IN (SELECT dbo.tblservices.computername FROM dbo.tblservices WHERE dbo.tblServices.Caption = 'SMS Agent Host')