
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2015 02:43 AM
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".
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".
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-21-2015 04:43 PM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-21-2015 04:43 PM
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
