crashes ======= Application, System, and Mobile App crash logs. 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: crashes`` - Mac OSX Table schema ------------ =============== ======= ============================================= Name Type Description =============== ======= ============================================= type TEXT Type of crash log pid BIGINT Process (or thread) ID of the crashed process path TEXT Path to the crashed process crash_path TEXT Location of log file identifier TEXT Identifier of the crashed process version TEXT Version info of the crashed process parent BIGINT Parent PID of the crashed process responsible TEXT Process responsible for the crashed process uid INTEGER User ID of the crashed process datetime TEXT Date/Time at which the crash occurred crashed_thread BIGINT Thread ID which crashed stack_trace TEXT Most recent frame from the stack trace exception_type TEXT Exception type of the crash exception_codes TEXT Exception codes from the crash exception_notes TEXT Exception notes from the crash registers TEXT The value of the system registers =============== ======= ============================================= Query examples -------------- .. code-block:: sql select * from users join crashes using (uid)