How to report on service startup type - Automatic (Delayed Start)

[Chris1]

I am attempting to create a report showing all servers with the Remote Registry service status is "stopped" and the startup type. The Startup Type is showing up in the resulting report as "Auto".. I need to determine if the startup Type is set to Automatic (Delayed start).


How do I go about creating a report showing all servers with the Remote Registry service is currently stopped and if the Startup Type is set to Automatic (Delayed Start)

So far I can only get a report to show the Startup Type as "Auto".

[Daniel_B · Accepted solution]

We query services from WMI which doesn't distinguish "Automatic" and "Automatic (Delayed)" unfortunately (at least not on all OS versions). The following report lists the status and startup mode of remote registry service on all servers:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Lastseen,
  tblServicesUni.Caption,
  tblServicesUni.Name,
  tblServiceState.State,
  tblServiceStartMode.StartMode,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
  Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
  Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
    tblServices.ServiceuniqueID
  Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
    tblServices.StartID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblServicesUni.Caption Like '%remote registry%' And tblAssetCustom.State =
  1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName