Re: Parsing Output

#!/usr/bin/perl

use strict; # https://perlmonks.org/?node_id=11141548
use warnings;
use JSON::PP;

my $data = join '', <DATA>;
my $hashref = JSON::PP->new->decode($data);
use Data::Dump 'dd'; dd $hashref;

__DATA__
{"paging":{"offset":0,"limit":100,"total":25},"data":[{"name":"ESPAP3"
+,"network":"ePMP","type":"epmp","timestamp":"2022-02-15T04:00:00-06:0
+0","radio":{"dl_frame_utilization":53.50833,"dl_kbits":218936297,"dl_
+pkts":24533891,"dl_retransmits_pct":3.7125,"dl_throughput":60611.0591
+7,"ul_kbits":11781720,"ul_pkts":10095078,"ul_retransmits_pct":1.7481,
+"ul_throughput":3261.45},"tower":"Espat Twr","sm_count":47,"mac":"00:
+04:56:22:51:32","mode":"ap","sm_drops":1,"managed_account":"","online
+_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ
+e":"epmp","timestamp":"2022-02-15T05:00:00-06:00","radio":{"dl_frame_
+utilization":55.79167,"dl_kbits":228622837,"dl_pkts":25268171,"dl_ret
+ransmits_pct":3.4875,"dl_throughput":63241.6925,"ul_kbits":11064503,"
+ul_pkts":10404746,"ul_retransmits_pct":1.6548,"ul_throughput":3060.63
+917},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mod
+e":"ap","sm_drops":3,"managed_account":"","online_duration":3600,"upt
+ime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp
+":"2022-02-15T06:00:00-06:00","radio":{"dl_frame_utilization":57.5833
+3,"dl_kbits":223937159,"dl_pkts":23815786,"dl_retransmits_pct":3.9375
+,"dl_throughput":61984.47583,"ul_kbits":10983095,"ul_pkts":10825123,"
+ul_retransmits_pct":1.8673,"ul_throughput":3040.02167},"tower":"Espat
+ Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":
+3,"managed_account":"","online_duration":3600,"uptime":3600},{"name":
+"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T07:00
+:00-06:00","radio":{"dl_frame_utilization":58.84167,"dl_kbits":228485
+690,"dl_pkts":24464710,"dl_retransmits_pct":4.07417,"dl_throughput":6
+3211.23917,"ul_kbits":10887235,"ul_pkts":11051562,"ul_retransmits_pct
+":1.894,"ul_throughput":3012.27583},"tower":"Espat Twr","sm_count":47
+,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account"
+:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network":
+"ePMP","type":"epmp","timestamp":"2022-02-15T08:00:00-06:00","radio":
+{"dl_frame_utilization":67.775,"dl_kbits":270520179,"dl_pkts":2923159
+2,"dl_retransmits_pct":4.19,"dl_throughput":74891.63583,"ul_kbits":15
+477123,"ul_pkts":13968153,"ul_retransmits_pct":1.8042,"ul_throughput"
+:4285.24083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:
+32","mode":"ap","sm_drops":2,"managed_account":"","online_duration":3
+600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","t
+imestamp":"2022-02-15T09:00:00-06:00","radio":{"dl_frame_utilization"
+:69.24167,"dl_kbits":264290580,"dl_pkts":28611603,"dl_retransmits_pct
+":3.92667,"dl_throughput":73100.34333,"ul_kbits":16808560,"ul_pkts":1
+3769154,"ul_retransmits_pct":1.8935,"ul_throughput":4649.08167},"towe
+r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s
+m_drops":3,"managed_account":"","online_duration":3600,"uptime":3600}
+,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02
+-15T10:00:00-06:00","radio":{"dl_frame_utilization":58.70833,"dl_kbit
+s":239591107,"dl_pkts":25503558,"dl_retransmits_pct":3.27417,"dl_thro
+ughput":66325.50667,"ul_kbits":11737909,"ul_pkts":12055338,"ul_retran
+smits_pct":1.7943,"ul_throughput":3249.29},"tower":"Espat Twr","sm_co
+unt":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":1,"managed_a
+ccount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","ne
+twork":"ePMP","type":"epmp","timestamp":"2022-02-15T11:00:00-06:00","
+radio":{"dl_frame_utilization":60.13333,"dl_kbits":261326558,"dl_pkts
+":27486494,"dl_retransmits_pct":3.88583,"dl_throughput":72350.99417,"
+ul_kbits":12646382,"ul_pkts":13759064,"ul_retransmits_pct":1.9393,"ul
+_throughput":3501.27167},"tower":"Espat Twr","sm_count":47,"mac":"00:
+04:56:22:51:32","mode":"ap","sm_drops":2,"managed_account":"","online
+_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ
+e":"epmp","timestamp":"2022-02-15T12:00:00-06:00","radio":{"dl_frame_
+utilization":60.96667,"dl_kbits":250838133,"dl_pkts":26973868,"dl_ret
+ransmits_pct":3.33417,"dl_throughput":69391.92,"ul_kbits":13262809,"u
+l_pkts":13460633,"ul_retransmits_pct":1.7437,"ul_throughput":3669.044
+17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode
+":"ap","sm_drops":4,"managed_account":"","online_duration":3600,"upti
+me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp"
+:"2022-02-15T13:00:00-06:00","radio":{"dl_frame_utilization":66.61667
+,"dl_kbits":280139966,"dl_pkts":30571916,"dl_retransmits_pct":3.14833
+,"dl_throughput":77542.95833,"ul_kbits":24334025,"ul_pkts":17020906,"
+ul_retransmits_pct":1.9275,"ul_throughput":6735.07083},"tower":"Espat
+ Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":
+3,"managed_account":"","online_duration":3600,"uptime":3600},{"name":
+"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T14:00
+:00-06:00","radio":{"dl_frame_utilization":73.70833,"dl_kbits":319827
+700,"dl_pkts":34334577,"dl_retransmits_pct":2.98333,"dl_throughput":8
+8461.8575,"ul_kbits":25273905,"ul_pkts":21591443,"ul_retransmits_pct"
+:2.2535,"ul_throughput":6991.14417},"tower":"Espat Twr","sm_count":47
+,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":8,"managed_account"
+:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network":
+"ePMP","type":"epmp","timestamp":"2022-02-15T15:00:00-06:00","radio":
+{"dl_frame_utilization":75.51667,"dl_kbits":326402388,"dl_pkts":35193
+281,"dl_retransmits_pct":3.0575,"dl_throughput":90371.21083,"ul_kbits
+":26966297,"ul_pkts":22515634,"ul_retransmits_pct":2.1412,"ul_through
+put":7466.1675},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:
+51:32","mode":"ap","sm_drops":8,"managed_account":"","online_duration
+":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp"
+,"timestamp":"2022-02-15T16:00:00-06:00","radio":{"dl_frame_utilizati
+on":74.14545,"dl_kbits":300839263,"dl_pkts":32604826,"dl_retransmits_
+pct":2.58364,"dl_throughput":90848.48727,"ul_kbits":30157231,"ul_pkts
+":21712953,"ul_retransmits_pct":2.0661,"ul_throughput":9106.83182},"t
+ower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap"
+,"sm_drops":4,"managed_account":"","online_duration":3600,"uptime":36
+00},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022
+-02-15T17:00:00-06:00","radio":{"dl_frame_utilization":56.83333,"dl_k
+bits":258417074,"dl_pkts":27833706,"dl_retransmits_pct":2.93667,"dl_t
+hroughput":71535.6275,"ul_kbits":22211683,"ul_pkts":14625319,"ul_retr
+ansmits_pct":1.8357,"ul_throughput":6148.98083},"tower":"Espat Twr","
+sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":4,"mana
+ged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3
+","network":"ePMP","type":"epmp","timestamp":"2022-02-15T18:00:00-06:
+00","radio":{"dl_frame_utilization":40.575,"dl_kbits":172161552,"dl_p
+kts":18441382,"dl_retransmits_pct":2.97,"dl_throughput":47646.78083,"
+ul_kbits":14526870,"ul_pkts":8192202,"ul_retransmits_pct":0.0175,"ul_
+throughput":4020.45417},"tower":"Espat Twr","sm_count":47,"mac":"00:0
+4:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_
+duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type
+":"epmp","timestamp":"2022-02-15T19:00:00-06:00","radio":{"dl_frame_u
+tilization":27.24167,"dl_kbits":120543656,"dl_pkts":13037188,"dl_retr
+ansmits_pct":2.56833,"dl_throughput":33365.85417,"ul_kbits":9618636,"
+ul_pkts":5176035,"ul_retransmits_pct":1.1299,"ul_throughput":2662.299
+17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode
+":"ap","sm_drops":0,"managed_account":"","online_duration":3600,"upti
+me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp"
+:"2022-02-15T20:00:00-06:00","radio":{"dl_frame_utilization":19.675,"
+dl_kbits":84770133,"dl_pkts":9138076,"dl_retransmits_pct":1.69667,"dl
+_throughput":23459.96083,"ul_kbits":7774048,"ul_pkts":3485288,"ul_ret
+ransmits_pct":0.8403,"ul_throughput":2151.21167},"tower":"Espat Twr",
+"sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":2,"man
+aged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP
+3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T21:00:00-06
+:00","radio":{"dl_frame_utilization":14.825,"dl_kbits":57400859,"dl_p
+kts":6403063,"dl_retransmits_pct":2.41167,"dl_throughput":15881.745,"
+ul_kbits":6620987,"ul_pkts":2642339,"ul_retransmits_pct":0.8676,"ul_t
+hroughput":1831.29833},"tower":"Espat Twr","sm_count":47,"mac":"00:04
+:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_d
+uration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type"
+:"epmp","timestamp":"2022-02-15T22:00:00-06:00","radio":{"dl_frame_ut
+ilization":10.68333,"dl_kbits":34960258,"dl_pkts":4146049,"dl_retrans
+mits_pct":3.375,"dl_throughput":9678.53,"ul_kbits":5463953,"ul_pkts":
+1916776,"ul_retransmits_pct":0.8151,"ul_throughput":1512.78583},"towe
+r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s
+m_drops":0,"managed_account":"","online_duration":3600,"uptime":3600}
+,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02
+-15T23:00:00-06:00","radio":{"dl_frame_utilization":10.73333,"dl_kbit
+s":26089752,"dl_pkts":3410266,"dl_retransmits_pct":3.58833,"dl_throug
+hput":7222.38833,"ul_kbits":7461182,"ul_pkts":2175629,"ul_retransmits
+_pct":0.7684,"ul_throughput":2065.60083},"tower":"Espat Twr","sm_coun
+t":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_acc
+ount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","netw
+ork":"ePMP","type":"epmp","timestamp":"2022-02-16T00:00:00-06:00","ra
+dio":{"dl_frame_utilization":12.975,"dl_kbits":33266867,"dl_pkts":415
+2622,"dl_retransmits_pct":4.33583,"dl_throughput":9210.01417,"ul_kbit
+s":7581406,"ul_pkts":2440010,"ul_retransmits_pct":0.801,"ul_throughpu
+t":2098.44167},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:5
+1:32","mode":"ap","sm_drops":0,"managed_account":"","online_duration"
+:3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp",
+"timestamp":"2022-02-16T01:00:00-06:00","radio":{"dl_frame_utilizatio
+n":23.325,"dl_kbits":84318817,"dl_pkts":9462660,"dl_retransmits_pct":
+4.0875,"dl_throughput":23342.555,"ul_kbits":9192208,"ul_pkts":3963593
+,"ul_retransmits_pct":1.3335,"ul_throughput":2544.4975},"tower":"Espa
+t Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops"
+:0,"managed_account":"","online_duration":3600,"uptime":3600},{"name"
+:"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-16T02:0
+0:00-06:00","radio":{"dl_frame_utilization":49.34167,"dl_kbits":20981
+2527,"dl_pkts":22210943,"dl_retransmits_pct":3.05833,"dl_throughput":
+58082.78167,"ul_kbits":15423110,"ul_pkts":9336658,"ul_retransmits_pct
+":1.6622,"ul_throughput":4269.34167},"tower":"Espat Twr","sm_count":4
+7,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account
+":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network"
+:"ePMP","type":"epmp","timestamp":"2022-02-16T03:00:00-06:00","radio"
+:{"dl_frame_utilization":52.00833,"dl_kbits":222219506,"dl_pkts":2498
+3513,"dl_retransmits_pct":3.02583,"dl_throughput":61488.975,"ul_kbits
+":12229903,"ul_pkts":9952773,"ul_retransmits_pct":2.0038,"ul_throughp
+ut":3384.43083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:
+51:32","mode":"ap","sm_drops":3,"managed_account":"","online_duration
+":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp"
+,"timestamp":"2022-02-16T04:00:00-06:00","radio":{"dl_frame_utilizati
+on":56.96667,"dl_kbits":239952199,"dl_pkts":27802637,"dl_retransmits_
+pct":3.02083,"dl_throughput":66419.54,"ul_kbits":14663893,"ul_pkts":1
+1988746,"ul_retransmits_pct":1.7661,"ul_throughput":4058.82583},"towe
+r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s
+m_drops":1,"managed_account":"","online_duration":3600,"uptime":3600}
+]}
[download]

Outputs:

{
  data   => [
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 53.50833,
                  dl_kbits => 218936297,
                  dl_pkts => 24533891,
                  dl_retransmits_pct => 3.7125,
                  dl_throughput => 60611.05917,
                  ul_kbits => 11781720,
                  ul_pkts => 10095078,
                  ul_retransmits_pct => 1.7481,
                  ul_throughput => 3261.45,
                },
                sm_count => 47,
                sm_drops => 1,
                timestamp => "2022-02-15T04:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 55.79167,
                  dl_kbits => 228622837,
                  dl_pkts => 25268171,
                  dl_retransmits_pct => 3.4875,
                  dl_throughput => 63241.6925,
                  ul_kbits => 11064503,
                  ul_pkts => 10404746,
                  ul_retransmits_pct => 1.6548,
                  ul_throughput => 3060.63917,
                },
                sm_count => 47,
                sm_drops => 3,
                timestamp => "2022-02-15T05:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 57.58333,
                  dl_kbits => 223937159,
                  dl_pkts => 23815786,
                  dl_retransmits_pct => 3.9375,
                  dl_throughput => 61984.47583,
                  ul_kbits => 10983095,
                  ul_pkts => 10825123,
                  ul_retransmits_pct => 1.8673,
                  ul_throughput => 3040.02167,
                },
                sm_count => 47,
                sm_drops => 3,
                timestamp => "2022-02-15T06:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 58.84167,
                  dl_kbits => 228485690,
                  dl_pkts => 24464710,
                  dl_retransmits_pct => 4.07417,
                  dl_throughput => 63211.23917,
                  ul_kbits => 10887235,
                  ul_pkts => 11051562,
                  ul_retransmits_pct => 1.894,
                  ul_throughput => 3012.27583,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T07:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 67.775,
                  dl_kbits => 270520179,
                  dl_pkts => 29231592,
                  dl_retransmits_pct => 4.19,
                  dl_throughput => 74891.63583,
                  ul_kbits => 15477123,
                  ul_pkts => 13968153,
                  ul_retransmits_pct => 1.8042,
                  ul_throughput => 4285.24083,
                },
                sm_count => 47,
                sm_drops => 2,
                timestamp => "2022-02-15T08:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 69.24167,
                  dl_kbits => 264290580,
                  dl_pkts => 28611603,
                  dl_retransmits_pct => 3.92667,
                  dl_throughput => 73100.34333,
                  ul_kbits => 16808560,
                  ul_pkts => 13769154,
                  ul_retransmits_pct => 1.8935,
                  ul_throughput => 4649.08167,
                },
                sm_count => 47,
                sm_drops => 3,
                timestamp => "2022-02-15T09:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 58.70833,
                  dl_kbits => 239591107,
                  dl_pkts => 25503558,
                  dl_retransmits_pct => 3.27417,
                  dl_throughput => 66325.50667,
                  ul_kbits => 11737909,
                  ul_pkts => 12055338,
                  ul_retransmits_pct => 1.7943,
                  ul_throughput => 3249.29,
                },
                sm_count => 47,
                sm_drops => 1,
                timestamp => "2022-02-15T10:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 60.13333,
                  dl_kbits => 261326558,
                  dl_pkts => 27486494,
                  dl_retransmits_pct => 3.88583,
                  dl_throughput => 72350.99417,
                  ul_kbits => 12646382,
                  ul_pkts => 13759064,
                  ul_retransmits_pct => 1.9393,
                  ul_throughput => 3501.27167,
                },
                sm_count => 47,
                sm_drops => 2,
                timestamp => "2022-02-15T11:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 60.96667,
                  dl_kbits => 250838133,
                  dl_pkts => 26973868,
                  dl_retransmits_pct => 3.33417,
                  dl_throughput => 69391.92,
                  ul_kbits => 13262809,
                  ul_pkts => 13460633,
                  ul_retransmits_pct => 1.7437,
                  ul_throughput => 3669.04417,
                },
                sm_count => 47,
                sm_drops => 4,
                timestamp => "2022-02-15T12:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 66.61667,
                  dl_kbits => 280139966,
                  dl_pkts => 30571916,
                  dl_retransmits_pct => 3.14833,
                  dl_throughput => 77542.95833,
                  ul_kbits => 24334025,
                  ul_pkts => 17020906,
                  ul_retransmits_pct => 1.9275,
                  ul_throughput => 6735.07083,
                },
                sm_count => 47,
                sm_drops => 3,
                timestamp => "2022-02-15T13:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 73.70833,
                  dl_kbits => 319827700,
                  dl_pkts => 34334577,
                  dl_retransmits_pct => 2.98333,
                  dl_throughput => 88461.8575,
                  ul_kbits => 25273905,
                  ul_pkts => 21591443,
                  ul_retransmits_pct => 2.2535,
                  ul_throughput => 6991.14417,
                },
                sm_count => 47,
                sm_drops => 8,
                timestamp => "2022-02-15T14:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 75.51667,
                  dl_kbits => 326402388,
                  dl_pkts => 35193281,
                  dl_retransmits_pct => 3.0575,
                  dl_throughput => 90371.21083,
                  ul_kbits => 26966297,
                  ul_pkts => 22515634,
                  ul_retransmits_pct => 2.1412,
                  ul_throughput => 7466.1675,
                },
                sm_count => 47,
                sm_drops => 8,
                timestamp => "2022-02-15T15:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 74.14545,
                  dl_kbits => 300839263,
                  dl_pkts => 32604826,
                  dl_retransmits_pct => 2.58364,
                  dl_throughput => 90848.48727,
                  ul_kbits => 30157231,
                  ul_pkts => 21712953,
                  ul_retransmits_pct => 2.0661,
                  ul_throughput => 9106.83182,
                },
                sm_count => 47,
                sm_drops => 4,
                timestamp => "2022-02-15T16:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 56.83333,
                  dl_kbits => 258417074,
                  dl_pkts => 27833706,
                  dl_retransmits_pct => 2.93667,
                  dl_throughput => 71535.6275,
                  ul_kbits => 22211683,
                  ul_pkts => 14625319,
                  ul_retransmits_pct => 1.8357,
                  ul_throughput => 6148.98083,
                },
                sm_count => 47,
                sm_drops => 4,
                timestamp => "2022-02-15T17:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 40.575,
                  dl_kbits => 172161552,
                  dl_pkts => 18441382,
                  dl_retransmits_pct => 2.97,
                  dl_throughput => 47646.78083,
                  ul_kbits => 14526870,
                  ul_pkts => 8192202,
                  ul_retransmits_pct => 0.0175,
                  ul_throughput => 4020.45417,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T18:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 27.24167,
                  dl_kbits => 120543656,
                  dl_pkts => 13037188,
                  dl_retransmits_pct => 2.56833,
                  dl_throughput => 33365.85417,
                  ul_kbits => 9618636,
                  ul_pkts => 5176035,
                  ul_retransmits_pct => 1.1299,
                  ul_throughput => 2662.29917,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T19:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 19.675,
                  dl_kbits => 84770133,
                  dl_pkts => 9138076,
                  dl_retransmits_pct => 1.69667,
                  dl_throughput => 23459.96083,
                  ul_kbits => 7774048,
                  ul_pkts => 3485288,
                  ul_retransmits_pct => 0.8403,
                  ul_throughput => 2151.21167,
                },
                sm_count => 47,
                sm_drops => 2,
                timestamp => "2022-02-15T20:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 14.825,
                  dl_kbits => 57400859,
                  dl_pkts => 6403063,
                  dl_retransmits_pct => 2.41167,
                  dl_throughput => 15881.745,
                  ul_kbits => 6620987,
                  ul_pkts => 2642339,
                  ul_retransmits_pct => 0.8676,
                  ul_throughput => 1831.29833,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T21:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 10.68333,
                  dl_kbits => 34960258,
                  dl_pkts => 4146049,
                  dl_retransmits_pct => 3.375,
                  dl_throughput => 9678.53,
                  ul_kbits => 5463953,
                  ul_pkts => 1916776,
                  ul_retransmits_pct => 0.8151,
                  ul_throughput => 1512.78583,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T22:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 10.73333,
                  dl_kbits => 26089752,
                  dl_pkts => 3410266,
                  dl_retransmits_pct => 3.58833,
                  dl_throughput => 7222.38833,
                  ul_kbits => 7461182,
                  ul_pkts => 2175629,
                  ul_retransmits_pct => 0.7684,
                  ul_throughput => 2065.60083,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-15T23:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 12.975,
                  dl_kbits => 33266867,
                  dl_pkts => 4152622,
                  dl_retransmits_pct => 4.33583,
                  dl_throughput => 9210.01417,
                  ul_kbits => 7581406,
                  ul_pkts => 2440010,
                  ul_retransmits_pct => 0.801,
                  ul_throughput => 2098.44167,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-16T00:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 23.325,
                  dl_kbits => 84318817,
                  dl_pkts => 9462660,
                  dl_retransmits_pct => 4.0875,
                  dl_throughput => 23342.555,
                  ul_kbits => 9192208,
                  ul_pkts => 3963593,
                  ul_retransmits_pct => 1.3335,
                  ul_throughput => 2544.4975,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-16T01:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 49.34167,
                  dl_kbits => 209812527,
                  dl_pkts => 22210943,
                  dl_retransmits_pct => 3.05833,
                  dl_throughput => 58082.78167,
                  ul_kbits => 15423110,
                  ul_pkts => 9336658,
                  ul_retransmits_pct => 1.6622,
                  ul_throughput => 4269.34167,
                },
                sm_count => 47,
                sm_drops => 0,
                timestamp => "2022-02-16T02:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 52.00833,
                  dl_kbits => 222219506,
                  dl_pkts => 24983513,
                  dl_retransmits_pct => 3.02583,
                  dl_throughput => 61488.975,
                  ul_kbits => 12229903,
                  ul_pkts => 9952773,
                  ul_retransmits_pct => 2.0038,
                  ul_throughput => 3384.43083,
                },
                sm_count => 47,
                sm_drops => 3,
                timestamp => "2022-02-16T03:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
              {
                mac => "00:04:56:22:51:32",
                managed_account => "",
                mode => "ap",
                name => "ESPAP3",
                network => "ePMP",
                online_duration => 3600,
                radio => {
                  dl_frame_utilization => 56.96667,
                  dl_kbits => 239952199,
                  dl_pkts => 27802637,
                  dl_retransmits_pct => 3.02083,
                  dl_throughput => 66419.54,
                  ul_kbits => 14663893,
                  ul_pkts => 11988746,
                  ul_retransmits_pct => 1.7661,
                  ul_throughput => 4058.82583,
                },
                sm_count => 47,
                sm_drops => 1,
                timestamp => "2022-02-16T04:00:00-06:00",
                tower => "Espat Twr",
                type => "epmp",
                uptime => 3600,
              },
            ],
  paging => { limit => 100, offset => 0, total => 25 },
}
[download]

