SQL Query Management

Manage Top Rtp Connections query

Endpoints

Execute query to retrieve data from the database. The response is unique UUID which supposed to be used for requesting results of the query.
- Path: /api/chf/tables/top_rtp_connections
- Method: POST
- Request body:
```
  {
    [mandatory] "limit": 1..10000,
    [optional] "from_timestamp": 1731589380,
    [optional] "to_timestamp": 1731589680,
    [optional] "order_by" : "column_name",
    [optional] "sort_order" : "desc",
    [optional] "selected_columns" : ["column_name1", "column_name2", ... , "column_nameX"],
    [optional] "filter_clause": "rtp_ip_client = '192.168.1.1' AND rtp_ip_server = '10.0.0.5'",
    [optional] "group_by": ["rtp_ip_client", "rtp_ip_server"],
    [optional] "settings":
    {
        "max_execution_time": 5.0,
        "timeout_overflow_mode": "throw"
    }
  }
```
- Response:
```
  {
    "message": "Success",
    "data": {
      "uuid": "c8144dc6-8aa0-ae89-1550-542cff5c3bab"
    }
  }
```
- if from_timestamp is not provided or is null, the minimum value is used.
- if to_timestamp is not provided or is null, the maximum value is used.
- limit must be in a range 1...10000.
- selected_columns - specified list of columns, which FE wants to receive in the response. If selected_columns is null, the back-end will treat this as a request for columns selected by default for this endpoint (has property is_selected = true).
- order_by is the name of the column used to sort the results. Must be presented in selected_columns.
- sort_order specifies the sorting direction and can be either asc for ascending or desc for descending order.
- either all the parameters selected_columns, order_by, and sort_order must be provided, or none of them should be.
- filter_clause Optional condition to further filter which rows are returned.
- group_by specifies the columns used for grouping. Default is ["rtp_ip_client", "rtp_ip_server"]. Accepts either a single string or an array of strings.
- settings defines a query execution time policy. If a query exceeds the specified maximum execution time, it is interrupted, and an error is returned to the FE. Otherwise, the query will be executed again, and the results will be available as usual.
  - max_execution_time: specifies the maximum allowed time in seconds before a query is interrupted.
  - timeout_overflow_mode: controls the behavior when a query exceeds the specified max_execution_time during execution. It supports the following options:
    - throw: The query is terminated and a 412 Precondition Failed error is returned.
    - break: The query is terminated but no error is returned. When the FE requests data, the BE returns no data.
If RTP analysis was disabled for the time range in [from_timestamp, to_timestamp] then the error 412 Precondition Failed should be returned immediately on POST request with the following JSON body:
```
        ```json
        {
          "message": "RTP analysis is disabled for the specified time range",
          "data": null
        }
        ```
```
Get next page by UUID.
- Path: /api/chf/tables/top_rtp_connections/{uuid}
- Method: GET
- Path parameter:
  - uuid - received from the previous request
