Header Only - DO NOT REMOVE - Extreme Networks

MySQL Queries for data extraction


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!

1 reply

Userlevel 2
netsight is used for ip, location, mac address. netsightrpt would be for the remaining data

Reply