Automatic Services Which Are Stopped on Servers

Find Servers Which Have Automatic Services That Are Stopped

Most services on a server will be set to automatically start as this is the default state for most software services when they are installed. 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 Servers 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 > 1 And tblServices.StartID = 3 And
  tblServices.StateID = 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting