topic Re: XMC python module for excel in ExtremeCloud IQ- Site Engine Management Center

XMC python module for excel

Jose_Chaves — Thu, 14 Jan 2021 07:41:19 GMT

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

Re: XMC python module for excel

StephanH — Thu, 14 Jan 2021 13:38:55 GMT

Hello Jose,

as far as I know there is no Excel module included in XMC. But you can try to install the module you need. But because of XMC uses Jython not all modules will work. In addition be aware Jython is still based on Python 2.7.x

Please be aware, there is no offical support for additional modules from GTAC.

Re: XMC python module for excel

Dan15 — Thu, 14 Jan 2021 17:16:01 GMT

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.

Re: XMC python module for excel

Miguel-Angel_RO — Thu, 14 Jan 2021 17:21:23 GMT

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

Re: XMC python module for excel

Jose_Chaves — Fri, 15 Jan 2021 02:43:09 GMT

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

Re: XMC python module for excel

StephanH — Fri, 15 Jan 2021 04:02:27 GMT

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?

Re: XMC python module for excel

Jose_Chaves — Tue, 19 Jan 2021 01:04:18 GMT

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

Re: XMC python module for excel

StephanH — Wed, 20 Jan 2021 00:43:22 GMT

based on my experience the way suggested by Mig is the easiest to implement and most flexible.

It is possible to read out the data from the individual switches via FlexViews and to display it in the GUI (if the devices have corresponding MIB entries for the required data). However, the FlexViews do not offer any reasonable possibilities to process the data as you want.

Besides the possibility mentioned by Mig to send the data by mail, there is of course also the possibility to simply include a shared folder in the Linux file system of the XMC and thus store the data directly there.

If you want to use the FlexViews you have to search the corresponding MIB tables of your switch for the data and build own FlexViews matching your requirements (can only be done in the legacy Java tool).

Re: XMC python module for excel

Dan15 — Thu, 21 Jan 2021 00:12:16 GMT

You have to create the ARP table flexview by hand with the legacy Java tool as mentioned by Stephan. The problem is you need to set the “SNMP context” to the right vrf where the IPs belong. By default you poll vrf0 (Global routing). You can do that in the Java MIB tool for queries, but not when you create a flexview. At least I do not know how.

Here is my flexview for the ARP table. If you copy the content to a tpl file and place it in /usr/local/Extreme_Networks/NetSight/appdata/System/FlexViews/My FlexViews, it should work:

<?xml version="1.0" encoding="UTF-8"?>
<flextablelist version="8.5.1.60">
<flextable autoExportCsvTextDelineation="DQUOTE" autoExportFrequencyUnit="Minutes" autoExportFormat="HTML" showHorizontalLines="true" autoExportFilename="" autoExportFileManagement="Replace" highlightBackground="153,255,255,255" class="com.enterasys.netsight.console.client.flexview.FvTable" id="IPmib_ARPTable" columnSelectionAllowed="false" autoCreateColumnsFromModel="false" autoExportAllowed="false" autoExportCsvFieldDelimiter="Comma">IPmib_ARPTable
<tableModel>com.ets.nac.tables.TbModel</tableModel>
<column comparator="com.ets.flextable.col.IntStringComparator" id="0" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" hidden="true">ReqID
<notes></notes>
<dataField>OID::ReqID:::SNMP::ReqID</dataField></column>
<column comparator="com.ets.nac.tables.TbCompOid" id="1" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" modelIndex="1">IP Address
<notes></notes>
<dataField>OID::IP Address:::SNMP::IP Address</dataField></column>
<column comparator="com.ets.nac.tables.TbCompOid" id="2" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" hidden="true" modelIndex="2">Instance
<notes></notes>
<dataField>OID::Instance:::SNMP::Instance</dataField></column>
<column comparator="com.ets.flextable.col.VarStringComparator" id="104" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="3">Interface Name
<notes></notes>
<dataField>OID::ifName:::SNMP::SNMP;false;15;3;false;false;5;7;0;0;0;0;0</dataField></column>
<column comparator="com.ets.nac.tables.TbCompIp" id="102" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="4">IP Address
<notes></notes>
<dataField>OID::ipNetToMediaNetAddress:::SNMP::SNMPW;false;64;4;true;false;4;2;0;0;0;0;0</dataField></column>
<column comparator="com.ets.flextable.col.VarStringComparator" id="101" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="5">MAC Address
<notes></notes>
<dataField>OID::ipNetToMediaPhysAddress:::SNMP::SNMPW;false;4;5;true;false;4;2;0;0;0;0;0</dataField></column>
<column comparator="com.enterasys.netsight.console.client.flexview.FvCompMibEnum" id="103" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="6">Type
<notes></notes>
<dataField>OID::ipNetToMediaType:::SNMP::SNMPW;false;2;6;true;false;4;2;0;0;0;0;0</dataField></column>
<column comparator="com.ets.flextable.col.IntStringComparator" id="100" width="1374" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="7">Interface Index
<notes></notes>
<dataField>OID::ipNetToMediaIfIndex:::SNMP::SNMPW;false;2;7;true;false;4;2;1;0;0;0;0</dataField></column>
<notes>IP-MIB ARP Table</notes>
<dataField>TBLHASH::::TBLHDR::0;0;true;30;None;V.0.3.3.0;0;0;105</dataField></flextable></flextablelist>

Re: XMC python module for excel

Jose_Chaves — Fri, 29 Jan 2021 00:04:31 GMT

Hi,

I have created a script to send the command that I want and them, process the output and save a csv file file in the XMC file system.

Now I creating a workflow to process all the files and send me the resolt by mail.

Regards,

Jose Chaves

Re: XMC python module for excel

marleyagostinel — Mon, 19 Sep 2022 18:13:46 GMT

It seems to me that it would be easiest for you to use one platform on which you will edit and create tables. Also, you may need to use additional formula calculation functions for your work, etc. For my work, for example, I often need to calculate indices, so I am always looking for a handy index match formula program. To provide all of these requirements, many people use Excel. Suppose your work is also related to the analysis of statistics. In that case, it may be useful to know the match formula, which can also be calculated online.