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

SSL Certificate Application alert

I have been away from Solarwinds for a while, but I'm trying to re-hone my skills.

have been attempting to build an email template for the SSL Alert, that includes the node, IP and # of days remaining (or past expiration, if possible). the template I am using keeps croaking on this one variable - but i am not sure what/how/where i can find the correct variable to use.

when I am editing the alert email in the UI, i can click on "insert variable", but I do find anything resembling a "Days to expire" like i find in the swsql tool (looking at Orion.APM.CurrentStatistics table.

does anyone have a template similar to this, know how to properly pull this stat for an email notification?

Solarwinds Orion Network Monitor

The SSL Certificate for server.site.com is about to EXIPIRE in ${N=SwisEntity;M=MultipleStatisticData.NumericData} days

Please login to the administrative website and validate the Web Server Certificates as well as all other active Certificates.

Find more posts tagged with

Accepted answers

All comments

stevenstadel

On a component monitor alert.

These variables should work:

${N=SwisEntity;M=Application.Node.Caption} - ${N=SwisEntity;M=Application.Node.IP_Address}

${N=SwisEntity;M=Application.ApplicationAlert.ApplicationName} - ${N=SwisEntity;M=ComponentAlert.StatisticData} Days until Certificate Expiry!

dclick

thanks, but that isnt working in the email alert.

im getting around it with this cludgy query -

${N=SWQL;M=SELECT aps.ComponentStatisticData as [Days to Expire], a.status
from orion.apm.application a join orion.nodes n on n.nodeid=a.nodeid join Orion.APM.CurrentStatistics aps on aps.ApplicationID=a.ApplicationID where aps.ComponentStatisticData < 61 And a.name = 'SSL Certificate Expiration Date'}