Examples
This example shows the output of all the flow metrics of the SCSI initiator ITL flow view instance:
switch# show analytics query 'select all from fc-scsi.scsi_initiator_itl_flow'
{ "values": {
"1": {
"port": "fc1/1",
"vsan": "10",
"app_id": "255",
"initiator_id": "0xe80041",
"target_id": "0xd60200",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "1",
"total_read_io_count": "0",
"total_write_io_count": "1162370362",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "116204704658",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "43996934029",
"total_read_io_bytes": "0",
"total_write_io_bytes": "595133625344",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "41139462314556",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "1162370358",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "595133623296",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "7250",
"peak_write_io_rate": "7304",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "3712384",
"peak_write_io_bandwidth": "3739904",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "512",
"write_io_size_max": "512",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "89",
"write_io_completion_time_max": "416",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "34",
"write_io_initiation_time_max": "116",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "31400",
"write_io_inter_gap_time_max": "118222",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "5",
"read_io_aborts": "0",
"write_io_aborts": "0",
"read_io_failures": "0",
"write_io_failures": "0",
"read_io_timeouts": "0",
"write_io_timeouts": "1",
"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": "1528535447",
"sampling_end_time": "1528697457"
},
.
.
.
"5": {
"port": "fc1/8",
"vsan": "10",
"app_id": "255",
"initiator_id": "0xe80001",
"target_id": "0xe800a1",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "1",
"total_read_io_count": "0",
"total_write_io_count": "1138738309",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "109792480881",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "39239145641",
"total_read_io_bytes": "0",
"total_write_io_bytes": "583034014208",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "41479779998852",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "1138738307",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "583034013184",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "7074",
"peak_write_io_rate": "7903",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "3622144",
"peak_write_io_bandwidth": "4046336",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "512",
"write_io_size_max": "512",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "71",
"write_io_completion_time_max": "3352",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "26",
"write_io_initiation_time_max": "2427",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "25988",
"write_io_inter_gap_time_max": "868452",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "5",
"read_io_aborts": "0",
"write_io_aborts": "0",
"read_io_failures": "0",
"write_io_failures": "0",
"read_io_timeouts": "0",
"write_io_timeouts": "1",
"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": "1528535447",
"sampling_end_time": "1528697457"
}
}}
This example shows the output of all the flow metrics of the NVMe initiator ITN flow view instance:
switch# show analytics query 'select all from fc-nvme.nvme_initiator_itn_flow'
{ "values": {
"1": {
"port": "fc1/9",
"vsan": "5",
"app_id": "255",
"initiator_id": "0xa40160",
"target_id": "0xa4018c",
"connection_id": "0000-0000-0000-0000",
"namespace_id": "1",
"active_io_read_count": "0",
"active_io_write_count": "0",
"total_read_io_count": "414106348",
"total_write_io_count": "0",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "0",
"total_read_io_time": "204490863437",
"total_write_io_time": "0",
"total_read_io_initiation_time": "132775579977",
"total_write_io_initiation_time": "0",
"total_read_io_bytes": "16226866588672",
"total_write_io_bytes": "0",
"total_read_io_inter_gap_time": "19198018763772",
"total_write_io_inter_gap_time": "0",
"total_time_metric_based_read_io_count": "414106244",
"total_time_metric_based_write_io_count": "0",
"total_time_metric_based_read_io_bytes": "16226860198912",
"total_time_metric_based_write_io_bytes": "0",
"read_io_rate": "0",
"peak_read_io_rate": "16826",
"write_io_rate": "0",
"peak_write_io_rate": "0",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "656438400",
"write_io_bandwidth": "0",
"peak_write_io_bandwidth": "0",
"read_io_size_min": "1024",
"read_io_size_max": "262144",
"write_io_size_min": "0",
"write_io_size_max": "0",
"read_io_completion_time_min": "16",
"read_io_completion_time_max": "7057",
"write_io_completion_time_min": "0",
"write_io_completion_time_max": "0",
"read_io_initiation_time_min": "16",
"read_io_initiation_time_max": "5338",
"write_io_initiation_time_min": "0",
"write_io_initiation_time_max": "0",
"read_io_inter_gap_time_min": "32",
"read_io_inter_gap_time_max": "83725169",
"write_io_inter_gap_time_min": "0",
"write_io_inter_gap_time_max": "0",
"peak_active_io_read_count": "11",
"peak_active_io_write_count": "0",
"read_io_aborts": "24",
"write_io_aborts": "0",
"read_io_failures": "80",
"write_io_failures": "0",
"read_io_timeouts": "0",
"write_io_timeouts": "0",
"read_io_nvme_lba_out_of_range_count": "0",
"write_io_nvme_lba_out_of_range_count": "0",
"read_io_nvme_ns_not_ready_count": "0",
"write_io_nvme_ns_not_ready_count": "0",
"read_io_nvme_reservation_conflict_count": "0",
"write_io_nvme_reservation_conflict_count": "0",
"read_io_nvme_capacity_exceeded_count": "0",
"write_io_nvme_capacity_exceeded_count": "0",
"sampling_start_time": "1512847422",
"sampling_end_time": "1513166516"
},
.
.
.
"5": {
"port": "fc1/9",
"vsan": "5",
"app_id": "255",
"initiator_id": "0xa40165",
"target_id": "0xa40190",
"connection_id": "0000-0000-0000-0000",
"namespace_id": "1",
"active_io_read_count": "0",
"active_io_write_count": "0",
"total_read_io_count": "33391955",
"total_write_io_count": "643169087",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "0",
"total_read_io_time": "13005795783",
"total_write_io_time": "131521212441",
"total_read_io_initiation_time": "5696099596",
"total_write_io_initiation_time": "71938348902",
"total_read_io_bytes": "1309083368448",
"total_write_io_bytes": "329302572544",
"total_read_io_inter_gap_time": "19175084866843",
"total_write_io_inter_gap_time": "19182318062480",
"total_time_metric_based_read_io_count": "33391919",
"total_time_metric_based_write_io_count": "643168808",
"total_time_metric_based_read_io_bytes": "1309074355200",
"total_time_metric_based_write_io_bytes": "329302429696",
"read_io_rate": "0",
"peak_read_io_rate": "574",
"write_io_rate": "0",
"peak_write_io_rate": "9344",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "19122176",
"write_io_bandwidth": "0",
"peak_write_io_bandwidth": "4784384",
"read_io_size_min": "1024",
"read_io_size_max": "262144",
"write_io_size_min": "512",
"write_io_size_max": "512",
"read_io_completion_time_min": "16",
"read_io_completion_time_max": "5123",
"write_io_completion_time_min": "27",
"write_io_completion_time_max": "2254",
"read_io_initiation_time_min": "16",
"read_io_initiation_time_max": "3650",
"write_io_initiation_time_min": "12",
"write_io_initiation_time_max": "1377",
"read_io_inter_gap_time_min": "32",
"read_io_inter_gap_time_max": "3234375975",
"write_io_inter_gap_time_min": "32",
"write_io_inter_gap_time_max": "38886219",
"peak_active_io_read_count": "6",
"peak_active_io_write_count": "16",
"read_io_aborts": "6",
"write_io_aborts": "18",
"read_io_failures": "30",
"write_io_failures": "261",
"read_io_timeouts": "0",
"write_io_timeouts": "0",
"read_io_nvme_lba_out_of_range_count": "0",
"write_io_nvme_lba_out_of_range_count": "0",
"read_io_nvme_ns_not_ready_count": "0",
"write_io_nvme_ns_not_ready_count": "0",
"read_io_nvme_reservation_conflict_count": "0",
"write_io_nvme_reservation_conflict_count": "0",
"read_io_nvme_capacity_exceeded_count": "0",
"write_io_nvme_capacity_exceeded_count": "0",
"sampling_start_time": "1512847422",
"sampling_end_time": "1513166516"
}
}}
This example shows an output of specific flow metrics for a specific initiator ID of an initiator ITL flow view type:
switch# show analytics query 'select port,initiator_id, target_id,lun,
total_read_io_count,total_write_io_count,read_io_rate, write_io_rate from
fc-scsi.scsi_initiator_itl_flow where initiator_id=0xe80001'
{ "values": {
"1": {
"port": "fc1/8",
"initiator_id": "0xe80001",
"target_id": "0xe800a1",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1139010960",
"read_io_rate": "0",
"write_io_rate": "7071",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697495"
}
}}
This example shows an output of specific flow metrics for a specific initiator ID and LUN of an initiator ITL flow view type:
switch# show analytics query 'select port,initiator_id, target_id,lun,
total_read_io_count,total_write_io_count,read_io_rate, write_io_rate from
fc-scsi.scsi_initiator_itl_flow where initiator_id=0xe80001 and lun= 0000-0000-0000-0000'
{ "values": {
"1": {
"port": "fc1/8",
"initiator_id": "0xe80001",
"target_id": "0xe800a1",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1139453979",
"read_io_rate": "0",
"write_io_rate": "7070",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697559"
}
}}
This example shows an output of specific flow metrics for a specific LUN with the output sorted for the write_io_rate flow
metrics of a target ITL flow view type:
switch# show analytics query 'select port,initiator_id, target_id,lun,total_read_io_count,
total_write_io_count,read_io_rate, write_io_rate from fc-scsi.scsi_initiator_itl_flow where
lun= 0000-0000-0000-0000 sort write_io_rate'
{ "values": {
"1": {
"port": "fc1/6",
"initiator_id": "0xe80020",
"target_id": "0xd60040",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1103394068",
"read_io_rate": "0",
"write_io_rate": "6882",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697630"
},
"2": {
"port": "fc1/6",
"initiator_id": "0xe80021",
"target_id": "0xe80056",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1119199742",
"read_io_rate": "0",
"write_io_rate": "6946",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697630"
},
"3": {
"port": "fc1/8",
"initiator_id": "0xe80000",
"target_id": "0xe80042",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1119506589",
"read_io_rate": "0",
"write_io_rate": "6948",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697630"
},
"4": {
"port": "fc1/8",
"initiator_id": "0xe80001",
"target_id": "0xe800a1",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1139953183",
"read_io_rate": "0",
"write_io_rate": "7068",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697630"
},
"5": {
"port": "fc1/1",
"initiator_id": "0xe80041",
"target_id": "0xd60200",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1163615698",
"read_io_rate": "0",
"write_io_rate": "7247",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697630"
}
}}
This example shows an output of specific flow metrics for a specific LUN with the output limited to three records and sorted
for the write_io_rate flow metrics of an initiator ITL flow view type:
switch# show analytics query 'select port,initiator_id, target_id,lun,total_read_io_count,
total_write_io_count,read_io_rate, write_io_rate from fc-scsi.scsi_initiator_itl_flow where
lun= 0000-0000-0000-0000 sort write_io_rate limit 3'
{ "values": {
"1": {
"port": "fc1/6",
"initiator_id": "0xe80020",
"target_id": "0xd60040",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1103901828",
"read_io_rate": "0",
"write_io_rate": "6885",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697704"
},
"2": {
"port": "fc1/8",
"initiator_id": "0xe80000",
"target_id": "0xe80042",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1120018575",
"read_io_rate": "0",
"write_io_rate": "6940",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697704"
},
"3": {
"port": "fc1/6",
"initiator_id": "0xe80021",
"target_id": "0xe80056",
"lun": "0000-0000-0000-0000",
"total_read_io_count": "0",
"total_write_io_count": "1119711583",
"read_io_rate": "0",
"write_io_rate": "6942",
"sampling_start_time": "1528535447",
"sampling_end_time": "1528697704"
}
}}
These examples show how to clear all the minimum, maximum, and peak flow metrics:
-
This example show the output before clearing the all the minimum, maximum, and peak flow metrics:
Note |
You must execute the clear command twice for the first time for clearing all the minimum, maximum, and peak flow metrics.
Thereafter, you can execute the clear command once for clearing the flow metrics.
|
switch# show analytics query "select all from
fc-scsi.scsi_target_itl_flow where port=fc1/17"
{ "values": {
"1": {
"port": "fc1/17",
"vsan": "1",
"app_id": "255",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "1",
"total_read_io_count": "0",
"total_write_io_count": "84701",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "7007132",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "2421756",
"total_read_io_bytes": "0",
"total_write_io_bytes": "86733824",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "2508109021",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "84701",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "86733824",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "8711",
"peak_write_io_rate": "8711",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "8920576",
"peak_write_io_bandwidth": "8920576",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "1024",
"write_io_size_max": "1024",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "74",
"write_io_completion_time_max": "844",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "24",
"write_io_initiation_time_max": "775",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "26903",
"write_io_inter_gap_time_max": "287888",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "3",
"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": "1530683133",
"sampling_end_time": "1530684301"
},
"2": {
"port": "fc1/17",
"vsan": "1",
"app_id": "255",
"target_id": "0xef0040",
"initiator_id": "0xef0020",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "0",
"total_read_io_count": "0",
"total_write_io_count": "84700",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "6973333",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "2400011",
"total_read_io_bytes": "0",
"total_write_io_bytes": "86732800",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "2508096990",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "84700",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "86732800",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "8711",
"peak_write_io_rate": "8711",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "8920576",
"peak_write_io_bandwidth": "8920576",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "1024",
"write_io_size_max": "1024",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "74",
"write_io_completion_time_max": "1134",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "24",
"write_io_initiation_time_max": "345",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "26789",
"write_io_inter_gap_time_max": "298809",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "3",
"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": "1530683133",
"sampling_end_time": "1530684301"
}
}}
-
This examples shows the output after clearing all the minimum, maximum, and peak flow metrics. The metrics that were cleared
are highlighted in the output.
switch# show analytics query "select all from
fc-scsi.scsi_target_itl_flow where port=fc1/17" clear
{ "values": {
"1": {
"port": "fc1/17",
"vsan": "1",
"app_id": "255",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0000-0000-0000-0000",
"active_io_read_count": "0",
"active_io_write_count": "0",
"total_read_io_count": "0",
"total_write_io_count": "800615",
"total_seq_read_io_count": "0",
"total_seq_write_io_count": "1",
"total_read_io_time": "0",
"total_write_io_time": "66090290",
"total_read_io_initiation_time": "0",
"total_write_io_initiation_time": "22793874",
"total_read_io_bytes": "0",
"total_write_io_bytes": "819829760",
"total_read_io_inter_gap_time": "0",
"total_write_io_inter_gap_time": "23702347887",
"total_time_metric_based_read_io_count": "0",
"total_time_metric_based_write_io_count": "800615",
"total_time_metric_based_read_io_bytes": "0",
"total_time_metric_based_write_io_bytes": "819829760",
"read_io_rate": "0",
"peak_read_io_rate": "0",
"write_io_rate": "0",
"peak_write_io_rate": "0",
"read_io_bandwidth": "0",
"peak_read_io_bandwidth": "0",
"write_io_bandwidth": "0",
"peak_write_io_bandwidth": "0",
"read_io_size_min": "0",
"read_io_size_max": "0",
"write_io_size_min": "0",
"write_io_size_max": "0",
"read_io_completion_time_min": "0",
"read_io_completion_time_max": "0",
"write_io_completion_time_min": "0",
"write_io_completion_time_max": "0",
"read_io_initiation_time_min": "0",
"read_io_initiation_time_max": "0",
"write_io_initiation_time_min": "0",
"write_io_initiation_time_max": "0",
"read_io_inter_gap_time_min": "0",
"read_io_inter_gap_time_max": "0",
"write_io_inter_gap_time_min": "0",
"write_io_inter_gap_time_max": "0",
"peak_active_io_read_count": "0",
"peak_active_io_write_count": "0",
"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": "1530683133",
"sampling_end_time": "1530684428"
},
}}
These examples show how to stream only the ITL flow metrics that have changed between streaming intervals:
-
This example shows the output before using the differential option:
switch# show analytics query "select port, target_id, initiator_id,lun,
total_write_io_count from fc-scsi.scsi_target_itl_flow where port=fc1/17"
differential
{ "values": {
"1": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0001-0000-0000-0000",
"total_write_io_count": "1515601",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683484"
},
"2": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0020",
"lun": "0000-0000-0000-0000",
"total_write_io_count": "1515601",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683484"
},
"3": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0020",
"lun": "0001-0000-0000-0000",
"total_write_io_count": "1515600",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683484"
},
"4": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0000-0000-0000-0000",
"total_write_io_count": "1515600",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683484"
}
}}
-
This example shows the output with the differential option and shows only the records that have changed:
switch# show analytics query "select port, target_id,
initiator_id,lun,total_write_io_count from fc-scsi.scsi_target_itl_flow where port=fc1/17"
differential
{ "values": {
"1": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0001-0000-0000-0000",
"total_write_io_count": "1892021",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683534"
},
"2": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0020",
"lun": "0000-0000-0000-0000",
"total_write_io_count": "1892021",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683534"
},
"3": {
"port": "fc1/17",
"target_id": "0xef0040",
"initiator_id": "0xef0000",
"lun": "0000-0000-0000-0000",
"total_write_io_count": "1892021",
"sampling_start_time": "1530683133",
"sampling_end_time": "1530683534"
}
}}
This example shows an output of all the installed push analytics queries:
switch# 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 how to view an installed push analytics query:
switch# show analytics query name tartl
Query Name :tartl
Query String :select all from fc-scsi.scsi_target_tl_flow
Query Type :periodic, interval 30
This example shows the output of a push query that has already been configured:
switch# show analytics query name iniitl 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"
}
}}