Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 02:15 PM
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.
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.
Labels:
- Labels:
-
Report Center
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 06:41 PM
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:
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