Aruba Central

 View Only
last person joined: 2 days ago 

Expand all | Collapse all

ClearPass - Microsoft Power BI - Understanding Datasets

This thread has been viewed 16 times
  • 1.  ClearPass - Microsoft Power BI - Understanding Datasets

    Posted Nov 29, 2022 05:31 AM
    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?


  • 2.  RE: ClearPass - Microsoft Power BI - Understanding Datasets

    Posted Jan 12, 2023 08:12 AM
    Hi, Did you manage to get anywhere with this, its similar to something I was hoping to do!..
    Thanks