MySQL Queries for data extraction

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
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!

Photo of Richard Gregory

Richard Gregory

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Tom Currier

Tom Currier, Employee

  • 720 Points 500 badge 2x thumb
netsight is used for ip, location, mac address.  netsightrpt would be for the remaining data