Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Phil1960
Engaged Sweeper
Hello,
Can't find this in the forum and existing reports, neither in the assets detail.
I need to provide the list of installed and active windows services, could you help?
I can only find the reports for stopped services, so I believe it should be possible to have it all?
thanks. Regards.
Philippe
1 REPLY 1
Tom_P
Lansweeper Employee
Lansweeper Employee
To get a list of the services running on your Windows based assets, you can make use of the following SQL. Additional columns and/or filters can of course still be added.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblServicesUni/caption,
tblServicesUni.name,
tblServiceState.State
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblServices On tblServices.AssetID = tblAssets.AssetID
Inner Join tblServicesUni On tblServices.ServiceuniqueID = tblServicesUni.ServiceuniqueID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active'
Order By tblAssets.Domain, tblAssets.AssetName

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now