SSL Certificate Expiration table in Modern dashboard

Hi Team,

I can able to create table for SSL certificate expiration < 30 daysin classic dashboard but i couldnt able to use any of custom properties in Modern dashboard for SSL certificate expiration to display?

Please help me on SWQL query to create SSL certificate table in modern dashboard.

Regards,

Vinoth Kumar

Find more posts tagged with

sam

ssl certificate

Dashboards

Accepted answers

All comments

DGNetops

This has given me an idea for my own environment so if I figure it out on a modern dashboard I will share what I come up with.

jenniferjohnson

To construct a table for SSL certificate expiration in the contemporary dashboard using SWQL (SolarWinds Query Language), follow the steps below:

Identify SSL Certificate Information
Write SWQL Query

Create a Modern Dashboard Widget

Here's an example SWQL query to get you started:

SELECT CertificateName, ExpirationDate
FROM Orion.Certificate
WHERE ExpirationDate < DATEADD(DAY, 30, GETDATE())

Once you've got the query, you can use it to build a custom widget for your modern dashboard:

Go to your modern dashboard editor.
Add a new widget.
Choose the custom widget option.
Select "Query" as the data source.
Paste your SWQL query into the query field.
Configure the display settings for your widget, including column names and formatting.
Save your widget and arrange it on your dashboard as desired.

This should enable you to add a table showing SSL certificate expiration details for certificates that are about to expire in the next 30 days to your contemporary dashboard.
If you encounter any issues or need further assistance, feel free to ask or read this blog

weston.hood

I have a resource like below, but it does not include Custom Property filters. Reply if interested, and I can drop the swql

jasonf1971

Could i have the swql for this please - thanks

NVSteven

I'm interested in the SWQL

mulambo

I have a SWQL for a table, building a KPI wouldn't be that complex, here's my code:

SELECT 
              [Comp].[Application].[Node].Caption as [Server Name]
            , ToString([Comp].[CurrentStatistics].[ErrorMessage]) AS [Status],
CASE 
            WHEN  ( [Comp].[CurrentStatistics].ComponentStatisticData < 30  AND  [Comp].[CurrentStatistics].ComponentStatisticData > 10)
                         THEN 3
            WHEN   [Comp].[CurrentStatistics].ComponentStatisticData < 10
                          THEN 14
            WHEN   [Comp].[CurrentStatistics].ComponentStatisticData > 30
                          THEN 2
END AS  [icon_for_Status] 

FROM Orion.APM.Component AS Comp
WHERE  [Comp].[Application].[Node].Caption in ('blah', 'blah','blah')  AND [comp].name like 'SSL Certificate Expiration Date Monitor'

jasonf1971

SWQL does not work - query is not valid

jasonf1971

SWQL does not work - query is not valid

obaid.rahman

the query is not right and throws an error. Would you please reupload

weston.hood

Sorry I missed this.

Use the KPI widget and add 4 entries each with these queries.

expired

SELECT COUNT(1) as Total 
FROM Orion.APM.Component c 
JOIN Orion.APM.CurrentComponentStatus ccs ON c.ComponentID=ccs.ComponentID 
JOIN Orion.APM.ChartEvidence ce ON ccs.ComponentStatusID=ce.ComponentStatusID 
WHERE c.ComponentType=48 AND ce.AvgStatisticData <= 0</pre>0-30 daysSELECT COUNT(1) as Total FROM Orion.APM.Component c 
JOIN Orion.APM.CurrentComponentStatus ccs ON c.ComponentID=ccs.ComponentID
JOIN Orion.APM.ChartEvidence ce ON ccs.ComponentStatusID=ce.ComponentStatusID
WHERE c.ComponentType=48 AND ce.AvgStatisticData <= 30 AND ce.AvgStatisticData > 0

30-90 days

SELECT COUNT(1) as Total FROM Orion.APM.Component c 
JOIN Orion.APM.CurrentComponentStatus ccs ON c.ComponentID=ccs.ComponentID
JOIN Orion.APM.ChartEvidence ce ON ccs.ComponentStatusID=ce.ComponentStatusID
WHERE c.ComponentType=48 AND ce.AvgStatisticData <= 90 AND ce.AvgStatisticData > 30

90+ days

SELECT COUNT(1) as Total FROM Orion.APM.Component c 
JOIN Orion.APM.CurrentComponentStatus ccs ON c.ComponentID=ccs.ComponentID
JOIN Orion.APM.ChartEvidence ce ON ccs.ComponentStatusID=ce.ComponentStatusID
WHERE c.ComponentType=48 AND ce.AvgStatisticData > 90

obaid.rahman

Thank you works fine for me

swf.nfs

Hi @weston.hood

Yes please share the SWQL, i need this. Thanks

weston.hood

queries are above

sujeet.choudhary

It is working Thanks for the SWQL

tobyw_loop1

If you are able to share in Custom Queries that would be helpful