- Download Diff

Summary:

AE-2130: SSLVPN Service API's

Review Request #1070 — Created Sept. 22, 2025 and submitted Sept. 23, 2025, 6:54 p.m.

Information
Owner:	apoorva.sn
Repository:	AMP
Branch:	amp_4_0
Bugs:	AE-2130
Depends On:
Reviewers
Groups:
People:	pmurugaiyan, shuinvy, timsu

Description

Problem

Create new API for Monitoring-SSLVPN Service for getting data from Timescale DB

Solution

Have created new endpoint /ssl_vpn for getting the data for Monitoring- SSL VPN data.
Also have added logic to query the Timscale DB for getting the respective information

Testing Done

SSLVPN Stats

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: uslN24161guxE7b8a3acMaRyKiyVeYLl' \
-b 'csrftoken= uslN24161guxE7b8a3acMaRyKiyVeYLl; hive_key=1; django_language=en; csrf_token= uslN24161guxE7b8a3acMaRyKiyVeYLl; current_user=array; hive_sess=52ec7acd-8614-4132-ae76-e470a7942a3a' \
--data-raw '{
"stat_name": "active_sessions",
"agent_host": "192.168.162.166",
"interval": "20s",
"from": "now-15m",
"to": "now"
}'
{"status": 200, "message": "success", "data": []}

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: nPiafxFWoxCJgBQI3sZ0kr71rDhdPL7K' \
-b 'csrftoken=nPiafxFWoxCJgBQI3sZ0kr71rDhdPL7K; hive_key=1; django_language=en; csrf_token=nPiafxFWoxCJgBQI3sZ0kr71rDhdPL7K; current_user=array; hive_sess=7acd122c-0e4c-47ba-8eb5-0c32ae38038a' \
--data-raw '{
"stat_name": "login_status",
"agent_host": "192.168.162.88",
"interval": "20s",
"from": "now-8h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-19T12:02:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:03:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:03:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:03:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:04:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:04:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:04:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:05:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:05:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:05:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:06:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"}, {"ts": "2025-09-19T12:06:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "success": "0", "failure": "0", "error": "0", "locked": "0", "rejected": "0"},

Client Throughput:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: 0LSAo9uGLlN8MJefV1aLt6iUpThZyfoc' \
-b 'csrftoken=0LSAo9uGLlN8MJefV1aLt6iUpThZyfoc; hive_key=1; django_language=en; csrf_token=0LSAo9uGLlN8MJefV1aLt6iUpThZyfoc; current_user=array; hive_sess=b5f35246-5318-4ca6-aade-63cce088fb7a' \
--data-raw '{
"stat_name": "net_thoughput",
"agent_host": "192.168.162.88",
"interval": "20s",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T05:17:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:18:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:18:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:18:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:19:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:19:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:19:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:20:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:20:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:20:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:21:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:21:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:21:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:22:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:22:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:22:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:23:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:23:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:23:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:24:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:24:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:24:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:25:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:25:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:25:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:26:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:26:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:26:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:27:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:27:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"}, {"ts": "2025-09-22T05:27:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0E-20", "nw_recv_bps": "0E-20"},
...
...
{"ts": "2025-09-22T20:16:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0", "nw_recv_bps": "0"}, {"ts": "2025-09-22T20:16:20+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0", "nw_recv_bps": "0"}, {"ts": "2025-09-22T20:16:40+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0", "nw_recv_bps": "0"}, {"ts": "2025-09-22T20:17:00+05:30", "agent_host": "192.168.162.88", "id": "vsite1", "nw_sent_bps": "0", "nw_recv_bps": "0"}, {"ts": "2025-09-22T20:17:20+05:30", "agent_host": "192.168.162

l3 Tunnel Status:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' -X POST -H 'Accept: application/json, text/plain, /' -H 'Content-Type: application/json' -H 'X-CSRFToken: 5cK26xRHWaFUlNkNaD0vW10GQIpB4xTJ' -b 'csrftoken=5cK26xRHWaFUlNkNaD0vW10GQIpB4xTJ; hive_key=1; django_language=en; csrf_token=5cK26xRHWaFUlNkNaD0vW10GQIpB4xTJ; current_user=array; hive_sess=fb7032c8-878e-404c-95af-398d1e8347c9' --data-raw '{
"stat_name": "tunnel_status",
"agent_host": "192.168.162.88",
"from": "now-8h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"agent_host": "192.168.162.88", "id": "vsite1", "open": "0", "est": "0", "rejected": "0", "terminated": "0"}]}}

L3 VPN Throughput:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: sKdo3yYkJ146BRFkKUazjRYJPaQNFG5L' \
-b 'csrftoken=sKdo3yYkJ146BRFkKUazjRYJPaQNFG5L; hive_key=1; django_language=en; csrf_token=sKdo3yYkJ146BRFkKUazjRYJPaQNFG5L; current_user=array; hive_sess=5da88441-2cf3-4e2f-9d38-7226fb8e6007' \
--data-raw '{
"stat_name": "l3_vpn_throughput",
"agent_host": "192.168.162.88",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T05:13:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:14:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:15:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:16:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:17:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:18:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:19:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:20:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:21:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:22:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:23:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:24:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:25:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:26:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:27:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:28:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:29:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:30:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:31:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:32:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:33:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:34:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:43:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:44:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:45:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:46:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:47:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:48:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T05:49:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"},
...
...
{"ts": "2025-09-22T14:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T14:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T14:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T14:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}, {"ts": "2025-09-22T14:43:00", "agent_host": "192.168.162.88", "id": "vsite1", "vpn_sent_bps": "0.00", "vpn_recv_bps": "0.00"}]}}

L3 Client APP Throughput:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: bg7d2SsEVcKmoEB2yWc1V2eSMCdZFdAF' \
-b 'csrftoken=bg7d2SsEVcKmoEB2yWc1V2eSMCdZFdAF; hive_key=1; django_language=en; csrf_token=bg7d2SsEVcKmoEB2yWc1V2eSMCdZFdAF; current_user=array; hive_sess=d5a55e18-46ee-434b-ad86-7ae3cd45acae' \
--data-raw '{
"stat_name": "l3_client_app_throughput",
"agent_host": "192.168.162.88",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T05:12:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:13:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:14:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:15:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:16:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:17:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:18:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:19:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:20:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:21:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:22:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:23:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:24:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:25:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:26:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:27:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:28:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:29:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:30:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:31:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:32:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:33:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:34:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:43:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:44:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T05:45:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"},
....
....

{"ts": "2025-09-22T14:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T14:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T14:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T14:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}, {"ts": "2025-09-22T14:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_app_sent_bps": "0.00", "client_app_recv_bps": "0.00"}]}}

L7 Request Status:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: WWIBUZ8yxWAxmJA7mUr6zAnPuJURV27W' \
-b 'csrftoken=WWIBUZ8yxWAxmJA7mUr6zAnPuJURV27W; hive_key=1; django_language=en; csrf_token=WWIBUZ8yxWAxmJA7mUr6zAnPuJURV27W; current_user=array; hive_sess=fc86b30e-fdf6-4d33-89f4-ed94d58f864c' \
--data-raw '{
"stat_name": "l7_request_status",
"agent_host": "192.168.162.88",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T05:10:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "237.60"}, {"ts": "2025-09-22T05:11:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:12:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:13:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:14:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:15:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:16:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:17:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:18:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:19:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:20:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:21:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:22:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:23:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:24:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:25:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:26:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:27:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:28:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:29:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:30:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:31:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:32:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:33:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:34:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:43:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:44:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"}, {"ts": "2025-09-22T05:45:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "95.04"},
...
...
{"ts": "2025-09-22T14:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}, {"ts": "2025-09-22T14:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}, {"ts": "2025-09-22T14:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}, {"ts": "2025-09-22T14:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}, {"ts": "2025-09-22T14:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}, {"ts": "2025-09-22T14:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "sent_bps": "0.00", "recv_bps": "0.00"}]}}

L7 Client Throughput:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: D6Pcpelw8fPtwgBoZV94IQQYxvzAAtRp' \
-b 'csrftoken=D6Pcpelw8fPtwgBoZV94IQQYxvzAAtRp; hive_key=1; django_language=en; csrf_token=D6Pcpelw8fPtwgBoZV94IQQYxvzAAtRp; current_user=array; hive_sess=8e54bb58-bb21-48fe-a9e9-5c41700d51c5' \
--data-raw '{
"stat_name": "l7_client_throughput",
"agent_host": "192.168.162.88",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T04:40:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "0.00"}, {"ts": "2025-09-22T04:41:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:42:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:43:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:44:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:45:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:46:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:47:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:48:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:49:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:50:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:51:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:52:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:53:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:54:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:55:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:56:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:57:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:58:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T04:59:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:00:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:01:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:02:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:03:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:04:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:05:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:06:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:07:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:08:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:09:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:10:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:11:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:12:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:13:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"}, {"ts": "2025-09-22T05:14:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "95.04"},
...
...
{"ts": "2025-09-22T14:07:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "0.00"}, {"ts": "2025-09-22T14:08:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "0.00"}, {"ts": "2025-09-22T14:09:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "0.00"}, {"ts": "2025-09-22T14:10:00", "agent_host": "192.168.162.88", "id": "vsite1", "client_sent_bps": "0.00", "client_recv_bps": "0.00"}]}}

L7 Server Throughput:

[root@AN admin]# curl 'http://127.0.0.1:8000/ssl_vpn' \
-X POST \
-H 'Accept: application/json, text/plain, /' \
-H 'Content-Type: application/json' \
-H 'X-CSRFToken: bYjQcVc1wOL005NINrzpgeGAxVs3ugtt' \
-b 'csrftoken=bYjQcVc1wOL005NINrzpgeGAxVs3ugtt; hive_key=1; django_language=en; csrf_token=bYjQcVc1wOL005NINrzpgeGAxVs3ugtt; current_user=array; hive_sess=98cbd6cc-bd61-472f-8a99-181a2a336ebb' \
--data-raw '{
"stat_name": "l7_server_throughput",
"agent_host": "192.168.162.88",
"from": "now-15h",
"to": "now",
"vsite_id": "vsite1"
}'
{"status": 1, "data": {"status": 200, "message": "success", "data": [{"ts": "2025-09-22T05:09:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:10:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:11:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:12:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:13:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:14:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:15:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:16:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:17:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:18:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:19:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:20:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:21:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:22:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:23:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:24:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:25:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:26:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:27:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:28:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:29:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:30:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:31:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:32:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:33:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:34:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T05:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"},
...
...
{"ts": "2025-09-22T14:34:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T14:35:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T14:36:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T14:37:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T14:38:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}, {"ts": "2025-09-22T14:39:00", "agent_host": "192.168.162.88", "id": "vsite1", "server_sent_bps": "0.00", "server_recv_bps": "0.00"}]}}

Issues

Description	From	Last Updated
Can we metrics/stats keys to the path, The 'ssl_vpn' endpoint gives an impression that we are actually performing operations on …	pmurugaiyan	Sept. 23, 2025, 3:53 p.m.
Can you share the output for this return, I believe this returns 200 OK with error and message fields as …	pmurugaiyan	Sept. 23, 2025, 2:24 p.m.
General comment - Please make sure the type casting done properly, I could see string type values for numeric columns.	pmurugaiyan	Sept. 23, 2025, 3:51 p.m.
Can we reduce the interval to 10s to align with Telegraf and AMP3. 20s is on the higher side for …	pmurugaiyan	Sept. 23, 2025, 2:27 p.m.
update the file naming convention - all small case.	pmurugaiyan	Sept. 23, 2025, 2:28 p.m.
can we remove the repeated keys like status & data. While parsing we have to parase response.data.data -> instead can …	pmurugaiyan	Sept. 23, 2025, 3:51 p.m.

Ship it!

```
Ship It!
```

branches/amp_4_0/src/webui/webui/htdocs/new/src/djproject/urls.py (Diff revision 1)

Show all issues

Can we metrics/stats keys to the path, The 'ssl_vpn' endpoint gives an impression that we are actually performing operations on SSLVPN functionality.

apoorva.sn Sept. 23, 2025, 2:32 p.m.

this is not possible as it complains that the module is not present. for now we can continue with the current endpoint, later we can revisit the endpoints again as it will not be a major code change

pmurugaiyan Sept. 23, 2025, 2:40 p.m.
```
/ssl_vpn_metrics?
```
apoorva.sn Sept. 23, 2025, 3:56 p.m.
```
have updated to ssl_vpn_stats
```

branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/controller/ssl_vpn_stats.py (Diff revision 1)

Show all issues

Can you share the output for this return, I believe this returns 200 OK with error and message fields as provided. Instead, can we return the status code as 405 with the error message!

branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/db/ssl_vpn_stat_queries.py (Diff revision 1)

Show all issues

General comment - Please make sure the type casting done properly, I could see string type values for numeric columns.

apoorva.sn Sept. 23, 2025, 2:32 p.m.

yes have tested with the output response. As of now the values are coming properly.

pmurugaiyan Sept. 23, 2025, 2:40 p.m.

The attached CURL samples shows the numeric values in quotes - "0.00"

apoorva.sn Sept. 23, 2025, 3:56 p.m.

ya even after converting to BIGINT or numeric it is showing same.. will have to cast this explicitly in response..
will take care of this in next review with LLB

pmurugaiyan Sept. 23, 2025, 4:06 p.m.
```
Sure.
```

branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/db/ssl_vpn_stat_queries.py (Diff revision 1)

Show all issues

Can we reduce the interval to 10s to align with Telegraf and AMP3. 20s is on the higher side for the SNMP metrics.

apoorva.sn Sept. 23, 2025, 2:32 p.m.

this is just the default which is set if the interval is not provided. This value is not considered usually if we give the value. Also this interval time I considered as it was already present for some queries before.

pmurugaiyan Sept. 23, 2025, 2:40 p.m.

[agent]

  interval = "10s"

  round_interval = true

  metric_batch_size = 5000

  metric_buffer_limit = 50000

  collection_jitter = "0s"

  flush_interval = "10s"

  precision = ""

  hostname = "AN"

  omit_hostname = false

  skip_processors_after_aggregators = false

Our telegraf service collects data at 10s interval, if query uses different we may have discrepancies with the outcome for default interval.

apoorva.sn Sept. 23, 2025, 3:56 p.m.

No, it will not use 20s if the user provides a specific interval. The query will use the interval given by the user, so we can plot the graph according to what makes sense for our application. The 20s value is just the default when no interval is provided. Even if the default is used, it’s unlikely to make a significant difference in the graph, and using fewer points actually improves performance.

Do you know what interval is currently used in APV?

pmurugaiyan Sept. 23, 2025, 4:06 p.m.

I dont think the user uses the interval much, better we give the optimal interval via default value. Make sure the values are affected for the smaller time interval(from-to). APV dont use the Telegraf, you can check on the ASF.

apoorva.sn Sept. 23, 2025, 4:55 p.m.

But what is the interval they provide as our graphs have to be consistent with the APV graph data.
Do you have info on this

pmurugaiyan Sept. 23, 2025, 5 p.m.

In APV, the interval is not part of request, you can check /tsdb/query endpoint.

apoorva.sn Sept. 23, 2025, 5:44 p.m.

it is calculated with this logic

def Interval(self):

    interval = (self.ParseTo() - self.ParseFrom()) / 50

    rounded = roundInterval(interval)

    if rounded < 10:

        return 10

    return rounded

so for Eg now-15m the interval comes to 18 → 20 seconds which was what used earlier in AMP as default.

So for now we can keep 20s as default. i,e if the user does not provide the interval.

Later we can revisit this depending on feedback from QA

branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/services/ssl_vpn_stat_Service.py (Diff revision 1)

Show all issues

update the file naming convention - all small case.

apoorva.sn Sept. 23, 2025, 2:32 p.m.

it is updated properly in my local. some issue with svn diff. will make changes in next commit if it is not updated properly as part of this commit

branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/controller/slb_stats.py (Diff revision 1)

Show all issues

can we remove the repeated keys like status & data. While parsing we have to parase response.data.data -> instead can we simply use the response.data

Also what does status 1/0 signify! can we introduce error code instaed. success/failure can be derived from http status code itself.

pmurugaiyan Sept. 23, 2025, 2:40 p.m.

Can you do the same for all monitoring APIs to align the structure!

Diff:

Revision 2 (+687 -359)

Show changes

	branches/amp_4_0/src/__init__.py
	branches/amp_4_0/src/webui/__init__.py
	branches/amp_4_0/src/webui/webui/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/djproject/urls.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/device_metrics.py
	12 more

Diff:

Revision 3 (+683 -359)

Show changes

	branches/amp_4_0/src/__init__.py
	branches/amp_4_0/src/webui/__init__.py
	branches/amp_4_0/src/webui/webui/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/__init__.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/djproject/urls.py
	branches/amp_4_0/src/webui/webui/htdocs/new/src/hive/device_metrics.py
	12 more

Ship it!

```
Ship It!
```

You have a pending review.

Review Board 5.0.5

AE-2130: SSLVPN Service API's

Problem

Solution

SSLVPN Stats

Diff:

Diff:

Status: Closed (submitted)