AppInsight has a way of providing the status of all databases, but there is no way to alert on this property. Please add this feature if possible. Thanks!
It is in fact possible to alert on the status of a database, as shown below.
I was looking at the operational status (online, offline, etc)...
I actually submitted a feature request about this, since Solarwinds support said they don't have this implemented in the current version.
Does a quick way exist to get those values included in an alert as opposed to just the numeric value? I see operational state in numerous tables in the db but nothing referencing the actual value context. I could use "Display Status" I suppose but I feel the information from Operational State is more helpful.
Got this figured out.
${N=SwisEntity;M=SqlDatabaseAlert.DatabaseName} on ${N=SwisEntity;M=SqlServer.Node.Caption} is ${SQL: select
(
case
when OperationalState = 0 then 'Online'
when OperationalState = 1 then 'Restoring'
when OperationalState = 2 then 'Recovering'
when OperationalState = 3 then 'Recovery_Pending'
when OperationalState = 4 then 'Suspect'
when OperationalState = 5 then 'Emergency'
when OperationalState = 6 then 'Offline'
when OperationalState = 7 then 'Copying'
when OperationalState = 10 then 'Offline_Secondary' end)
as OpState from APM_SqlBbCurrentDatabases where ID = ${N=SwisEntity;M=SqlDatabaseAlert.DatabaseID} }
I am at SAM 6.6.0 and still it gives the numeral value for the variable 'Operational State'. Has this still not been implemented and using the query the only way to replace the numeral value? aLTeReGo
This was implemented in SAM 6.4
@aLTeReGo looks like variable is still in numeric in the alert Email notifications on SAM 2020.2