- Response:
```
{
  "message": "Success",
  "data": {
      "state": "no_page_no_processing",
      "columns": [
          {
              "name": "rtp_ip_client",
              "type": "ip_address",
              "sort_order": null,
              "is_selected": true,
              "is_enabled": true,
              "is_sortable": false,
              "is_suggestable": true,
              "is_static": true,
              "link_details": true,
              "is_filterable": true,
              "filter_options": {
                  "filter_operators": [
                      "=",
                      "!=",
                      "IN-CIDR",
                      "NOT-IN-CIDR",
                      "IN-RANGE",
                      "NOT-IN-RANGE"
                  ]
              },
              "is_groupable": true
          },
          ...
      ],
      "page": [
          {
              "rtp_ip_client": "192.168.1.100",
              "rtp_ip_server": "10.0.0.5",
              "rtp_total_sent_packets": 125000,
              "rtp_total_lost_packets_ratio": 0.02
          },
          ...
      ]
   }
}
```
- columns - a list of properties defining all supported columns:
  - name - the name of the column in the database.
  - type - the data type represented by the column (e.g., string, number_bytes, number_units, etc.).
  - sort_order - specifies the sorting direction. Possible values are asc for ascending, desc for descending order and null for columns not used for sorting.
  - is_selected - indicates whether the column is included in the results.
  - is_enabled - indicates whether the column can be selected.
  - is_sortable - indicates whether the column can be used for sorting data.
  - is_suggestable - indicates whether the column can be used for suggestion queries.
  - is_static - indicates that the column is always included in the results and should not be specified in selected_columns.
  - link_details - indicates that the column values are clickable on dashboards.
  - is_filterable - denotes that this column can be used in a filter_clause field of the request.
  - filter_options - not NULL only if is_filterable = true and contains the following fields:
    - filter_operators - a list of operators which can be used when filtering against this column; it includes SQL operators such as =, !=, LIKE, ILIKE etc.
  - is_groupable - denotes that this column can be used in a group_by field of the request.
  - is_hidden - if true, the column is not visible to the user but may be used internally.
  - threshold - optional threshold values for ratio columns.
  - column_group_tag - optional list of tags for grouping related columns.
- state one of:
  - has_next - there is the next page, it can asked for immediately
  - no_page_processing - there is no next page yet, but the query it still being processed, maybe it will appear later; sleep for a bit and try again
  - no_page_no_processing - the query processing has finished and there’s no next page; stop
- page contains data for selected_columns. Since both IP columns are in GROUP BY, rtp_ip_server, hostname_server and host_groups_server contain single values, not arrays.
Interrupt the query.
- Path: /api/chf/tables/top_rtp_connections/{uuid}
- Method: DELETE
- Path parameter:
  - uuid - received from the previous request
- Response:
```
{
  "message": "Successfully interrupted processing the query (5f966c56-6acb-d5c5-7832-eb29b000f333)",
  "data": null
}
```

Get supported columns.

Path: /api/chf/tables/top_rtp_connections/columns
Method: GET

Response:

{
  "message": "Success",
  "data": [
      {
          "name": "rtp_ip_client",
          "type": "ip_address",
          "sort_order": null,
          "is_selected": true,
          "is_enabled": true,
          "is_sortable": false,
          "is_suggestable": true,
          "is_static": true,
          "link_details": true,
          "is_filterable": true,
          "filter_options": {
              "filter_operators": [
                  "=",
                  "!=",
                  "IN-CIDR",
                  "NOT-IN-CIDR",
                  "IN-RANGE",
                  "NOT-IN-RANGE"
              ]
          },
          "is_groupable": true
      },
      ...
  ]
}

Compute match/total counts and their ratio for a given filter
- Path: /api/chf/tables/top_rtp_connections/match_ratio
- Method: POST
- Request body:
```
{
  [optional] "from_timestamp": 1731589380,
  [optional] "to_timestamp": 1731589680,
  [optional] "filter_clause": "rtp_ip_client = '68.67.152.80'",
  [optional] "match_clause": "rtp_client_mos < 3.5",
  [optional] "group_by": ["rtp_ip_client", "rtp_ip_server"]
}
```
- Response:
```
{
  "message": "Success",
  "data": {
    "match_count": 5000,
    "total_count": 10000,
    "match_ratio": 0.5
  }
}
```
- if from_timestamp is not provided or is null, the minimum value is used.
- if to_timestamp is not provided or is null, the maximum value is used.
- filter_clause Optional condition to further filter which rows are returned.
- match_clause Optional condition rows are tested against to compute the match ratio.
- group_by specifies the columns used for grouping. Accepts a single string or an array of strings. Default is ["rtp_ip_client", "rtp_ip_server"].
- match_count - number of groups matching both filter_clause and match_clause for the given time range and group_by.
- total_count - number of groups matching filter_clause for the given time range and group_by.
- match_ratio - match_count / total_count as a floating-point value, or 0.0 when total_count is 0.

