Request - Lansweeper report for computers without specific service

[nmjohns]

Looking to generate a report for all computers that are missing a specific service. The name of it is "Remote Access Service".

Could someone point me in the right direction? I tried looking at the tblServices but I'm not even sure that's the right table or if it is, how I'm supposed to use it.

[MikeMc]

The tblServices and tblServicesUni tables are where you want to look. The database dictionary is a very good reference for these kind of things, http://www.lansweeper.com/Forum/yaf_postsm38296_Lansweeper-database-dictionary.aspx#post38296

Here's a quick query:

Select tblAssets.AssetID,
  tblAssets.AssetName
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1 And
  Not Exists(Select tblServices.AssetID
  From tblServices Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
      tblServices.ServiceuniqueID
  Where tblServices.AssetID = tblAssets.AssetID And tblServicesUni.Caption =
    'Remote Access Service')
Order By tblAssets.AssetName