XMC python module for excel

[Jose_Chaves]

Hi,

I’m trying to make a table of the arp table of a VSP and put it to a excel file.

Does the XMC have a python module for that? I normally use openpyxl for that.

Regards,

Jose Chaves

[Jose_Chaves]

Hi,

I have a 100 VSP 4400 all connected by SPB and all have 5 L3VSN share among then.

Those VSP have in average 8 ERS (4800 and 3600) connected to the in FA.

Each VSP as its own network in the VRF.

I need to collect the IP, mac and if possible the port where the IPs are connected (the hosts are in the ERS). Them I have to pass it to a more user-friendly format like excel.

To be able to see the ARP table of a VSP in flexview is also a very interesting. How can I do it?

Regards,

Jose Chaves

[StephanH]

Hello Jose,

perhaps you can describe your project in more detail. Should XMC write directly into your sqlite3 DB, or store the ARP info somewhere and the database system fetches the data itself?

[Jose_Chaves]

Thanks for the reply.

I did not find the flexview to see the arp table, I’m using a vsp 4450.

I will try to save the info to a sqlite3 db.

Regards,

Jose Chaves

[Miguel-Angel_RO]

Hi Jose,

From my perspective it should be ok but you need to take a step back defining your requirements.

I would do it this way:

• python script in XMC
• connect to voss and dump the arp table
  • enable
  • term more disable
  • show ip arp
• use the module csv to work it out on a csv table that can be read easily with excel
  • use a text fixed with to csv  method, there are plenty of examples on the net
• send the result to the file system or elsewhere (mail)

This can also done with a workflow but an advanced license is needed.

Mig

[Dan15]

There is a built-in CSV export feature for flexviews. I did a quick test and have scheduled a flexview to be runned via “Tasks” and send per email (you have to choose email send). The CSV file landed in /usr/local/Extreme_Networks/NetSight/appdata/OneView/tmp.

So maybe you can build something with that approach.