Windows Certificate Overview

Get an Overview of All Certificates in Your Environment

Lansweeper automatically scans Windows certificates including many details like the name, issuer, start date, expiration date, signature algorithm, and much more. Using this data we can help you manage all the certificates in your environment so you always know where you've got which certificates along with all the previously mentioned details. You can find more use cases with certificate data in the Certificates Pro Tips blog post.

The report below provides an overview of the number of certificates in your entire IT environment.

Certificate Overview Query

Select tblCertificates.SubjectName,
tblCertificates.IssuerName,
tblCertificates.FriendlyName,
Case
When tblCertificates.HasPrivateKey = 0 Then 'no'
Else 'yes'
End As HasPrivateKey,
Case
When tblCertificates.IsArchived = 0 Then 'no'
Else 'yes'
End As IsArchived,
tblCertificates.SignatureAlgorithm,
Count(tblCertificates.Thumbprint) As Total,
tblCertificates.StartDate,
tblCertificates.ExpirationDate
From tblCertificates
Inner Join tblCertificateLocations On tblCertificateLocations.CertificateID =
tblCertificates.CertificateID
Group By tblCertificates.SubjectName,
tblCertificates.FriendlyName,
tblCertificates.IssuerName,
tblCertificates.HasPrivateKey,
tblCertificates.IsArchived,
tblCertificates.StartDate,
tblCertificates.ExpirationDate,
tblCertificates.SignatureAlgorithm
Order By Total Desc

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting