Report on number of e-mails sent by Solarwinds

swptout

Hi all,

Is there any way to query the database to get a report on the number of e-mails sent, for example in the last 30 days or any other kind of timeframe?

This would be a report of the number of times an action (either trigger or reset) of the type "Send An Email/Page" happens.

The idea behind this need is the following, we had way too many emails being sent by Solarwinds and have optimized it to just send when it is really needed and on the right situations, and I would now like to get visibility on how much of it changed, the actual impact of the change, meaning have a way to say from, for example on Q4 (october to December) X amount of e-mails was sent and from Q1 (january to March) Y amount of emails was sent.

Don't know if this is possible but maybe somebody has done something similar.

Cheers

mesverrum

I use this report every day, it goes in the Custom Chart resource using a custom SWQL data source, the data series should be Emails, time column is Date, Data grouping is Name, time period is Once a day, looks best with a stacked column chart type.

select

count(message) as [Emails]

,datetrunc('day',timestamp) as [date]

,ac.name

FROM Orion.AlertHistory ah

left join orion.alertobjects ao on ah.alertobjectid=ao.alertobjectid

left join orion.AlertConfigurations ac on ac.alertid=ao.alertid

join orion.Actions a on a.actionid=ah.actionid

where daydiff(timestamp,getdate())<30

and a.actiontypeid='Email'

group by datetrunc('day',timestamp)

,ac.name

order by [date]

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

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