Exporting NAC End System Data

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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

Photo of Andre Brits Kannemeyer

Andre Brits Kannemeyer

  • 5,360 Points 5k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,650 Points 5k badge 2x thumb
Hi Andre,
which version of software are you using?
Photo of Andre Brits Kannemeyer

Andre Brits Kannemeyer

  • 5,360 Points 5k badge 2x thumb
Hi Mike
V6.3.0.168

Thx
Photo of mp2014

mp2014

  • 1,270 Points 1k badge 2x thumb
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.
Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,650 Points 5k badge 2x thumb
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.







Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb

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


Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,650 Points 5k badge 2x thumb
Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb

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

Photo of Mike Thomas

Mike Thomas, Employee - GTAC - NMS

  • 7,650 Points 5k badge 2x thumb
Got it.
From Extreme Management Center, Control Tab->End System->Tools->Generate PDF 
This may meet your  requirements.
Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb

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



Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb
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
Photo of Patrick Koppen

Patrick Koppen

  • 770 Points 500 badge 2x thumb
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.
Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb
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.
Photo of SH

SH

  • 5,454 Points 5k badge 2x thumb
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
(Edited)
Photo of Flavio Boniforti

Flavio Boniforti

  • 60 Points
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.