Report: Windows computers not running a certain service

[PGarridoN]

Hello, I'm creating a report that reads all Windows computers and uses a subquery to tell me which Windows computers have a certain service running.
What I really need is to list the computers that don't have that service running.
And I can't find the report code.
Here's what I've done:

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
SubConsulta1.AssetName
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where (tsysassettypes.AssetTypename = 'Windows' And tblassetcustom.State = 1) and
NotExitst ( Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tblServicesUni.Name,
tsysAssetTypes.AssetTypename
From tblassets
Inner Join tblServices On tblassets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblassets.Assettype
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Where tblServicesUni.Name = 'CmRcService' And tsysAssetTypes.AssetTypename =
'Windows' And tblAssetCustom.State = 1 ) SubConsulta1
Right Join tblAssets On tblAssets.AssetName = SubConsulta1.AssetName

[Mister_Nobody]

Can't run your report.

[PGarridoN]

I know, that's why I'm looking for the mistake, which I can't find.

[PGarridoN]

I have already found the solution and it works for me.

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where tblassets.AssetName Not In (Select Top 1000000 tblassets.AssetName
From tblassets Inner Join tblServices On tblassets.AssetID =
tblServices.AssetID Inner Join tblServicesUni On
tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblassets.Assettype Inner Join tblAssetCustom On tblassets.AssetID =
tblAssetCustom.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
And tblServicesUni.Name = 'Service_X') And tsysassettypes.AssetTypename = 'Windows' And
tblassetcustom.State = 1
Order By tblassets.AssetName