CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Windows Certificate Expiration Date Chart

Chart Operating System

Get an Overview of the Certificate Expiration Dates

Lansweeper scans certificates from your Windows devices by default including information such as the name, issuer, start date, expiration date, certificate algorithm, and more. TO ensure services and sites continue to work, you’ll need to ensure that your certificates stay valid and are renewed in time before they expire. You can find more use cases with certificate data in the Certificates Pro Tips blog post. The report below provides you with an overview of how many certificates will be expiring in each month of the current year so you have a better view of how much work might be coming in a specific month if you’re managing certificates.
To use this in a chart widget, prefix the report name with “Chart:” and select it in the chart report widget found on a dashboard.
Certificate expiration month chart

Windows Certificate Expiration Date Chart Query

select
case when month(ExpirationDate) = 1 then 'Jan' 
when month(ExpirationDate) = 2 then 'Feb'
when month(ExpirationDate) = 3 then 'Mar'
when month(ExpirationDate) = 4 then 'Apr'
when month(ExpirationDate) = 5 then 'May'
when month(ExpirationDate) = 6 then 'Jun'
when month(ExpirationDate) = 7 then 'Jul'
when month(ExpirationDate) = 8 then 'Aug'
when month(ExpirationDate) = 9 then 'Sep'
when month(ExpirationDate) = 10 then 'Oct'
when month(ExpirationDate) = 11 then 'Nov'
when month(ExpirationDate) = 12 then 'Dec'
end as Month,
count(Thumbprint) as Total
from tblCertificates
where YEAR(ExpirationDate) = YEAR(Getdate())
group by month(ExpirationDate)
order by month(ExpirationDate) asc

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.