Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
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 |