topic Getting .csv data / machine readable data from Flex reports in ExtremeSwitching (EXOS/Switch Engine)

Getting .csv data / machine readable data from Flex reports

Extreme-Newbie — Wed, 30 Sep 2020 02:34:56 GMT

Hello friends -

I’ve been asked to generate some analytics from data within Extreme, specifically set up some alerts on bandwidth by ports; i.e., tell the customer when a port in range (x-z) exceeds/exceeded bandwidth threshold y.

But I cannot figure out how to get this data except via an email of completely horrible .pdf exports from a FlexReport. If you generate a .pdf report using a columnar tab, the data can conceivably be extracted via OCR, but the formatting engine cuts off part of your data. I have created a custom report and exported the .csv data *manually* that would be machine readable and usable, but that really isn't feasible for the number of ports I have been asked to evaluate and even if it was only port, I cannot realistically ask someone to manually run a report every day.

I cannot access mysql and anecdotally it is largely obfuscated if I do get access.

Can Connect natively set up this kind of alert?

Can I get bandwidth usage data logged out somewhere I can consume with Splunk and fire the alert that way?

I have to believe someone has solved this problem already. Any insight on paths forward is greatly appreciated.

Thanks!

brian

Re: Getting .csv data / machine readable data from Flex reports

Miguel-Angel_RO — Wed, 30 Sep 2020 21:20:08 GMT

Newbie,

It”s not clear what “from data within Extreme” means.

Are you talking about XMC, netsight, other?

Mig

Re: Getting .csv data / machine readable data from Flex reports

Extreme-Newbie — Thu, 01 Oct 2020 23:58:49 GMT

Hi Mig -

Sorry! We are using XMC.

brian

Re: Getting .csv data / machine readable data from Flex reports

Miguel-Angel_RO — Fri, 02 Oct 2020 00:12:39 GMT

Newbie,

You should be able to setup a threshold alarm in XMC to trigger when the bandwidth is reached.

This alarm can trigger an email and/or a workflow.

From the workflow the sky is the limit but this requires some python skills.

I’m really not a specialist of the reporting matter in XMC, but you should be able to run ad-hoc reports from the workflow engine.

Mig