【APM】获取所有服务器监控的所有进程清单

【APM】获取所有服务器监控的所有进程清单

1.设置->支持->数据库摘要

2.执行查询语句即可获取所有监控内服务器监控的进程清单：
SELECT pmo.RESOURCEID,pmo.DISPLAYNAME as MONITOR,cmo.DISPLAYNAME as PROCESS FROM AM_ManagedObject pmo INNER JOIN AM_ManagedResourceType mrt ON pmo.TYPE = mrt.RESOURCETYPE and mrt.RESOURCEGROUP = 'SYS' INNER JOIN AM_PARENTCHILDMAPPER pcm on pcm.PARENTID = pmo.RESOURCEID INNER JOIN AM_ManagedObject cmo ON cmo.RESOURCEID = pcm.CHILDID AND cmo.TYPE in ('Process') order by 1,2