NPM database table changes

Nice catch. Looks like I am going to have to rebuild a bunch of reports too

You could either get what you are looking for directly from the 'AlertActive' table, or from the 'AlertStatusView' (it's probably best to go to the view if possible). Just a note, AlertStatusView has a 'TriggerTimeOffset' column that is a representation of how many seconds have elapsed since the trigger. Also, it looks like the TimeStamps are UTC.

Good luck!

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

dclick,

You should be able to fix your query without much hassle. As you probably already know, the nodes table was broken into three different tables. I don't recall what table the caption (node name) was moved to, but to fix your query you should be able to update "Node ${Node.Name}" to the new table with the new column ex. "Node.newTableName.newColumName." I'm intrested to know if that fixes your problem, that is if you haven't already fixed it...

-David

We add this query to our alert reset conditions.  Not my work.  I got this from another thread a couple years ago so I can't give credit to whom credit is due.

Duration: ${SQL:Select Floor(Convert(float,(Convert(datetime,'${Year}-${MM}-${DD} ${Hour}:${Minute}:${Second}')-Convert(datetime,'${AlertTriggerTime}'))))} Days ${SQL:Select Convert(time,Convert(datetime,'${Year}-${MM}-${DD} ${Hour}:${Minute}:${Second}') - Convert(datetime,'${AlertTriggerTime}'))}

Result is...

Duration: x Days HH:MM:SS

Hello, You can use macro: ${N=Alerting;M=DownTime}  for this. It show how long is alert triggered.

Hi dclick‌, did you ever find out how to query for historical alerts since the upgrade - we have similar issue. We used to be able to extract records from this table to report on repetitive alerts, not I am not sure where this history is stored

this information is in the SDK, newly migrated to github: Alerts · solarwinds/OrionSDK Wiki · GitHub

That's great, thanks Richard. Would you help to link Orion.AlertHistory to SQL Table? Where in SQL these records are stored

Hello,

Is this enough?

https://github.com/solarwinds/OrionSDK/wiki/Alerts

no, unfortunately it is not. there is no full history for all alerts there, neither I could find full history in SQL. It does not have similar records as in dbo.AlertLog table in SQL for earlier NPM verisons. I ended up triggering NPMLog action and then interrogating Events table instead

Hello,

What are you missing in AlertHistory table?

If you need time which show you how lond is alert triggerd there is macro for that:

${N=Alerting;M=DownTime}

Lada