→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Chris1
Engaged Sweeper III
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".

1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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