Query Details
Certificates That Will Expire In The Next 90 Days
Query
Use Case: Generating a list of expiring SSL certificates for proactive renewal within the next 90 days. Query: Certificate | project SubjectName, ValidFromDateTime, ValidToDateTime, CommonName | where ValidToDateTime > now() and ValidToDateTime < now() + 90d
Explanation
The query is used to generate a list of SSL certificates that will expire within the next 90 days. It selects specific information about each certificate, such as the subject name, validity period, and common name. The query filters the results to only include certificates that have a validity end date greater than the current date and less than 90 days in the future. This allows for proactive renewal of expiring certificates.
Details
Ugur Koc
Released: February 4, 2024
Tables
Certificate
Keywords
Certificate,SubjectName,ValidFromDateTime,ValidToDateTime,CommonName,ValidToDateTime,now(),now()+90d
Operators
projectwhere><now()+90d