SQL Query Management

Manage Top DNS queries query

Endpoints

Supported columns

Column Details

dns_query

Columns Response:

{
    "name": "dns_query",
    "type": "string",
    "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": [
            "=",
            "!=",
            "LIKE",
            "ILIKE"
        ]
    },
    "is_groupable": true,
    "is_chartable": false
}

↑ Back to list


dns_ip_server

Columns Response:

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

↑ Back to list


dns_num_clients

Columns Response:

{
    "name": "dns_num_clients",
    "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": [
        "unique_host_count"
    ]
}

↑ Back to list


dns_num_servers

Columns Response:

{
    "name": "dns_num_servers",
    "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": [
        "unique_host_count"
    ]
}

↑ Back to list


dns_response_time_min_ns

Columns Response:

{
    "name": "dns_response_time_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": [
        150000000,
        500000000
    ],
    "column_group_tag": [
        "dns_transaction_delay"
    ]
}

↑ Back to list


dns_response_time_avg_ns

Columns Response:

{
    "name": "dns_response_time_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": [
        150000000,
        500000000
    ],
    "column_group_tag": [
        "dns_transaction_delay"
    ]
}

↑ Back to list


dns_response_time_max_ns

Columns Response:

{
    "name": "dns_response_time_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": [
        150000000,
        500000000
    ],
    "column_group_tag": [
        "dns_transaction_delay"
    ]
}

↑ Back to list


dns_no_request_transactions

Columns Response:

{
    "name": "dns_no_request_transactions",
    "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": [
        "dns_status_transactions",
        "dns_errors"
    ]
}

↑ Back to list


dns_no_response_transactions

Columns Response:

{
    "name": "dns_no_response_transactions",
    "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": [
        "dns_status_transactions",
        "dns_errors"
    ]
}

↑ Back to list


dns_successful_transactions

Columns Response:

{
    "name": "dns_successful_transactions",
    "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": [
        "dns_status_transactions",
        "dns_performance_successful_transactions"
    ]
}

↑ Back to list


dns_failed_transactions

Columns Response:

{
    "name": "dns_failed_transactions",
    "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": [
        "dns_status_transactions",
        "dns_performance_failed_transactions"
    ]
}

↑ Back to list


dns_completed_transactions

Columns Response:

{
    "name": "dns_completed_transactions",
    "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": [
        "dns_performance_total_transactions"
    ]
}

↑ Back to list


dns_total_transactions

Columns Response:

{
    "name": "dns_total_transactions",
    "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": [
        "dns_status_transactions"
    ]
}

↑ Back to list


dns_no_request_transactions_ratio

Columns Response:

{
    "name": "dns_no_request_transactions_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.15,
        0.3
    ],
    "column_group_tag": [
        "dns_status_transactions_ratio"
    ]
}

↑ Back to list


dns_no_response_transactions_ratio

Columns Response:

{
    "name": "dns_no_response_transactions_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.15,
        0.3
    ],
    "column_group_tag": [
        "dns_status_transactions_ratio"
    ]
}

↑ Back to list


dns_successful_transactions_ratio

Columns Response:

{
    "name": "dns_successful_transactions_ratio",
    "type": "number_ratio_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_chartable": true,
    "threshold": [
        0.7,
        0.85
    ],
    "column_group_tag": [
        "dns_status_transactions_ratio"
    ]
}

↑ Back to list


dns_failed_transactions_ratio

Columns Response:

{
    "name": "dns_failed_transactions_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.15,
        0.3
    ],
    "column_group_tag": [
        "dns_status_transactions_ratio"
    ]
}

↑ Back to list


dns_successful_fast_transactions

Columns Response:

{
    "name": "dns_successful_fast_transactions",
    "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": [
        "dns_performance_successful_transactions"
    ]
}

↑ Back to list


dns_successful_moderate_transactions

Columns Response:

{
    "name": "dns_successful_moderate_transactions",
    "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": [
        "dns_performance_successful_transactions"
    ]
}

↑ Back to list


dns_successful_slow_transactions

Columns Response:

{
    "name": "dns_successful_slow_transactions",
    "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": [
        "dns_performance_successful_transactions"
    ]
}

↑ Back to list


dns_successful_fast_transactions_ratio

Columns Response:

{
    "name": "dns_successful_fast_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_successful_transactions_ratio"
    ]
}

↑ Back to list


dns_successful_moderate_transactions_ratio

Columns Response:

{
    "name": "dns_successful_moderate_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_successful_transactions_ratio"
    ]
}

↑ Back to list


dns_successful_slow_transactions_ratio

Columns Response:

{
    "name": "dns_successful_slow_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_successful_transactions_ratio"
    ]
}

↑ Back to list


dns_failed_fast_transactions

Columns Response:

{
    "name": "dns_failed_fast_transactions",
    "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": [
        "dns_performance_failed_transactions"
    ]
}

↑ Back to list


dns_failed_moderate_transactions

Columns Response:

{
    "name": "dns_failed_moderate_transactions",
    "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": [
        "dns_performance_failed_transactions"
    ]
}

↑ Back to list


dns_failed_slow_transactions

Columns Response:

{
    "name": "dns_failed_slow_transactions",
    "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": [
        "dns_performance_failed_transactions"
    ]
}

↑ Back to list


dns_failed_fast_transactions_ratio

Columns Response:

{
    "name": "dns_failed_fast_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_failed_transactions_ratio"
    ]
}

↑ Back to list


dns_failed_moderate_transactions_ratio

Columns Response:

{
    "name": "dns_failed_moderate_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_failed_transactions_ratio"
    ]
}

↑ Back to list


dns_failed_slow_transactions_ratio

Columns Response:

{
    "name": "dns_failed_slow_transactions_ratio",
    "type": "number_ratio",
    "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": [
        "dns_performance_failed_transactions_ratio"
    ]
}

↑ Back to list


dns_total_fast_transactions

Columns Response:

{
    "name": "dns_total_fast_transactions",
    "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": [
        "dns_performance_total_transactions"
    ]
}

↑ Back to list


dns_total_moderate_transactions

Columns Response:

{
    "name": "dns_total_moderate_transactions",
    "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": [
        "dns_performance_total_transactions"
    ]
}

↑ Back to list


dns_total_slow_transactions

Columns Response:

{
    "name": "dns_total_slow_transactions",
    "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": [
        "dns_performance_total_transactions"
    ]
}

↑ Back to list


dns_total_fast_transactions_ratio

Columns Response:

{
    "name": "dns_total_fast_transactions_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": [
        1.0,
        1.0
    ],
    "column_group_tag": [
        "dns_performance_total_transactions_ratio"
    ]
}

↑ Back to list


dns_total_moderate_transactions_ratio

Columns Response:

{
    "name": "dns_total_moderate_transactions_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.0,
        1.0
    ],
    "column_group_tag": [
        "dns_performance_total_transactions_ratio"
    ]
}

↑ Back to list


dns_total_slow_transactions_ratio

Columns Response:

{
    "name": "dns_total_slow_transactions_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.0,
        0.0
    ],
    "column_group_tag": [
        "dns_performance_total_transactions_ratio"
    ]
}

↑ 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_groupable": false,
    "is_hidden": true,
    "is_chartable": false
}

↑ 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"
    ]
}

↑ 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"
    ]
}

↑ Back to list


Back to Clickhouse Facade