topic RE: Oneview top interfaces reports in ExtremeCloud IQ- Site Engine Management Center

Oneview top interfaces reports

Andre_Brits_Kan — Thu, 17 Sep 2015 13:17:00 GMT

Hi community

I am look for some advice on the interface reports in oneview.
In my Netsight (6.3) I have over 100 S series switches (Various S8,S6 and SSA's)

In one view I can generate custom reports for each infividual interface on every device/port.
If I look at the predefined reports under "Reports", we find "Interface Reports" and then we find "Top interfaces by Bandwidth".
The reports looks as follows:

The problem I have is that this reports is across all 100 switches.
I am looking for the same report but for a individual device.
I would like to see the top 10 ports on a specific S series switch.
How do you generate the same report but on a per device basis?

Regards

RE: Oneview top interfaces reports

Andre_Brits_Kan — Thu, 17 Sep 2015 13:21:00 GMT

Also is their a way to add this report to the scheduler so that it can be emailed?
Currently you can only create a report with the "Top 5 Interfaces" under the device category but this again is across all devices not a individual device.

RE: Oneview top interfaces reports

Frank_Thomas — Tue, 29 Sep 2015 01:15:00 GMT

How's your mysql skills?

Here is a template that you could use.

Network Utilization X.X.X.X
Network Utilization X.X.X.X
Network Utilization X.X.X.X
true
table-icon
true
com.enterasys.netsight.reporting.server.webapps.monitor.schedule.SchedTabbedPDFReport

--pdfWidth
1425

--pdfHeight
1800

customArgs
Interface Utilization

--javascript-delay
45000

none
fit
false

Interface Utilization

fit

description

Name
displayName

displayName

250

Utilization
ifUtilization

ifUtilization

200

targetData
SELECT t.displayName AS Name, (truncate(r.val ,3)) AS Utilization
FROM netsightrpt.rpt_default_raw r LEFT OUTER JOIN netsightrpt.rpt_target t
ON r.targetID=t.targetID WHERE r.statisticID=(
SELECT statisticID FROM netsightrpt.rpt_statistic WHERE name="ifUtilization")
AND time_stamp > UNIX_TIMESTAMP(NOW() - INTERVAL 20 MINUTE) * 1000 and t.displayName like '%X.X.X.X%'
ORDER BY r.val DESC
LIMIT 100;
]]>

So copy and paste this into notepad Change the X.X.X.X to the IP you want Save it as an xml file Drop it in /NetSight/appdata/OneView/MyReports. Refresh Report Tree. This is also able to be scheduled and emailed.

RE: Oneview top interfaces reports

Andre_Brits_Kan — Wed, 30 Sep 2015 16:17:00 GMT

Hi Thomas

Thank you very much for this, this report is just what I was looking for.
I have copied the template and replaced with x.x.x.x with the device IP.
I have renamed the file to .xml but am not seeing this report listed in my reports.

Any ideas??

PS my "MYSQL" skills = 0

RE: Oneview top interfaces reports

Frank_Thomas — Wed, 30 Sep 2015 18:50:00 GMT

My first guess would be to double check where the file was dropped on the server, and refresh the tree (report tree must be refreshed for new reports to show up.

Second would guess there is an error. Any errors in the server log? In the admin panel under diagnostics. If there was an error in the report, it'll show which line it failed on.

RE: Oneview top interfaces reports

Andre_Brits_Kan — Wed, 30 Sep 2015 20:49:00 GMT

Hi Thomas

I see no errors in the Server log regarding the report.

As mentioned I know very little about MYSQL but looking at the template you only refer to 4 locations with X.X.X.X that I substitute with the device IP:

Network Utilization X.X.X.X
Network Utilization X.X.X.X
Network Utilization X.X.X.X

As far as I can read the above three lines refer to the naming convention of the report and does not actually refer to the device.

AND time_stamp > UNIX_TIMESTAMP(NOW() - INTERVAL 20 MINUTE) * 1000 and t.displayName like '%X.X.X.X%'

Then the the above is a reference to another display name.
I have changed all 4 x.x.x.x to the switch IP but see no report

Should their not be a reference to something like ip=192.168.x.x?

Regards

RE: Oneview top interfaces reports

Frank_Thomas — Thu, 01 Oct 2015 00:54:00 GMT

Correct,
The first 3 are for the report itself, having duplicate report ids is a bad thing. You could have the title and category be whatever you like.

Anyways the in regards to the sql query.
You can try it yourself on the netsight server.
1.) /usr/local/Extreme_Networks/NetSight/scripts$ ./mysql.sh
you'll now be in the sql interface.

2.) Enter the following
SELECT t.displayName AS Name, (truncate(r.val ,3)) AS Utilization
FROM netsightrpt.rpt_default_raw r LEFT OUTER JOIN netsightrpt.rpt_target t
ON r.targetID=t.targetID WHERE r.statisticID=(
SELECT statisticID FROM netsightrpt.rpt_statistic WHERE name="ifUtilization")
AND time_stamp > UNIX_TIMESTAMP(NOW() - INTERVAL 20 MINUTE) * 1000;

This will output 100 stat variables similar to default report.
3.) Add the filter for one of the switches you desire
SELECT t.displayName AS Name, (truncate(r.val ,3)) AS Utilization
FROM netsightrpt.rpt_default_raw r LEFT OUTER JOIN netsightrpt.rpt_target t
ON r.targetID=t.targetID WHERE r.statisticID=(
SELECT statisticID FROM netsightrpt.rpt_statistic WHERE name="ifUtilization")
AND time_stamp > UNIX_TIMESTAMP(NOW() - INTERVAL 20 MINUTE) * 1000 and t.displayName like '%134.141.106.11%' ;

Basically, what we're taking is the t.displayName and filtering the output to a particular IP at that point. My example it would be '%134.141.106.11%'

RE: Oneview top interfaces reports

Frank_Thomas — Fri, 02 Oct 2015 19:13:00 GMT

Just a sanity check as well.
You did refresh the tree correct? This reloads the tree with everything from the reports and myreports directory