IT OPS
Weekly Dormant SaaS Seat Sweep from BigQuery Usage Logs
Each week, queries BigQuery SSO and app usage logs to find seats with no activity past a threshold, then posts a ranked reclamation list to Slack for IT review.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires
- ActionQuery BigQuery for seats idle past thresholdBigQuery
- LogicRank by cost and drop below savings floor
- ActionBuild per-app dormancy summary
- OutputPost ranked reclamation list to SlackSlack
What it does
Runs a scheduled BigQuery query against your aggregated SSO and SaaS usage logs to surface every seat that hasn't shown login or feature activity in the last N days. It scores each dormant seat by monthly cost and posts a ranked, app-by-app reclamation candidate list to a Slack channel so IT can act in one place.
When to use it
Use it when license spend is creeping up and you suspect paid seats are sitting idle. Ideal for IT operations teams that already centralize login and product-usage events in BigQuery and want a recurring, no-effort dormancy report instead of manual quarterly audits.
How it works
- 1A weekly schedule fires the workflow.
- 2BigQuery runs a query joining identity events with per-app last-activity timestamps, filtering to seats idle beyond the dormancy threshold.
- 3A logic step ranks results by estimated monthly cost and drops seats below a savings floor.
- 4A formatting action builds a per-app summary with seat counts and projected savings.
- 5Slack posts the ranked candidate list to the IT channel for review.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, 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.