Detection: Organization Moderator Removed

Overview

Detect when an organization's moderator was removed. Removing a moderator may reduce oversight and weaken security controls, potentially impacting the organization's ability to manage discussions, enforce policies, and monitor repository activity. Monitoring these events ensures that privilege revocations are intentional and align with security policies.

References:

Managing Moderators in an Organization

Usage

Run the detection in your terminal:

powerpipe detection run github_audit_log_detections.detection.organization_moderator_removed

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run github_audit_log_detections.detection.organization_moderator_removed --share

SQL

This detection uses a named query:

select
  tp_timestamp as timestamp,
  action as operation,
  concat('https://github.com/', user) 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 = 'organization_moderators.remove_user'
order by
  tp_timestamp desc;

Detection: Organization Moderator Removed

Overview

Usage

SQL

Tags