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 ================= ======== ================================================== Query examples -------------- Select all the results for the given table. .. code-block:: sql SELECT * FROM certificates;