Hot!Interface History Custom Report

Page: < 12 Showing page 2 of 2
Author
Osama
New Member
  • Total Posts : 4
  • Scores: 0
  • Reward points: 0
  • Joined: 2017/08/28 02:42:00
  • Status: offline
Re: Interface History Custom Report 2017/08/29 01:11:37 (permalink)
0
this is from FG Fortiview

Attached Image(s)

#21
abelio
Expert Member
  • Total Posts : 3642
  • Scores: 55
  • Reward points: 0
  • Joined: 2005/03/31 13:28:59
  • Location: Buenos Aires, Argentina
  • Status: offline
Re: Interface History Custom Report 2017/08/29 08:27:17 (permalink)
0
Osama
hzhao_FTNT
Please change $flex_timescale to to_char(from_itime(itime), 'MM-DD HH:MI')




Sorry hzhao,
 
select to_char(from_itime(itime), 'MM-DD HH:MI') as hodex, sum(traffic_out) as traffic_out, sum(traffic_in) as traffic_in from ###(select $flex_timestamp as timestamp, sum(coalesce(sentbyte, 0)) as traffic_out, sum(coalesce(rcvdbyte, 0)) as traffic_in from $log where $filter and logid_to_int(logid) not in (4, 7, 14) group by timestamp having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by timestamp desc)### t group by hodex order by hodex
 
 
has an error 
ERROR: column "itime" does not exist LINE 1: select * from (select to_char(from_itime(itime), 'MM-DD HH:M...                                                                                                                            ^  either when I tried the select * from $log
there was a coloum named itime
 thanks for your support, help me if there is another modification for above query.

Osama
 
Try
 
select to_char(from_itime(itime), 'MM-DD HH:MI') as hodex, max(coalesce(sentbyte, 0)/duration) as traffic_out_speed, max(coalesce(rcvdbyte, 0)/duration) as traffic_in_speed from $log where $filter and logid_to_int(logid) not in (4, 7, 14) and duration!=0 group by hodex having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by hodex
 
 

regards
--
Abel
#22
hzhao_FTNT
Expert Member
  • Total Posts : 347
  • Scores: 60
  • Reward points: 0
  • Joined: 2014/09/12 10:03:54
  • Status: offline
Re: Interface History Custom Report 2017/08/29 10:18:05 (permalink)
0
Hi there, you have to put the to_char() in inner query.
 
select timestamp as hodex, sum(traffic_out) as traffic_out, sum(traffic_in) as traffic_in from ###(select to_char(from_itime(itime), 'MM-DD HH:MI')  as timestamp, sum(coalesce(sentbyte, 0)) as traffic_out, sum(coalesce(rcvdbyte, 0)) as traffic_in from $log where $filter and logid_to_int(logid) not in (4, 7, 14) group by timestamp having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by timestamp desc)### t group by hodex order by hodex
 
FAZ bandwidth summary is to calculate total bytes transferred in certain period. When you select 1 day report period, the time interval is 1 hr. So this chart is for total volume, not bandwidth rate.
FGT bandwidth chart will show bandwidth rate in kbps instead.
If you want to see bandwidth rate in FAZ, please go to FortiView->System->Resource Usage
 
regards,
hz
 
 
 
#23
tux3domike
New Member
  • Total Posts : 1
  • Scores: 0
  • Reward points: 0
  • Joined: 2019/03/13 14:10:27
  • Status: offline
Re: Interface History Custom Report 2019/03/13 14:12:38 (permalink)
0
It's now 2019.  Has anyone found a way in FortiAnalyzer to get this graph that appears on the Widget?
[image]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAn8AAAJTCAIAAAD2QufhAAAgAElEQVR4nO29e7wVV333P97qrTft1acXa592G5OtKCKPCh4TQkI4KSdcDuYiMREwQd2n+pA8pGhAawYz/tr0d0o4Ewi7MUeLRILmiEzAQFQMqUQsYXygITH2kJLQo2BTPTEnmtb1/DG3tea2L8ysNWd9P+8Xf7Dnut971prPrDVr5hgMAAAAAHIxVH8BAAAAgBxIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAJXm9KFd23ke+D4/9/sPCDN3HTqt6nt2BNIXkObEiROqv0JAhb4KANXCHeyt8QyM8HNHBoSZvYOuqu/ZEWH6Ht66JsnWw+Xs9fDWbjZ+Yu/6NWvWrN+bcY5qudETe9fnrN4BD9/xtY9e09a/4VxHTyigiG9WeUTltq1bHLruytOZrHimeL8Dv2dlXwWA6uMO9sYjN52RgRLS1914RU9PT09PzxUbi9yymL78+c0/T5aSCd2dafwLhKz14hs9vDW2bJHpmx+r7Szm2QRf0PtUZgCf2LteccAHF3jRQfGntP5a5aTvib3rlQReeKUr7vvwViKXYKAo3MFeaS29kYH24q8c1KZv1LYu9BfITl+WdoFeEKVc5ytLX74pHJuemb7yWzqK01e82OiUUtJXSdr5F7Vbt6Z8ZcQv6IAgEpC+PNqkb2kZISN9kw2bgtPXC93wP2H68tOz0rewr9I+Sk/tZ3odV0b6KvhBuHsnqV9Zff8EmBx4t0EHRtzBXhrpe3Tz+3p61uxuveDuNT0979t8tNi9n9y3ac1111133ZpN+04WuNnWbV9hGn93mJ8RtDO5+SnX9eGc8NSTcfsruc+th1nKGSt9o1k3FwMdbnZ3pzo+fXPu+LZs+2btvqNfM7ERwT763Xi8rQXneqEjNHnRIvzq/lcL98H9sjm/aOqlXRrJ785NF75ropsj5UvnHmRetLNimLP51kcu+ysHUxG/oBXuyMDAoMu8FE6mb6yhGGsORjHKDWUSNpI6XUhfrzHIhfG6detqCdatW1eotjrGx0ZHR0dHR8fG43PORDwnfeN9hcKgp9gIqOBskz436G3jT3XBx9j5JnknkFtAOGPlbTSxsLBMMLXrztAC0lfImdQuh/ivGTvziz9DKJFyNzmK2tiO4r9HNDE/fdeIB2T9+vXC5+Qv2mbLV1g7zTJ+uMXil/EbZO1cvDHRQTHsvh4kZNN/KQy9Au2S0fYVJntJKXwcGIlFNBfQWdOj9M3o3I3lkD7Ry9jOlXVPqr5yZ3Ju1+J5Y57zL8KF03niXMLPzWiZcKdZ4ey1dWt8Stpe8jeaukBGU77zk10R6RvuPuXnznBbv/dE6vk5ypEcn8z0jS3eTvrmtDozO1S76xkW0lb89lmFIfcHyvbsoBimbKitepBp1+KrApBFVs8zN90d7O0dHByIh2i8I3nEXyJrejAj9wZsmEM6RS9r475vd+J5Pc8txuFm5WJ8bsp5JnFC59oKWw/Hm7tpTZxWG20vfVObGmK/ddqpsKj0Tewx83IlnJToVOejO6/llJW+qf3WlUjfRNdw9rePt/GzfqA8z/aLYYx260FyLaQvOEMy7/uGM9zB3t5BNxGu8edng+Zx1nQugfLvM69bt06z6GWt2r4eXYjnj7rKvdPKn9POJH2jRf2zHjdFPHfJSd/WhOk7fJg9uXvfZ3aPsafcz3zKfZKN3fepffc9JSzQJnxCtUrfvByoYvq2f983EZ7Z6ZtxS6Ld8Wzpnm0Vw3CPndWDlJ8E6QvOjOxRV+5gr99UDcPTb7mG3cfxFV3XzZ4e5HYpY4pbo3bUFZs4/cTo6OjoE6cnitxqi/RNNDDa6BOOz20vKP3RUGJ3dNrdOE3Tt125Vq2wSqZv1g3h5J65pbpr++b+QPGvlPyN2yiG3daDlF8E933BmZEz5tkd7K0NDAbhG34M+k7b6LMWCbuk2374p0jUPnF0cvfaBT09PT0L1u6WNuY50SBL3DRt56yT0u+Yds7eujc663FT4iNKhQ7GM73vqy59Txw+nPJTt3GjPLcXt4v7vqmHvMVg387TNyd/g18icSzy0zfzdmu73dxZ94dbFcOu60HK75HaSYAxz6Bt8p448juRg8iKfYy9qSNqFGdN524IK8hfas/7xl52JZzVgnZKe2cd4QZy6khbvz0RP423fugje6PR9z28NatTUlX6Bv2WQjMvMXI29efLHwKdNo8fmbR+7wl2Yu9W7kdL7+7I/F27Tt9kmYlvXSiBsV8o1i6Oacb2mjtGXDwIKZ3ZrYrhGdSDxK7iXwrhC9okcX82JXFGBoS4SHkxFv9+5IERr4c5a7o4HGtkoOUd4EIhkL5xMp5QCc7i69s/63CbD/pPE+2clOZe9jDXNjbKzY4GJRWXvme4WOwOZ+KLb93LLZB2mhbkuDf0C/O4FU/Et5c/Hjf9dz2D9E1+ufgBzt6vf6BiJTBnr3k/EL9My1HgKcXwTOpB6qAwfm2ELwBJ1P6VhbJ7nkH7FPVXFrJoFWGgGCp2lxXhC0AG+AuDQA5IX1lUKPAqdikAACgZpG8FQfrK48SJw9X4s7qV+SIAACkgfQEAAADZIH0745sBLafs37/f+/j8889nTTlw4IA3ZWJiImvKd7/7XW/K+Ph4yylPP/20N+Xw4cNZU06dOuVNOXLkSNaUsbExb8ojjzzScsrjjz/uTTlx4kTWlOPHj3tTjh8/njUlHBj1+OOPZ00ZGxvzpjzyyCMtpxw5csSbcurUqawphw8f9qY8/fTTWVO++93velPGx8dbTpmY8B/IP3DgQNaU559/3puyf//+rCkMAKA1SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANvH0dZuNfh/TSSztmMHMRtNNrpeyBnNMf2G32UhdAAAAAKCGmL6OGcUq/3/GmBefwRTHjGWtl9rxTOYnI30BAAAADyF93WaDy0/HFNIyFrixcA7azGK++m1lpC8AAADAkWj7hgmZEq98eMY+u81Go+lwrWMWNJabJp++Yd+1t264mtCdHXV/xxvTlwMAAABVooj05ZMv1k5N9DWL6ew3m2Px3W864XLehv2ZwXJus9Ef787mc911HCF++wEAAIAqUUD68nd2U3qa20jfaBNhhjpmWs+zPzVtYjhOKwVP9TlZHDlyRNq+qgB89Qa+egNf+RSVvsnOZO5jOz3PbjAj6m/OSl//UyJ9vU9BAzwRwmei2gWPPvqotH1VAfjqDXz1Br7ykZK+rUddCa3m5P3jttu+0RdKDLtG+pYLfPUGvnoDX/mU2/Ms9CXnPXEkDJdORiq/euo2w/87jnjnuCDVLqjC0ZUJfPUGvnoDX/kUlr6Mf58G13MsDJYSZoaI6RvbYhC0DdMMBjP7G3Sbjf5GQ5jIve8DPc+Sga/ewFdv4CufItNXMp0+BIz0LRX46g189Qa+8kH6lkUVjq5M4Ks38NUb+MpnEqdvpyB9SwW+egNfvYGvfJC+ZVGFoysT+OoNfPUGvvJB+pZFFY6uTOCrN/DVG/jKB+lbFlU4ujKBr97AV2/gKx+kb1lU4ejKBL56A1+9ga98kL5lUYWjKxP46g189Qa+8kH6lkUVjq5M4Ks38NUb+MoH6VsWVTi6MoGv3sBXb+ArH6RvWVTh6MoEvnoDX72Br3yQvmVRhaMrE/jqDXz1Br7yQfqWRRWOrkzgqzfw1Rv4ygfpWxZVOLoyga/ewFdv4CuZB06eQPqWhfKjKxn46g189Qa+Mvnbhx96zZ0b3vLRDyF9SwGlWW/gqzfw1Ru1vqsP7DNs65yVDaRvKaA06w189Qa+eqPWd+W37jNs66yPrFiwYEF3W0D65oHSrDfw1Rv46o1a3498c7dhW7UPf2D+/PndbQHpmwdKs97AV2/gqzdqfQe+scuwrdcjfUsCpVlv4Ks38NUbtb4NP32XI31LAaVZb+CrN/DVG7W+H7r/XsO2zvoQ0rccUJr1Br56A1+9Uev7wfsdw7bO+tAypG8poDTrDXz1Br56o9Z3hZe+H0T6lgNKs97AV2/gqzdqfa/Zu9OwrTd8cBmeOCoFlGa9ga/ewFdv1Pou3/NVw7besGIp0rcUUJr1Br56A1+9Ueu7bM9XDds6G+lbEijNegNfvYGv3qj1Xbpnh2FbZ1+L9C0HlGa9ga/ewFdv1Ppefd9XDNs6+9r3I31LAaVZb+CrN/DVG7W+V933FcO2zrkG6VsOKM16A1+9ga/eqPW9cveIYVvnXHM10rcUUJr1Br56A1+9Ueu7ZPeIYVv1DyB9ywGlWW/gqzfw1Ru1vu/dfQ/St0RQmvUGvnoDX71R63v5ri8btvXG5VchfUsBpVlv4Ks38NUbtb6X3vslw7be9IGi09dtNvr7+00nPt0x+30aTTe5RnIFb5VG0/WWSFugI5C+pQJfvYGv3sBXJoud7YZtvangtm9GkrrNRhi6jhlbwsvreCbzk5G+1Qe+egNfvYGvTBbtvLvw9OVDlicWuI4pLOXFbDy0/bYy0neSAF+9ga/ewFcmM764wbCtN656X2Hpm5W9ifCMfXabjUbTEVf2ttU0+fQN+669dcPVhO7sIMqTjWmkb6nAV2/gqzfwlclbv3CLYVtv/NiVBaVvFHuJdmyir1ls/LrNRqPpCkv5/3e49A1nBsu5zUZ/vDubz3XXcYT4RfqWCnz1Br56A1+ZvPnzf2PY1jl/dcUll1zS3RaE9HVMLnNjreD20jdaK8xQx0zrefanpk0Mx2ml4KXvCVk88MAD0vZVBeCrN/DVG/jK5Jw7P23Y1tmrLps3b96Zp2+8c1nI13Z6nt1gRtTfnJW+/qdE+nqfgjZ4IoS99P2ZLFzXlbavKgBfvYGv3sBXJvVhy7Cts//PpYWkL3PM7PRtPeoq/Ojd2+U6oDtr+2Z9gSh9u1PtAvTk6A189Qa+eqPWtz78GcO2zrm+oPQV4o6/NSt2KrP0J46EpE5GKr966jbD/zuOeOeYA+lbKvDVG/jqDXxlcs6wZdjWOdcVlb7CuCtugJTw/6y3bWTcq+XSt2GaDXHjbrPR32gIE/mRXxk9z92pdgFKs97AV2/gqzdqfc8etgzbql/3nsLSVzKdPgSM9C0V+OoNfPUGvjI5y0vfle/p6+vrbgtI3zxQmvUGvnoDX71R6/v6O282bKv+vxcX88RR9UH6lgp89Qa+egNfmdTuvNmwrTcifUsCpVlv4Ks38NUbtb5/7qXvR/uRvqWA0qw38NUb+OqNWt8/++ynkb4lgtKsN/DVG/jqjVrfP/3spw3betNHFiF9SwGlWW/gqzfw1Ru1vq+7Y51hW2/6y4VI31JAadYb+OoNfPVGre+f3LHOsK0pA0jfckBp1hv46g189Uat72uRvqWC0qw38NUb+OqNWt8//od1hm1NaSB9ywGlWW/gqzfw1Ru1vn/UNA3bejPStyRQmvUGvnoDX71RnL7/sM6wrbd8GOlbDijNegNfvYGv3qj1/cPmOsO23vKhBUjfUkBp1hv46g189Uat7/9omoZtTf0g0rccUJr1Br56A1+9Uev7ms1I3zJBadYb+OoNfPVGcfp6bd8V85G+pYDSrDfw1Rv46o1a39/fbBq29dZrkb7lgNKsN/DVG/jqjVrf39t8k2Fbb73mEqRvKaA06w189Qa+eqPW93dvv8mwrbd+oA/pWwoozXoDX72Br96o9f2dzaZhW9M+0Dd//vzutoD0zQOlWW/gqzfw1Ru1vr99+02GbU1bPg/pWwoozXoDX72Br96o9f2tTTcZtvU2pG9JoDTrDXz1Br56o9b31bffZNjW25b9xYIFC7rbAtI3D5RmvYGv3sBXb9T6vspr+y5F+pYDSrPewFdv4Ks3qtPXNGxr+vuRvuWA0qw38NUb+OqNWt/f3HSTYVvTr74Y6VsKKM16A1+9ga/eqE5f07Ct6Vej7VsOKM16A1+9ga/eqPX9jY03Gbb1v65C27ccUJr1Br56A1+9Uev7a176vg/pWw4ozXoDX72Br95UIX3ffmUv0rcUUJr1Br56A1+9UZ2+pmFbb1+C9C0HlGa9ga/ewFdv1Pr+6sabDNt6x3vnIn1LAaVZb+CrN/DVG7W+r9xoGrb1ziuQvuWA0qw38NUb+OqNWt9X3HaTYVvvvLz49HXM/n7TSZvq0Wi6why32UhbwVul0XS9JdIW6Aikb6nAV2/gqzfwlckrbjMN23rnZRcVm75us9HfnwhTt9kIQzcRzt4q8UzmJyN9qw989Qa+egNfmbx8o2nY1oxi09eLSceMZWUscB1TyFo/sFPWQfpOHuCrN/DVG/jK5GW3mYZtzbh0TnHpG6RqPH3j4Rn77DYbjabDtY5Z0Fhumnz6hn3X3rrhakJ3dhDlycY00rdU4Ks38NUb+MrES9+Zi+csXLiwuy3E0jdq0cbTN9HXLDZ+3Waj0XSFpfz/O1z6hjOD5dxmoz/enc3nuus4QvwifUsFvnoDX72Br0xeetu6AtNXaM52l77RzeFwY46Z1vPsT02bGI7TSsFL31OyeOihh6TtqwrAV2/gqzfwlcmveOnbf2ER6Rv193KEMdhOz7MbzIj6m7PS1/+USF/vU/BVEiHsfakfy+LgwYPS9lUF4Ks38NUb+MrES993LSwkfUU6H3UVfvTu7XId0J21fYVdxvIXPc+lAl+9ga/ewFcmL/HT94IS01foS8574ogLSsdMRiq/euo2w/87jnjnmAPpWyrw1Rv46g18ZfJie51hW+9aUGb6OqY4WCrzbRsZ92q59G2YZtC57W/QbTb6Gw1hIt8BntHz3J1qF6A06w189Qa+elOF9O2ZP3vRokXdbUHxmyY7fQgY6Vsq8NUb+OoNfGXyIvvThm31XIL0LQeUZr2Br97AV2+qkL7vvuSCyZq+nYL0LRX46g189Qa+MnnRbTcbtvXuvknb9u0UpG+pwFdv4Ks38JWJn77zkL7lgNKsN/DVG/jqjVrfF3rp+xdI33JAadYb+OoNfPVGre8L7JsN2zr34vORvqWA0qw38NUb+OoN0lcqSN9Sga/ewFdv4CsTw0vfubOQvqWA0qw38NUb+OqN6vS1DNs676LzkL6lgNKsN/DVG/jqjULf//7lL5G+5YLSrDfw1Rv46o1C3+f/678M23qBffOsi9DzXA4ozXoDX72Br94o9P3588976Xv+HIy6KgeUZr2Br97AV28U+k5w6dt1JCF980Bp1hv46g189Uah77O/+IVhWy+0P430LQuUZr2Br97AV28U+j7zi5/76Xsh0rccUJr1Br56A1+9Ueg7/vPnDNt6ob0O6VsWKM16A1+9ga/eKPT9yc+fM2zrRfa68y9A+pYDSrPewFdv4Ks3Cn3/87kJw7ZeZJvnz0b6lgNKs97AV2/gqzcKff9jYsKwrRcNIX1LA6VZb+CrN/DVG4W+p5/9mWFbLx4yzz8f6VsOKM16A1+9ga/eKPT94TM/NWzrxUM3zZ49G+lbCijNegNfvYGv3ij0ffKnTyN9ywWlWW/gqzfw1RuFvk/8548N23rJ0KcuuOACpG8poDTrDXz1Br56o9B39OlTSN9yQWnWG/jqDXz1RqHvD/7jh4ZtvWTor5G+ZYHSrDfw1Rv46o1C38d+PGbY1q8gfcsDpVlv4Ks38NUbhb7HTp80bOulNtK3NFCa9Qa+egNfvVHoe/TUk4ZtvRRt3/JAadYb+OoNfPVGoe/3fnTCsK2XDX0S6VsWKM16A1+9ga/eKPR9eOwJpG+5oDTrDXz1Br56o9D3n/991LCtlw994sILL0T6lgJKs97AV2/gqzcKfb9z8geGbb3C/iTStyxQmvUGvnoDX71R6PvtJ79v2NYrhj4xZ84cpG8poDTrDXz1Br56o9B3/4lHkb7lgtKsN/DVG/jqjULfb/3bI4ZtvbLg9HXMfp9G021/ptts9PebTnIHjukv7DYbqQt0BNK3VOCrN/DVG/hK4xtPHDVs65VDa4tLX8eMIpT/P2PMi88gdFNnpgQ2NxnpW33gqzfw1Rv4SuP+40cM23rl0JrC0tcx+fwUP8UDNzbXi9l489dvKyN9Jwnw1Rv46g18pXHf6PcM2/rVItu+PHxTlyXDM/bZbTYaTSe5SqPZNPn0DfuuvXXD1YTu7CDKk41ppG+pwFdv4Ks38JXG7n91Ddv6tZLSNxa+yb5msfHrNhuNppvWde1w6RvODJZzm43+eHc2n+uu4wjx66XvuCwefvhhafuqAvDVG/jqDXyl8aWjBwzb+rUCe56FaI21O9tL3yi0wwx1zLSeZ39q2sTkvuPp+5QsHnzwQWn7qgLw1Rv46g18pTH8nb2Gbf168enrmIkbuO31PLvBjKi/OSt9/U+J9PU+BV3PiRBGz3OpwFdv4Ks38JXGVx49aNjWbxScvrmPDuWOugo/evd2uQ7oztq+wi5j+Yv0LRX46g189Qa+0vjysYcM2/qNoRuLS1/hNiw3TexUZulPHAnDpZORyq+eus3w/46T9dAT0rdc4Ks38NUb+Erj7kcOFJu+0VDjEG/UlDBYKvNtGxn3arn0bZhmI9pwsMtGQ5jIfwv0PMsFvnoDX72BrzS++C/fNmzrN+0C277S6fQhYKRvqcBXb+CrN/CVxtajDxq29aoie56lg/StFPDVG/jqDXylseXofsO2Xj2p276dgvQtFfjqDXz1Br7S+Pz//ZZhW6+e1G3fTkH6lgp89Qa+egNfadz5vX2Gbb166ONI37JAadYb+OoNfPVGoe8d7jcN2/ot+8aLLroI6VsKKM16A1+9ga/eKPRtHv66YVu/PfRxpG9ZoDTrDXz1Br56o9D39sP3G7b1OzbStzRQmvUGvnoDX71R6Lvx4b1I33JBadYb+OoNfPVGoe/QP99n2NbvDH0M6VsWKM16A1+9ga/eKPT9++/uMmzrd+2Pz507F+lbCijNegNfvYGv3ij0HTx4r2Fbv2d/DOlbFijNegNfvYGv3ij0/bvvOIZt/T7StzxQmvUGvnoDX71R6Pu339lp2NZrbkPPc2mgNOsNfPUGvnqj0PczB3YYtvU/0PYtD5RmvYGv3sBXbxT63vxPI0jfckFp1hv46g189Uah77oHRwzb+gOkb3mgNOsNfPUGvnqj0PemB7+M9C0XlGa9ga/ewFdvFPr+9YNfNmzrD29D+pYGSrPewFdv4Ks3Cn0/sX+7YVt/hDHP5YHSrDfw1Rv46o1C3zXfutuwrT9C27c8UJr1Br56A1+9Ueh747e2Gbb1WqRveaA06w189Qa+eqPQd/W+uwzbeu1tq5G+ZYHSrDfw1Rv46o1C3xu+8QXDtv7kto/19vYifUsBpVlv4Ks38NUbhb6rvrnVsK3XbUT6lgZKs97AV2/gqzcKfa//xhbDtl6Htm95oDTrDXz1Br56o9B35f3/aNjWnyJ9ywOlWW/gqzfw1RuFvh/103c10rcsUJr1Br56A1+9Uej7kfs/Z9jW/0TbtzxQmvUGvnoDX71R6Duw93OGbf05Rl2VB0qz3sBXb+CrNwp9P7znTsO2/hw9z+WB0qw38NUb+OqNQt8VX/usYVuvR9u3PFCa9Qa+egNfvVHoe83ufzBs6yykb3mgNOsNfPUGvnqj0Hf57qZhW2/Y+HGkb1mgNOsNfPUGvnqjPH3P3lSl9HWbjX4f00nMiU3qAqRvqcBXb+CrN/CVxrLdTcO2zqlQ+jpmGLpus9HfaLrRPKTvJAC+egNfvYGvNN6/a3Ol0jcWuLG4RfpOAuCrN/DVG/hK46p7bzdsq16Z9HVMsbUrfvbS1zGFfmm32Wg0naC3Olg6XCgZ10jfUoGv3sBXb+ArjSudTYZt1TdVZMxzi75m746w/znoonabDTF0TUcIbceJxa+Xvr+UxbFjx6TtqwrAV2/gqzfwlcaSnbcZtjXl9hsnTfpGn/yITZl4T7OR0uYN8NL3SVns379f2r6qAHz1Br56A19pLNu2/uV/c+Pb/v/rqpG+bfU8xz4l0tf7FHQ9J0N4MQAAAKCUefPmveMd75g5c+bFF1+8ePHi7iJT0air7Lavm7GGxwAAAACglGXLli1cuHDRokXLli0bGBjoLjKlPnEUTAj/nzbRdRw3fRMAAACAcp599tlTp06dOnXqmWee6XojMt+20TDNhjjTbTb6Gw1hYjTgOef2LwAAADCZUfumyWIeAgYAAAAmF0hfAAAAQDaT7K8sAAAAABpAI30dsz91AJeb+3BxFsmb2/zN6ircsy7bN9iH+I4ydcjwzXsFm2yK9U3fZGWOrwzZM9xeocjwzR6fIx/JvurPVhF00jflSGZMbr2trIHdLG+yREr35W8ZVOD2QfnHl5sq/F8NRfpGK3KFli/CqnVLl2UsOj0rzyLJB1f9uUrC8RVen6i88nJQSt8iKlz+Q83hziqRRiX6Oqb46pRKVOByfVscdakUGSDB215zTlHx9+jIpWxZfw+mo/ywct+mRN+8dxCqoPTjK5ysFBdmETLp6/2Fh1jPqdmMyl6iYzFciS8E+S/0Sp8in9J945fP6q82yvWtXvoW5CtsM+uIqvUtWTZC+WH1kOYbbVl1+srzrUBbn4NQ+qb1uIQVzjETpx7/iljYUMs/W1yNGizFN6gRFSjM5fvGe56V31koxlfcZmZfs9IrypJlI6pRd+X5+jNUO8vy9c5XFThbRVBKX66sBUcno+e40XTTj2Cr9K1Cw5dJ8OUrbQUuJ2Uc3+jyu/MOsaIpzDdlMZZySq5A+pYmG1Gp9JXgW5FxZvJ8GUsp2yqhlb6JLg3uAHPD4nIOcG7PcwVyyKNs39hU5dccko5vbIvqKM5X2GaFe56D/xUvG1GJQyvNN7hFWpZG20g7vizcVAWOMmOMXvr6xzF+nol1LGYf4LxRV9W5rCrbt7rpW+bxTc5WRXG+wjbD2bGSrPb4lsbYZTEAACAASURBVC0bUpHzshRf9XdPQkgVZhFy6cuY2zSF1qp/gPlut7wDzB1M8VxcocNaum9Fe57971PO8a3QKatIX26b6b04qi8qS5eNtl219C3J18m/aSoZqYW5AicrDoLpyxNWuKhrw2z6D9BkHmCuGyTcajVuoQSU7yv0BSn3luDrnbIqUnGL9XX4O9opb5Cp0qUVT3GyfGFWLly2b2yK9r6xqcpPVhw00hcAAACoEkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANpMsfQ+cGaq/foGMH9m29vI5M6bWa7VarT51xoKBwR1HxttcbfqUWq1Wq02ZPufytcPfPj6Ru1R96qz0pQJGBmoeU5bfdTJ/96d3rpzuLzww4k1yB3vFCWCSgMrYLaf3fGqeX3P7bvlOrNZOHP/28NrLZwU1O6PyHd98WS2V3kE3d98Tx+/fNLAg88QRVsdskhW1vTocnCdafUM6TL70VbJutZg4tGHhlJRqUZ+xciQn/rJWm7Jww6GJDpfiCdO3Vpu+ek9mSDOxaiN9JzuojN1xcmTAvwSdPhCvrxm1L1n59qyelhqN9SV3Hs/b9coZ9dwTR+v0ra/cGd8s0rc7JmX6/sU98zv9x/Sp8BN7VgeVd4m14+Do6OiRB25f4VeqaQMjp9NXC5ud9Rkrbn/gyOjo6MEd1tX+amFqhhvnlvpEcD7IqDZc+tbql21+LOuLn75rOVfzkb6THa9CGbbV6T+mT2XsnMc2X+bVgnrfYPxyNlFHuZo9feVOrmb7Td+Za3aNCozldX+5G/rqfph/wj9xDK+aO0WsuBOnnxhN4bHda2Z5Cy6/K3GGQfp2B9n0HTuw5dZbdx1rsb+xA1tu3XJgrDyhzvcYZljvLXyLdd8nZ2ZdmTLGogpSX7qFv9w+uWVpnatTYX/Wok1ciIa7nGnuT9k0n7612rQbdqc2fyf2m+fxyyF9JzvFp++xXbdytKyd3Hr8ssd2dbJuEbS9x4lDg34AJpu9jD1knZdyCRtWkPOsh8KJftP3ss05Dd34vkcGvF2fZ+7namhYL/nNJ3hs06Jaysrxr4j07Qikby4VTN+Dwx+5fE5Pz5zVO4VL0IntK/IqQBirK7aLlef0lqVRak/sXDW1nnJ9G9aupVtSWtZi+mbUriDmkb7aUGj6jh3YcuutfMlPTMjm2K5bJ0X6Thy6xb8ETjZ7GWP7Tf8COlb7Ui5+/eqcdamdStBXPeeWQ+n77dtwNOuLhz1i6V1bSN/uQPrmUsH0zSCoQhlXsJn1IyW1x8fj3VfBxvPTd8UNN3j1O9n9HVXf5cuXZqavNyDEG+w1ZfqCVdu40SDeTupL7jzOxo9sW+UPG6lPnTewaR/fiBg/so0bsjJjwcCm+7PHi4EzocD0zaiNx3a1k79jB7ZMhvQNb/emNXsZY0c39GVUsvDSOcxHP0mz8zKFzPA7dMuc/FQMO8uz+rVSzy7hPebgWoP7AlwtrU+dtWyQq6PtVnT+ZOGNH93WxqjTaoH0DT7sOuZdbd/KX3H7WRj2iPGngmhxfrpYEbkszdyHsKktu3Z1mr7jY9HdoYyKHTVxazM/uY+vQKdHBqa1vGwNesRa9DwPjITVNNY/FU7vHXSjpb15Yc3tXZgYb8K1EYLVFi1fPj22VHRLLBrPImxlwW1H2v85QbsUl76ZKRvV0thVaVDN+EoYbMObF82JJ3OiZztj295/+eqfsaldu1qnb1Q0Z86eF1xgCpERlPBpq/fEVw6HWPmVJojjKdP9scvtxE94Cb1kWDhHRBUwPX2jW0bC7ajUTUQnkej2dnirKxCc2bcwMfQrOnG1VdGjHnxx/vW7ns75BSoH0jf8EFZA7lzgV+GoLgb/HzuwJVqB/5Cbvtn7SNtUG/Cdvuctz2vmRbVhxorhh09PMMbGH79vcElQwrPvIEV9xhntai5Pw5rK316e2B20iW/YPcEy07dWq89eOeyPNQlqXtjVFZnWZ1ztDTY7uOPGPuGbhfe2+270B5XcbS2bM2dV3kBw0DWFpW9Of09YT7ITMtHy9GIxpXZx9TdRmTPTN1qFP2VkbSoD7km7OOF445yO2bCO+PeNdq5MiZ5arVabvmRzxoMJ/GjNKQut+x4fZ4xNnH5428rZ/rZSUp8xrt87e0BnIn3Tb2/zz0YsSVThYOBnOxU9vIU9fbk/NHTP7asW9FyR9VRGVUH6Bh9Sq1/8vBDMiV+sR8vlpm/aPmKb6qznWbjlWp9x9eC+zKDJuFz0ybqs5dYSB12mfImBEcY1psNh1GEmekGa3fZNHUUWXBaELYMV2znFcDDItNV7uC7w7ZOrEk5SCkvfnA7msJp2mL7c52DNRO92uFx++qbU5vimWvU8h8W0NmXuquH4AwderuU1QePzxh9/4G7r+usHh/ccHPWvMsPL6Jy7quldQz4Zvcphv1feoCwxfaPbTOLt7fQqfHJ4CVeF26vowf4St7AnGUjf4EOs+nkf41nof07epgpX6SR9084JnaXv+Jh34bd2sV+T8574YeNHtq3yn/Kv1Wr1qXP75rw5qv5JJo5vD6pr+jgRj1ieimkbpnHQGZ2ZvrGu7/D63pue0TII1+7bcDT6MH3B2uEHHp9sd4EmG1Vu+6Z8TmR8G8merM2pF98t0je8bxu7IRP1Ki3dcrqTtm8K4YiujNtD/lLH7x9cdm54g2fKuQt73565V8Y1fNOeM0r5ftcOjx7ZNpAxQitDMLzf7U1vp6KHbd/67BWDO7yevMkI0jf4MCnTNyK8hMx9cIAx5kf22Hh4JRx7CCncYnSlnHk7mTGWzNPw2nfaDbv3W/Ge6HbTNzY9o1KGg8Z6B13GTu9ZO5tr30+ZjkFXJVKF+77x/+d8Vpe+mbkapshMc38n931TyX8wQdzv6SdGR584PR52bKU+R8Q/7JQ+P7FcxNs/siN+ysj6GcTpbVV05t65hGvG16fOmoyDrpC+4Yd20jez+nXX85wS192Psu7wyZ3wyXuxhyeAeynO9OVbHskNsHieck8RT58+LV6V2k3fYCRmfvqGo8mC6RPHvz1889JgLGStlt9sB2eA1DHP3adv1nVudz3PaXHdbvpmv6KxvnJnR2Oe0wgrUpsPAUf3ooV7PhHheI3cDjVh1xzJatderrZb0dn4kR2D1wePN3hnqtxGQgVB+gYfMtNXHHXRaqgUv11hoFXmPvgxGy0fcvzJ9+5aNW9qPeUmbCytcsl/6J+d3L06aEK2E10pJxfx1RpCx3ab6RvWydjtoFilzH4Wih9T1ro1ADpH7vO+/AWvMBiK650eiwZXCYu2GiqVue2M9BWrv/htUgiqZuI2ZRgpfRuOdvS8bxrB6hmjp2JEPV9ZNTy61ZrxnFGEUIejPrNYizmjCocnLu+qoeOKzg8dy/+FKgfSN/iQmb67jqU/cZD+xJHw+NCBMe+Rhdx9ZK6RSsZLZ6K4a33lm/eeWcZO7jP7OohelnFpHz3KFLtyzkxf4Z5WeEusPjAi3C4WzmDRMM70UWNBxe7ouUjQJrLfdcVXQ+EZ39jDRcd23brlwLHUR/vSnzjK3nZW+uZ9mxSCnmOxvo3v+6T4KE/b77o6+Z2v7on1s57cvoJ7sKAF0dV3ZhVvVbUEYlfQUataaCSkV+HwxOXHbVcVPbhW7+j1I+qZlOkrf90KERXtKXNXbYu9rTUo7hOHNlw6tV6bcm7iaZv8Qczj37kljN7Zq51HY698fSJ1fENGx9pjW1fMqCffD5/9xBH39tnwMYjwGiMc3R08ljR6cEc40NNvXD+2+bJ6feo8f1TpkbDt2/pWOOgCVMa24Z73u9oa3r59+/ZooCRXD5Pveb5v8OrEe579jU2ZOzC44+CoN+wyqDBRcGefAqKr73rfhpYv2Mh+zigi0X8VZSp3wRFVYe5N80EVDgeGtFPRJ/asnl6bcu4yy/cP2r75Y8Oqx+RLX/xRs8xnh6Kki55EEjtw+OxN+XNE/B9OqdfT/hhK2rVl9m2tNLLSd2ZfX/xxCD65g9WSXyt8YPLg381N+1km3d2gyQIqYwdk/HWh+BO6bfyNo+M7V89N+yNktdqUhYPRnyvMOgVw2Zt5OzcKz/YuXFPuHkVnmnBgSdin3Bc/ffF/nK2Niv7kPalPTk2+AR6TLH2Bx8Tx+zddz/0F3hkLlt7Mj/lLv/CN7vVMvTT1wfT4G5uTpCVsIelbX37XyUe2r7383OA9k7HRymHVveXe7dxL6sShjt6fRp0zuV8/BzRF+Mu6tSnTM/4kdzt/39cbccTX/8S2Uk8BUSamtIlDgts+U85dnfGIf4z0sRvuRv9Cor50+PhEWIXPsx46uW/TwLz0KtxeRWfjR3YMin+leDI+3ID0BZMCvKIdAAJQquhIXzApoFQpASALpYqO9AWTAkqVEgCyUKroSF8wKaBUKQEgC6WKjvQFAAAAZIP0BQAAAGSD9AUAAABkg/QFAAAAZIP0BQAAAGSD9AUAAABkg/QFAAAAZIP0BQAAAGSD9AUAAABkg/QFAAAAZIP0BQAAAGSD9AUAAABkg/QFAAAAZIP0BQAAAGRjHAAAAACAXIxnAQAAACAXpC8AAAAgG6QvAAAAIBukLwAAACAbpC8AAAAgG6QvAAAAIBukLwAAACAbpC8AAAAgG7xtAwAAAJAN3jQJAAAAyAbpCwAAAMgG6QsAAADIBukLAAAAyAbpCwAAAMgG6QsAAADIBukLAAAAyAbpCwAAAMgG6QsAAADIBukLAAAAyAbpS4ETJ06o/goBFfoqAIBJwulDu7bzPPB9fu73HxBm7jp0WtX37IgwfQ9vXZNk6+Fy9np4azcbP7F3/Zo1a9bvzTh9t9zoib3rc1aXSOpvHeJ9w5Rluv3q3f3aZ4Tw7bldK/gqAIBJjzvYW+MZGOHnjgwIM3sHXVXfsyPE9OXP717WlZNW3Z2E/VN61nrxjR7eGlu2sPR9+I6vffSatv4Nt3bM+C3ix6Prw3Fi73q5ged/U3+X3kGLvvbhrdW4AgJg8uMO9krLmpGBeObJxB3sbW/3IwMl/CLuxit6enp6enqu2FjklrPTlwXn0RLO3KU0gaSmbxux2uZibaZv1rR2Ni817ZI+4hTELwBFEDT4kL48paRv1LYu9BfITd/SOgplpG+yzVdW+vJN4dj0YtO3i6shJeGb9rWjaSf2rkf8AnAmeB2xAyPuYC/SV0Cb9E3GFX8/j58RtDO5+bGQEOaEiZPMk+T3iOIpEVTpGw36PuNfNdDhZneXAl6seqEb/idMX356sekbLhvvzg1/ivh2+EuQzn5rlnmwg/Rs+2dM65RA/ALQNe7IwMCgy7xQSmZNLKpigRTFKHczVdhI6nQhfb04khjGRze/r6dnze7WC+5e09Pzvs1Hi937yX2b1lx33XXXrdm072SBm81J3/j5XBj0FBsBFZyo0+eKdwKDs7b3MXYq9jcUm+J/FE7jeRtNLCwsI96S7KIJzqdvzh3fUnuexSujrM4Esfe9g98652B3+DMmQ1/6nWgANCWj7StM9pJS+DgwEotoLqCzpkfpm9a8XLduXS3BunXrSnBWwfjY6Ojo6Ojo2Hh8zpmI5415zm+fCKf/xNmfn5t/J1CIhMNb16zZujU+JW0vrW4vZqVvdlOvfZSkb2LMWaST2ZiM51wHv3XKhlJzP0chXDjtKgLpC8AZk9XzzE13B3t7BwcH4iEa70ge8ZfImh7MyO4CjuWQPtHL2M6VdU+qvnJncm7X4nk9zyn9myw2OzN9ubkp5+ZEByd3Yvc7VrnkTmvhtdpoe+mb2goT+63TUkJa+ra4HPKE1mffzU74tf9bp3ydzPTNbMxmNIuRvgAUQuZ933CGO9jbO+gmwjX+BE/QPM6azt37zLmrGuaQTtHL2rjv2514/qir3DutfB6cSfpGi/qBwE0RA0FO+rZGVc9zxsrZyyX92v6tua3HDna7P2N2jzTSF4BCyB515Q72+k3VMDz9lmvYfRxf0XXd7OlBbrca1bRu3TrNope1avt6dCHeIn0THcht9AnH57YXlP5oKLE7Ou1GZZXSd/gwe3L3vs/sHmNPuZ/5lPskG7vvU/vue0pYoBVnkL7eqltzlkzmXJu/dc7BbutnzLsZjPu+ABRDzphnd7C3NjAYhG/4MWi9tdFnLRJ2Sbc9/LhI1I66YhOnnxgdHR194vREkVvNT19+xEyiadRu+qY8J5M2Cnbr3igQuCmJW5/eIq03qn36RitmL5uRiy1/67yD3fpn7OCWBQCge/KeOPI7kYOcjH2MvakjahRnTeduCCvIX7VPHJ3cvXZBT09Pz4K1uyWNeY69XUnIu+DeaDvpGzsbx4fMckskz+Atn4fJ3mj0fQ9v5RJbl/RNdt6nLp2SdO381nkHu8XP2CJ6Eb4AnDmJ+7MpiTMyINyoTHkxFv+GxoERr4c5a7o4HGtkIP8OcNEQeN43jniSjD3gyb81IT99xc0HzwUnhkinNGVT7kMmUyNro9zs8FanFukrPmzFyyZXSGZde7919sHO/RkTj1oLRyj9CwEAQC56py9on0LfNFk2FbvLivAFAHSK2r+yUHbPM2ifQv/KQvlUKPAqdikAAJgU6P0XBoHGnDhxuBp/VrcyXwQAANSC9AUAAABkg/TtjG8GYEqBUwAAgBpIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2SF8AAABANkhfAAAAQDZIXwAAAEA2ifR1zH6fRtNtf6ZjJpdPmwYAAAAAMX0ds7/fdJL/Z4wx5jYbYZomZiJ9AQAAgHYR0leMy1h4xgI3ORfpCwAAALRF9n1fvqnrf+Rbu7HPXNI6pt8z7Zj9jabTbAh91Y7ZbzphD7a/BTdYKBHXlwMAAAAVpuD0jYVvq77m8FNaDPObc0wxdBtNlw9y13GE+O0HAAAAKkyh6euY8WZoW+krNoiFJYJZKROTO4vw3J6TyJEjR2TuTjnUfJ+jp0zN9zkoE6AivkWnL988DWnd89zf39+fcy/Y/5RI30bTjbqeEyF8Jm7d8eijj8rcnXKo+TJ6ytR8GZQJUBHfQtPXbTaS0ctYe6OuxJXbbfuyrI0ypG/5UPNl9JSp+TIoE6AivsWlr9tsJNqfQvu09RNH3JzU55fSJjpO1lNOSN/SoebL6ClT82VQJkBFfItK32jkcYjpCP3Qbb1tw9uMt6ZpmrEVHLO/0RBGOPO7Rc+zdKj5MnrK1HwZlAlQEd8SRl2VR4cPASN9y4aaL6OnTM2XQZkAFfFF+hZJRQ6qNKj5MnrK1HwZlAlQEd9Jlb4dgvQtG2q+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfJG+RVKRgyoNar6MnjI1XwZlAlTEF+lbJBU5qNKg5svoKVPzZVAmQEV8kb5FUpGDKg1qvoyeMjVfBmUCVMQX6VskFTmo0qDmy+gpU/NlUCZARXyRvkVSkYMqDWq+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfJG+RVKRgyoNar6MnjI1XwZlAlTEF+lbJBU5qNKg5svoKVPzZVAmQEV8kb5FUpGDKg1qvoyeMjVfBmUCVMQX6VskFTmo0qDmy+gpU/NlUCZARXyRvkVSkYMqDWq+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfJG+RVKRgyoNar6MnjI1XwZlAlTEF+lbJBU5qNKg5svoKVPzZVAmQEV8kb5FUpGDKg1qvoyeMjVfBmUCVMQX6VskFTmo0qDmy+gpU/NlUCZARXyRvkVSkYMqDWq+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfJG+RVKRgyoNar6MnjI1XwZlAlTEF+lbJBU5qNKg5svoKVPzZVAmQEV8kb5FUpGDKg1qvoyeMjVfBmUCVMQX6VskFTmo0qDmy+gpU/NlUCZARXyRvkVSkYMqDWq+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfJG+RVKRgyoNar6MnjI1XwZlAlTEF+lbJBU5qNKg5svoKVPzZVAmQEV8kb5FUpGDKg1qvoyeMjVfBmUCVMQX6VskFTmo0qDmy+gpU/NlUCZARXyRvkVSkYMqDWq+jJ4yNV8GZQJUxBfpWyQVOajSoObL6ClT82VQJkBFfAtPX8fs72803cR0t9nojzAdcZXEGmnTOgXpWzbUfBk9ZWq+DMoEqIhvsenrmP39/enp65hi5IqzkL6TEmq+jJ4yNV8GZQJUxLe49HWbjf7+RtNNz0232chMU6TvZIWaL6OnTM2XQZkAVfB1T/+o+Pu+memb1fTl13BMv+nsmP2NphP0VvuzHbPfdPz2ddh7HXVpx3eL9C0bar6MnjI1XwZlAij3bf6LO+WLd7ytsUJK+oaZmZKS4RppMcy8fG00XX8iF7qNpus2G2GPtus4woaRvmVDzZfRU6bmy6BMAOW+Hz+wz7Cts69ryEhf13X5BdJGXfE5GttKMCtlYtYgL8aC9D0hkQceeEDm7pRDzfcEPWVqviegTADlvh/cPWLY1lkf+eDChQs7jF2fTtq+PGLORu1ifjVxK/6nRPo2mm7U9ZzYq7fVn0nEdV2Zu1MONd+f0VOm5vszKBNAue/A/Y5hW7WBa+fPn99h7Pp0m77xJaK2bxTK7bZ98/aLnueyoebL6ClT82VQJoBy349+c7dhW7XGB0pMX6592gyCMpyWXIPrk+a7p8P/p010nPhSIUjfsqHmy+gpU/NlUCaAct+//MYuw7Ze/+Hi0pcfWeUNjwqGSTnNRvSujbyni7xeZG9N0zRjazhmf6MhjHDm3+GR0fPcnVt3KD+okqHmy+gpU/NlUCaAct+Gl74fWl5w27dEOnwIGOlbNtR8GT1lar4MygRQ7vvhr99r2NZZSN8CUX5QJUPNl9FTpubLoEwA5b4fvN8xbOusDy6bPOnbIUjfsqHmy+gpU/NlUCaAct9r73cM23oD0rdAlB9UyVDzZfSUqfkyKBNAue81e3catvWGFUsXLFjQ3RaQvnGUH1TJUPNl9JSp+TIoE0C57/I9XzVs62ykb4EoP6iSoebL6ClT82VQJoBy36X37TBs6+xr34/0LQzlB1Uy1HwZPWVqvgzKBFDue/V9OwzbOgfpWyDKD6pkqPkyesrUfBmUCaDc96qvfcWwrXOuQfoWh/KDKhlqvoyeMjVfBmUCKPe9cveIYVv1a65G+haG8oMqGWq+jJ4yNV8GZQIo933v7nsM26p/AOlbHMoPqmSo+TJ6ytR8GZQJoNz3il1fNmzrjcuvQvoWhvKDKhlqvoyeMjVfBmUCKPe97N4vGbb1JqRvgSg/qJKh5svoKVPzZVAmgHLfxc52pG/BKD+okqHmy+gpU/NlUCaAct9FO+82bGvKsvchfQtD+UGVDDVfRk+Zmi+DMgGU+y786jakb8EoP6iSoebL6ClT82VQJoBy3/k7vmjY1puXIn2LQ/lBlQw1X0ZPmZovgzIBlPv2+el7JdK3MJQfVMlQ82X0lKn5MigTQLnvvK/cZdjWW96P9C0O5QdVMtR8GT1lar4MygRQ7nvxV7YatvWW9y9B+haG8oMqGWq+jJ4yNV8GZQIo95078gXDtqZejfQtDuUHVTLUfBk9ZWq+DMoEUO47x0/f9yJ9C0P5QZUMNV9GT5maL4MyAZT7XnjPFsO23nrVexcuXNjdFpC+cZQfVMlQ82X0lKn5MigTQLnv7C//o2Fbb73qCqRvYSg/qJKh5svoKVPzZVAmgHLfWV/+R8O2pr0P6Vscyg+qZKj5MnrK1HwZlAmg3Pe8L33esK1pVyJ9i0P5QZUMNV9GT5maL4MyAZT7vnv75wzbetuVlyN9C0P5QZUMNV9GT5maL4MyAZT7vstL3yVI3+JQflAlQ82X0VOm5sugTADlvjPvHjZsa/qSy5C+haH8oEqGmi+jp0zNl0GZAMp933n3nYZtTX8v0rc4lB9UyVDzZfSUqfkyKBNAue/bt33WsK3/hfQtEOUHVTLUfBk9ZWq+DMoEUO47/Yt3GLb1dqRvgSg/qJKh5svoKVPzZVAmgHLft931D4Ztvf2KS5G+haH8oEqGmi+jp0zNl0GZAMp937q1adjWO5C+BaL8oEqGmi+jp0zNl0GZAMp937K1adjWOy9/T7Hp65j9/Y2mmz7DIz7bMZNrpE3rFKRv2VDzZfSUqfkyKBNAue+bv7C58PT1EzaZm26zEU51zP5+0xHXQvpOSqj5MnrK1HwZlAmg3PdNX9hs2NaMyxYXlL5us9Hf32i6GVnKB25sEaTvZIWaL6OnTM2XQZkAyn3fuOX2QtM3ICU33WZDaO3GPnNrOKbfdHbM/kbTaTaEvmrH7DedsAfb34IbLJTYLdK3bKj5MnrK1HwZlAmg3Pecf9xk2NbMSyWkb4u+5vBTWgwzrtvaMcXQbTRdPshdxxH2i/QtG2q+jJ4yNV8GZQIo933D5zcatjXz0v6KpK/YIBaWCGalTMwc5MWC9D0lkYceekjm7pRDzfcUPWVqvqegTADlvn9255BhW+96T/+iRYs6T17GCu15TvQcp7aOE+nbaLpR13MihL2t/lgiBw8elLk75VDz/TE9ZWq+P4YyAZT7/k8/fReVn75tjbpymw1uoXbbvnn7Rc9z2VDzZfSUqfkyKBNAue+ffc42bKtncZnpK7RPWz9xxM3hFwr/nzbRceJLhSB9y4aaL6OnTM2XQZkAyn3/1E/fhYWlb/Q+jWBMMj9Mqq23bXi9yN6apmnGVnDM/kZDGOEcRDNAoAAAGF1JREFUDXjO7Hnuzq07lB9UyVDzZfSUqfkyKBNAue/rhocM23p3f3HpWzodPgSM9C0bar6MnjI1XwZlAij3fa2XvouQvsWh/KBKhpovo6dMzZdBmQDKff/4zg2GbZ27aMHkSd8OQfqWDTVfRk+Zmi+DMgGU+/7hnbcatnXuQqRvcSg/qJKh5svoKVPzZVAmgHLfP0D6Fo7ygyoZar6MnjI1XwZlAij3fc1n1xu2dR56ngtE+UGVDDVfRk+Zmi+DMgGU+/7+HX9v2NYstH0LRPlBlQw1X0ZPmZovgzIBlPv+7h1/b9jW+QvnI30LQ/lBlQw1X0ZPmZovgzIBlPu+avPfGrY1a+klSN/CUH5QJUPNl9FTpubLoEwA5b6/uskybOu86/qQvoWh/KBKhpovo6dMzZdBmQDKfV+50TJs690fvbjgvzBYHZC+ZUPNl9FTpubLoEwA5b4v32gZtvWugYvmz5/f3RaQvnGUH1TJUPNl9JSp+TIoE0C578u89P3wnEsuuaS7LSB94yg/qJKh5svoKVPzZVAmgHLfl952s2Fb7/rQhUjfwlB+UCVDzZfRU6bmy6BMAOW+L91oGbbVs+JC9DwXhvKDKhlqvoyeMjVfBmUCKPd9yW2WYVs9116wYMGC7raA9I2j/KBKhpovo6dMzZdBmQDKfV98282Gbb37mtlI38JQflAlQ82X0VOm5sugTADlvi++zTJs693Lz0f6FobygyoZar6MnjI1XwZlAij3fZGXvsuQvsWh/KBKhpovo6dMzZdBmQDKfV9o32zY1rlLZyF9C0P5QZUMNV9GT5maL4MyAZT7vsC2DNs692q0fYtD+UGVDDVfRk+Zmi+DMgGU+xq2ZdjWeVeh7Vscyg+qZKj5MnrK1HwZlAmg1ve/2S/99H0f0rc4UIi1h5oyNV8GZQKo9X3+v//LsK0X2DfPuhI9z8WBQqw91JSp+TIoE0Ct73P/9byfvkuQvsWBQqw91JSp+TIoE0Ct77PP/8KwrRfYn571XqRvcaAQaw81ZWq+DMoEUOv7zC9+btjWC+1Pz7rifPx938JAIdYeasrUfBmUCaDWd/znz/npeznStzhQiLWHmjI1XwZlAqj1/YmfvutmXYb0LQ4UYu2hpkzNl0GZAGp9n35uwrCtF9nrZl2K9C0OFGLtoaZMzZdBmQBqfX888axhWy+yzfPfMxvpWxgoxNpDTZmaL4MyAdT6nn72Z4ZtvXjIPH8x0rc4UIi1h5oyNV8GZQKo9f3Rz54xbOvFQzed/x70PBcHCrH2UFOm5sugTAC1vv/+zLifvouRvsWBQqw91JSp+TIoE0Ct71PjPzVs6yVDnzp/EdK3OFCItYeaMjVfBmUCqPV98qc/8dN3YdHp65j9EY2m6011m41gmumkLBsuGM2JT+oYpG/ZUPNl9JSp+TIoE0Ct77/99CeGbf3K0F/PWnD+okWLuttIavq6zUYyNh0zDF232fBzNfqfsEC4BtK38lDzZfSUqfkyKBNAre/xn/ynn77zC05fxxRjlIkx6380nXjgxuIW6TsZoObL6ClT82VQJoBa33/9z6cN2/qVoU/O6is8fROpGU9Sx+xvNO/xMjjEFT87Zn+j6QTd1f7qjtlvOmFvNdeYTu+9RvqWDTVfRk+Zmi+DMgHU+v7g6f8wbOulQ5+cNa/Y9OXu7wb5GGv6+kH7N/l9zY4ZxWm4Acfsj/dg86HtOo4Qv96XGJfIww8/LHN3yqHmO05PmZrvOJQJoNbXffKEYVsvHfrE+fNmF5u+rtDD3Gi6Xadv9CmI2JSJjpls84rp+5REHnzwQZm7Uw4136foKVPzfQrKBFDr+61Hjhq29bLi01fAT8uue57jWZxI30bTjZrbiRBGz3PZUPNl9JSp+TIoE0Ct77+c+qFhWy8bWjv74gtKS98gUM941FVO25dlbYAhfcuHmi+jp0zNl0GZAGp9j5z6oWFbLx9aO7u32Lav0wwTkIvXrp44CieE/0+b6DjxpUKQvmVDzZfRU6bmy6BMALW+3/vRmJ++c4tMX7dpNhqxQVfBnI7ftmGaZmymY/Y3GsIIZ36QF3qepUPNl9FTpubLoEwAtb6Hf/Tvhm29YmjN7ItKvO9bNB0+BIz0LRtqvoyeMjVfBmUCqPV9+IcnDdt6xdCNs+fM7jqhkL5xUIi1h5oyNV8GZQKo9f3nH540bOuVQzfOvnASpW+HIH3Lhpovo6dMzZdBmQBqfQ+OPWXY1iuHPj77AqRvcaAQaw81ZWq+DMoEUOv70MkTfvrORvoWBwqx9lBTpubLoEwAtb7/9OQThm396oaPIX2LBIVYe6gpU/NlUCaAWt99//YDw7Z+behjF1xwAdK3MFCItYeaMjVfBmUCqPXde/xRw7Z+fehjF154IdK3MFCItYeaMjVfBmUCqPX92r8+YtjWr29YjfQtEhRi7aGmTM2XQZkAan3v/cFRw7Z+YwjpWygoxNpDTZmaL4MyAdT6fvX73zNs6zeRvsWCQqw91JSp+TIoE0Ct75cfPWzY1quGVs+ZMwfpWxgoxNpDTZmaL4MyAdT63n3skGFbrxr6K6RvkaAQaw81ZWq+DMoEUOt71yPfNWzr1Wj7FgsKsfZQU6bmy6BMALW+W44+ZNjWb6HtWywoxNpDTZmaL4MyAdT6Dh/5tmFbvz30VxdddBHStzBQiLWHmjI1XwZlAqj1veN7+5G+xYNCrD3UlKn5MigTQK3v7Yf3Gbb1O0jfYkEh1h5qytR8GZQJoNb3tkPfMGzr92ykb6GgEGsPNWVqvgzKBFDru+Gfv27Y1u8N3YD0LRIUYu2hpkzNl0GZAGp9//67ew3b+n20fYsFhVh7qClT82VQJoBa3787+DXDtl6D9C0WFGLtoaZMzZdBmQBqff+/h3YZtvWaoRvmzp2L9C0MFGLtoaZMzZdBmQBqfW8+4Bi29Qc20rdQUIi1h5oyNV8GZQKo9TX/aYdhW39o/xXSt0hQiLWHmjI1XwZlAqj1/esHRwzb+iOkb7GgEGsPNWVqvgzKBFDr+4n99xi29ce3IX0LBYVYe6gpU/NlUCaAWt8bH/iSYVuvRfoWCwqx9lBTpubLoEwAtb6r991t2Naf3LYa6VskKMTaQ02Zmi+DMgHU+t7wzS8atvUnuO9bLCjE2kNNmZovgzIB1Ppe/427DNt6HXqeiwWFWHuoKVPzZVAmgFrf//2NLxi29adI32JBIdYeasrUfBmUCaDW9y/v/7xhW3++cXVvby/StzBQiLWHmjI1XwZlAqj1bez5nGFbNaRvsaAQaw81ZWq+DMoEUOv7wfvuNGzr9WrT1202+n1MJzEnNqkLkL5lQ82X0VOm5sugTAC1viu+dqdhW2epTF/HDEPXbTb6G003mof0nRxQ82X0lKn5MigTQK3vB3bfYdjWGzZ+TFX6xgI3FrdI38kBNV9GT5maL4MyAdT6Lt3VNGzrnE3K0tcxxdau+NlLX8cU+qXdZqPRdILe6mDpcKFkXCN9y4aaL6OnTM2XQZkAan2vunez0vRt0dfs3RH2Pwdd1G6zIYau6Qih7Tix+PXS95cSOXbsmMzdKYea7y/pKVPz/SWUCaDW96p7Nxm29cYqp2/0yY/YlIn3NBspbd4AL32flMj+/ftl7k451HyfpKdMzfdJKBNAre/yuze8/G9unDZ4fZV7nmOfEunrfQq6npMhvBgAAACoEvPmzXvHO94xc+bMiy++ePHixd0lqKxRV9ltXzdjDY8BAAAAoEosX7584cKFixYtWrp06cDAQHcJWu4TR8GE8P9pE13HcdM3AQAAAFSNZ5999tSpU6dOnXrmmWe63kipb9tomGZDnOk2G/2NhjAxGvCcc/sXAAAA0AjJb5os5iFgAAAAYFKD9AUAAABkU/W/sgAAAADoh6bp65j9qQO43NyHi7NI3tzmb1ZX5J512crBPsTXlKlDhm/eW9gUUKxy+iardIiZHOUz3F6hyPDNHqujBMnKlSjWPhqnb8qhy5jceltZA7tZ3mS5lK7M3zWowB2E8g8xN1X4vzKKVI5W5IouX5ArYVy+MmPRuVm9rtxDXInzloRDLLxNsRLF2kfr9C2ikuU/1BzuTP0BLV3ZMcW3pyiutzJ8Wxx42RQZHcE7X3POTPG36aigbGV/D6ZThePLyvfNex+hIko/xMKJqxKlOkDf9PX+wkOs29RsRuUt0asYrsQf9fwXeqVPUULpyvGrZvVt33J9K5m+BSkL28w6qASUI6ogyyT6RltWLS1VuRrN/QCd0zetlyWsZI6ZOOn4V8HChlr+2eKK1FpJykEtqEABLt833vOsXLowZXGbmX3NFbiuLFk5oiL1WJqvP6MCzrKUvXOX6gItoHX6cuUrOBwZPceNppt+yFqlbwVOUD6lK/N1tQKXkDIOcXTJ3XknWAkUppyyGEs5GVegcJesHFGp9JXgW5lxZhKVGUsp5CrRPH0TfRjcEeXGweUc0dye5wqEUEjZyrGpys/Mkg5xbItKKU5Z2Gble56D/xWvHFEFWSbNN7g/WpZGJ0g7xCzcVAUONGOMQPr6By5+hon1KmYf0bxRV5W6jipbubrpW+YhTs5WSHHKwjbD2bHyrPwQs/KVQypyUpbiW4nbKCEES3WA/unLmNs0hdaqf0T5Dre8I8odPfFEXKXjKEG5oj3P/vcp5xBX60xVpDK3zfS+nGpcWpauHG27aulbkq+Tf8dUPlJLdQVOXBwU0pcnrGRRX4bZ9J+eyTyiXL9HuNXK3DYJKF9Z6P9Rri7B1ztTVaeyFqvs8De1U94jUwlvCcp8qVauXbZvbIpyXya7VKs/cXFomr4AAABAhUH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALJB+gIAAACyQfoCAAAAskH6AgAAALLRM30PnBmqv37hTBzavGR6rVar1XoH3TYWP/7t4bWXz5par9VqtfrUWZevHf728YnkcuNHtq29fM70KbUWyzHGGHMHe2u1Wq1WGxjJ2fXIQK397wn0BfW3M7y6OCOoszMWDAzuODKetZxfZ6dMn5NeZ0uo2SCJtumrZN1KcnL36tn1Wq3dVJs4tGHhlFqCKQs3HJpovVhiuRCkL+iArquhdvW3NVl1sT5j5cjJNpYT62xJNRsk0Tl9/+Ke+Z3+Y/HaO3Zgy6237jrWYn9jB7bcuuXAWHlC3e5x4pEty6fzVahVqp3euXK6X3NX3P7AkdHRIw/cvmKGF97TV+48HWx3z2pxsdGDOz4R1Nn0fSB9QQd41dCwrY7+scz0HTuw5daIDirrsV1c9Zdf0dmxXS1OQGFdrE1fYu04OCrU2WkDI0GdTVTt0YM7rKuDur16z4S4taJrNkiC9NU3fU/uM/v8Rm+9Xm8r1R6yzvOWv2zzY9HUsHqdZz3EGGPs+ObLvAmLNnGLnb5rubeXmeb+5KaRvqADikzfY7tuvVWoxYkJ2RzbdWu10zesdb238A3YfZ+c6dXklTu9KUH9qy/dwreHT25Z6nVWL7/rNCuzZoMkSF9d0/fR2xfXg0viTd/Z1laq7Tf9KutVxZBY7ZvYuWpqPWWxsBou3SJMF2cifUFrikvfY7vS2rrtVWw2dmBLxdP34PBHLp/T0zNn9U6hzk1sXyFUtzBWV2wXu49Pb1kaxXSJNRskQfp2kL5eVYz6sMJ66FdK75I61rHFd3lF08U6xVXqzH0Im9qya1fL08DEocG+en32auf4RJupdnRDX0YdC+tu34ajwbTx8figjiC826+jJ0dWel1f9b7BQxNM+J7jR7YFQ7/qU2ctG7w/Gvbhb2v62q+zieP3Dy7zx4dMOffytdsf4U4uE8fv3zSwgB9isi1tJAqoHkWlb3bKRqkcy9SgbqZ0VudVdBZO5dvVGdv2/stvSviS3NRdrXqe0wnqYtBdlRmR8ZhmZ1Kz+Qo3ZfqCVXx186p2fcmdx9n4kW2rFszwq/a8gU37hLvTdCot0rfD9I1qHHdN7dfTqFoF/x87sCVagf+Qm77Z+0jbVFu0lb7BQtNW74nP2rN6Wsvr26Dbuu3+qcc2X+Y1qaPesOArzOxbOCMcKuYzfSAYQxJsa+bS5X3xpep9GzzFiUODiZm1Wm369buebucXA0opKn2zm45R1c5OyPjqmRVd+H/8DJCZvtEq/Hkma1NtMj4W3feNqkzQxK3N/OQ+vvF7emSgsJrduzAxXCu4qmZR1V60XByKUqtxQ0poVVqkb4fpm1qT4h1SwZx4p1e0XG76pu0jtqlOu8A6St+UhcIaFu+4CgluIEWX2xlb8Gt5VM+iU0T0FWrRGJKDO24MKmQwNiTcVq02Ze6qYX90WFCpvW6ziZEBf/PL/dEje25ftaDnioyBm6BaFJS+eR3MYZXqLH3TKnpiN+F6+embcgqIb6rlqCservrUzlu+iesu4i51Z6wYfvj0BGNs/PH7BpcESXjZ5uMZG227Ztdq9dkrE7UxGEISfbf6jKsTVdvbNLFKi/Q9s/RN7boKPierfrhKJ+m75cBYok6Wkb7RNWxO+qZvgLtk5UZGp29hYITxQyuji2P+e05bsZ3rjTo5vMSf7LXKo28jjDTZfcO06EwSLDPnlkOtfhxQParb9k27nE7cWw433kn6pl6xd52+tfqMqwe5Pt2MZqWPMMqKo5OanT7uK8j19Kr92KZFXNUmVmmRvkjfdhbKa/tOHN8+EFzoilmauoVrh0ePbPNXEMdWZ3+F8I60Nz3rJlawdn3lzugyuj57xeAO72IfTBoqcN83/v/kkpVL3/Exr724drF/30asYONHtq2aNzWI4PrUuX1z3uxFX/RgEk+HNTtWG3eurPPTM6p2uHbfhqPUKi3St4T0zaxJ3fU8p8R1uenb0X3fkyNBBRW6kBNw/VMBb//IjvjyWd9TnJ5V3w/dMoeb7t65hLvBVJ86S+PxG9ohc8xz1+krZOyZ9zynxXVn6RsRdhel9BaPj42Ojo6NhzU39hBSuIlOa3asNsamZ1TtcNSXX7UpVVqkb1HpKw6gaDVUKl75b22VvsLwC3FoVjuUMOaZMW7Mcq02ffmWR/IuVVPSN+WCus0qmlHfw6GZwfTxIzsGrw/emdn6PAIqg9TnffmAFudF94bHcit69lCpzG1npG/KZrtJ35bPAbkb/B5lsSc4oJuanXstnFW1w+Fg4XQ6lRbpW1T67jqW/vBA+hNHwuNDB8a8pw9y95G5Rlu09xxtm8/7+nCvsMzplwoQ6mh0WX2euZ9fMeN7hhXZu4eUUd+jcZ3xoZkTpx/etnJ2zhsDQMWQ/K4rvu4Kz/hG6wUN06yKnv7EUfa2s9I379sk+Mn37lo1b2o95Z5sLPtE0oc8hpxBzeb2EVwx+11pGVU7+2Em/Sst0jc/fXWhzbdYtPmuKya+SKt1BWWJOhq+9048cQTfUxh2MbHfPE/4+ul3ocNRndNu2J3yfYKzQfj2H1Bhik5fXQlHLYmXsVGVSRnLHF37pmVv9zVbqI3hSOn6wMgEY1lVO3xNZvqwL70rrc7pK3/dqjE+NuozfK1f9M2vexOeOD3B2MShDZdOrdemnLsqfCww8Z7n+wavTrznefw7t4QVdPZq59EnRgWeSBstkbhCjk4Q3DkgHLTJv4w2uBMU3p+KerGjV9sOB5fJfkRP7Fk9vTbl3GXe/NGDwWV0vF0PKgn+ykKbRJexU+au2ubXhVVzp6Rc2jLGWg1iPqOaXZuy8BOJ2hheFURV238sia/a/rAvYpVW2/TFXyhjsQcQRHoHXX5+1CZu428chUOwatwbpHnSrlRT+qeiE0F47ylso/fFn47g/2BLuK3k3oPv+eQ9A4ln+mvtXs0D5aD+tk3mo0Qpf5WIz97gDytwnFHNntnXF69y/DcIH0hIbDes2tQqrZ7pCzxapW+y7csYa/33fXM265Nyryn97pC70Y/6+tJh7o2Y51kPndy3aWBe8J7J2MDHaFvD+/g32w0I7xcYP7JjcGAB/ydPhdkA6MLE8fs3Xc/9Qd4ZC5benDJUOBrlPPXS1BdYnEnNri+/6+Qj29defm56bYwurG+5dzv3CtlY1SZVaZG+YPKB97oDMMnAH1BJgPQFkw+kLwCTDKRvAqQvmHwgfQGYZCB9EyB9weQD6QvAJAPpmwDpCwAAAMgG6QsAAADIBukLAAAAyAbpCwAAAMgG6QsAAADIBukLAAAAyAbpCwAAAMgG6QsAAADIBukLAAAAyAbpCwAAAMjm/wEPH9qkOVqafgAAAABJRU5ErkJggg==[/image]
#24
eduardo.musumeci
New Member
  • Total Posts : 1
  • Scores: 0
  • Reward points: 0
  • Joined: 2019/06/07 13:05:47
  • Status: offline
Re: Interface History Custom Report 2019/06/10 04:55:17 (permalink)
0
Hello everyone,
I've got a searchable "Dataset" that displays the information of Down, Up and Total interfaces.
But I still could not display a column with the interface description. Ex: WAN1 - LINK "XYZ"
In the report I only have the name of the interface and for the end user this is not acceptable.
Can someone help me ?

Dataset:

select `srcintf`,
sum(coalesce(`rcvdbyte`,0)) as total_recvd_bytes,
sum(coalesce(`sentbyte`,0)) as total_sent_bytes,
sum(coalesce(`rcvdbyte`,0)+coalesce(`sentbyte`,0))
as total_bytes from $log where $filter group by `srcintf` order by total_bytes desc

Result Image" />
#25
Page: < 12 Showing page 2 of 2
Jump to:
© 2019 APG vNext Commercial Version 5.5