Difference between revisions of "Venafi Queries"
Jump to navigation
Jump to search
(Created page with "``` DELETE FROM config_contains where Attribute ='Authentication Scheme' ```") |
|||
| Line 1: | Line 1: | ||
| + | # | ||
| + | ## | ||
| + | |||
| + | ### Delete auth scheme | ||
``` | ``` | ||
DELETE FROM config_contains where Attribute ='Authentication 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'; | ||
``` | ``` | ||
Latest revision as of 14:28, 6 February 2024
#
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';