Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

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, SWQL) 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