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

where is the certificate expiration information stored

I am new to SW and I am having trouble. I want to make a table widget will have the node name and the certificate expiration date.

I found a query that uses the Orion.SSL.Certificates table and we do not have that table when I try using SWQL

In SAM Summary, I do see alerts for expired certificates and plenty of information, but my team leads wants a list of all servers that Certificate that are expired, expire in 30 days, expire in 60 days, and expire in 90 days

Any feedback is appreciated.

Find more posts tagged with

Accepted answers

All comments

adam.beedell

If you're using their SAM SSL monitor you want to look for the component/componentdata table, using message and statistic. Same if you're using mine

If you're using the appinsight for IIS ones then they appear in the table you mentioned

bobmarley

This may or may not work in your environment, here is the query I use.

SELECT
    Caption,
    ErrorMessage,
    NodeID,
    ComponentName,
    ComponentType,
    ComponentAvailability,
    ComponentPortNumber,
    ComponentStatisticData 
FROM Orion.APM.CurrentStatistics cp
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID
Where ComponentName LIKE 'SSL Certificate Expiration Date Monitor' AND ComponentStatisticData < 31 --displays only 31 days or less
Order BY ComponentStatisticData, ErrorMessage ASC

jayoub

Thank you very much for the help

I was only able to try the query that bob Marley sent and I was able to return some data, but I do not know what each column represents Please can you elaborate for me

I will also check for the Component data tables next

bobmarley

Mine looks like this.

Take out the Where part and you will see the entire table which will give you a better idea of what all of them are.