Query Details

Show Valid Certificates On Device

Query

Use Case: Identifying and monitoring active SSL/TLS certificates to ensure website security and trustworthiness.

Query:

Certificate
| where ValidToDateTime > now()
| project ValidToDateTime, SubjectName, CommonName

Explanation

The query is used to identify and monitor SSL/TLS certificates that are currently active. It selects certificates where the expiration date is in the future and displays the expiration date, subject name, and common name of each certificate.

Details

Ugur Koc profile picture

Ugur Koc

Released: February 4, 2024

Tables

Certificate

Keywords

Certificate,ValidToDateTime,SubjectName,CommonName

Operators

where>now()project

Actions