cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL query for SSL certificates - Notebooks

Maelam
Observer

Hi there,

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

 

Maelam_0-1695292297979.png

 

 

3 REPLIES 3

Mizső
DynaMight Leader
DynaMight Leader

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:

Mizs_0-1695294350692.png

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

Mizs_1-1695294391693.png

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

Extensions Health | Dynatrace Hub

I hope it helps.

Best regards,

Mizső

Dynatrace Community RockStar 2024, Certified Dynatrace Professional

sinisa_zubic
Dynatrace Champion
Dynatrace Champion

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

sinisa_zubic_1-1695306656223.png

 

 

 

Best,
Sini

Hi Sini,

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

Featured Posts