MySQL Queries for data extraction

Richard_Gregory — Mon, 13 Mar 2017 20:11:00 GMT

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!

RE: MySQL Queries for data extraction

Tom_Currier — Wed, 17 May 2017 19:33:00 GMT

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

topic RE: MySQL Queries for data extraction in ExtremeCloud IQ- Site Engine Management Center

MySQL Queries for data extraction

RE: MySQL Queries for data extraction