Oneview top interfaces reports

[Andre_Brits_Kan]

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

[Andre_Brits_Kan]

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

[Frank_Thomas]

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
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.

[Andre_Brits_Kan]

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.