Query NAC Database

[TeamNetzBetrieb]

Hi, can anybody tell me, how I can query the database on the NAC?

Hint:
I try to make a query for the actual count of end systems on the NAC?
I have found, that a table "end_system" in the database exist, but the query:
tag=# select end_system_id from end_system
give me no results.

Regards
Michael

[StephanH]

Hello Michael,

there are more steps to get your requested date. First of all you have to use the XMC database not a NAC database. All data are transmitted and aggregated in XMC.

Here is a excellent article how to connect to the database from @Martin Flammia (he is here in the HUB, too):
http://www.extremenetworks.guru/extreme-networks-managemet-netsight-access-database-externally/

If you are connected to the database (the correct one is the netsightrpt database for the statistics), you have to check where your data are stored. For that "select * from rpt_statistics" to receive all statistics availably on your system. Please be awary that entries differ from installation to installation.

Search in the output for your statistic. I think the display name is "NAC End-Systems seen last 24 hours "
Take the ID form the first column.

Now you can do an "Select * from rpt_default_day where statisticid =

Have fun.

Best regards
Stephan