I have recently followed the following guide to allow me to extract data from the ClearPass tipsLogDb and insightDb.ClearPass - Microsoft Power BI Desktop Integration (arubanetworks.com)
But I am struggling to understand what the relationship is between each table within each database.
Does anyone know of a data dictionary for these databases so I can build a useful query.
For reference, we have a govroam/eduroam SSID for which we would like to report metrics on.
So we would like to know how many roaming guests connect to it and also how many of our users roam to other partners govroam offerings.