Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Server & Application Monitor (SAM) > 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