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

Alert History Report not working after 11.5 upgrade

Hey guys,

I need a little help reformatting a report that I have been using for showing All Alert History for the past 4 days in my current deployment. The problem I have is the report worked prior to upgrading to NPM v11.5, however it doesn't work now. I am a complete novice when it comes to SQL so please forgive the primitive nature of the old query. I have found this thread Note about SQL table changes with NPM 11.5 or SAM 6.2 release that mentions changing AlertLog to AlertHistory and LogDateTime to TimeStamp but when I update the string it still isn't working. Does anyone have any pointers for updating it to pull the same info from the old database structure? We use this report for determining problem devices that need to have added scrutiny b/c they are alerting on a regular basis. Thanks for any help in advance.

PJ Martin

select a.LogDateTime, b.AlertName, a.ObjectName, a.ActionType, a.Message from alertlog a inner join AlertDefinitions b on a.AlertDefID=b.AlertDefID where ( DateDiff(dd, LogDateTime, getDate()))<4 order by LogDateTime Desc

Find more posts tagged with

Accepted answers

LadaVarga

Is this enough for you?

select aa.[timestamp] as TriggeredDateTime , aa.message,

(CASE aa.eventtype

WHEN 0 then 'Triggered'

WHEN 1 THEN 'Reset'

WHEN 2 THEN 'Acknowledged'

WHEN 3 THEN 'Note Added'

WHEN 4 THEN 'Added to Incident'

WHEN 5 THEN 'Action Failed'

WHEN 6 THEN 'Action Succeeded'

WHEN 7 THEN 'Unacknowledge'

WHEN 8 THEN 'Cleared'

END) AS EventType

,ac.name,ao.entityCaption as Name_of_alert from Alerthistory aa

join AlertObjects ao on ao.AlertObjectID = aa.AlertObjectID

join AlertConfigurations ac on ao.AlertID = ac.AlertID

where ( DateDiff(dd, aa.[timestamp], getDate()))< 4 order by aa.[timestamp] Desc

All comments

ShadowLawz

Bumping this up to the top for some visibility. Can anyone off any assistance here? Thanks

peter.copan

Hi, do you looking for something like this ?

select aa.[TriggeredDateTime], ac.[Name], ao.[RelatedNodeCaption] from AlertActive aa

join AlertObjects ao on ao.AlertObjectID = aa.AlertObjectID

join AlertConfigurations ac on ao.AlertID = ac.AlertID

where ( DateDiff(dd, aa.[TriggeredDateTime], getDate()))< 4 order by aa.[TriggeredDateTime] Desc

ShadowLawz

I am really looking for the historical, showing the triggered, cleared and alert emails from what used to be the AlertLog table but is now the AlertHistory table, while including ACTIONTYPE, ALERTNAME and MESSAGE. Going to see if I can replace AlertActive with AlertHistory and pull down what I am looking for, then report back here. Thanks a bunch for the response sir!

Edit: Replacing AlertActive with AlertHistory isn't working either. I really appreciate the help, Peter

LadaVarga

Is this enough for you?

select aa.[timestamp] as TriggeredDateTime , aa.message,

(CASE aa.eventtype

WHEN 0 then 'Triggered'

WHEN 1 THEN 'Reset'

WHEN 2 THEN 'Acknowledged'

WHEN 3 THEN 'Note Added'

WHEN 4 THEN 'Added to Incident'

WHEN 5 THEN 'Action Failed'

WHEN 6 THEN 'Action Succeeded'

WHEN 7 THEN 'Unacknowledge'

WHEN 8 THEN 'Cleared'

END) AS EventType

,ac.name,ao.entityCaption as Name_of_alert from Alerthistory aa

join AlertObjects ao on ao.AlertObjectID = aa.AlertObjectID

join AlertConfigurations ac on ao.AlertID = ac.AlertID

where ( DateDiff(dd, aa.[timestamp], getDate()))< 4 order by aa.[timestamp] Desc