Filter Operator Sets

filter_comparison_operators: {filter_operator::equal, filter_operator::not_equal, filter_operator::less_than, filter_operator::greater_than, filter_operator::less_than_or_equal, filter_operator::greater_than_or_equal, filter_operator::in_range, filter_operator::not_in_range}
filter_ip_operators: {filter_operator::equal, filter_operator::not_equal, filter_operator::in_cidr, filter_operator::not_in_cidr, filter_operator::in_range, filter_operator::not_in_range}

Supported columns

rtp_ip_client
rtp_ip_server
rtp_num_client_streams
rtp_num_server_streams
rtp_client_sent_packets
rtp_server_sent_packets
rtp_total_sent_packets
rtp_client_lost_packets
rtp_server_lost_packets
rtp_total_lost_packets
rtp_client_lost_packets_ratio
rtp_server_lost_packets_ratio
rtp_total_lost_packets_ratio
rtp_client_overhead_packets
rtp_server_overhead_packets
rtp_total_overhead_packets
rtp_client_overhead_packets_ratio
rtp_server_overhead_packets_ratio
rtp_total_overhead_packets_ratio
rtp_client_ooo_packets
rtp_server_ooo_packets
rtp_total_ooo_packets
rtp_client_ooo_packets_ratio
rtp_server_ooo_packets_ratio
rtp_total_ooo_packets_ratio
rtp_client_duplicate_packets
rtp_server_duplicate_packets
rtp_total_duplicate_packets
rtp_client_duplicate_packets_ratio
rtp_server_duplicate_packets_ratio
rtp_total_duplicate_packets_ratio
rtp_client_jitter_min_ns
rtp_client_jitter_avg_ns
rtp_client_jitter_max_ns
rtp_server_jitter_min_ns
rtp_server_jitter_avg_ns
rtp_server_jitter_max_ns
rtp_client_mos
rtp_server_mos
hostname_client
hostname_server
host_groups_client
host_groups_server
is_any_packets_written

Column Details

`rtp_ip_client`

Columns Response:

{
    "name": "rtp_ip_client",
    "type": "ip_address",
    "sort_order": null,
    "is_selected": true,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": true,
    "is_static": true,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "IN-CIDR",
            "NOT-IN-CIDR",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_groupable": true,
    "is_chartable": false,
    "column_group_tag": [
        "client_info"
    ]
}

↑ Back to list

`rtp_ip_server`

Columns Response:

{
    "name": "rtp_ip_server",
    "type": "ip_address",
    "sort_order": null,
    "is_selected": true,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": true,
    "is_static": true,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "IN-CIDR",
            "NOT-IN-CIDR",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_groupable": true,
    "is_chartable": false,
    "column_group_tag": [
        "server_info"
    ]
}

↑ Back to list

`rtp_num_client_streams`

Columns Response:

{
    "name": "rtp_num_client_streams",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": false,
    "is_chartable": true,
    "column_group_tag": [
        "rtp_unique_stream_count"
    ]
}

↑ Back to list

`rtp_num_server_streams`

Columns Response:

{
    "name": "rtp_num_server_streams",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": false,
    "is_chartable": true,
    "column_group_tag": [
        "rtp_unique_stream_count"
    ]
}

↑ Back to list

`rtp_client_sent_packets`

Columns Response:

{
    "name": "rtp_client_sent_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_sent_packets"
    ]
}

↑ Back to list

`rtp_server_sent_packets`

Columns Response:

{
    "name": "rtp_server_sent_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_sent_packets"
    ]
}

↑ Back to list

`rtp_total_sent_packets`

Columns Response:

{
    "name": "rtp_total_sent_packets",
    "type": "number_units",
    "sort_order": "desc",
    "is_selected": true,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_sent_packets"
    ]
}

↑ Back to list

`rtp_client_lost_packets`

