nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

Custom DB field for receive errors last hour

vhcato

Find more posts tagged with

Accepted answers

All comments

mark_wiggans

Vic-

I'm assuming the post is not showing for some reason>?

jtimes

yeah, very strange... I got an email with the following:

View the complete topic at: ">

Posted By: vhcato in Orion Network Performance Monitor
Subject: Custom DB field for receive errors last hour

And another one that does not exist:

View the complete topic at: ">

Posted By: vhcato in Orion Network Performance Monitor
Subject: Recieve errors over time

I'm trying to come up with a way to alert and report on interfaces that have exceeded a certain number of receive errors for a specified rolling period of time (last hour, last 3 hours, etc). I know I can do it with "this hour", but that resets at the turn of every hour.I created a custom SQL report that can do this, but it takes too long to execute and display via the web, so I thought about using a SQL trigger to perform the processing on the back end. Since I'm by no means a SQL guru, I was wondering if someone can take a look at my trigger and tell me if I have it configured correctly.CREATE TRIGGER [trg_CalcInErrors] ON [dbo].[Interfaces] FOR INSERTASDECLARE @InterfaceID AS intSET @InterfaceID = (SELECT INTERFACEID FROM INSERTED)UPDATE INTERFACES SET RX_Errors = (SELECT ROUND ((SUM(InterfaceErrors.In_Errors)/12), 0) AS RX_Errors FROM INSERTED, InterfaceErrors WHERE InterfaceErrors.INTERFACEID = @InterfaceID AND (DATEDIFF (Hour, InterfaceErrors.DateTime, getdate())

vhcato

Yeap... I can't post anything unless I use the "plain text" editor, which removes all the carriage returns. Not real happy with the new forum so far...

jtimes

hey Vic, what browser are you using (IE5,6,7 FirFox etc...)

I see you posted another message on the Lean & Green Layout, but have you tried re-setting your forum view back to the defaults, then re-customizing it?