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 LSAgent Rescan Asset
by  marck1024   Go to last post Go to first unread
Last post: Yesterday at 4:11:53 PM(UTC)
Lansweeper Allowing a role to create asset groups
by  mh6543   Go to last post Go to first unread
Last post: 2/26/2021 10:00:40 PM(UTC)
Lansweeper Export LsAgent Assets
by  steveb  
Go to last post Go to first unread
Last post: 2/26/2021 7:26:32 PM(UTC)
Lansweeper Asset Uptime "Asset on total"
by  Andy.S   Go to last post Go to first unread
Last post: 2/26/2021 3:07:35 PM(UTC)
Lansweeper Scanning for Static Routes?
by  ChrisParr  
Go to last post Go to first unread
Last post: 2/26/2021 12:43:28 PM(UTC)
Lansweeper lansweeperuser sql database permissions
by  David K.   Go to last post Go to first unread
Last post: 2/25/2021 11:54:38 PM(UTC)
Lansweeper Scanning certificates
by  Vincent Pollock  
Go to last post Go to first unread
Last post: 2/25/2021 8:35:11 PM(UTC)