DLP Services Not Installed

[renato_gabriel]

I need a report of workstations and servers that does NOT have the EDPA service installed. At minimum I need the asset name and OS name.

[Hemoco · Accepted solution]

Please try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tsysOS.Image As icon,
tblServicesUni.Caption,
tblServicesUni.Name,
tblServicesUni.Pathname,
tblServicesUni.Startname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblAssets.AssetID NOT In (Select tblServices.AssetID
From tblServices Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Where (tblServicesUni.Name Like '%EDPA%') Or
(tblServicesUni.Caption Like '%EDPA%') Or
(tblServicesUni.Pathname Like '%EDPA%')) And tblAssetCustom.State = 1 And
tblAssets.Assettype = -1