→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
renato_gabriel
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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