Query: organization_application_uninstalled

select
  tp_timestamp as timestamp,
action as operation,
additional_fields ->> 'integration' as resource,
actor,
tp_source_ip as source_ip,
tp_index as organization,
split_part(repo, '/', 2) as repository,
tp_id as source_id,
*
exclude (actor, timestamp)

from
  github_audit_log
where
  action = 'integration_installation.delete'
order by
  tp_timestamp desc;