ExtremeCloud IQ- Site Engine & Extreme Management Center

Expand all | Collapse all

MySQL Queries for data extraction

  • 1.  MySQL Queries for data extraction

    Posted 03-13-2017 13:11
    Hello,

    I have connected to the Netsight Database via MySQL Workbench. I am going to be setting up an ETL job to extract certain information from the database to be integrated into a data store for a companywide dashboard and reporting. I see two databases out there; netsight and netsightrpt. So I was wondering which database(s)/tables keep the information I need;

    Switches

    - IP

    - Location/Description

    - Current State (Up or Down)

    - Current (active) alarm(s)

    - Historical State (Up or Down); daily, weekly, monthly and yearly

    APs

    - IP

    - Location/Description

    - Current State (Up or Down)

    - Current (active) alarm(s)

    - Historical State (Up or Down); daily, weekly, monthly and yearly

    - Connected Users

    - MAC address

    - Connection Start/End

    - Data transmitted/received

    Also if anyone has any kind of topology layouts for the databases and table definitions; that would help greatly as I assume more information will be requested in the future.



    Thank you for your help!



  • 2.  RE: MySQL Queries for data extraction

    Posted 05-17-2017 12:33
    netsight is used for ip, location, mac address. netsightrpt would be for the remaining data