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