Examples
This example shows how to configure a push query when the duration to refresh the flow metrics is set to the default duration
of 30 seconds:
switch# configure
switch(config)# analytics query 'select all from fc-scsi.scsi_initiator_itl_flow' name
inititl type periodic
This example shows how to display the list of configured push queries that were installed on a switch:
switch(config)# show analytics query all
Total queries:7
============================
Query Name :init
Query String :select all from fc-scsi.scsi_initiator
Query Type :periodic, interval 30
Query Name :targettl
Query String :select all from fc-scsi.scsi_target_tl_flow
Query Type :periodic, interval 30
Query Options :differential clear
Query Name :port
Query String :select all from fc-scsi.logical_port
Query Type :periodic, interval 30
Query Name :targetit
Query String :select all from fc-scsi.scsi_target_it_flow
Query Type :periodic, interval 30
Query Name :targetitl
Query String :select all from fc-scsi.scsi_target_itl_flow
Query Type :periodic, interval 30
Query Options :differential clear
Query Name :inititl
Query String :select all from fc-scsi.scsi_initiator_itl_flow
Query Type :periodic, interval 30
Query Name :initit
Query String :select all from fc-scsi.scsi_initiator_it_flow
Query Type :periodic, interval 30
This example shows an output of the push analytics query that was configured in the previous example (query name inititl):
switch(config)# show analytics query name inititl result
{ "values": {
"1": {
"port": "fc1/6",
"vsan": "10",
"app_id": "255",
"initiator_id": "0xe800a0",
"target_id": "0xd601e0",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "7",
"total_read_io_count": "0",
"total_write_io_count": "1008608573",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "370765952314",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "52084968152",
"total_read_io_bytes": "0",
"total_write_io_bytes": "2065630357504",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "16171468343166",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "1008608566",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "2065630343168",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "16070",
"peak_write_io_rate": "32468",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "32912384",
"peak_write_io_bandwidth": "66494976",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "2048",
"write_io_size_max": "2048",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "111",
"write_io_completion_time_max": "9166",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "36",
"write_io_initiation_time_max": "3265",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "100",
"write_io_inter_gap_time_max": "1094718",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "23",
"read_io_aborts": "0",
"write_io_aborts": "0",
"read_io_failures": "0",
"write_io_failures": "0",
"read_io_timeouts": "0",
"write_io_timeouts": "0",
"read_io_scsi_check_condition_count": "0",
"write_io_scsi_check_condition_count": "0",
"read_io_scsi_busy_count": "0",
"write_io_scsi_busy_count": "0",
"read_io_scsi_reservation_conflict_count": "0",
"write_io_scsi_reservation_conflict_count": "0",
"read_io_scsi_queue_full_count": "0",
"write_io_scsi_queue_full_count": "0",
"sampling_start_time": "1529993232",
"sampling_end_time": "1529993260"
},
"2": {
"port": "fc1/6",
"vsan": "10",
"app_id": "255",
"initiator_id": "0xe800a1",
"target_id": "0xd601e1",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "8",
"total_read_io_count": "0",
"total_write_io_count": "1004271260",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "370004164726",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "51858511487",
"total_read_io_bytes": "0",
"total_write_io_bytes": "2056747540480",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "16136686881766",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "1004271252",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "2056747524096",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "16065",
"peak_write_io_rate": "16194",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "32901632",
"peak_write_io_bandwidth": "33165824",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "2048",
"write_io_size_max": "2048",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "114",
"write_io_completion_time_max": "9019",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "37",
"write_io_initiation_time_max": "3158",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "101",
"write_io_inter_gap_time_max": "869035",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "19",
"read_io_aborts": "0",
"write_io_aborts": "0",
"read_io_failures": "0",
"write_io_failures": "0",
"read_io_timeouts": "0",
"write_io_timeouts": "0",
"read_io_scsi_check_condition_count": "0",
"write_io_scsi_check_condition_count": "0",
"read_io_scsi_busy_count": "0",
"write_io_scsi_busy_count": "0",
"read_io_scsi_reservation_conflict_count": "0",
"write_io_scsi_reservation_conflict_count": "0",
"read_io_scsi_queue_full_count": "0",
"write_io_scsi_queue_full_count": "0",
"sampling_start_time": "1529993232",
"sampling_end_time": "1529993260"
}
}}
This example shows how to remove an installed query name:
switch(config)# no analytics name inititl