→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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

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

View solution in original post

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now