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.
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
