chore: dev-3.9 分支, system_version=23.10rel-23.10.06

1 files changed, 1 insertions, 1 deletions

diff --git a/nz-admin/src/main/resources/db/R__AZ_sys_config.sql b/nz-admin/src/main/resources/db/R__AZ_sys_config.sql
index 0724329c..b3ada198 100644
--- a/nz-admin/src/main/resources/db/R__AZ_sys_config.sql
+++ b/nz-admin/src/main/resources/db/R__AZ_sys_config.sql
@@ -45,7 +45,7 @@ REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`)
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'snmp_exporter_prometheus_host', '127.0.0.1', 1, NULL);
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'blackbox_exporter_prometheus_scheme', 'http', 1, NULL);
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'blackbox_exporter_prometheus_host', '127.0.0.1', 1, NULL);
-REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'system_version', '23.07', 1, 'NZ系统版本');
+REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'system_version', '23.10', 1, 'NZ系统版本');
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (NULL, 'prometheus_default_retention_time_when_s3', '1', 1, 'metrics 对象存储时普罗米修斯默认保留时间 单位: d');
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'interface_name', 'eth0,en0,bond0,ens2f0,enp0s31f6', 1, NULL);
 REPLACE INTO `sys_config`(`id`, `param_key`, `param_value`, `status`, `remark`) VALUES (null, 'stat_query_json', '[\r\n    {\r\n        \"name\": \"asset\",\r\n        \"datasql\": \"SELECT t.name as asset,t.*,atc.vm,atc.vmh,atc.NAME AS type,assc.NAME AS state,ab.NAME AS brand,am.NAME AS model,dc.NAME AS datacenter,cabinet.NAME AS cabinet,(CASE ap.`status` WHEN 1 THEN \'Up\' WHEN 0 THEN \'Down\' ELSE \'Suspended\' END) AS ping,(CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END) AS alert_message_count,(CASE WHEN mc.c IS NULL THEN 0 ELSE mc.c END) AS endpoint_count FROM asset_asset t LEFT JOIN asset_type_conf atc ON t.type_id=atc.id LEFT JOIN asset_state_conf assc ON t.state_id=assc.id LEFT JOIN asset_brand ab ON t.brand_id=ab.id LEFT JOIN asset_model am ON t.model_id=am.id LEFT JOIN dc ON t.dc_id=dc.id LEFT JOIN cabinet ON t.cabinet_id=cabinet.id LEFT JOIN asset_ping ap ON t.id=ap.asset_id LEFT JOIN (SELECT asset_id,count(1) AS c FROM alert_message_active ama WHERE ama.asset_id IS NOT NULL GROUP BY asset_id) amc ON amc.asset_id=t.id LEFT JOIN (SELECT asset_id,count(1) AS c FROM monitor_endpoint me GROUP BY asset_id) mc ON mc.asset_id=t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"ping\",\r\n                \"expr\": \"ping\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"asset_type\",\r\n                \"expr\": \"type\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"asset_state\",\r\n                \"expr\": \"state\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"brand\",\r\n                \"expr\": \"brand\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"model\",\r\n                \"expr\": \"model\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"expr\": \"datacenter\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"cabinet\",\r\n                \"expr\": \"cabinet\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"expr\": \"asset\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"endpoint_sum\",\r\n                \"expr\": \"sum(endpoint_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_datacenter_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"dc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"dc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"dc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"dc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset type\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_type_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"atc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"atc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"atc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"atc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset state\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_state_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"assc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"assc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"assc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"assc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset brand\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_brand_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"ab.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"ab.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"ab.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"ab.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset model\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_model_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"am.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"am.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"am.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"am.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"id\",\r\n                \"type\": 1,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \"\\\\d+\",\r\n                        \"tip\": \"filter_asset_id_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \">\",\r\n                        \"expr\": \"t.id > {{value}}\"\r\n                    },\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.id = {{value}}\"\r\n                    },\r\n                    {\r\n                        \"name\": \"<\",\r\n                        \"expr\": \"t.id < {{value}}\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.id != {{value}}\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"datacenter\",\r\n        \"datasql\": \"SELECT t.id,t.name as datacenter,(CASE WHEN cc.c IS NULL THEN 0 ELSE cc.c END) AS cabinet_count,(CASE WHEN ac.c IS NULL THEN 0 ELSE ac.c END) AS asset_count,(CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END) AS alert_message_count FROM dc t LEFT JOIN (SELECT dc_id,count(1) AS c FROM cabinet GROUP BY dc_id) cc ON cc.dc_id=t.id LEFT JOIN (SELECT dc_id,count(1) AS c FROM asset_asset GROUP BY dc_id) ac ON ac.dc_id=t.id LEFT JOIN (SELECT dc_id,count(1) AS c FROM alert_message_active ama WHERE ama.dc_id IS NOT NULL GROUP BY dc_id) amc ON amc.dc_id=t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"expr\": \"datacenter\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"cabinet_sum\",\r\n                \"expr\": \"sum(cabinet_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"asset_sum\",\r\n                \"expr\": \"sum(asset_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_datacenter_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"project\",\r\n        \"datasql\": \"SELECT t.id,t.name as project,(CASE WHEN mm.c IS NULL THEN 0 ELSE mm.c END) AS module_count,(CASE WHEN aec.c IS NULL THEN 0 ELSE aec.c END) AS endpoint_count,(CASE WHEN aec.ac IS NULL THEN 0 ELSE aec.ac END) AS asset_count,(CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END) AS alert_message_count FROM monitor_project t LEFT JOIN (SELECT project_id,count(1) AS c FROM monitor_module GROUP BY project_id) mm ON mm.project_id=t.id LEFT JOIN (SELECT project_id,count(1) AS c FROM alert_message_active ama WHERE ama.project_id IS NOT NULL GROUP BY project_id) amc ON amc.project_id=t.id LEFT JOIN (SELECT project_id,count(1) AS c,count(DISTINCT e.asset_id) AS ac FROM monitor_endpoint e LEFT JOIN monitor_module m ON m.id=e.module_id GROUP BY m.project_id) aec ON aec.project_id=t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"expr\": \"project\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"module_sum\",\r\n                \"expr\": \"sum(module_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"endpoint_sum\",\r\n                \"expr\": \"sum(endpoint_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"asset_sum\",\r\n                \"expr\": \"sum(asset_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_project_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"module\",\r\n        \"datasql\": \"SELECT t.id,t.NAME AS module,mp.NAME AS project,(CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END) AS alert_message_count,(CASE WHEN mc.c IS NULL THEN 0 ELSE mc.c END) AS endpoint_count,(CASE WHEN mc.ac IS NULL THEN 0 ELSE mc.ac END) AS asset_count FROM monitor_module t LEFT JOIN monitor_project mp ON t.project_id=mp.id LEFT JOIN (SELECT module_id,count(1) AS c FROM alert_message_active ama WHERE ama.module_id IS NOT NULL GROUP BY module_id) amc ON amc.module_id=t.id LEFT JOIN (SELECT module_id,count(1) AS c,count(DISTINCT asset_id) AS ac FROM monitor_endpoint me GROUP BY module_id) mc ON mc.module_id=t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"expr\": \"project\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"expr\": \"module\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"endpoint_sum\",\r\n                \"expr\": \"sum(endpoint_count)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"asset_sum\",\r\n                \"expr\": \"sum(asset_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_project_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"mp.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"mp.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"mp.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"mp.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_module_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"endpoint\",\r\n        \"datasql\": \"SELECT \\tt.NAME AS endpoint, \\tt.*, \\tmm.NAME AS module, \\tmp.NAME AS project, \\tdc.NAME AS datacenter, \\taa.NAME AS asset, \\tatc.vm, \\tatc.vmh, \\tatc.NAME AS type, \\tassc.NAME AS state, \\tab.NAME AS brand, \\tam.NAME AS model, \\tcabinet.NAME AS cabinet, \\t( CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END ) AS alert_message_count FROM \\tmonitor_endpoint t \\tLEFT JOIN monitor_module mm ON t.module_id = mm.id \\tLEFT JOIN monitor_project mp ON mm.project_id = mp.id \\tLEFT JOIN asset_asset aa ON t.asset_id = aa.id \\tLEFT JOIN asset_type_conf atc ON aa.type_id = atc.id \\tLEFT JOIN asset_state_conf assc ON aa.state_id = assc.id \\tLEFT JOIN asset_brand ab ON aa.brand_id = ab.id \\tLEFT JOIN asset_model am ON aa.model_id = am.id \\tLEFT JOIN dc ON aa.dc_id = dc.id \\tLEFT JOIN cabinet ON aa.cabinet_id = cabinet.id \\tLEFT JOIN asset_ping ap ON aa.id = ap.asset_id \\tLEFT JOIN ( SELECT endpoint_id, count( 1 ) AS c FROM alert_message_active ama WHERE ama.endpoint_id IS NOT NULL GROUP BY endpoint_id ) amc ON amc.endpoint_id = t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"expr\": \"project\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"expr\": \"module\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"expr\": \"datacenter\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"expr\": \"asset\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"endpoint\",\r\n                \"expr\": \"endpoint\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_project_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"mp.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"mp.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"mp.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"mp.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_module_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"mm.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"mm.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"mm.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"mm.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"endpoint\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_endpoint_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_datacenter_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"dc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"dc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"dc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"dc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"aa.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"aa.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"aa.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"aa.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"alert rule\",\r\n        \"datasql\": \"SELECT t.id,t.NAME AS \'alertRule\',(CASE t.state WHEN 1 THEN \'Enabled\' WHEN 0 THEN \'Disabled\' ELSE \'Unkown\' END) AS state,(CASE t.type WHEN 1 THEN \'Metrics\' WHEN 2 THEN \'Logs\' WHEN 3 THEN \'SNMPTRAP\' ELSE \'Unkown\' END) AS typename,(CASE WHEN amc.c IS NULL THEN 0 ELSE amc.c END) AS alert_message_count FROM alert_rule t LEFT JOIN (SELECT rule_id,count(1) AS c FROM alert_message_active ama WHERE ama.rule_id IS NOT NULL GROUP BY rule_id) amc ON amc.rule_id=t.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"type\",\r\n                \"expr\": \"typename\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"state\",\r\n                \"expr\": \"state\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"alert_rule\",\r\n                \"expr\": \"alertRule\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"alert_message_sum\",\r\n                \"expr\": \"sum(alert_message_count)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"alert rule\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_alert_rule_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"t.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"t.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"t.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"t.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"alert message\",\r\n        \"datasql\": \"SELECT t.id,t.asset_id,t.endpoint_id,t.rule_id,t.project_id,t.module_id,t.dc_id,alsc.NAME AS severity,ar.NAME AS alert,(CASE ar.type WHEN 1 THEN \'Metrics\' WHEN 2 THEN \'Logs\' WHEN 3 THEN \'SNMPTRAP\' ELSE \'Unkown\' END) AS alertType,mp.NAME AS project,mm.NAME AS module,me.NAME AS endpoint,aa.NAME AS asset,dc.NAME AS datacenter FROM alert_message_active t LEFT JOIN alert_rule ar ON t.rule_id=ar.id LEFT JOIN monitor_project mp ON t.project_id=mp.id LEFT JOIN monitor_module mm ON t.module_id=mm.id LEFT JOIN monitor_endpoint me ON t.endpoint_id=me.id LEFT JOIN asset_asset aa ON t.asset_id=aa.id LEFT JOIN dc ON t.dc_id=dc.id LEFT JOIN alert_severity_conf alsc ON t.severity_id=alsc.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"expr\": \"datacenter\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"project\",\r\n                \"expr\": \"project\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"expr\": \"module\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"endpoint\",\r\n                \"expr\": \"endpoint\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"expr\": \"asset\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"alert_rule\",\r\n                \"expr\": \"alert\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"priority\",\r\n                \"expr\": \"severity\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_asset\",\r\n                \"expr\": \"count(DISTINCT  t.asset_id)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_datacenter\",\r\n                \"expr\": \"count(DISTINCT  t.dc_id)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_project\",\r\n                \"expr\": \"count(DISTINCT  t.project_id)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_module\",\r\n                \"expr\": \"count(DISTINCT  t.module_id)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_endpoint\",\r\n                \"expr\": \"count(DISTINCT  t.endpoint_id)\",\r\n                \"type\": 1\r\n            },\r\n            {\r\n                \"name\": \"affected_alert_rule\",\r\n                \"expr\": \"count(DISTINCT  t.rule_id)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"project\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_project_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"mp.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"mp.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"mp.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"mp.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"module\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_module_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"mm.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"mm.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"mm.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"mm.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"endpoint\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_endpoint_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"me.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"me.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"me.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"me.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_datacenter_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"dc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"dc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"dc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"dc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"asset\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_asset_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"aa.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"aa.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"aa.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"aa.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"priority\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_priority_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"alsc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"alsc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"alsc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"alsc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            },\r\n            {\r\n                \"name\": \"alert rule\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_alert_rule_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"ar.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"ar.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"ar.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"ar.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    },\r\n    {\r\n        \"name\": \"agent\",\r\n        \"datasql\": \"SELECT \\tt.id, \\tt.type, \\t( CASE t.STATUS WHEN 1 THEN \'Up\' ELSE \'Down\' END ) AS STATUS, \\t( CASE t.type WHEN 1 THEN \'Global\' WHEN 2 THEN \'Per-datacenter\' ELSE \'Unkown\' END ) AS typename, \\tdc.NAME AS datacenter FROM \\tagent t \\tLEFT JOIN dc ON t.dc_id = dc.id\",\r\n        \"group\": [\r\n            {\r\n                \"name\": \"type\",\r\n                \"expr\": \"type\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"state\",\r\n                \"expr\": \"status\",\r\n                \"type\": 2\r\n            },\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"expr\": \"datacenter\",\r\n                \"type\": 2\r\n            }\r\n        ],\r\n        \"select\": [\r\n            {\r\n                \"name\": \"count\",\r\n                \"expr\": \"count(1)\",\r\n                \"type\": 1\r\n            }\r\n        ],\r\n        \"filter\": [\r\n            {\r\n                \"name\": \"datacenter\",\r\n                \"type\": 2,\r\n                \"rule\": [\r\n                    {\r\n                        \"regex\": \".+\",\r\n                        \"tip\": \"filter_datacenter_is_null\"\r\n                    }\r\n                ],\r\n                \"opers\": [\r\n                    {\r\n                        \"name\": \"=\",\r\n                        \"expr\": \"dc.name = \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"~=\",\r\n                        \"expr\": \"dc.name like \'%{{value}}%\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!=\",\r\n                        \"expr\": \"dc.name != \'{{value}}\'\"\r\n                    },\r\n                    {\r\n                        \"name\": \"!~\",\r\n                        \"expr\": \"dc.name not like \'%{{value}}%\'\"\r\n                    }\r\n                ]\r\n            }\r\n        ]\r\n    }\r\n]', 1, NULL);