Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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

Overview

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. 

Environment

  • All SAM versions

Steps

  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',
    LEFT(SUBSTRING(ErrorMessage,
    CHARINDEX(':',ErrorMessage)+1,15),
    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

Tags

Classifications

Public
/*]]>*/