SaaS Use Cases/Engineering & PlatformDevOps Engineer

How many active user accounts exist in our system that no longer have a corresponding record in any connected identity provider?

Identifies orphaned accounts that bypassed deprovisioning to close security gaps and ensure access control integrity.

Metrics & KPIs

Orphaned account countdays since last IdP syncaccount types affected

Required Data

System user accountsIdP user recordsSSO connection datalast login dates

Data Sources

Engineering PlatformData Warehouse

Works with tools like

GitHubJiraLinearPagerDutyDatadogSnowflakeBigQueryRedshiftDatabricksClickHouse

How Bruin answers this

Bruin

Bruin AI Data Analyst

How many active user accounts exist in our system that no longer have a corresponding record in any connected identity provider?

Bruin connects to your Engineering Platform, Data Warehouse and runs the analysis automatically.

It tracks Orphaned account count, days since last IdP sync, account types affected and delivers the answer in seconds, in Slack, Discord, Teams, Google Chat, WhatsApp, Telegram, email, or your browser.

Bruin for SaaS

Use cases across every team in your SaaS company, from churn & retention to revenue operations, product analytics to engineering. One AI that speaks your data.

C-Level/ExecutiveCustomer Success ManagerData AnalystDevOps EngineerEngineering ManagerFinance/FP&A AnalystGrowth ManagerMarketing ManagerProduct ManagerRevenue Operations ManagerSales Operations ManagerSupport Manager

Get this answer in seconds

Connect your data, ask the question, get the answer. No SQL needed.