DQL query for SSL certificates - Notebooks

[Maelam]

Hi there,

I need help querying SSL certificates with exp_days == 30 and set that as warning and exp_days == 10 critical

[Mizső]

Hi @Maelam,

It is not a Notebook but you can try it and use the created metric information on your Notebook.

SSL Certificate Monitor | Dynatrace Hub

Example:

Created metric with lot of dimension for splitting the cert information:

You can check you this or other extensions health (eg. errors) with this:

Extensions Health | Dynatrace Hub

I hope it helps.

Best regards,

Mizső

[sinisa_zubic · Accepted solution]

Hi @Maelam 

you can query it with such query

fetch `dt.entity.python:certificate_monitor_certificate`
| fieldsAdd lifetime, status = if(lifetime[end] -10d < now(), "🔴", else:if(lifetime[end] -30d< now(), "🟡"))

and this would be the result

Best,
Sini

[Xin_Peng]

Hi Sini,

in addition to the lifetime, how do we retrieve other info such as cert name, host name, process name, signer etc.? Thanks.