IT OPS
Escalate Continued Use of Denied SaaS Apps to PagerDuty
Hourly checks Snowflake SSO logs for logins to apps the review board has explicitly denied.
How it runs
The automated pipeline, trigger to output.
- TriggerHourly schedule fires
- ActionQuery logins to denied apps from SnowflakeSnowflake
- LogicFilter to usage after the deny cutoff date
- ActionOpen PagerDuty incident for security on-callPagerDuty
- OutputAlert security Slack channel with offendersSlack
What it does
Approval decisions only matter if denials are enforced. This workflow watches for SSO logins to applications the governance board marked "Denied," cross-references the deny decision's effective cutoff date, and when employees are still authenticating to a banned app after the grace period it escalates: it opens a PagerDuty incident for the security on-call and drops a Slack alert naming the offending users.
When to use it
Run this when policy decisions need teeth. It catches the gap between deciding to block an app and actually stopping its use, surfacing willful or accidental policy violations in near-real-time rather than at the next quarterly audit.
How it works
- 1An hourly schedule triggers the check.
- 2Query Snowflake for recent logins matching apps on the Denied list.
- 3Filter to logins occurring after each app's deny cutoff date, ignoring anything inside the grace window.
- 4If any post-cutoff usage exists, open a PagerDuty incident with the app and user list.
- 5Post a parallel alert to the security Slack channel for visibility.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect PagerDutyIncidents, on-call, escalations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.