Hi!
I currently have a report that someone here posted on an older question, it returns the average traffic, total traffic, and (optionally) the 95th percentile to all channels (Traffic In, Traffic Out, etc) for a number of SNMP Traffic (64 bit) sensors. I need to add (if possible) another column with the Maximum Traffic, but still keep the rows to each channel of every sensor.
I tried to modify the template but I haven't been able to the maximum value in the same template.
The output for each sensor looks like the one on this link: http://s9.postimg.org/eat2vbaan/Report_Output_Sample.png
Here's the report templates:
Main template (/webroot/reporttemplates):
<!--Data Table Only: Data Table (5 min interval) – Custom Percentil 95 --> <!--5--> <#include file="includes\reportheader.htm"> <br/> <h1><b><#objectproperty name="name"></b> (<#report type="startdate"> - <#report type="enddate"> <#report type="reporthours">)</h1> <#report type="list" name="details\Table Custom Data Percentil 95.htm" subname="details\Detail Loop.htm" graphaverage="300" tableaverage="300"> <#cropmsg> Detail templates (/webroot/reporttemplates/details): 1) (Detail Loop) <!-- Template Detail Loop.htm--> <tr class="subtitle" style="<#clusterdependent showfor='clusterinstallation'>"> <td class="title"><#lang key="html.reporttemplates.clusternode" default="Cluster Node">:</td> <td colspan="6"><b><#cluster type="name" clgid="<@clgid>"></b></td> </tr> <tr class=even> <td class="title"><#lang key="html.reporttemplates.uptimestats" default="Uptime Stats">:</td> <td><#lang key="html.reporttemplates.up" default="Up">:</td><td class="rightalign"><#report type="uptimeper" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td><td> <span class="percent">[<#report type="uptime" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>">]</span> </td> <td><#lang key="html.reporttemplates.down" default="Down">:</td><td class="rightalign"><#report type="downtimeper" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td><td> <span class="percent">[<#report type="downtime" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>">]</span> </td> </tr> <tr class=odd> <td class="title"><#lang key="html.reporttemplates.requeststats" default="Request Stats">:</td> <td><#lang key="html.reporttemplates.good" default="Good">: </td><td class="rightalign"><#report type="goodreqper" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td><td><span class="percent">[<#report type="goodreq" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>">]</span> </td> <td><#lang key="html.reporttemplates.failed" default="Failed">: </td><td class="rightalign"><#report type="failedreqper" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td><td width="40%"><span class="percent">[<#report type="failedreq" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>">]</span> </td> </tr> <tr class=even> <td class="title"><#report type="avgvaluelabel" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td> <td colspan=6><#report type="avgvalue" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td> </tr> <tr class=odd> <td class="title"><#report type="sumvaluelabel" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td> <td colspan=6><#report type="sumvalue" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td> </tr> 2) (Custom) <div class="onereport report<@counter>"> <h2> <#objectproperty id="<@objectid>" name="name"> </h2> <#report type="averagetable" repnodeid="<@subid>" repsensid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>"> </div>
My guess is I have to find the keyword for maximum traffic and throw in some code in the detail loop file like:
<td colspan=6><#report type="" objectid="<@objectid>" avg="<@tableaverage>" sdate="<@start>" edate="<@end>" clgid="<@clgid>"></td>
So far nothing I've tried worked. Any ideas on this and what keywords should I use, or even if it's actually possible?
Thanks in advance!
Add comment