topic Re: DQL query for SSL certificates - Notebooks in DQL

DQL query for SSL certificates - Notebooks

Maelam — Thu, 21 Sep 2023 10:32:33 GMT

Hi there,

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

Re: DQL query for SSL certificates - Notebooks

Mizső — Thu, 21 Sep 2023 11:07:07 GMT

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ő

Re: DQL query for SSL certificates - Notebooks

sinisa_zubic — Thu, 21 Sep 2023 14:31:05 GMT

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

Re: DQL query for SSL certificates - Notebooks

Xin_Peng — Tue, 14 May 2024 18:53:26 GMT

Hi Sini,

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