Report to list all installed and active services

[Phil1960]

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

[Tom_P]

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