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
