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
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
Just a sanity check as well.
You did refresh the tree correct? This reloads the tree with everything from the reports and myreports directory
You did refresh the tree correct? This reloads the tree with everything from the reports and myreports directory
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%'
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%'
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.
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.
