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.
Run the Certificates Overview Audit Now!
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
Explore the full platform, free for 14 days.
No credit card required.