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.
The report below provides an overview of the number of expired certificates in your entire IT environment.
Run the Expired Certificates Overview Audit Now!
Select Top 1000000 tblAssets.AssetID,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username As UserName,
tblAssets.Userdomain As UserDomain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen As [Last successful scan],
tblAssets.Lasttried As [Last scan attempt],
tblCertificates.SubjectName,
tblCertificates.IssuerName,
tblCertificates.HasPrivateKey,
Case
When tblCertificates.IsArchived = 0 Then 'no'
Else 'yes'
End As IsArchived,
tblCertificates.StartDate,
tblCertificates.ExpirationDate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblCertificateLocations On tblCertificateLocations.AssetID =
tblAssets.AssetID
Inner Join tblCertificates On tblCertificates.CertificateID =
tblCertificateLocations.CertificateID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblCertificates.ExpirationDate <
GetDate() And tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1 And tblCertificates.IsArchived = 0
Order By tblCertificates.ExpirationDate Desc
Explore the full platform, free for 14 days.
No credit card required.