FAP usage related report

[abelio]

Hello all,

in order to obtain a profile of bandwidth usage vs specific FortiAPs, we found that all relevant an interesting values to build the dataset are in Traffic Log.

There's also a builtin report with "Top-AP-By-Bandwidth".

But, that report shows usage by src interface or SSID, not for specific FortiAPs.

On the other side, all specific FAP info is logged in Wifi Event Log.

As far i can see, only src interface/ssid or source ip are present in this log.

How could be the best approach to join both log files in order to build a query/dataset  involving specific FortiAP (Name or # Serial) in event logs with the usage values in traffic logs?

Thanks in advance to share

regards