Find Workstations Which Have Automatic Services That Are Stopped
Most services on a machine will automatically start as this is configured during the software's installation. Services can be stopped for various reasons, but usually, services set to automatically start are not often stopped. One particular case to look out for is security related services. You will obviously want that these are running at all times. Additionally, malware, viruses or hackers will often attempt to stop these services as they can interfere.
Automatic Services Which Are Stopped on Workstations Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblAssets.Description, tblServicesUni.Caption, tblServices.Lastchanged, tsysOS.Image As icon From tblServices Inner Join tblAssets On tblServices.AssetID = tblAssets.AssetID Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Inner Join tblServicesUni On tblServices.ServiceuniqueID = tblServicesUni.ServiceuniqueID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblComputersystem.Domainrole < 2 And tblServices.StartID = 3 And tblServices.StateID = 1 And tblAssetCustom.State = 1 Order By tblAssets.AssetName