Notification

Icon
Error

Report service custon windows

Posted: Wednesday, January 20, 2021 1:03:09 PM(UTC)
diogo

diogo

Member Original PosterPosts: 2
0
Like
This issue has been solved! Click here to view the solution
Dear,


I would like to create a report with the status of a specific windows service, for example:

service: servicexxx status: running or stop startmode: enable, disable
Brandon
#1Brandon Member Posts: 90  
posted: 1/20/2021 4:09:57 PM(UTC)
This should work:
Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblServicesUni.Name As Service,
tblServices.Started,
tblServiceStartMode.StartMode
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
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Where tblServicesUni.Name = 'wscsvc' And tblAssetCustom.State = 1
Order By tblAssets.AssetName


The only line that you need to change is the name of the service in the line Where tblServicesUni.Name = 'wscsvc'

Active Discussions

Lansweeper Asset management/replacement
by  RC62N   Go to last post Go to first unread
Last post: 2/26/2021 6:30:22 PM(UTC)
Lansweeper Turn off graphical report builder
by  Tenacious   Go to last post Go to first unread
Last post: 2/23/2021 7:53:03 PM(UTC)
Report Center Reference software list
by  DeviantTomato   Go to last post Go to first unread
Last post: 2/23/2021 1:16:48 PM(UTC)
Lansweeper Report Filtering Uptime
by  CyberCitizen  
Go to last post Go to first unread
Last post: 2/22/2021 12:28:22 AM(UTC)
Lansweeper Adobe Report for CVE-2021-21017
by  baycrest   Go to last post Go to first unread
Last post: 2/10/2021 2:27:57 PM(UTC)
Lansweeper Need help with two reports
by  Andy.S  
Go to last post Go to first unread
Last post: 2/10/2021 10:15:42 AM(UTC)