19.5.7. The closed_not_indexed_audit_channels view


The structure of these database tables may change in future PSM versions.

This view returns all audited channels whose connection have been closed, but have not been indexed yet. The view is defined as follows:

create view closed_not_indexed_audit_channels
select *
from channels
where audit is not null
and (index_status = 1
or index_status = 2);

For details on the returned columns, see Section 19.5.5, The channels table.