Create report to show service status (Windows Update)

[robsdroid215]

Hello,

I always keep 'Windows Update' service disabled on all my servers.

How can I write a report that would:

- list just servers
- Echo the Start Mode status of the 'Windows Update' service
- Echo the State of the Windows Update Service

Output would look like..

SRV - Start Mode - State
FS001 - Delayed Start - Started
FS002 - Disabled - Stopped

I did manage to put this together but it will only display the servers where the Windows update service is stopped.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.IPAddress,
tsysOS.Image As icon,
tblServicesUni.Caption,
tblServiceStartMode.StartMode,
tblServiceState.State
From tblAssets
Inner Join tblServices On tblAssets.AssetID = tblServices.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
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblServices.Started = 0 And tblServicesUni.Name = N'wuauserv' And
tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName

[robsdroid215 · Accepted solution]

I figured it out. Hope this helps someone else.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.IPAddress,
tsysOS.Image As icon,
tblServicesUni.Caption,
tblServiceStartMode.StartMode,
tblServiceState.State
From tblAssets
Inner Join tblServices On tblAssets.AssetID = tblServices.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
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblServicesUni.Name = N'wuauserv' And tblComputersystem.Domainrole > 1 And
tblAssetCustom.State = 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName