IT OPS
Offboarding Orphaned Seat Reconciliation Audit
Weekly, cross-check active SaaS seats against the HR roster to catch accounts that belong to people who already left, then flag every orphaned seat for reclaim.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly reconciliation schedule fires
- ActionPull active employee roster from PostgresPostgres
- ActionFetch current seat membership from Slack and GitHubGitHub
- LogicDiff seat lists against roster to find orphans
- ActionWrite orphaned seats to reclaim-candidates tablePostgres
- OutputPost orphaned-seat summary to IT-ops channelSlack
What it does
Catches offboarding gaps that slipped through. It compares the live seat lists from your SaaS tools against the current employee roster in Postgres and surfaces any seat still active for someone marked as departed — the licenses that should already be gone.
When to use it
Run it on a weekly cadence as a safety net behind your real-time offboarding, or before a license true-up, when you want to find and eliminate spend on ghosts in the system.
How it works
- 1A weekly schedule kicks off the reconciliation.
- 2The flow pulls the authoritative roster of active employees from Postgres.
- 3It fetches current seat membership from Slack and GitHub.
- 4A logic step diffs each tool's seat list against the active roster to isolate orphaned accounts.
- 5Confirmed orphans are written back to a reclaim-candidates table with estimated monthly cost.
- 6A summary of orphaned seats and total recoverable spend is posted to the IT-ops Slack channel for action.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Connect GitHubRepos, issues, pull requests, actions.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More IT Ops workflows
Daily Building Anomaly Digest to MS Teams
Each morning queries BigQuery for the prior day's flagged sensor anomalies, summarizes them by site and system into a ranked briefing.
Indoor Air Quality Breach to Tenant Notice and Work Order
Listens for CO2, VOC, or humidity sensor alerts via webhook, and when a zone exceeds occupant-safety limits it emails affected tenants, opens a Monday remediation task.
Self-Service Reclaim Email for Idle Users
Detects users idle in a SaaS app past the threshold and emails each one a keep-or-release link; unanswered seats after the deadline are auto-flagged for removal.
Outlook Room Conflict Resolver with Approval Gate in Teams
When an Outlook room clashes, proposes a rebooking and asks the bumped meeting's organizer to approve the move in Microsoft Teams before any change is made.
Outlook Room Double-Booking Resolver with Auto-Rebook
Detects when two meetings claim the same Outlook room resource and automatically relocates the lower-priority meeting to a comparable free room.
Monthly Wasted-License Cost Report
Aggregates inactive-seat data across all tracked SaaS apps each month, computes total reclaimable spend, and delivers a ranked cost report to leadership in Notion and Slack.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.