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

Bandwidth alerts

Hi,

I have setup an advance bandwidth alert which will trigger for all the WAN interfaces (a custom property)

Is there a possibility that i could add Top 10 talkers, Top 10 conversations, Top 10 receivers and Top 10 transmitters in the same alert which would really help?

I think someone should have done this for sure as this involved SQL to get the information to advance alert

Thanks

Chandru

Find more posts tagged with

Accepted answers

All comments

macnugetz

Chandru-

Could you provide some more detail on what you're trying to do with the alert? For example, what are the trigger conditions for your bandwidth alert, and what are the conditions you want to be alerted on for the Top 10's?

Thanks!

Craig

Chandru

Hi Craig,

I am triggerring an alert when the bandwidth of the circuit reaches 85% and resetting the same if it reaches 70%

Can we get all this below information as part of the alerts?

Top 10 talkers

Top 5 Source

Top 5 Destination

Top 5 conversation

and the conversation that is swamping the link at the time of alert trigger with the help of SQL code in Advance alert

I think this is possible but not sure how to get this done

Chandru

Hi,

Any help on this please

regards

Chandru

mcbridea

Hi Chandru,

This really sounds like NetFlow data you are after. Are you using Orion NTA? You can alert on bandwidth in Orion then look in NTA to see top talkers, apps, and conversations and more.

Andy

Chandru

Hi Andy,

Can we not send that information via Advance alert?

Is this possible via SQL?

Please your help is highly needed

Thanks

Chandru

Karlo.Zatylny

Hi,

[Note I edited this post as I made an incorrect statement about our functionality.]

You could do this with a Custom SQL Macro in the Alert.

${SQL: SELECT MyCustomUserFunctionThatReturnsTop10NodesByCPU}

See my post later in this thread for the working answer.

Please let me know if you have any questions.

Thanks

Chandru

Thanks all!!

I already have netflow and currently we are manually looking into this for troubleshooting

Is the SQL macro can be get from Netflow as well

If you have setup anything or any example that would be good for a start

Chandru

Karlo.Zatylny

Hi,

The SQL Macro can take any valid SQL, so you could write a statement that pulls from the Netflow tables and have that information put into your Alert. But note that only the first column of the first returned row will appear, so you need to make sure your SQL returns only one value.

I don't have any examples off the top of my head. What are you looking for?

Thanks

Chandru

Hi,

Can you help me with top 5 conversations from netflow?

Thanks

Chandru

Hi,

It would be really great if i can get the below information from netflow

Can we get all this below information as part of the alerts?

Top 10 talkers

Top 5 Source

Top 5 Destination

Top 5 conversation

Chandru

Hi Karlo Zatylny,

Any help with this SQL macros

Thanks

Chandru