【APM】报表导出时想要同步导出IP地址的解决办法

问题：在导出某监视器组的报表时，有时需要对具体监视器比如服务器或者网络设备的IP地址进行同步导出，但我们的报表功能暂时不支持该需求，因此我们可以使用数据库语句来解决。

解决办法：我们以导出监视器组的CPU使用率为例，具体操作步骤如下导航到App Manager UI->管理/设置->支持->数据库摘要->查询工具。执行以下查询：

SELECT mo.RESOURCEID,mo.DISPLAYNAME as MONITORNAME,col.TARGETADDRESS as IPADDRESS, COALESCE(hmo.DISPLAYNAME,'Not associated to Monitor Group') as "Monitor Group",cpu.MIN as CPU_MIN,cpu.MAX as CPU_MAX,cpu.avg as CPU_AVG FROM AM_ManagedObject mo INNER JOIN AM_ManagedResourceType mrt on mo.TYPE = mrt.RESOURCETYPE AND mrt.RESOURCEGROUP = 'SYS' INNER JOIN COLLECTDATA col ON col.RESOURCENAME = mo.RESOURCENAME LEFT JOIN AM_PARENTCHILDMAPPER pcm on pcm.CHILDID = mo.RESOURCEID LEFT JOIN AM_ManagedObject hmo ON hmo.RESOURCEID = pcm.PARENTID and hmo.TYPE = 'HAI' INNER JOIN (SELECT RESID,min(MINVALUE) as min,MAX(MAXVALUE) as max,(SUM(TOTAL)/SUM(TOTALCOUNT)) as avg FROM AM_CPU_MinMaxAvgData data INNER JOIN AM_ATTRIBUTES att on att.ATTRIBUTEID = data.ATTRIBUTEID and att.ATTRIBUTE = 'CPU Utilization' WHERE data.ARCHIVEDTIME > (EXTRACT(EPOCH FROM (CURRENT_DATE - INTERVAL '30 days')) * 1000::bigint) GROUP BY RESID) cpu ON cpu.RESID = mo.RESOURCEID where hmo.DISPLAYNAME='监视器组名称' order by 2