Find the Remote Desktop Services Status
Services are a core Windows function designed to enable the creation and management of long-running processes. The Remote Desktop Service is one of the components in Windows that allows you to take control of a remote or virtual machine over a network. Due to the increase of working from home, many people rely on RDS to perform their daily tasks so it is important to ensure that machines that need to be connected to have the service running and ones that do not, don't. Having RDS running on client machines that do not need to accept remote connections can also be seen as a security issue.
To help you get an overview of the RDS status, you can use the report below to get a list of all machines in your environment that have the Remote Desktop Services service (the name makes it a bit confusing). You can read more about the report's use case in the Pro Tips blog post.
Remote Desktop Services Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tsysOS.OSname As OS, tblServicesUni.Caption As [Service Name], tblServicesUni.Pathname As [Service Path], tblServiceStartMode.StartMode As [Service Start Mode], tblServiceState.State As [Service State], Case When tblErrors.ErrorText Is Not Null Or tblErrors.ErrorText != '' Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg Else '' End As ScanningErrors, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner join tblServices on tblServices.AssetID = tblassets.AssetID Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID Inner Join tblServiceStartMode On tblServiceStartMode.StartID = tblServices.StartID Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Max(tblErrors.Teller) As ErrorID From tblErrors Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = ScanningError.ID Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype = tblErrors.ErrorType Where tblState.Statename = 'Active' and tblServicesuni.Name = 'termservice' Order By tblAssets.Domain, tblAssets.AssetName