Venafi Queries

#

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';