Columns Response:

{
    "name": "rtp_client_lost_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_lost_packets"
    ]
}

↑ Back to list

`rtp_server_lost_packets`

Columns Response:

{
    "name": "rtp_server_lost_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_lost_packets"
    ]
}

↑ Back to list

`rtp_total_lost_packets`

Columns Response:

{
    "name": "rtp_total_lost_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": true,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_lost_packets"
    ]
}

↑ Back to list

`rtp_client_lost_packets_ratio`

Columns Response:

{
    "name": "rtp_client_lost_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_lost_ratio"
    ]
}

↑ Back to list

`rtp_server_lost_packets_ratio`

Columns Response:

{
    "name": "rtp_server_lost_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_lost_ratio"
    ]
}

↑ Back to list

`rtp_total_lost_packets_ratio`

Columns Response:

{
    "name": "rtp_total_lost_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": true,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_lost_ratio"
    ]
}

↑ Back to list

`rtp_client_overhead_packets`

Columns Response:

{
    "name": "rtp_client_overhead_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_overhead_packets"
    ]
}

↑ Back to list

`rtp_server_overhead_packets`

Columns Response:

{
    "name": "rtp_server_overhead_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_overhead_packets"
    ]
}

↑ Back to list

`rtp_total_overhead_packets`

Columns Response:

{
    "name": "rtp_total_overhead_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_overhead_packets"
    ]
}

↑ Back to list

`rtp_client_overhead_packets_ratio`

Columns Response:

{
    "name": "rtp_client_overhead_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_overhead_ratio"
    ]
}

↑ Back to list

`rtp_server_overhead_packets_ratio`

Columns Response:

{
    "name": "rtp_server_overhead_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_overhead_ratio"
    ]
}

↑ Back to list

`rtp_total_overhead_packets_ratio`

Columns Response:

{
    "name": "rtp_total_overhead_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_overhead_ratio"
    ]
}

↑ Back to list

`rtp_client_ooo_packets`

Columns Response:

{
    "name": "rtp_client_ooo_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_ooo_packets"
    ]
}

↑ Back to list

`rtp_server_ooo_packets`

Columns Response:

{
    "name": "rtp_server_ooo_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_ooo_packets"
    ]
}

↑ Back to list

`rtp_total_ooo_packets`

Columns Response:

{
    "name": "rtp_total_ooo_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_ooo_packets"
    ]
}

↑ Back to list

`rtp_client_ooo_packets_ratio`

Columns Response:

{
    "name": "rtp_client_ooo_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_ooo_ratio"
    ]
}

↑ Back to list

`rtp_server_ooo_packets_ratio`

Columns Response:

{
    "name": "rtp_server_ooo_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_ooo_ratio"
    ]
}

↑ Back to list

`rtp_total_ooo_packets_ratio`

Columns Response:

{
    "name": "rtp_total_ooo_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_ooo_ratio"
    ]
}

↑ Back to list

`rtp_client_duplicate_packets`

Columns Response:

{
    "name": "rtp_client_duplicate_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_duplicate_packets"
    ]
}

↑ Back to list

`rtp_server_duplicate_packets`

Columns Response:

{
    "name": "rtp_server_duplicate_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_duplicate_packets"
    ]
}

↑ Back to list

`rtp_total_duplicate_packets`

Columns Response:

{
    "name": "rtp_total_duplicate_packets",
    "type": "number_units",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "column_group_tag": [
        "rtp_duplicate_packets"
    ]
}

↑ Back to list

`rtp_client_duplicate_packets_ratio`

Columns Response:

{
    "name": "rtp_client_duplicate_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_duplicate_ratio"
    ]
}

↑ Back to list

`rtp_server_duplicate_packets_ratio`

Columns Response:

{
    "name": "rtp_server_duplicate_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_duplicate_ratio"
    ]
}

↑ Back to list

`rtp_total_duplicate_packets_ratio`

