Services

[cojast]

I am trying to figure out how i can get a list of all computers that have a certain service turned on. I am sure there is probably a report but i am either not seeing it or not understanding on how to create my own report.

Any help would be appreciated? I am using Lansweeper version 5079

[Hemoco]

A sample report can be seen below. Replace YourService with the name of the service you would like to report on. You can verify what the exact service name is in the Config\Windows\Services section of your assets' Lansweeper webpages.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblServicesUni.Caption,
tblServicesUni.Startname,
tblServiceStartMode.StartMode,
tblServiceState.State
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblServicesUni.Caption = 'YourService' And
tblServiceState.State = 'running'
Order By tblAssets.Domain,
tblAssets.AssetName

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• 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.
• The report will now also be listed under Dashboard\Reports\All Reports.