Venafi Queries
Jump to navigation
Jump to search
#
Delete auth scheme
DELETE FROM config_contains where Attribute ='Authentication Scheme'
Get expiring certificates
select store_entry_certificates_subject.Value, store_entry_certificates.ValidTo, store_entry_certificates.SubjectId, store_entry_certificates_subject.Id from store_entry_certificates INNER JOIN store_entry_certificates_subject ON store_entry_certificates.SubjectID = dbo.store_entry_certificates_subject.id WHERE store_entry_certificates.ValidTo BETWEEN '2023-02-01' AND '2023-02-27';