→ 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: 
nmjohns
Engaged Sweeper II
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.
1 REPLY 1
MikeMc
Champion Sweeper II
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