Down Alert Report with Notes

All,

Currently we make notes on a down alert log entry (usually these notes are short and describe the outage, e.g. power loss, ticket #xxxxx opened with ATT, etc...):

Screen Shot 2016-07-18 at 8.33.06 AM.png

Most of our outages are power related. When we run our monthly availability reports I would like to include the notes in the report so we can identify the cause of the outage (power, ATT, etc...). Has anyone implemented this sort of feature in their outage reports?

Thanks,

Tim

Find more posts tagged with

npm notes

reports_availability_customize

Accepted answers

dhanson

There's a SQL table in 11.0.1 (possibly the same in 11.5) called AlertStatus, with a column "Notes" that includes the input from this window. With some SQL prowess, you can add this. Are you using a canned report for monthly availability or a custom one?

Oh, and is it a web report or from the Report Writer app on the server?

All comments

dhanson

Oh, and is it a web report or from the Report Writer app on the server?

tpfannes

Canned report but we have utilized custom SQL queries in the past. I'm not fluent in SQL but if the table is there we can find someone to report on it. Thanks.