1. Click Reporting | Reports.
2. Click Choose Actions - New(SQL).
3. Enter Title Category and Description.
4. In the SQL field, enter the following script:
********** BEGIN SQL CODE ***********
select
D.NAME,
D.OS_NAME,
D.IP,
SRV.NAME,
SRV.PRODUCT_VERSION,
SRV.DISPLAY_NAME,
SRV.`STATUS`,
SRV.STARTUP_TYPE
from NTSERVICE SRV JOIN MACHINE_NTSERVICE_JT DSJT
ON SRV.ID=DSJT.NTSERVICE_ID JOIN MACHINE D
ON D.ID=DSJT.MACHINE_ID
WHERE SRV.NAME rlike 'ntservicename'
********** END SQL CODE ***********
# Replace ntservicename to actual name (e.g. AMPAgent )
5. Save the report.
