IT OPS

Offboarded-User Orphan Seat Sweep

When an HR offboarding event fires, it sweeps every SaaS app for seats still assigned to the departed user, cross-checks SSO to confirm no recent activity.

CategoryIT Ops
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerHRIS offboarding webhook firesHTTP webhook
  • ActionFind all seats for departed user in PostgresPostgreSQLPostgres
  • LogicConfirm no post-departure SSO activity, total cost
  • ActionCreate reclaim task per orphan seat in Mondaymonday.com
  • OutputPost consolidated orphan-seat alert to SlackSlack

What it does

This workflow catches the seats that survive employee departures. On an offboarding event, it searches all tracked SaaS apps for any seat still tied to the leaving user, confirms against SSO last-login that the account is genuinely dormant, and tallies the orphaned licenses and their cost. It then opens reclaim tasks and alerts IT so nothing keeps billing after someone leaves.

When to use it

Use this as the safety net on your offboarding process. Even with deprovisioning automation, niche or shadow-IT tools slip through — this sweep finds the leftover paid seats that quietly accrue cost for months.

How it works

  1. 1An offboarding webhook from your HRIS triggers the run with the departed user's identity.
  2. 2The workflow queries Postgres for every seat assignment matching that user across all apps.
  3. 3A logic step confirms each seat shows no SSO activity post-departure and computes total orphaned spend.
  4. 4If orphans exist, it creates a reclaim item per seat on the Monday.com board.
  5. 5It posts a consolidated Slack alert summarizing orphaned seats, cost, and links to the tasks.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect monday.comVisual work management for teams.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.