Certificate Expiration

CourtesyIT

All,  I am looking for some SWAL/SQL code that can pull out the following information from the database. 

Columns Include: 

Server Name

IP Address

Certficate Expiration Date

jm_sysadmin

Are these pulling data from SAM certificate monitors? If you have more details I might have answers. Right now I do a few types of reports, one is data from something like this: How to Monitor an SSL Certificate and Create an Alert in SAM When There Are X Days Before Expiration (solarwinds.com) 

That I have a '90 days left' table in a modern dash from SWQL (careful with the custom properties I left in)

SELECT 
  [Comp].[Application].[Node].Caption as [Server Name]
, [Comp].[Application].[Node].CustomProperties.Support_Group as [Support Group]
, [Comp].[Application].[Node].Status as [Server Status]
, [Comp].[Application].[Node].DetailsUrl as [Server URL]
, [Comp].Name as [Monitor Name]
, [Comp].DetailsUrl as [Monitor URL]
, [Comp].Status as [Monitor Status]
, [Comp].StatusDescription as [Monitor Description]
, [Comp].[CurrentStatistics].ComponentStatisticData as [Days Until Expiration]
FROM Orion.APM.Component AS Comp
WHERE
(([Comp].[CurrentStatistics].[ComponentType]) = (48)) AND (([Comp].[CurrentStatistics].[ComponentStatisticData]) <= (90)) or [Comp].[CurrentStatistics].[ErrorMessage] like 'Certificate was expired%'
WITH NOLOCK</pre>

It looks like this: 
And I also have some mildly crazy, not completely efficient, direct exports from internal PKI servers that would take some customization for the environment that you are in. If that helps you, then I can talk about how I pull cert info in from the PKI servers, and how I report on it. 

And maybe I don't know what you are getting at... but if I don't, let me know. Glad to assist