Find Expired Test Certificates

//
// Find all certificates expected to expire within next 7 days
//
cluster("https://dsms.kusto.windows.net/")
.database("dsms")
.GetAKVCertificateInformation
| where ServiceName contains "cpim"
| where SecretType == "Certificate"
| extend Expiration = todatetime(NotAfter)
| extend CertName = split(Secret, "/")[-1]
| where datetime_diff("day", Expiration, now()) <= 7