CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Windows Self-Signed Certificate Overview

Operating System

Get an Overview of All Self-Signed 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 self-signed certificates in your entire IT environment. Certificates overview report

Self-Signed 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
Where tblCertificates.SubjectName = tblCertificates.IssuerName
Group By tblCertificates.SubjectName,
tblCertificates.FriendlyName,
tblCertificates.IssuerName,
tblCertificates.HasPrivateKey,
tblCertificates.IsArchived,
tblCertificates.StartDate,
tblCertificates.ExpirationDate,
tblCertificates.SignatureAlgorithm
Order By Total Desc

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.