How do I create a SWQL for SSL certs?

jruiz73

Hello,

How do I create a Query for SSL on specific server?

I need :

1.Display name of Node

2. SSL cert name

3. Expiration date

4. Days till Expiration

Find more posts tagged with

ssl certificate monitor

ssl cert

Accepted answers

All comments

bobmarley

Here is a good starting point. You may need to adjust the component name to match your component.

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' 
Order BY ComponentStatisticData, ErrorMessage ASC

jruiz73

Thanks how would i pick a server to check ?

Example:

Select Displayname from Orion.Nodes

Where ( display name = XXX ) not sure of the syntax

bobmarley

The syntax woudl look similar to this

Where ComponentName LIKE 'SSL Certificate Expiration Date Monitor' AND Caption LIKE '%YOURSERVERNAME%'