in reply to Re^2: Parsing Output
in thread 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; 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} +]}
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
You didn't specify exactly what fields you wanted, so I just took a guess, hope this helps...
|
|---|