Comment on Re: Parsing Output Select or Download Code

Replies are listed 'Best First'.
Re^2: Parsing Output by PerlMonger79 (Sexton) on Feb 23, 2022 at 13:31 UTC
Hello, thank you for taking your time and providing a feedback on my issue. However, I tried your script but I got an error for the Data::Dump module, so I tried to install it using cpan and then it gave me an error response that it did not know what Data::Dump was. So I haven't been able to run your script. On another note, from my output response I'd like to be able to parse it and get certain information from it in a format as the example below. example: ESPAP3, 2022-02-15T04:00:00-06:00, 53.50833, 218936297, 3.7125 ... ESPAP3, 2022-02-15T05:00:00-06:00, 55.79167, 228622837, 3.4875 ... and so forth, for each record. Would this be possible to achieve?	[reply]
Re^3: Parsing Output by hippo (Archbishop) on Feb 23, 2022 at 13:48 UTC
then it gave me an error response that it did not know what Data::Dump was. Sure it knows: `$ cpan -D Data::Dump Reading '/home/redacted/.cpan/Metadata' Database was generated on Wed, 23 Feb 2022 09:55:53 GMT Data::Dump ---------------------------------------------------------------------- +--- (no description) G/GA/GARU/Data-Dump-1.25.tar.gz (no installation file) Installed: not installed CPAN: 1.25 Not up to date Breno G. de Oliveira (GARU) garu@cpan.org` [download] Why describe the error messages when you could simply paste them? 🦛	[reply] [d/l]
Re^4: Parsing Output by PerlMonger79 (Sexton) on Feb 23, 2022 at 15:13 UTC
Hi again. So I was able to install the module and I added the code to my script and got a few errors but also the same output as yours. Please find my code and output below. Is there something I must fix? #!/usr/bin/perl -w use strict; use warnings; use JSON; use LWP::UserAgent; require HTTP::Cookies; my $netloc = "xxx.xx.xx.xx:80"; my $realm = "Realm"; my $user = "username"; my $pass = "password"; my $auth_token = "token code"; my $ua = new LWP::UserAgent; $ua->agent('Mozilla/5.0'); my $cookie_jar = HTTP::Cookies->new( file => 'cookies_lwp.txt', autosa +ve => 1, ignore_discard => 1 ); $ua->cookie_jar($cookie_jar); $ENV{PERL_LWP_SSL_VERIFY_HOSTNAME}=0; $ua->default_header( "Authorization" => "Bearer $auth_token"); $ua->default_header( "Accept" =>"application/json" ); $ua->default_header( "Content-Type" => "application/json"); $ua->credentials( $netloc, $realm, $user, $pass); $ua->ssl_opts( verify_hostname => 0, SSL_verify_mode => 0x00); my $request = new HTTP::Request('GET','https://xxx.xx.xx.xx/api/v2/dev +ices/00:04:56:22:51:32/performance/?start_time=2022-02-15T10:00:00&st +op_time=2022-02-16T10:00:00'); my $response = $ua->request($request); if ($response->is_success) { my $output = $response->decoded_content; #print $output."\n"; #Code from perlmonks use JSON::PP; my $data = join '', $output; my $hashref = JSON::PP->new->decode($data); use Data::Dump 'dd'; dd $hashref; } else { print STDERR $response->status_line, "\n"; } [download] Output: Subroutine main::encode_json redefined at /usr/local/share/perl5/Expor +ter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::decode_json redefined at /usr/local/share/perl5/Expor +ter.pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::decode_json ($) vs none at /usr/local/sh +are/perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::from_json redefined at /usr/local/share/perl5/Exporte +r.pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::from_json ($@) vs ($) at /usr/local/shar +e/perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. Subroutine main::to_json redefined at /usr/local/share/perl5/Exporter. +pm line 66. at ./wifi-api-get.pl line 33. Prototype mismatch: sub main::to_json ($@) vs ($) at /usr/local/share/ +perl5/Exporter.pm line 66. at ./wifi-api-get.pl line 33. { data => [ { mac => "00:04:56:22:51:32", managed_account => "", mode => "ap", name => "Espat AP3", network => "Belize City ePMP", online_duration => 3600, radio => { dl_frame_utilization => 53.50833, dl_kbits => 218936297, dl_pkts => 24533891, dl_retransmits_pct => 3.7125, dl_throughput => 60611.05917, ul_kbits => 11781720, ul_pkts => 10095078, ul_retransmits_pct => 1.7481, ul_throughput => 3261.45, }, sm_count => 45, sm_drops => 1, timestamp => "2022-02-15T04:00:00-06:00", tower => "Espat Twr", type => "epmp", uptime => 3600, }, { mac => "00:04:56:22:51:32", managed_account => "", mode => "ap", name => "Espat AP3", network => "Belize City ePMP", online_duration => 3600, radio => { dl_frame_utilization => 55.79167, dl_kbits => 228622837, dl_pkts => 25268171, dl_retransmits_pct => 3.4875, dl_throughput => 63241.6925, ul_kbits => 11064503, ul_pkts => 10404746, ul_retransmits_pct => 1.6548, ul_throughput => 3060.63917, }, . . . . rest of the output similar to your output. [download]	[reply] [d/l] [select]
Re^5: Parsing Output by Fletch (Bishop) on Feb 23, 2022 at 15:17 UTC
Re^4: Parsing Output by PerlMonger79 (Sexton) on Feb 23, 2022 at 14:45 UTC
Ok, I tried it again just now and it gave me a different error. Seems connection to the internet has been blocked by the network admin. The server is on a private LAN.. so once I get the access again I'll try installing the module again. I'll keep you posted, and thanks again for taking time in helping me. I appreciate it very much.	[reply]
Re^3: Parsing Output by tybalt89 (Monsignor) on Feb 23, 2022 at 19:50 UTC
#!/usr/bin/perl use strict; # https://perlmonks.org/?node_id=11141548 use warnings; use JSON::PP; my $data = join '', <DATA>; my $hashref = JSON::PP->new->decode($data); #use Data::Dump 'dd'; dd $hashref; for my $data ( @{ $hashref->{data} } ) { print join ', ', $data->{name}, $data->{timestamp}, $data->{radio}{dl_frame_utilization}, $data->{radio}{dl_kbits}, $data->{radio}{dl_pkts}, ; print "\n"; } __DATA__ {"paging":{"offset":0,"limit":100,"total":25},"data":[{"name":"ESPAP3" +,"network":"ePMP","type":"epmp","timestamp":"2022-02-15T04:00:00-06:0 +0","radio":{"dl_frame_utilization":53.50833,"dl_kbits":218936297,"dl_ +pkts":24533891,"dl_retransmits_pct":3.7125,"dl_throughput":60611.0591 +7,"ul_kbits":11781720,"ul_pkts":10095078,"ul_retransmits_pct":1.7481, +"ul_throughput":3261.45},"tower":"Espat Twr","sm_count":47,"mac":"00: +04:56:22:51:32","mode":"ap","sm_drops":1,"managed_account":"","online +_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ +e":"epmp","timestamp":"2022-02-15T05:00:00-06:00","radio":{"dl_frame_ +utilization":55.79167,"dl_kbits":228622837,"dl_pkts":25268171,"dl_ret +ransmits_pct":3.4875,"dl_throughput":63241.6925,"ul_kbits":11064503," +ul_pkts":10404746,"ul_retransmits_pct":1.6548,"ul_throughput":3060.63 +917},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mod +e":"ap","sm_drops":3,"managed_account":"","online_duration":3600,"upt +ime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp +":"2022-02-15T06:00:00-06:00","radio":{"dl_frame_utilization":57.5833 +3,"dl_kbits":223937159,"dl_pkts":23815786,"dl_retransmits_pct":3.9375 +,"dl_throughput":61984.47583,"ul_kbits":10983095,"ul_pkts":10825123," +ul_retransmits_pct":1.8673,"ul_throughput":3040.02167},"tower":"Espat + Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops": +3,"managed_account":"","online_duration":3600,"uptime":3600},{"name": +"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T07:00 +:00-06:00","radio":{"dl_frame_utilization":58.84167,"dl_kbits":228485 +690,"dl_pkts":24464710,"dl_retransmits_pct":4.07417,"dl_throughput":6 +3211.23917,"ul_kbits":10887235,"ul_pkts":11051562,"ul_retransmits_pct +":1.894,"ul_throughput":3012.27583},"tower":"Espat Twr","sm_count":47 +,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account" +:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network": +"ePMP","type":"epmp","timestamp":"2022-02-15T08:00:00-06:00","radio": +{"dl_frame_utilization":67.775,"dl_kbits":270520179,"dl_pkts":2923159 +2,"dl_retransmits_pct":4.19,"dl_throughput":74891.63583,"ul_kbits":15 +477123,"ul_pkts":13968153,"ul_retransmits_pct":1.8042,"ul_throughput" +:4285.24083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51: +32","mode":"ap","sm_drops":2,"managed_account":"","online_duration":3 +600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","t +imestamp":"2022-02-15T09:00:00-06:00","radio":{"dl_frame_utilization" +:69.24167,"dl_kbits":264290580,"dl_pkts":28611603,"dl_retransmits_pct +":3.92667,"dl_throughput":73100.34333,"ul_kbits":16808560,"ul_pkts":1 +3769154,"ul_retransmits_pct":1.8935,"ul_throughput":4649.08167},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":3,"managed_account":"","online_duration":3600,"uptime":3600} +,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02 +-15T10:00:00-06:00","radio":{"dl_frame_utilization":58.70833,"dl_kbit +s":239591107,"dl_pkts":25503558,"dl_retransmits_pct":3.27417,"dl_thro +ughput":66325.50667,"ul_kbits":11737909,"ul_pkts":12055338,"ul_retran +smits_pct":1.7943,"ul_throughput":3249.29},"tower":"Espat Twr","sm_co +unt":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":1,"managed_a +ccount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","ne +twork":"ePMP","type":"epmp","timestamp":"2022-02-15T11:00:00-06:00"," +radio":{"dl_frame_utilization":60.13333,"dl_kbits":261326558,"dl_pkts +":27486494,"dl_retransmits_pct":3.88583,"dl_throughput":72350.99417," +ul_kbits":12646382,"ul_pkts":13759064,"ul_retransmits_pct":1.9393,"ul +_throughput":3501.27167},"tower":"Espat Twr","sm_count":47,"mac":"00: +04:56:22:51:32","mode":"ap","sm_drops":2,"managed_account":"","online +_duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","typ +e":"epmp","timestamp":"2022-02-15T12:00:00-06:00","radio":{"dl_frame_ +utilization":60.96667,"dl_kbits":250838133,"dl_pkts":26973868,"dl_ret +ransmits_pct":3.33417,"dl_throughput":69391.92,"ul_kbits":13262809,"u +l_pkts":13460633,"ul_retransmits_pct":1.7437,"ul_throughput":3669.044 +17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode +":"ap","sm_drops":4,"managed_account":"","online_duration":3600,"upti +me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp" +:"2022-02-15T13:00:00-06:00","radio":{"dl_frame_utilization":66.61667 +,"dl_kbits":280139966,"dl_pkts":30571916,"dl_retransmits_pct":3.14833 +,"dl_throughput":77542.95833,"ul_kbits":24334025,"ul_pkts":17020906," +ul_retransmits_pct":1.9275,"ul_throughput":6735.07083},"tower":"Espat + Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops": +3,"managed_account":"","online_duration":3600,"uptime":3600},{"name": +"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T14:00 +:00-06:00","radio":{"dl_frame_utilization":73.70833,"dl_kbits":319827 +700,"dl_pkts":34334577,"dl_retransmits_pct":2.98333,"dl_throughput":8 +8461.8575,"ul_kbits":25273905,"ul_pkts":21591443,"ul_retransmits_pct" +:2.2535,"ul_throughput":6991.14417},"tower":"Espat Twr","sm_count":47 +,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":8,"managed_account" +:"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network": +"ePMP","type":"epmp","timestamp":"2022-02-15T15:00:00-06:00","radio": +{"dl_frame_utilization":75.51667,"dl_kbits":326402388,"dl_pkts":35193 +281,"dl_retransmits_pct":3.0575,"dl_throughput":90371.21083,"ul_kbits +":26966297,"ul_pkts":22515634,"ul_retransmits_pct":2.1412,"ul_through +put":7466.1675},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22: +51:32","mode":"ap","sm_drops":8,"managed_account":"","online_duration +":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp" +,"timestamp":"2022-02-15T16:00:00-06:00","radio":{"dl_frame_utilizati +on":74.14545,"dl_kbits":300839263,"dl_pkts":32604826,"dl_retransmits_ +pct":2.58364,"dl_throughput":90848.48727,"ul_kbits":30157231,"ul_pkts +":21712953,"ul_retransmits_pct":2.0661,"ul_throughput":9106.83182},"t +ower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap" +,"sm_drops":4,"managed_account":"","online_duration":3600,"uptime":36 +00},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022 +-02-15T17:00:00-06:00","radio":{"dl_frame_utilization":56.83333,"dl_k +bits":258417074,"dl_pkts":27833706,"dl_retransmits_pct":2.93667,"dl_t +hroughput":71535.6275,"ul_kbits":22211683,"ul_pkts":14625319,"ul_retr +ansmits_pct":1.8357,"ul_throughput":6148.98083},"tower":"Espat Twr"," +sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":4,"mana +ged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3 +","network":"ePMP","type":"epmp","timestamp":"2022-02-15T18:00:00-06: +00","radio":{"dl_frame_utilization":40.575,"dl_kbits":172161552,"dl_p +kts":18441382,"dl_retransmits_pct":2.97,"dl_throughput":47646.78083," +ul_kbits":14526870,"ul_pkts":8192202,"ul_retransmits_pct":0.0175,"ul_ +throughput":4020.45417},"tower":"Espat Twr","sm_count":47,"mac":"00:0 +4:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_ +duration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type +":"epmp","timestamp":"2022-02-15T19:00:00-06:00","radio":{"dl_frame_u +tilization":27.24167,"dl_kbits":120543656,"dl_pkts":13037188,"dl_retr +ansmits_pct":2.56833,"dl_throughput":33365.85417,"ul_kbits":9618636," +ul_pkts":5176035,"ul_retransmits_pct":1.1299,"ul_throughput":2662.299 +17},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode +":"ap","sm_drops":0,"managed_account":"","online_duration":3600,"upti +me":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp" +:"2022-02-15T20:00:00-06:00","radio":{"dl_frame_utilization":19.675," +dl_kbits":84770133,"dl_pkts":9138076,"dl_retransmits_pct":1.69667,"dl +_throughput":23459.96083,"ul_kbits":7774048,"ul_pkts":3485288,"ul_ret +ransmits_pct":0.8403,"ul_throughput":2151.21167},"tower":"Espat Twr", +"sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":2,"man +aged_account":"","online_duration":3600,"uptime":3600},{"name":"ESPAP +3","network":"ePMP","type":"epmp","timestamp":"2022-02-15T21:00:00-06 +:00","radio":{"dl_frame_utilization":14.825,"dl_kbits":57400859,"dl_p +kts":6403063,"dl_retransmits_pct":2.41167,"dl_throughput":15881.745," +ul_kbits":6620987,"ul_pkts":2642339,"ul_retransmits_pct":0.8676,"ul_t +hroughput":1831.29833},"tower":"Espat Twr","sm_count":47,"mac":"00:04 +:56:22:51:32","mode":"ap","sm_drops":0,"managed_account":"","online_d +uration":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type" +:"epmp","timestamp":"2022-02-15T22:00:00-06:00","radio":{"dl_frame_ut +ilization":10.68333,"dl_kbits":34960258,"dl_pkts":4146049,"dl_retrans +mits_pct":3.375,"dl_throughput":9678.53,"ul_kbits":5463953,"ul_pkts": +1916776,"ul_retransmits_pct":0.8151,"ul_throughput":1512.78583},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":0,"managed_account":"","online_duration":3600,"uptime":3600} +,{"name":"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02 +-15T23:00:00-06:00","radio":{"dl_frame_utilization":10.73333,"dl_kbit +s":26089752,"dl_pkts":3410266,"dl_retransmits_pct":3.58833,"dl_throug +hput":7222.38833,"ul_kbits":7461182,"ul_pkts":2175629,"ul_retransmits +_pct":0.7684,"ul_throughput":2065.60083},"tower":"Espat Twr","sm_coun +t":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_acc +ount":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","netw +ork":"ePMP","type":"epmp","timestamp":"2022-02-16T00:00:00-06:00","ra +dio":{"dl_frame_utilization":12.975,"dl_kbits":33266867,"dl_pkts":415 +2622,"dl_retransmits_pct":4.33583,"dl_throughput":9210.01417,"ul_kbit +s":7581406,"ul_pkts":2440010,"ul_retransmits_pct":0.801,"ul_throughpu +t":2098.44167},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22:5 +1:32","mode":"ap","sm_drops":0,"managed_account":"","online_duration" +:3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp", +"timestamp":"2022-02-16T01:00:00-06:00","radio":{"dl_frame_utilizatio +n":23.325,"dl_kbits":84318817,"dl_pkts":9462660,"dl_retransmits_pct": +4.0875,"dl_throughput":23342.555,"ul_kbits":9192208,"ul_pkts":3963593 +,"ul_retransmits_pct":1.3335,"ul_throughput":2544.4975},"tower":"Espa +t Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops" +:0,"managed_account":"","online_duration":3600,"uptime":3600},{"name" +:"ESPAP3","network":"ePMP","type":"epmp","timestamp":"2022-02-16T02:0 +0:00-06:00","radio":{"dl_frame_utilization":49.34167,"dl_kbits":20981 +2527,"dl_pkts":22210943,"dl_retransmits_pct":3.05833,"dl_throughput": +58082.78167,"ul_kbits":15423110,"ul_pkts":9336658,"ul_retransmits_pct +":1.6622,"ul_throughput":4269.34167},"tower":"Espat Twr","sm_count":4 +7,"mac":"00:04:56:22:51:32","mode":"ap","sm_drops":0,"managed_account +":"","online_duration":3600,"uptime":3600},{"name":"ESPAP3","network" +:"ePMP","type":"epmp","timestamp":"2022-02-16T03:00:00-06:00","radio" +:{"dl_frame_utilization":52.00833,"dl_kbits":222219506,"dl_pkts":2498 +3513,"dl_retransmits_pct":3.02583,"dl_throughput":61488.975,"ul_kbits +":12229903,"ul_pkts":9952773,"ul_retransmits_pct":2.0038,"ul_throughp +ut":3384.43083},"tower":"Espat Twr","sm_count":47,"mac":"00:04:56:22: +51:32","mode":"ap","sm_drops":3,"managed_account":"","online_duration +":3600,"uptime":3600},{"name":"ESPAP3","network":"ePMP","type":"epmp" +,"timestamp":"2022-02-16T04:00:00-06:00","radio":{"dl_frame_utilizati +on":56.96667,"dl_kbits":239952199,"dl_pkts":27802637,"dl_retransmits_ +pct":3.02083,"dl_throughput":66419.54,"ul_kbits":14663893,"ul_pkts":1 +1988746,"ul_retransmits_pct":1.7661,"ul_throughput":4058.82583},"towe +r":"Espat Twr","sm_count":47,"mac":"00:04:56:22:51:32","mode":"ap","s +m_drops":1,"managed_account":"","online_duration":3600,"uptime":3600} +]} [download] Outputs: ESPAP3, 2022-02-15T04:00:00-06:00, 53.50833, 218936297, 24533891 ESPAP3, 2022-02-15T05:00:00-06:00, 55.79167, 228622837, 25268171 ESPAP3, 2022-02-15T06:00:00-06:00, 57.58333, 223937159, 23815786 ESPAP3, 2022-02-15T07:00:00-06:00, 58.84167, 228485690, 24464710 ESPAP3, 2022-02-15T08:00:00-06:00, 67.775, 270520179, 29231592 ESPAP3, 2022-02-15T09:00:00-06:00, 69.24167, 264290580, 28611603 ESPAP3, 2022-02-15T10:00:00-06:00, 58.70833, 239591107, 25503558 ESPAP3, 2022-02-15T11:00:00-06:00, 60.13333, 261326558, 27486494 ESPAP3, 2022-02-15T12:00:00-06:00, 60.96667, 250838133, 26973868 ESPAP3, 2022-02-15T13:00:00-06:00, 66.61667, 280139966, 30571916 ESPAP3, 2022-02-15T14:00:00-06:00, 73.70833, 319827700, 34334577 ESPAP3, 2022-02-15T15:00:00-06:00, 75.51667, 326402388, 35193281 ESPAP3, 2022-02-15T16:00:00-06:00, 74.14545, 300839263, 32604826 ESPAP3, 2022-02-15T17:00:00-06:00, 56.83333, 258417074, 27833706 ESPAP3, 2022-02-15T18:00:00-06:00, 40.575, 172161552, 18441382 ESPAP3, 2022-02-15T19:00:00-06:00, 27.24167, 120543656, 13037188 ESPAP3, 2022-02-15T20:00:00-06:00, 19.675, 84770133, 9138076 ESPAP3, 2022-02-15T21:00:00-06:00, 14.825, 57400859, 6403063 ESPAP3, 2022-02-15T22:00:00-06:00, 10.68333, 34960258, 4146049 ESPAP3, 2022-02-15T23:00:00-06:00, 10.73333, 26089752, 3410266 ESPAP3, 2022-02-16T00:00:00-06:00, 12.975, 33266867, 4152622 ESPAP3, 2022-02-16T01:00:00-06:00, 23.325, 84318817, 9462660 ESPAP3, 2022-02-16T02:00:00-06:00, 49.34167, 209812527, 22210943 ESPAP3, 2022-02-16T03:00:00-06:00, 52.00833, 222219506, 24983513 ESPAP3, 2022-02-16T04:00:00-06:00, 56.96667, 239952199, 27802637 [download] You didn't specify exactly what fields you wanted, so I just took a guess, hope this helps...	[reply] [d/l] [select]