Read incident additional comments

Fetch Additional Comments (customer-visible notes) for incidents. These comments are typically shared with end users and customers.

Data is sourced from the ServiceNow journal table.

-- Get customer-facing comments for incidents
SELECT *
FROM get_table_rows
WITH(
TableName='sys_journal_field',
Query='name=incident^element=comments'
)