338 lines
84 KiB
Plaintext
338 lines
84 KiB
Plaintext
*** Settings ***
|
|
Force Tags tsg_bf_api report
|
|
Library OperatingSystem
|
|
Library GetTimeLibrary
|
|
Resource ../../../03-Variable/BifangApiVariable.txt
|
|
Resource ../../../02-Keyword/tsg_bfapi/Common.robot
|
|
Resource ../../../02-Keyword/tsg_bfapi/offline_stat_report/ApiRequest1.robot
|
|
Resource ../../../02-Keyword/tsg_adc/FileOperation.robot
|
|
*** Variables ***
|
|
${dataset_url} /${version}/report/dataset
|
|
${datasetId} ${EMPTY}
|
|
${reportId} ${EMPTY}
|
|
${report_url} /${version}/report/offlinejob
|
|
${chartId} ${EMPTY}
|
|
${chart_url} /${version}/report/chart
|
|
${result_url} /${version}/report/offlinejob/result
|
|
${resultId} ${EMPTY}
|
|
*** Test Cases ***
|
|
# Report 目的性测试
|
|
|
|
#############################################################Security Event########################################################################
|
|
ReportDatasetsSecurityEventMaximumCombination
|
|
[Tags] Positive API Report Security Event 最大组合条件
|
|
${name} Set Variable ${TEST NAME}
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${name}","description":null,"logType":"security_event_log","queryColumnList":[{"name":"quic_sni","expression":"","label":"Quic.SNI"},{"name":"mail_to","expression":"","label":"Mail.To"},{"name":"mail_from","expression":"","label":"Mail.From"},{"name":"mail_account","expression":"","label":"Mail.Account"},{"name":"ssl_server_side_version","expression":"","label":"SSL.Server Side Version"},{"name":"ssl_client_side_version","expression":"","label":"SSL.Client Side Version"},{"name":"ssl_ja3_hash","expression":"","label":"SSL.JA3 hash"},{"name":"ssl_sni","expression":"","label":"SSL.SNI"},{"name":"http_url","expression":"","label":"Http.URL"},{"name":"http_domain","expression":"","label":"Http.Domain"},{"name":"http_host","expression":"","label":"Http.Host"},{"name":"common_start_time","expression":"","label":"Start Time"},{"name":"common_server_asn","expression":"","label":"Server ASN"},{"name":"common_client_asn","expression":"","label":"Client ASN"},{"name":"common_data_center","expression":"","label":"Data Center"},{"name":"common_l7_protocol","expression":"","label":"L7 Protocol"},{"name":"common_l4_protocol","expression":"","label":"L4 Protocol"},{"name":"common_schema_type","expression":"","label":"Schema Type"},{"name":"common_server_port","expression":"","label":"Server Port"},{"name":"common_client_port","expression":"","label":"Client Port"},{"name":"common_subscriber_id","expression":"","label":"Subscriber ID"},{"name":"common_server_location","expression":"","label":"Server Location"},{"name":"common_client_location","expression":"","label":"Client Location"},{"name":"common_device_id","expression":"","label":"Device ID"},{"name":"common_sled_ip","expression":"","label":"Sled IP"},{"name":"common_action","expression":"","label":"Action"},{"name":"common_policy_id","expression":"","label":"Policy ID"},{"name":"common_external_ip","expression":"","label":"External IP"},{"name":"common_internal_ip","expression":"","label":"Internal IP"},{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"common_server_ip","expression":"","label":"Server IP"},{"name":"ssl_client_side_latency","expression":"sum","label":"SSL.Client Side Latency(ms)","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_sessions","expression":"min","label":"Sessions","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_pkt_num","expression":"max","label":"Packets Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_pkt_num","expression":"avg","label":"Packets Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_con_duration_ms","expression":"count","label":"Duration(ms)","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_establish_latency_ms,common_con_duration_ms,ssl_server_side_latency,ssl_client_side_latency","expression":"sum","label":"Establish Latency(ms)+Duration(ms)+SSL.Server Side Latency(ms)+SSL.Client Side Latency(ms)","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"groupColumnList":[{"name":"common_server_ip","expression":null},{"name":"common_client_ip","expression":null},{"name":"common_internal_ip","expression":null},{"name":"common_external_ip","expression":null},{"name":"common_policy_id","expression":null},{"name":"common_action","expression":null},{"name":"common_sled_ip","expression":null},{"name":"common_device_id","expression":null},{"name":"common_client_location","expression":null},{"name":"common_server_location","expression":null},{"name":"common_subscriber_id","expression":null},{"name":"common_client_port","expression":null},{"name":"common_server_port","expression":null},{"name":"common_schema_type","expression":null},{"name":"common_l4_protocol","expression":null},{"name":"common_l7_protocol","expression":null},{"name":"common_data_center","expression":null},{"name":"common_client_asn","expression":null},{"name":"common_server_asn","expression":null},{"name":"common_start_time","expression":null},{"name":"http_host","expression":null},{"name":"http_domain","expression":null},{"name":"http_url","expression":null},{"name":"ssl_sni","expression":null},{"name":"ssl_ja3_hash","expression":null},{"name":"ssl_client_side_version","expression":null},{"name":"ssl_server_side_version","expression":null},{"name":"mail_account","expression":null},{"name":"mail_from","expression":null},{"name":"mail_to","expression":null},{"name":"quic_sni","expression":null}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_action","expression":"=","value":[1],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_address_type","expression":"=","value":[4],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_policy_id","expression":"=","value":[20155],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_server_ip","expression":"=","value":["192.168.32.32"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_client_ip","expression":"=","value":["192.168.32.50"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_internal_ip","expression":"=","value":["104.85.195.76"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_external_ip","expression":"=","value":["192.168.32.32"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_client_port","expression":"!=","value":[444],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]}]},{"orConditions":[{"name":"common_server_port","expression":">","value":[25],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_server_port","expression":"<","value":[8888],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_client_location","expression":"Like","value":["%*"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_server_location","expression":"Not Like","value":["%a"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_subscriber_id","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_c2s_pkt_num","expression":">=","value":[4],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_s2c_pkt_num","expression":"=","value":[2],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_c2s_byte_num","expression":"<=","value":[1100],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_s2c_byte_num","expression":"=","value":[232],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_l4_protocol","expression":"=","value":["IPv4_TCP"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_l7_protocol","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_stream_dir","expression":"=","value":[3],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_data_center","expression":"=","value":["City A"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_sled_ip","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_device_id","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_direction","expression":"=","value":[69],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_schema_type","expression":"=","value":["SSL"],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"common_client_asn","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_server_asn","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"common_start_time","expression":"=","value":[1616256000],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_end_time","expression":"=","value":[1616601600],"type":"long","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_con_duration_ms","expression":"!=","value":[111],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"common_establish_latency_ms","expression":"!=","value":[52],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"http_host","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"http_domain","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"http_url","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"ssl_sni","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"ssl_ja3_hash","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"http_content_type","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"ssl_pinningst","expression":"!=","value":[0],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"ssl_intercept_state","expression":"=","value":[1],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"ssl_client_side_version","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"ssl_server_side_version","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"ssl_cert_verify","expression":"!=","value":[0],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}]},{"name":"ssl_client_side_latency","expression":"<","value":[20],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"ssl_server_side_latency","expression":"!=","value":[50],"type":"int","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}]},{"name":"mail_account","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"mail_from","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"mail_to","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"mail_subject","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]},{"name":"quic_sni","expression":"notEmpty","value":[],"type":"string","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}]}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_server_ip","function":"count_distinct","expression":"=","value":500,"funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"type":"","expressionList":["=","!=",">","<",">=","<="]}]}]},"isInitialize":0}}
|
|
Comment 获取dataset的ID
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
${data1} Create Dictionary ids=${datasetId}
|
|
BaseDeleteRequestOK ${dataset_url} ${data1}
|
|
|
|
ReportDatasetsProxyEventMaximumCombination
|
|
[Tags] Positive API Report Proxy Event 最大组合条件
|
|
${name} Set Variable ${TEST NAME}
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${name}","logType":"proxy_event_log","groupColumnList":[{"name":"common_server_ip"},{"name":"common_client_ip"},{"name":"common_internal_ip"},{"name":"common_external_ip"},{"name":"common_policy_id"},{"name":"common_sub_action"},{"name":"common_sled_ip"},{"name":"common_device_id"},{"name":"common_client_location"},{"name":"common_server_location"},{"name":"common_subscriber_id"},{"name":"common_client_port"},{"name":"common_server_port"},{"name":"common_schema_type"},{"name":"common_data_center"},{"name":"common_client_asn"},{"name":"common_server_asn"},{"name":"http_host"},{"name":"http_domain"},{"name":"http_url"},{"name":"doh_host"},{"name":"doh_qname"},{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"doh_qname","expression":"","label":"DoH.QNAME"},{"name":"doh_host","expression":"","label":"DoH.Host"},{"name":"http_url","expression":"","label":"Http.URL"},{"name":"http_domain","expression":"","label":"Http.Domain"},{"name":"http_host","expression":"","label":"Http.Host"},{"name":"common_server_asn","expression":"","label":"Server ASN"},{"name":"common_client_asn","expression":"","label":"Client ASN"},{"name":"common_data_center","expression":"","label":"Data Center"},{"name":"common_schema_type","expression":"","label":"Schema Type"},{"name":"common_server_port","expression":"","label":"Server Port"},{"name":"common_client_port","expression":"","label":"Client Port"},{"name":"common_subscriber_id","expression":"","label":"Subscriber ID"},{"name":"common_server_location","expression":"","label":"Server Location"},{"name":"common_client_location","expression":"","label":"Client Location"},{"name":"common_device_id","expression":"","label":"Device ID"},{"name":"common_sled_ip","expression":"","label":"Sled IP"},{"name":"common_sub_action","expression":"","label":"Sub Action"},{"name":"common_policy_id","expression":"","label":"Policy ID"},{"name":"common_external_ip","expression":"","label":"External IP"},{"name":"common_internal_ip","expression":"","label":"Internal IP"},{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"common_server_ip","expression":"","label":"Server IP"},{"name":"common_sessions","expression":"sum","label":"Sessions","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_byte_num","expression":"min","label":"Bytes Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_byte_num","expression":"max","label":"Bytes Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_log_id","expression":"count","label":"1445","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_sessions,common_c2s_byte_num,common_s2c_byte_num","expression":"avg","label":"Sessions+Bytes Sent+Bytes Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_policy_id","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[19225],"type":"long"},{"name":"common_sub_action","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":["hijack"],"type":"string"},{"name":"common_address_type","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[4],"type":"int"},{"name":"common_server_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_client_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_internal_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_external_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_client_port","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[11],"type":"int"},{"name":"common_server_port","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[50],"type":"int"},{"name":"common_client_location","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_server_location","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_subscriber_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_l4_protocol","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_data_center","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":["City A"],"type":"string"},{"name":"common_sled_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_device_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_client_asn","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_server_asn","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_direction","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[69],"type":"int"},{"name":"common_schema_type","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":["HTTP"],"type":"string"},{"name":"http_host","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"http_domain","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"http_url","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"http_content_type","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"doh_host","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"doh_qname","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_sled_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":"=","value":555}]}]},"isInitialize":0}}
|
|
Comment 获取dataset的ID
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
${data1} Create Dictionary ids=${datasetId}
|
|
BaseDeleteRequestOK ${dataset_url} ${data1}
|
|
|
|
ReportDatasetsSessionRecordsMaximumCombination
|
|
[Tags] Positive API Report Session Records 最大组合条件
|
|
${name} Set Variable ${TEST NAME}
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${name}","logType":"connection_record_log","groupColumnList":[{"name":"common_server_ip"},{"name":"common_client_ip"},{"name":"common_internal_ip"},{"name":"common_external_ip"},{"name":"common_sled_ip"},{"name":"common_device_id"},{"name":"common_client_location"},{"name":"common_server_location"},{"name":"common_subscriber_id"},{"name":"common_client_port"},{"name":"common_server_port"},{"name":"common_schema_type"},{"name":"common_l4_protocol"},{"name":"common_l7_protocol"},{"name":"common_client_asn"},{"name":"common_server_asn"},{"name":"http_host"},{"name":"http_domain"},{"name":"http_url"},{"name":"ssl_sni"},{"name":"ssl_ja3_hash"},{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"ssl_ja3_hash","expression":"","label":"SSL.JA3 hash"},{"name":"ssl_sni","expression":"","label":"SSL.SNI"},{"name":"http_url","expression":"","label":"Http.URL"},{"name":"http_domain","expression":"","label":"Http.Domain"},{"name":"http_host","expression":"","label":"Http.Host"},{"name":"common_server_asn","expression":"","label":"Server ASN"},{"name":"common_client_asn","expression":"","label":"Client ASN"},{"name":"common_l7_protocol","expression":"","label":"L7 Protocol"},{"name":"common_l4_protocol","expression":"","label":"L4 Protocol"},{"name":"common_schema_type","expression":"","label":"Schema Type"},{"name":"common_server_port","expression":"","label":"Server Port"},{"name":"common_client_port","expression":"","label":"Client Port"},{"name":"common_subscriber_id","expression":"","label":"Subscriber ID"},{"name":"common_server_location","expression":"","label":"Server Location"},{"name":"common_client_location","expression":"","label":"Client Location"},{"name":"common_device_id","expression":"","label":"Device ID"},{"name":"common_sled_ip","expression":"","label":"Sled IP"},{"name":"common_external_ip","expression":"","label":"External IP"},{"name":"common_internal_ip","expression":"","label":"Internal IP"},{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"common_server_ip","expression":"","label":"Server IP"},{"name":"common_c2s_tcp_lostlen","expression":"sum","label":"Sequence Gap Loss(c2s)","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_address_type","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[4],"type":"int"},{"name":"common_server_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_client_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_internal_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_external_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_client_port","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[11],"type":"int"},{"name":"common_server_port","expression":"<","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[100],"type":"int"},{"name":"common_client_location","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_server_location","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_subscriber_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_c2s_pkt_num","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[44],"type":"long"},{"name":"common_s2c_pkt_num","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[11],"type":"long"},{"name":"common_c2s_byte_num","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[50],"type":"long"},{"name":"common_s2c_byte_num","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[41],"type":"long"}]},{"orConditions":[{"name":"common_c2s_ipfrag_num","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[12],"type":"long"},{"name":"common_s2c_ipfrag_num","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[22],"type":"long"},{"name":"common_c2s_tcp_lostlen","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[23],"type":"long"},{"name":"common_s2c_tcp_lostlen","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[51],"type":"long"},{"name":"common_c2s_tcp_unorder_num","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[24],"type":"long"},{"name":"common_s2c_tcp_unorder_num","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[53],"type":"long"},{"name":"common_l4_protocol","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_l7_protocol","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_stream_dir","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[1],"type":"int"},{"name":"common_direction","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[69],"type":"int"},{"name":"common_data_center","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":["City B"],"type":"string"},{"name":"common_sled_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_device_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_schema_type","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":["BASE"],"type":"string"},{"name":"common_client_asn","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_start_time","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[1615910400],"type":"long"},{"name":"common_end_time","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[1616688000],"type":"long"},{"name":"common_con_duration_ms","expression":"<","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[11],"type":"int"},{"name":"common_establish_latency_ms","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[23],"type":"int"},{"name":"http_host","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"http_domain","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"http_url","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"ssl_sni","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"ssl_ja3_hash","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_c2s_byte_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":"=","value":123}]},{"orConditions":[{"name":"common_server_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":"=","value":123}]}]},"isInitialize":0}}
|
|
Comment 获取dataset的ID
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
${data1} Create Dictionary ids=${datasetId}
|
|
BaseDeleteRequestOK ${dataset_url} ${data1}
|
|
|
|
ReportDatasetRadiusMaximumCombination
|
|
[Tags] Positive API Report Radius 最大组合条件
|
|
${name} Set Variable ${TEST NAME}
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${name}","logType":"radius_record_log","groupColumnList":[{"name":"radius_nas_ip"},{"name":"radius_framed_ip"},{"name":"common_subscriber_id"},{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"common_subscriber_id","expression":"","label":"Subscriber ID"},{"name":"radius_framed_ip","expression":"","label":"Framed IP"},{"name":"radius_nas_ip","expression":"","label":"Nas IP"},{"name":"radius_event_timestamp","expression":"min","label":"Event Timestamp","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_pkt_num","expression":"sum","label":"Packets Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_pkt_num","expression":"max","label":"Packets Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_byte_num","expression":"avg","label":"Bytes Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_byte_num","expression":"count","label":"Bytes Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_log_id","expression":"count","label":"counter","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"radius_framed_ip","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"common_subscriber_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"radius_packet_type","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[1],"type":"int"},{"name":"radius_acct_session_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"radius_acct_multi_session_id","expression":"notEmpty","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":[],"type":"string"},{"name":"radius_acct_status_type","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[1],"type":"int"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"radius_framed_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":"=","value":12},{"name":"common_c2s_pkt_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":"=","value":22}]},{"orConditions":[{"name":"common_s2c_pkt_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":"=","value":32}]}]},"isInitialize":0}}
|
|
Comment 获取dataset的ID
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
${data1} Create Dictionary ids=${datasetId}
|
|
BaseDeleteRequestOK ${dataset_url} ${data1}
|
|
|
|
ReportSecurityEventClientIPTotal
|
|
[Tags] Positive API Report 统计时间线上ClientIP数量
|
|
${name} Set Variable ${TEST NAME}
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${name}","description":null,"logType":"security_event_log","queryColumnList":[{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"common_client_ip","expression":"count","label":"Client IP","expressionList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}]}],"groupColumnList":[{"name":"common_recv_time","expression":null}],"filterCondition":null,"havingCondition":null,"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${name}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${name}","description":"","datasetId":"${datasetId}","chartType":"line","dataTop":0,"orderBy":"","orderDesc":0,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"Client IP","type":"Line Up","format":"Default","legend":"Client IP"}],"groupBy":null},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${name}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":"","rangeUnit":"","jobName":"${name}","scheduleId":"","chartList":[{"chartId":${chartId},"timeGranulartiy":30,"timeUnit":"minute","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
#查询Report的id
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${name}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID1 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID1 ${chartId}
|
|
insert_Report_to_file1 Report_ID1 ${reportId}
|
|
|
|
ReportSecurityEventNotMonitorClientIP
|
|
[Tags] Positive API Report 去重后不为Monitor各ClientIP的命中数量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"security_event_log","groupColumnList":[{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"common_internal_ip","expression":"count_distinct","label":"Internal IP","expressionList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_action","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[1],"type":"int"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_sled_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count_distinct","expression":"!=","value":1}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","chartType":"bar","dataTop":0,"orderBy":"","orderDesc":"","includeOther":false,"xAxis":{"dataBinding":"Client IP","label":"Client IP","dataTop":5,"dataType":""},"yAxis":[{"dataBinding":"Internal IP","format":"Default","legend":"Internal IP"}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
#查询Report的id
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID2 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID2 ${chartId}
|
|
insert_Report_to_file1 Report_ID2 ${reportId}
|
|
|
|
ReportSecurityEventActionBytesSentMax
|
|
[Tags] Positive API Report 安全日志各动作的流量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"security_event_log","groupColumnList":[{"name":"common_action"}],"queryColumnList":[{"name":"common_action","expression":"","label":"Action"},{"name":"common_c2s_byte_num","expression":"max","label":"Bytes Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_direction","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[69],"type":"int"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_con_duration_ms","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":">","value":1}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"pie","dataTop":0,"orderBy":"","orderDesc":"","includeOther":false,"xAxis":{"dataBinding":"Action","label":"Action","dataTop":"10","dataType":""},"yAxis":[{"dataBinding":"Bytes Sent","format":"Default","legend":"Bytes Sent"}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID3 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID3 ${chartId}
|
|
insert_Report_to_file1 Report_ID3 ${reportId}
|
|
|
|
ReportSecurityEventTop10ServerIPHits
|
|
[Tags] Positive API Report 安全日志前十服务器IP命中日志数量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"security_event_log","groupColumnList":[{"name":"http_domain"},{"name":"common_server_ip"}],"queryColumnList":[{"name":"common_server_ip","expression":"","label":"Server IP"},{"name":"http_domain","expression":"","label":"Http.Domain"},{"name":"common_log_id","expression":"count","label":"counter","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":null,"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_client_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">","value":1}]},{"orConditions":[{"name":"common_c2s_pkt_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":">","value":1}]},{"orConditions":[{"name":"common_sled_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">=","value":1}]},{"orConditions":[{"name":"common_device_id","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">=","value":1}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"table","dataTop":10,"orderBy":"","orderDesc":"","drilldownTop":5,"includeOther":false,"tableType":"Regular","columns":[{"title":"Server IP","width":0,"dataBindings":[{"dataType":"","dataBinding":"Server IP","format":"Default","legend":"Server IP","name":"common_server_ip"}]},{"title":"Http.Domain","width":0,"dataBindings":[{"dataType":"","dataBinding":"Http.Domain","format":"Default","legend":"Http.Domain","name":"http_domain"}]},{"title":"counter","width":0,"dataBindings":[{"dataType":"","dataBinding":"counter","format":"Default","legend":"counter","name":"common_log_id"}]}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID4 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID4 ${chartId}
|
|
insert_Report_to_file1 Report_ID4 ${reportId}
|
|
|
|
ReportSecurityEventEndTimeInterceptHits
|
|
[Tags] Positive API Report 结束时间Intercept动作命中数量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"security_event_log","groupColumnList":[{"name":"common_end_time"}],"queryColumnList":[{"name":"common_end_time","expression":"","label":"End Time"},{"name":"http_domain","expression":"count","label":"Http.Domain","expressionList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_action","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[2],"type":"int"}]}]},"havingCondition":null,"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"area","dataTop":0,"orderBy":"","orderDesc":0,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"End Time","label":"","format":"Time"},"line":[{"dataBinding":"Http.Domain","type":"Line Up","format":"Default","legend":"Http.Domain"}],"groupBy":null},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"yesterday","rangeInterval":"","rangeUnit":"","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"hour","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID5 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID5 ${chartId}
|
|
insert_Report_to_file1 Report_ID5 ${reportId}
|
|
|
|
ReportProxyEventAddressTypeNotIpv6CountExternalIP
|
|
[Tags] Positive API Report 代理日志ipv4统计ExternalIP数量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"proxy_event_log","groupColumnList":[{"name":"common_recv_time"},{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"common_external_ip","expression":"count","label":"External IP","expressionList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_address_type","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[6],"type":"int"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_client_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">","value":1000}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"line","dataTop":0,"orderBy":"","orderDesc":0,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"External IP","type":"Line Up","format":"Default","legend":"External IP"}],"groupBy":null},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"today so far","rangeInterval":"","rangeUnit":"","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":30,"timeUnit":"minute","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID6 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID6 ${chartId}
|
|
insert_Report_to_file1 Report_ID6 ${reportId}
|
|
|
|
ReportProxyEventAddressTypeNotIpv6CountExternalIP
|
|
[Tags] Positive API Report 代理日志ipv4统计ExternalIP数量
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"proxy_event_log","groupColumnList":[{"name":"common_schema_type"}],"queryColumnList":[{"name":"common_schema_type","expression":"","label":"Schema Type"},{"name":"common_log_id","expression":"count","label":"counter","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_client_port","expression":">","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":">","value":">"},{"label":"<","value":"<"},{"label":">=","value":">="},{"label":"<=","value":"<="}],"value":[10000],"type":"int"}]}]},"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_device_id","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count_distinct","expression":"<","value":100}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"pie","dataTop":0,"orderBy":"","orderDesc":"","includeOther":false,"xAxis":{"dataBinding":"Schema Type","label":"Schema Type","dataTop":5,"dataType":""},"yAxis":[{"dataBinding":"counter","format":"Default","legend":"counter"}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":1}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID7 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID7 ${chartId}
|
|
insert_Report_to_file1 Report_ID7 ${reportId}
|
|
|
|
ReportSessionRecordsTrafficTop30ServerIPbyBandwidthandSessions
|
|
[Tags] Positive API Report 通过带宽和会话访问前30个服务器IP
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"connection_record_log","groupColumnList":[{"name":"common_server_ip"}],"queryColumnList":[{"name":"common_server_ip","expression":"","label":"Server IP"},{"name":"common_c2s_byte_num","expression":"sum","label":"Bytes Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_byte_num","expression":"sum","label":"Bytes Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_byte_num,common_s2c_byte_num","expression":"sum","label":"bytes","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_sessions","expression":"sum","label":"Sessions","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_l4_protocol","expression":"=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="},{"label":"Like","value":"Like"},{"label":"Not Like","value":"Not Like"},{"label":"notEmpty","value":"notEmpty"}],"value":["IPv4_TCP"],"type":"string"}]}]},"havingCondition":null,"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"table","dataTop":30,"orderBy":"bytes","orderDesc":0,"drilldownTop":5,"includeOther":false,"tableType":"Regular","columns":[{"title":"Server IP","width":0,"dataBindings":[{"dataType":"","dataBinding":"Server IP","format":"Default","legend":"Server IP","name":"common_server_ip"}]},{"title":"Throughput","width":0,"dataBindings":[{"dataType":"","dataBinding":"bytes","format":"Bandwidth(KB/MB/GB)","legend":"bytes","name":"common_c2s_byte_num,common_s2c_byte_num"}]},{"title":"Bandwidth","width":0,"dataBindings":[{"dataType":"","dataBinding":"Bytes Sent","format":"Bar","legend":"Bytes Sent","name":"common_c2s_byte_num"},{"dataType":"","dataBinding":"Bytes Received","format":"Bar","legend":"Bytes Received","name":"common_s2c_byte_num"}]},{"title":"Sessions","width":0,"dataBindings":[{"dataType":"","dataBinding":"Sessions","format":"Counter(K/M/G)","legend":"Sessions","name":"common_sessions"}]}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID8 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID8 ${chartId}
|
|
insert_Report_to_file1 Report_ID8 ${reportId}
|
|
|
|
ReportSessionRecordsTop10LogIDHits
|
|
[Tags] Positive API Report
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"connection_record_log","groupColumnList":[{"name":"http_url"},{"name":"common_client_ip"}],"queryColumnList":[{"name":"common_client_ip","expression":"","label":"Client IP"},{"name":"http_url","expression":"","label":"Http.URL"},{"name":"common_log_id","expression":"count","label":"counter","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":null,"havingCondition":{"andConditions":[{"orConditions":[{"name":"common_sled_ip","funList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">","value":1}]},{"orConditions":[{"name":"common_c2s_pkt_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"sum","expression":">","value":1}]},{"orConditions":[{"name":"common_sessions","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">=","value":1}]},{"orConditions":[{"name":"common_s2c_byte_num","funList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}],"expressionList":["=","!=",">","<",">=","<="],"function":"count","expression":">","value":1}]}]},"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"table","dataTop":10,"orderBy":"","orderDesc":"","drilldownTop":5,"includeOther":false,"tableType":"Regular","columns":[{"title":"Client IP","width":0,"dataBindings":[{"dataType":"","dataBinding":"Client IP","format":"Default","legend":"Client IP","name":"common_client_ip"}]},{"title":"Http.URL","width":0,"dataBindings":[{"dataType":"","dataBinding":"Http.URL","format":"Default","legend":"Http.URL","name":"http_url"}]},{"title":"counter","width":0,"dataBindings":[{"dataType":"","dataBinding":"counter","format":"Default","legend":"counter","name":"common_log_id"}]}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID9 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID9 ${chartId}
|
|
insert_Report_to_file1 Report_ID9 ${reportId}
|
|
|
|
|
|
ReportRadiusFramedIPTits
|
|
[Tags] Positive API Report 统计Radius日志FramedIP总数
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"radius_record_log","groupColumnList":[{"name":"common_recv_time"}],"queryColumnList":[{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"radius_framed_ip","expression":"count","label":"Framed IP","expressionList":[{"label":"count","value":"count"},{"label":"count distinct","value":"count_distinct"}]}],"filterCondition":null,"havingCondition":null,"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"line","dataTop":0,"orderBy":"","orderDesc":0,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"Framed IP","type":"Line Up","format":"Default","legend":"Framed IP"}],"groupBy":null},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"hour","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID10 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID10 ${chartId}
|
|
insert_Report_to_file1 Report_ID10 ${reportId}
|
|
|
|
ReportVoip
|
|
[Tags] Positive API Report Voip日志
|
|
Comment 创建Datasets
|
|
BasePostRequestOK ${dataset_url} {"list":{"name":"${TEST NAME}","logType":"voip_record_log","groupColumnList":[{"name":"common_recv_time"},{"name":"common_action"}],"queryColumnList":[{"name":"common_action","expression":"","label":"Action"},{"name":"common_recv_time","expression":"","label":"Receive Time"},{"name":"common_c2s_byte_num","expression":"sum","label":"Bytes Sent","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_s2c_byte_num","expression":"sum","label":"Bytes Received","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]},{"name":"common_c2s_byte_num,common_s2c_byte_num","expression":"sum","label":"Bytes","expressionList":[{"label":"sum","value":"sum"},{"label":"min","value":"min"},{"label":"max","value":"max"},{"label":"avg","value":"avg"},{"label":"count","value":"count"}]}],"filterCondition":{"andConditions":[{"orConditions":[{"name":"common_action","expression":"!=","expressionList":[{"label":"=","value":"="},{"label":"!=","value":"!="}],"value":[16],"type":"int"}]}]},"havingCondition":null,"isInitialize":0}}
|
|
${response} BaseGetRequestOK ${dataset_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&logType=&opStartTime=&opEndTime=&opUser=
|
|
${datasetId} Set Variable ${response}[data][list][0][id]
|
|
|
|
Comment 创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"${datasetId}","datasetName":"","chartType":"line","dataTop":0,"orderBy":"","orderDesc":0,"drilldownTop":0,"includeOther":false,"timeline":{"dataBinding":"Receive Time","label":"","format":"Time"},"line":[{"dataBinding":"Bytes Sent","type":"Line Up","format":"Default","legend":"Bytes Sent"},{"dataBinding":"Bytes Received","type":"Line Down","format":"Default","legend":"Bytes Received"},{"dataBinding":"Bytes","type":"Line Up","format":"Default","legend":"Bytes"}],"groupBy":null},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"hour","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Datasets_ID11 ${datasetId}
|
|
insert_Report_to_file1 CharLibraries_ID11 ${chartId}
|
|
insert_Report_to_file1 Report_ID11 ${reportId}
|
|
|
|
|
|
ReportTrafficTop10WebsiteDomainbySessions
|
|
[Tags] Positive API Report 使用内置datasets数据
|
|
Comment 使用默认datasets创建Chart Libraries
|
|
BasePostRequestOK ${chart_url} {"list":{"id":null,"name":"${TEST NAME}","description":"","datasetId":"1","datasetName":"Traffic-Top-Website-Domain-by-Sessions","chartType":"table","dataTop":10,"orderBy":"","orderDesc":"","drilldownTop":5,"includeOther":false,"tableType":"Regular","columns":[{"title":"sessions","width":0,"dataBindings":[{"dataType":"","dataBinding":"sessions","format":"Default","legend":"sessions","name":"common_sessions"}]},{"title":"domain","width":0,"dataBindings":[{"dataType":"","dataBinding":"domain","format":"Default","legend":"domain","name":"http_domain"}]}]},"refuseCode":true}
|
|
${response1} BaseGetRequestOK ${chart_url} pageSize=20&pageNo=1&id=&name=${TEST NAME}&opUser=
|
|
${chartId} Set Variable ${response1}[data][list][0][id]
|
|
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":${chartId},"chartName":"","timeGranulartiy":1,"timeUnit":"","disabled":true}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 CharLibraries_ID12 ${chartId}
|
|
insert_Report_to_file1 Report_ID12 ${reportId}
|
|
|
|
ReportEstimatedTCPSequenceGapLoss
|
|
[Tags] Positive API Report 使用内置ChartLibraries数据
|
|
Comment 创建Report
|
|
BasePostRequestOK ${report_url} {"reportJobList":{"rangeType":"last","rangeInterval":1,"rangeUnit":"week","jobName":"${TEST NAME}","scheduleId":"","chartList":[{"chartId":31,"chartName":"Estimated TCP Sequence Gap Loss","timeGranulartiy":1,"timeUnit":"hour","disabled":false}],"isNotice":0,"noticeMethod":"","receivers":[""],"receiver":"","startTime":"","endTime":"","filterCondition":null,"isDisplayTrafficTrend":0}}
|
|
${response2} BaseGetRequestOK ${report_url} pageSize=20&pageNo=1&jobIds=&jobName=${TEST NAME}&opStartTime=&opEndTime=&opUser=&scheduleId=
|
|
${reportId} Set Variable ${response2}[data][list][0][jobId]
|
|
Comment 验证报告是否产生
|
|
ResultGetRequestOK ${result_url} jobId=${reportId}&opStartTime=&opEndTime=&pageSize=-1
|
|
insert_Report_to_file1 Report_ID13 ${reportId}
|
|
|