Custom report

I would like to create a report that would provide me with the Avg xmit/receive and Peak xmit/receive during a certian time period (e.g. 7:00AM to 9:00PM) summarized monthly. SW has a report already defined that gives me the Average and Peak Traffic Rates - WAN Links Utilization, however it averages it over a 24 hour time period. This gives me the peaks but not a realistic average as most of our traffic occurs during the hours of 7-9.

Unfortunately, I know how to spell SQL but this is about the extent of my SQL knowledge. Anyone create a report such as this?

Thanks!

Chuck

Find more posts tagged with

avg_xmitreceive

peak_xmitreceive

report

Accepted answers

Hi,

Have you tried to Filter the results with the Hour of Day fields?

report-hour-range.JPG

All comments

Hi,

Have you tried to Filter the results with the Hour of Day fields?

report-hour-range.JPG

Or Alternatively Edit the where condition of a Report.

DatePart(hour, DateTime) between 8 and 17

Will show results recorded between 8am to 5pm.

This worked great. Thank you for your reply!

When I try this my report goes blank. If I don't filter the times it shows me data, but when I specify the times my report goes blank. Any ideas?

Sorry in addtion to what I said.

For my select filters I am selecting:

Filter Results:

Is the "MPLS interface" a custom property?

If so please goto custom property editor and make sure you don't have any fields blank instead add some value.Say for example "Non Custom interface".

And also make sure the "Property Name" does not contain any special characters in it.

Quick Links