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.
Certificate
| project SubjectName, ValidFromDateTime, ValidToDateTime, CommonName
| where ValidToDateTime > now() and ValidToDateTime < now() + 90dExplanation
This query is designed to identify SSL certificates that are set to expire within the next 90 days. It works by:
- Accessing a database or table named "Certificate" that contains information about SSL certificates.
- Selecting specific columns of interest:
SubjectName,ValidFromDateTime,ValidToDateTime, andCommonName. - Filtering the results to include only those certificates whose expiration date (
ValidToDateTime) is in the future but within the next 90 days from the current date and time.
In simple terms, this query helps you find SSL certificates that need to be renewed soon, allowing you to take action before they expire.
Details
Ugur Koc
Released: December 13, 2024
Tables
Certificate
Keywords
Certificate
Operators
projectwherenowand+