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!
