{ "code" : 200, "msg" : "Success", "data" : { "total" : 1, "pageSize" : 30, "pages" : 1, "pageNo" : 1, "list" : [ { "resultId" : 19259, "resultName" : "linkedin-IGW linkedin-IGW/PE/GGSN", "jobId" : 249, "chartId" : 285, "jobUuid" : "9be1d348-b959-46dd-a549-241c532ef9a1", "startTime" : "2022-08-30T10:31:41Z", "endTime" : "2022-09-06T10:31:41Z", "querySql" : "select FROM_UNIXTIME(\"Start Time\") as \"Start Time\" ,\"Device Group\" as \"Device Group\" , sum(\"Sessions\") as \"Sessions\" from (select common_device_group as \"Device Group\" ,TIME_FLOOR_WITH_FILL (common_start_time,'PT1H','zero') as \"Start Time\" ,sum(common_sessions) as \"Sessions\" from session_record where ((common_recv_time >= UNIX_TIMESTAMP('2022-08-30 10:31:41') and common_recv_time < UNIX_TIMESTAMP('2022-09-06 10:31:41')) AND ( ( common_device_group = 'BOL-IGW' OR common_device_group = 'SSM-IGW' OR common_device_group = 'MWV-IGW' OR common_device_group = 'BJR-IGW' OR common_device_group = 'DIR-IGW' ) ) and common_device_group IN ( select common_device_group from session_record where (common_recv_time >= UNIX_TIMESTAMP('2022-08-30 10:31:41') and common_recv_time < UNIX_TIMESTAMP('2022-09-06 10:31:41'))AND ( ( common_device_group = 'BOL-IGW' OR common_device_group = 'SSM-IGW' OR common_device_group = 'MWV-IGW' OR common_device_group = 'BJR-IGW' OR common_device_group = 'DIR-IGW' ) ) group by common_device_group order by sum(common_sessions) desc limit 10) ) group by \"Device Group\",\"Start Time\") group by \"Start Time\" ,\"Device Group\" order by \"Start Time\" asc ", "status" : 2, "excuteTime" : 276834, "excuteRow" : 206686766968, "excuteProcess" : 100, "resultRows" : 1155, "excuteDetail" : "SUCCESS", "isSendNotice" : 3, "opTime" : "2022-09-06T10:39:45Z", "issuedTime" : "2022-09-06T10:31:41Z", "timeGranularity" : 3600, "chartType" : "line", "jobName" : "linkedin-IGW", "isValid" : 1, "createTime" : "2022-09-06T10:31:41Z", "opUser" : 6, "opUserName" : "admin", "isDisplayTrafficTrend" : 0, "timeZone" : "Africa/Addis_Ababa", "vsysId" : 1 } ] }, "success" : true }