Submit a ticketCall us
Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > SSL Certificate Expiration Report

SSL Certificate Expiration Report

Table of contents

Updated January 30, 2018


SolarWinds does not provide an out-of-the-box solution for reporting on the expiration of SSL certificates. This article explains how to build this report. 


  • All SAM versions


  1. Log in to the Orion Web Console and go to Settings > All Settings > Manage Reports.
  2. Click Create New Report.
  3. Add a custom table. Select Advanced Database Query (SQL) in the selection method drop-down.
  4. Enter the following query:
    SELECT nd.Caption, nd.IP_Address, ccs.StatisticData AS 'Days Remaining',
    CHARINDEX('/',ErrorMessage)) AS 'Expiration Date'
    FROM [dbo].[APM_CurrentComponentStatus] ccs
    JOIN [APM_Component] c ON c.ID = ccs.ComponentID
    JOIN [APM_Application] a ON a.ID = c.ApplicationID
    JOIN [NodesData] nd ON nd.NodeId = a.NodeID
    WHERE c.ComponentType = '48'
  5. Select the SQL radio button and click Add To Layout.
  6. Add columns to the report (select all and click Add Column).
  7. Click Submit.
  8. Name the report and next through the rest of the report wizard.


Please note: This is a custom SQL report and therefore will not be supported by SolarWinds. This is for informational use only.



Last modified