Kickin the tires - Need some guidance

[Chris1]

Hello,

I need some assistance creating a report(s).. I am trying to create a report polling only Servers..

"wuaserv" Windows Update service
"remoteregistry" Remote Registry service

I need to know the startup type (Manual\Automatic\Automatic (Delayed Start)\Disabled

and service status (Started \ Stopped \ Paused) or (Enabled \ Disabled)

I appreciate any assistance!

[Daniel_B · Accepted solution]

Data about services is stored in multiple tables. tblServices is stores asset-specific data while tblServicesUni, tblServiceState and tblServiceStartMode store lookup information.
If you would like to report on servers only, add tblComputersystem to your report, select tblComputersystem.Domainrole and enter a criterion on this field. It is > 1 for servers.

Please find an example report below:

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