Aruba Central

Hi All,

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.

Thoughts?

Hi, Did you manage to get anywhere with this, its similar to something I was hoping to do!..
Thanks
Original Message:
Sent: Nov 29, 2022 05:31 AM
From: stewea81
Subject: ClearPass - Microsoft Power BI - Understanding Datasets

Hi All,

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.

Thoughts?