certificates

Certificate Authorities installed in Keychains/ca-bundles.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: certificates

  • Mac OSX
  • Windows

Table schema

Name Type Description
common_name TEXT Certificate CommonName
subject TEXT Certificate distinguished name
issuer TEXT Certificate issuer distinguished name
ca INTEGER 1 if CA: true (certificate is an authority) else 0
self_signed INTEGER 1 if self-signed, else 0
not_valid_before DATETIME Lower bound of valid date
not_valid_after DATETIME Certificate expiration data
signing_algorithm TEXT Signing algorithm used
key_algorithm TEXT Key algorithm used
key_strength TEXT Key size used for RSA/DSA, or curve name
key_usage TEXT Certificate key usage and extended key usage
subject_key_id TEXT SKID an optionally included SHA1
authority_key_id TEXT AKID an optionally included SHA1
sha1 TEXT SHA1 hash of the raw certificate contents
path TEXT Path to Keychain or PEM bundle
serial TEXT Certificate serial number

Query examples

Select all the results for the given table.

SELECT * FROM certificates;