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 Expiration Date?

When you install the SSL Certificate Expiration Date there is a field in the component view that says statistic and has the number of days til the cert expires. I am trying to create a report with that info in it. Does anyone know the name of the table that has that column?

Find more posts tagged with

Accepted answers

This information is contained within the dbo.APM_PortEvidence_Detail table in the ErrorMessage column

Certificate Expires.png

All comments

This information is contained within the dbo.APM_PortEvidence_Detail table in the ErrorMessage column

Certificate Expires.png

Thank you

when you done can you share that report as well :-)

Will do

GREAT TIMING.

This was high on my to do list so I knocked it out.

Here is the SQL you can plug into web report gui.

select n.nodeid, n.Caption, d.StatisticData as ExpiresIn, d.ErrorMessage

from APM_Component c

LEFT JOIN

(

select

DISTINCT ApplicationID

, MAX(ID) over (PARTITION BY ApplicationID) as lastID

from APM_ComponentStatus

) AS lastCS

ON c.ApplicationID=lastCS.ApplicationID

LEFT JOIN APM_PortEvidence_Detail d ON lastCS.lastID=d.ComponentStatusID

LEFT JOIN APM_Application a on c.ApplicationID=a.ID

LEFT JOIN Nodes n on a.NodeID=n.NodeID

WHERE c.Name like '%ssl cert exp%'

ORDER BY ExpiresIn ASC

Change the WHERE clause to match what you name the app template. Mine is "SSL Cert Exp"

Perfect that is exactly what i was going to make. Thank you.

did you just use the custom query resource

Quick Links