Canonical artifacts without an owner

Details

query_kind: sql
severity_default: attention
recommended_action_template: Assign owners to {n} canonical artifacts lacking an `owned_by` link. Use `scidex.link(from='type:id', predicate='owned_by', to='actor:owner-id')` to assign ownership.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

SELECT a.id::text AS ref, a.title
FROM artifacts a
WHERE a.lifecycle_state = 'canonical'
  AND a.is_latest = 1
  AND NOT EXISTS (
    SELECT 1 FROM substrate_provenance_links spl
    WHERE spl.source_artifact_type = a.artifact_type
      AND spl.source_artifact_id = a.id
      AND spl.predicate = 'owned_by'
  )

query_params

{}

threshold

{
  "warning_at": 5,
  "critical_at": 50
}

Canonical artifacts without an owner

Details

Replication

Discussion