Columns Response:

{
    "name": "rtp_total_duplicate_packets_ratio",
    "type": "number_ratio_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        0.02,
        0.1
    ],
    "column_group_tag": [
        "rtp_duplicate_ratio"
    ]
}

↑ Back to list

`rtp_client_jitter_min_ns`

Columns Response:

{
    "name": "rtp_client_jitter_min_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_client_jitter_avg_ns`

Columns Response:

{
    "name": "rtp_client_jitter_avg_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_client_jitter_max_ns`

Columns Response:

{
    "name": "rtp_client_jitter_max_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_server_jitter_min_ns`

Columns Response:

{
    "name": "rtp_server_jitter_min_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_server_jitter_avg_ns`

Columns Response:

{
    "name": "rtp_server_jitter_avg_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_server_jitter_max_ns`

Columns Response:

{
    "name": "rtp_server_jitter_max_ns",
    "type": "number_ns_threshold",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_chartable": true,
    "threshold": [
        20000000,
        50000000
    ],
    "column_group_tag": [
        "rtp_jitter"
    ]
}

↑ Back to list

`rtp_client_mos`

Columns Response:

{
    "name": "rtp_client_mos",
    "type": "number_score_threshold_reversed",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_groupable": false,
    "is_hidden": false,
    "is_chartable": true,
    "threshold": [
        3.0,
        4.0
    ],
    "column_group_tag": [
        "rtp_mos"
    ]
}

↑ Back to list

`rtp_server_mos`

Columns Response:

{
    "name": "rtp_server_mos",
    "type": "number_score_threshold_reversed",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": true,
    "is_suggestable": false,
    "is_static": false,
    "link_details": false,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!=",
            "<",
            ">",
            "<=",
            ">=",
            "IN-RANGE",
            "NOT-IN-RANGE"
        ]
    },
    "is_groupable": false,
    "is_hidden": false,
    "is_chartable": true,
    "threshold": [
        3.0,
        4.0
    ],
    "column_group_tag": [
        "rtp_mos"
    ]
}

↑ Back to list

`hostname_client`

Columns Response:

{
    "name": "hostname_client",
    "type": "string",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": false,
    "is_static": false,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!="
        ]
    },
    "is_chartable": false,
    "column_group_tag": [
        "hostnames",
        "client_info"
    ]
}

↑ Back to list

`hostname_server`

Columns Response:

{
    "name": "hostname_server",
    "type": "string",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": false,
    "is_static": false,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "=",
            "!="
        ]
    },
    "is_chartable": false,
    "column_group_tag": [
        "hostnames",
        "server_info"
    ]
}

↑ Back to list

`host_groups_client`

Columns Response:

{
    "name": "host_groups_client",
    "type": "tags_list",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": false,
    "is_static": false,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "="
        ]
    },
    "is_chartable": false,
    "column_group_tag": [
        "host_groups",
        "client_info"
    ]
}

↑ Back to list

`host_groups_server`

Columns Response:

{
    "name": "host_groups_server",
    "type": "tags_list",
    "sort_order": null,
    "is_selected": false,
    "is_enabled": true,
    "is_sortable": false,
    "is_suggestable": false,
    "is_static": false,
    "link_details": true,
    "is_filterable": true,
    "filter_options": {
        "filter_operators": [
            "="
        ]
    },
    "is_chartable": false,
    "column_group_tag": [
        "host_groups",
        "server_info"
    ]
}

↑ Back to list

`is_any_packets_written`

Columns Response:

{
    "name": "is_any_packets_written",
    "type": "pcap_download_link",
    "sort_order": null,
    "is_selected": true,
    "is_enabled": false,
    "is_sortable": false,
    "is_suggestable": false,
    "is_static": false,
    "link_details": true,
    "is_filterable": false,
    "is_hidden": true,
    "is_chartable": false
}

↑ Back to list

Back to Clickhouse Facade