Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Report writing

Hi
I have created a report, which shows Historical (7 dys) TX BPS of several interfaces, it is fine but how i can add sepecific time along with max Tx BPS? i.e time at which max TX bps occured..
Can anybody help me please?
Regards
K. Riaz

Find more posts tagged with

Accepted answers

All comments

leo_leo

A month and two days still waiting for HELP

Network_Guru

Ok Leo²

Try this... (I'm no SQL guru, but this might do it for you).

You will have to create a Custom SQL query to do this.
One place to start is this post from Don Yonce;

www2.solarwinds.net/.../topic.asp

Use the Report Writer and create a new "Historical - Availability" report from scratch. (this report is NOT going to give you the data you need, just an example of how to do weekly/monthly grouping in SQL).

Along the same lines as this, there is a "current interface traffic" report which also gives the time of the max. utilization.
You should be able to pull the code out of this & apply it to your existing report as per this post:
www2.solarwinds.net/.../topic.asp

If not, then you might have to find yourself a DBA/SQL coder that can do this for you.

(I'm not logged into my Orion server right now, so I can't give you a specific example).

As Isaac says - Be Fantastic!

-=Cheers=-
NG

Cygnuz

did you use the wizard or sql?
if you worked on sql maybe you need a nested select.

leo_leo

Im using report writer