ServiceNow Learning 51: Important Flow reporting related tables in ServiceNow.

[Shamma Negi]

Hi All,

Few more useful reporting Flow Designer tables as below:

Flow reporting data tables

Table Name	Description	Default retention period
sys_flow_report_doc	Parent table that stores references to Flow Designer context records that have execution detail reporting data available. See the child tables for the execution details of flows and actions in specific states.	The system removes these records when it removes the parent context record from sys_flow_context.
sys_flow_report_doc_chunk	Child table that stores the reporting data and execution details for currently running flows and actions. A running flow or action can be in one of these states. Continue Sync In Progress Queued Waiting Danger: Do not change or delete data in this table. Flow Designer uses this table for flows and actions that are in an active state.	The system removes these records when the flow stops running and creates an entry in the sys_flow_report_doc_chunk_archive table.
sys_flow_report_doc_chunk_archive	Child table that stores the reporting data and execution details for flows and actions that have stopped running. A stopped flow or action can be in one of these states. Cancelled Complete Error Note: This table replaces the sys_json_chunk table as the location to store reporting data for inactive execution details.	The system removes these records when it removes the parent context record from sys_flow_context_chunk_archive. 2 weeks for completed flows 6 weeks for flows in the error or cancelled state
sys_json_chunk	Table that stores compiled process plans for future, running, and completed flows and actions created prior to the San Diego release. Danger: Do not change or delete data in this table. Flow Designer uses this table for flows and actions that are in an active state.	The system removed these records when it removed the parent record.
sys_flow_log	Table that stores replicated log entries from the Log [syslog] table. Enables users to correlate logs with flow contexts.	The system removes these records in 28 days when the table is rotated or when it removes the context record, whichever comes first. The table rotation on sys_flow_log is configurable. For more information, see Table rotation.

Hope this helps you.

I hope this article helpful. Please mark it as helpful and bookmark if you like it.

Thanks,

Shamma