Services

[ckapustka7]

I was wondering if there was a report out there can tell me if a specific service is running on all servers in my environment. Starting with the remote registry service.

[Hemoco]

Please use the following report, change the word in red with the name of the domain that you want to filter on.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblServicesUni.Caption,
tblServiceState.State,
tblAssets.Domain
From tblAssets
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 tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblServicesUni.Caption Like 'remote registry' And
tblComputersystem.Domainrole > 1 And tblComputersystem.Domainrole > 1 And
tblAssets.Domain = 'name domain'

[bennavinet]

This was a huge help for me as well. How do I go about specifying a specific domain for Lansweeper to run the report in?

[ckapustka7]

Thanks! Works great.

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblServicesUni.Caption,
tblServiceState.State
From tblAssets
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 tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblServicesUni.Caption Like 'remote registry' And
tblComputersystem.Domainrole > 1 And tblComputersystem.Domainrole > 1


To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.