nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

SQL Databases Status alerting

nmoraru

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!

Find more posts tagged with

Status: None

Comments

aLTeReGo

It is in fact possible to alert on the status of a database, as shown below.

Database Status.png

nmoraru

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.

shack

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.

shack

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} }

amrita1690

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

aLTeReGo

This was implemented in SAM 6.4

amrita1690

Hi aLTeReGo,

Seems like the non-numeric value is available in fields/events for setting the alert trigger condition(the screenshot of which you've shared) and in columns variable in the reports. However, the same is not available as a variable in the alert Email notifications. PFB a screenshot taken while selecting a variable in the alert email notification action.

Can you please check and see why it has been missed at one place and has been implemented at rest.

aLTeReGo

Thank you for clarifying. We are tracking this internally under SAM-7259.

jameslindsay

I'm on SAM 6.7.1 and still no relief.

teja0909

@aLTeReGo looks like variable is still in numeric in the alert Email notifications on SAM 2020.2