topic RE: Exporting NAC End System Data in ExtremeCloud IQ- Site Engine Management Center

Exporting NAC End System Data

Andre_Brits_Kan — Mon, 25 Apr 2016 13:59:00 GMT

How do I go about exporting the end system information from NAC Manager to excel?

In oneview I can export to a PDF but I would like to export all the data to Excel.

Thx

Andre

RE: Exporting NAC End System Data

Mike_Thomas — Mon, 25 Apr 2016 18:12:00 GMT

Hi Andre,
which version of software are you using?

RE: Exporting NAC End System Data

Andre_Brits_Kan — Mon, 25 Apr 2016 18:18:00 GMT

Hi Mike
V6.3.0.168

Thx

RE: Exporting NAC End System Data

mp2014 — Mon, 25 Apr 2016 19:12:00 GMT

in NAC Manager End Systems View:

click the wrench and Table Tools --> Export --> delimeted Text. Save an CSV that will open just fine in excel.

RE: Exporting NAC End System Data

Mike_Thomas — Mon, 25 Apr 2016 23:08:00 GMT

You are also able to export these via oneview, but only via a Custom Report Tab.
It will not be as detailed as mp2014 method however.

RE: Exporting NAC End System Data

StephanH — Fri, 17 Mar 2017 14:55:00 GMT

Hello,

in the near future we won't have the lovely Java NAC-Manger for the scheduled export like this:

Therefore the question is. How can I export the data in the same way via Extreme Control Center?

The way Thomas showed above delivers to less informations. Many of my customers need all Infos from the table and not only a small part of this.

Are there any new ways?

I know I can do it via Webservices. But this is not very handy.

Regards

Stephan

RE: Exporting NAC End System Data

Mike_Thomas — Fri, 17 Mar 2017 17:06:00 GMT

Stephan, Please see the following Knowledge Base article.

https://gtacknowledge.extremenetworks.com/articles/Q_A/Where-did-the-NacESE-logs-go-after-upgrade-to...

RE: Exporting NAC End System Data

StephanH — Fri, 17 Mar 2017 18:49:00 GMT

Hello Mike,

thank you for the fast response. But I am looking for an export of the "End-Systems" and not for "End-System Events" descripted in the mentioned GTAC article.

Regards

Stephan

RE: Exporting NAC End System Data

Mike_Thomas — Fri, 17 Mar 2017 18:53:00 GMT

Got it.
From Extreme Management Center, Control Tab->End System->Tools->Generate PDF
This may meet your requirements.

RE: Exporting NAC End System Data

StephanH — Fri, 17 Mar 2017 19:05:00 GMT

Hello Mike,

no, I am afraid not. I know the PDF but my customers use the exported data to create data for different reportings and as import source for other IT Systems. They need a csv for import.

If there is a file in file system or script on the operating system (we use Netsight as Linux appliance) that will be ok for me. I need no GUI.

As I mentioned Webservices are not very handy and if I have to export 35.000 End-Systems via "axis/services/NACWebService/getallEndSystem" is very very slow!

Stephan

RE: Exporting NAC End System Data

StephanH — Sat, 18 Mar 2017 02:14:00 GMT

Hello all,

The NAC Request Tool can be a workaround for me to export all "End Systems" from NAC/NetSight.

But will be the NAC Request Tool still available if the Java tools are no longer supported?

Regards
Stephan

RE: Exporting NAC End System Data

Patrick_Koppen — Sat, 18 Mar 2017 03:30:00 GMT

Hello Stephan,

the backend api will still exists, when the java frontends are removed. So you can use the
nac request tool or something else for the api. But is there really a difference between
"axis/services/NACWebService/getallEndSystem" and the nac request tool? It uses
the soap api. And it is just a reference implemantation (with really bad cli arg parsing) for
the soap api.

RE: Exporting NAC End System Data

StephanH — Sat, 18 Mar 2017 14:13:00 GMT

Hello Patrick,

up to now I do not know if there is a difference. I wanted to know whether it is supported before I test the tools for my purpose.

RE: Exporting NAC End System Data

StephanH — Sat, 18 Mar 2017 15:10:00 GMT

Hello Patrik,

you are right I didn't see a difference in speed between NAC Request tool and a direct call via WebServices in my test.

Then I will probably have to write a small script for my customers, if the java tool no longer exists.

Regards
Stephan

RE: Exporting NAC End System Data

Flavio — Thu, 05 Oct 2017 17:07:00 GMT

Hi all.
I'm facing the same "issue": I'm on version 8.0.3.53 and I'd like to be able to export in some useable file format (csv, txt, xls, or simiilar) the end-systems list (after applying a filter).
I tried with the "axis/services/NACWebService/getAllEndSystem" path but it did not work. I get following error displayed:
"The endpoint reference (EPR) for the Operation not found is /axis/services/NACWebService/getAllEndSystem and the WSA Action = null"

Any help will be much appreciated!
Thanks,
Flavio.