Skip to Content
🏆 1st Place on Product Hunt! Check it out →
DocumentationExtracting Reports

Extracting Reports

Warestack lets you generate precise reports across your GitHub operations. These reports are structured, audit-grade, and backed by SQL—not heuristics.
You can use them to investigate incidents, surface team metrics, or stay compliant with standards like SOC-2.

Warestack Audits and Reports

Do you ever wonder how many deployment rules broke this month, and where? Or need to know which PRs broke security policy?
Generate a structured report in seconds by writing your query in plain English. Get the facts—no logs, no spreadsheets, no hallucinations.

Why use Reports?

Warestack runs deterministic queries and extracts the data you need in seconds.
Skip hours of digging through spreadsheets or logs. Save time, stay compliant, and act faster.

Here is an example of a report showing all the violations this month per repository and status.

Report Screenshot
Click to view full-size report.

Deterministic Nature of Reports

Reports use deterministic SQL and can be fully tailored to custom needs—so you don’t have to worry about inference or hallucinations.

  1. Describe your report in plain English and optionally select a team.
  2. Warestack generates a deterministic SQL query. You can refine it as needed.
  3. Save the report with appropriate versioning for future use.

A few examples of standard reports include:

Report TypeDescriptionCompliance
Deployment ViolationsSee all deployments in the past 30 days that skipped approvals or ran outside working hours.SOC-2
PR Review BypassList PRs merged without required reviewers or that bypassed branch protection rules.SOC-2, HIPAA
Sensitive File AccessTrack who modified sensitive files (.env, secrets.yml, auth.py) in the last 14 days.SOC-2, GDPR
Failed WorkflowsShow failed GitHub Actions or skipped CI/CD steps across critical services (e.g. backend team).Release Standard
Inactive IssuesIdentify issues or compliance tickets that have been open with no updates for over 7 days.Jira’s Standard

Reporting Info

Warestack reports support versioning and scheduled reruns. Each saved report includes:

  • A fully defined SQL query
  • Output filters and time window
  • Optional tags (e.g. security-audit, weekly-checkin)
  • Export options (CSV, JSON, or shareable link)

Reporting and Compliance

Warestack offers an optional service that transforms tabular data into rich, structured reports ideal for compliance audits.
We analyze the output and deliver summaries, trends, and key takeaways—ready to share or present.

⚠️ Warestack doesn’t certify your organization’s compliance, but it provides evidence in the form of data and reports.

Last updated on

Warestack

About

Our story

© 2024, Warestack