Okta Reports in Okta

Okta Reports in Okta

How to turn a mountain of identity activity into clear answers. A complete guide to the built-in reports, where their data comes from, how to run and export them safely, how they support audits and access reviews, and where they stop and other tools begin.

Three questions arrive in the same week at the same company. The finance director asks, “Exactly who can open the payroll application, and has anyone not used it in the last three months?” An external auditor asks, “Can you show me what share of your staff are enrolled in multi-factor authentication?” And the security lead, after reading a news story about stolen passwords, asks, “Are our people reusing weak passwords in the legacy apps we put behind single sign-on?”

Each question is perfectly reasonable, and each one is impossible to answer by guessing. The honest answers sit inside Okta, spread across thousands of sign-ins, hundreds of application assignments, and many months of activity. Nobody can read that much raw data. What the team needs is a way to ask a clear question and receive a clear, organized answer. That is what reports are for.

Okta includes a set of built-in reports in its Admin Console. They turn raw activity into readable tables that show sign-in patterns, multi-factor usage, password health, application usage, assignments, and security signals. Used well, reports save hours of detective work, give auditors the evidence they need, and help administrators spot problems before they become incidents. Used badly, they produce spreadsheets that nobody reads and sensitive data that leaks into inboxes. This guide teaches Okta reports from the beginning: what they are, where their data comes from, which reports exist, how to run and protect them, how they connect to audits and access reviews, and what to do when the built-in reports are not enough.

1What Are Okta Reports?

A plain definition, a simple picture, and the sentence worth remembering.

Okta is an identity platform. It keeps the official list of who your people are, which applications each person may open, and how they prove who they are. Every day it records a huge number of events: sign-ins, failed attempts, password changes, factor enrollments, application assignments, and administrator actions. All of that activity is valuable, but in raw form it is overwhelming.

An Okta report is a prepared view of that activity or of the current state of your organization, organized to answer a common question. Instead of searching through thousands of log lines, an administrator opens the Reports area of the Admin Console, picks a report, chooses a time range or filter, and receives a table or summary. Many reports can be exported as a file, usually in comma-separated format that opens in a spreadsheet.

It helps to think of two kinds of questions that reports answer. The first kind is about activity over time: who signed in, how often, from where, and with which factors. The second kind is about the current state: who is assigned to which application right now, and which passwords look weak today. Both kinds matter. Activity shows behavior, and state shows exposure.

Everyday Analogy

Imagine a large office building with a front-desk visitor book and a security camera system. The raw footage and the thick logbook contain everything, but nobody can watch weeks of video. A building manager asks for simple summaries instead: “How many visitors came each day?”, “Who still holds a key to the server room?”, “Which doors were opened after midnight?” Okta reports are those summaries. The log is the footage, and the reports are the manager’s weekly briefing.

Ask
Start with a clear question about activity or access
Run
Pick a report, a filter, and a time range
Act
Turn findings into fixes and evidence
!
The Sentence to Remember

A report is only useful when it answers a question and leads to an action. Data without a question is noise.

2The Problem: Questions Nobody Can Answer Without Data

To feel why reports matter, imagine running an identity system with no summaries at all.

Identity systems create two kinds of risk. Some risks are loud, like an obvious attack. Others are quiet, like an old account that still has access to a sensitive application, or a group of users who never enrolled in multi-factor authentication. Quiet risks can sit unnoticed for years, because nothing about them is dramatic. They are found only by someone asking the right question and looking at the right data.

The questions leaders and auditors actually ask

Access

Who can open this application?

A question about current assignments. It matters for least privilege, licensing costs, and incident response.

Usage

Is anyone actually using it?

Unused access is wasted money and unnecessary risk. Usage reports reveal applications and assignments that can be retired.

Strength

How many people use multi-factor authentication?

A question about coverage. Auditors, insurers, and boards increasingly ask for the number.

Hygiene

Are passwords weak or reused?

A question about exposure. Weak and reused passwords turn one small breach into many.

Threat

Has anything suspicious happened?

A question about attacks in progress, such as repeated failures or sign-ins from unusual places.

Lifecycle

Did leavers lose their access?

A question about offboarding. Lingering access after someone leaves is among the most common findings in audits.

What happens without reports

Without a ready way to answer these questions, teams fall back on manual detective work. Someone exports a list from one system, a second list from another, and compares them in a spreadsheet. The work is slow, error-prone, and rarely repeated. Findings arrive late and are often out of date by the time anyone acts. Audits become painful annual scrambles, when they should be a routine collection of fresh evidence.

QuestionWithout reportsWith reports
Who is assigned to the finance app?Click through the application and count by handRun a current-assignments report and export it
What is our multi-factor coverage?Guess, or sample a few usersRun a usage report and calculate the share
Which apps are unused?Ask each application ownerRun an application usage report over a long period
Is there a spike in failed sign-ins?Search raw logs and countRun a failure report for the period
Show the auditor evidenceAssemble screenshots at the last minuteKeep a dated set of exported reports
Everyday Analogy

Think of running a school with no attendance register. When a parent asks how often their child was absent this term, the teacher would have to remember or guess. With a register, the answer takes seconds, and patterns, such as a child absent every Monday, become visible. Reports are the identity system’s register.

What you cannot see, you cannot secure, and what you cannot prove, you cannot audit.

3A Short History: From Log Files to Reports to Streaming

How organizations moved from reading raw logs to asking questions of curated reports, and on to automated pipelines.

1

Plain log files

Early systems wrote text lines to files. Experts could search them, but only after the fact and only if they knew what to look for.

2

Central log collection

Organizations began gathering logs from many systems into one place, which made searching possible across the whole estate.

3

Prepared reports

Products started offering ready-made summaries for common questions, so non-experts could get answers without writing searches.

4

Compliance pressure

Regulations and frameworks asked organizations to prove, repeatedly, that access was controlled. Reports became evidence, not just curiosity.

5

APIs and streaming

Platforms added programmatic access and live streaming of logs to security monitoring tools, enabling custom analysis and long-term storage.

6

Insights and governance

Newer capabilities add dashboards, risk signals, and governance reporting such as access certifications, moving from “what happened” toward “what should we do.”

Where Okta reports fit today

Okta offers several layers of visibility. The System Log holds detailed raw events. Built-in reports present curated views for common questions. APIs and log streaming move data into your own tools for deeper analysis and long retention. Governance features add structured reviews of who has access to what. Reports sit in the middle: more approachable than the log, less flexible than your own analytics. Understanding that middle position tells you when to use them and when to reach for something else.

Everyday Analogy

Think of how a company watches its money. There is a general ledger with every transaction (the log), monthly statements that summarize it for managers (reports), a data warehouse for analysts (streaming and APIs), and an annual audit that checks the whole thing (governance). Each layer serves a different reader.

4Core Concepts and Vocabulary

Ten terms carry the whole topic. Each is explained with what it is, why it exists, and where you will meet it.

Term 01

Report

A prepared view of Okta data that answers a common question, such as sign-in activity or current application assignments.

Term 02

System Log

Okta’s detailed record of events. Many reports are built from the same underlying activity. The log is raw and searchable, while reports are curated.

Term 03

Activity Report

A report about what happened over a period, such as sign-ins, failures, or factor use.

Term 04

State Report

A report about how things are right now, such as current assignments or current password health.

Term 05

Time Range

The period a report covers. Choosing it carefully matters, since results depend heavily on it.

Term 06

Filter

A condition that narrows a report, such as a particular user, application, or outcome.

Term 07

Export

Saving a report’s results as a file, usually a spreadsheet-friendly format, for sharing, analysis, or evidence.

Term 08

Report Administrator

An administrator role focused on viewing reports, which allows insight without broad permission to change settings.

Term 09

Retention

How long data remains available. Reports can only show what is still retained, which limits how far back you can look.

Term 10

Evidence

A dated, saved report used to prove to an auditor that a control worked at a given time.

Three questions to ask of any report

Whenever you open a report, ask three questions. What exactly does this measure? A sign-in report might count successful launches, failed attempts, or both. What period and scope does it cover? A report on the last seven days tells a different story than the last ninety. What would I do differently if the answer were bad? If nothing would change, the report may not be worth running regularly.

Everyday Analogy

Reading a report is like reading a weather forecast. You need to know the place, the time window, and what “chance of rain” actually means. The same number can mean very different things depending on those details. A careful reader checks the labels before drawing conclusions.

5Reports, System Log, Dashboard and Log Streaming Compared

Okta offers several ways to see what is going on. Choosing the right one saves time.

Newcomers often confuse reports with the System Log, and the dashboard with both. They overlap, but each has its own purpose. Knowing the differences helps you reach for the right tool.

ToolWhat it showsBest forLimits
Built-in reportsCurated views of common questionsQuick answers, audits, routine reviewsFixed shapes, limited customization, limited retention
System LogEvery recorded event with rich detailInvestigations, custom searches, root causeRaw and detailed, needs skill to interpret
Admin dashboardHigh-level snapshots and trendsA daily glance at health and activityNot detailed enough for evidence
System Log APIThe same events, for programs to readCustom reports, automation, pipelinesNeeds development effort and care with rate limits
Log streamingA live feed of events to an outside platformLong retention, security monitoring, correlation with other systemsRequires a destination platform and its cost
Governance reportingStructured access reviews and certifications, on plans that include themPeriodic review of who should keep accessDepends on plan and setup

A simple rule of choice

1

Need a quick, common answer?

Use a built-in report. It is the fastest route and needs no skill with log searches.

2

Investigating something specific?

Use the System Log, where you can search by user, event type, time, and outcome in full detail.

3

Need something repeated, custom, or long-term?

Use the API or log streaming to build your own reports and keep data longer.

4

Need a formal review of access?

Use governance features if your plan includes them, or build a review process using assignment reports.

Everyday Analogy

Think of a hospital. The patient chart holds every detail (the log). The nurse’s morning summary highlights what needs attention (reports). The wall display shows how busy each ward is (the dashboard). The research database stores years of anonymized records for analysis (streaming and APIs). Each serves a different person at a different moment.

i
Good to Know

The exact set of tools available, and how Okta groups and names them, depends on your plan and release. Confirm in your own Admin Console and in current Okta documentation before building a process around any one of them.

6The Families of Okta Reports

An overview of the main kinds of reports, before we examine each family in its own chapter.

Okta groups its reports into families by purpose. The exact titles and groupings differ between releases, and Okta occasionally renames or reorganizes them, so treat the list below as a map of the territory rather than a catalog of menu labels.

Family 1

Sign-in and authentication activity

Who signed in, how often, to which applications, with which factors, and where sign-ins failed. The backbone of everyday visibility.

Family 2

Multi-factor usage

Which factors are enrolled and used, and how widely multi-factor authentication is adopted across users and groups.

Family 3

Password health

A look at weak, reused, or otherwise risky passwords in user-managed application credentials, without revealing the passwords themselves.

Family 4

Application usage and assignments

Which applications are used, by whom, and who is currently assigned to what. Central to access reviews and cost control.

Family 5

Lifecycle and provisioning

Activity around creating, changing, and removing user accounts and application access, important for joiners, movers, and leavers.

Family 6

Security and threat signals

Suspicious activity, repeated failures, and threat-detection findings that may indicate attacks or misuse.

How the families map to questions

If your question is…Look in this family
Who is signing in, and to what?Sign-in and authentication activity
How much of our staff uses multi-factor authentication?Multi-factor usage
Are our application passwords weak or reused?Password health
Who has access to this application, and who uses it?Application usage and assignments
Did leavers lose access, and what changed for movers?Lifecycle and provisioning
Is something suspicious going on?Security and threat signals
What happened to this one user at 2 a.m.?Not a report, but the System Log
Everyday Analogy

Think of the sections of a newspaper: front page, business, sports, weather, local news. You do not read the whole paper to find the football score. You go to the right section. Report families are the sections, and knowing which one answers your question is half the skill.

!
Verify Before You Rely

Report names, groupings, available filters, and which reports exist differ between Okta Identity Engine and Classic Engine, between plans, and between releases. Open the Reports area in your own org and match this guide’s families to what you see there.

7Architecture and Components

A map of every part involved in producing and using an Okta report.

flowchart LR
  EV["User and Admin Activity"] --> LOG["Okta System Log"]
  APPS["Application Assignments and User Profiles"] --> DIR["Universal Directory"]
  LOG --> RPT["Reports Engine"]
  DIR --> RPT
  RPT --> VIEW["Admin Console Report Views"]
  VIEW --> CSV["CSV Export"]
  LOG --> API["System Log API"]
  API --> SIEM["SIEM or Data Warehouse"]
  CSV --> REVIEW["Review, Audit and Action"]
    
Fig 1. The main parts involved in producing and using Okta reports. A simplified teaching model.

Walking through the boxes

User and admin activity. Everything starts with people and systems doing things: signing in, enrolling factors, changing passwords, assigning applications. Each action creates events.

System Log. Okta writes events into the System Log as they happen. This is the detailed record. Many activity reports are built on top of it.

Universal Directory and assignments. The current state of users, groups, and application assignments lives here. State reports draw on this information rather than on past events.

Reports engine. The component that takes your chosen report, filters, and time range, queries the underlying data, and builds an organized result.

Admin Console report views. The pages where administrators select and read reports, subject to their role and permissions.

CSV export. A way to save the results as a file for sharing, analysis, and evidence. Once exported, the data leaves Okta’s protections and becomes your responsibility.

System Log API. A programmatic interface to the same events, which lets your own tools build custom reports and long-term archives.

SIEM or data warehouse. External platforms that collect logs for security monitoring and analytics, often with longer retention than Okta provides by itself.

Review, audit, and action. The human end of the chain: where findings become tickets, fixes, and evidence.

Everyday Analogy

Imagine a restaurant. The kitchen order tickets are the log. The list of tables currently occupied is the directory state. The manager’s end-of-day summary, which combines both, is the report. A spreadsheet of that summary handed to the owner is the export, and the accountant’s database holds many years of summaries. Everyone gets a view that suits their role.

!
Design Hint

When a report looks wrong, trace it along this map: was the activity recorded, did the report cover the right period and scope, and has anything changed in how it was exported?

8Internal Working: Where Report Data Comes From

A report is only as trustworthy as its source. Knowing the sources tells you what a report can and cannot say.

Okta reports draw from two broad kinds of sources. Understanding which kind a report uses explains most of its behavior: why it can look back only so far, why it may differ slightly from another view, and why some reports are snapshots.

Source type 1: recorded events

Activity reports are generally built from events that Okta recorded as things happened. A sign-in produces an event. A failed attempt produces an event. A factor enrollment produces an event. The report reads these events over the chosen time range, counts and groups them, and presents the result. Because the events are recorded in time order, these reports can answer “what happened between these dates.” They can only look back as far as the event data is retained.

Source type 2: current state

State reports read the present condition of the organization: which users are assigned to which applications, what the current profile attributes are, and what the present password health looks like. They answer “what is true now” and do not replay history. If you run such a report today and again next month, the difference between the two results is your own record of change, which is why saving dated exports matters.

FeatureActivity reportsState reports
Based onRecorded events over timeThe present condition of the org
Question answeredWhat happened between two dates?What is true right now?
Depends on a time range?Yes, stronglyNot in the same way
Limited by retention?Yes, you cannot look back past what is keptNo, it reads current data
Good forTrends, investigations, usage patternsAccess reviews, exposure checks, inventory
How to preserve historyExport or stream regularlyExport on a schedule and compare snapshots

Why two reports might not match exactly

Reason

Different definitions

One report may count launches and another counts distinct users. The labels differ, and so do the numbers.

Reason

Different time windows

Reports may use different time zones or boundaries, so a day’s total can shift slightly.

Reason

Timing of data

Recent events may take a short time to appear, so a report run immediately after an event may miss it.

Reason

Scope differences

A report may include only some kinds of applications, such as those that use particular sign-on methods.

Everyday Analogy

A bank gives you a statement of past transactions (activity) and a balance as of today (state). The statement tells you what happened last month, and the balance tells you what you have now. If you want to know what the balance was last March, the balance alone cannot help. You need a saved statement from then. Reports work the same way.

!
Verify Before You Rely

The exact data source, retention, and freshness of each report depend on the report and the release. Read the description shown with each report, and test with a known event before using a report as formal evidence.

9Sign-In and Authentication Reports

The most commonly used family, showing who is signing in, to what, and how it went.

Sign-in reports answer the daily questions of any identity team. How many people are using single sign-on? Which applications are busiest? Are there unusual spikes in failures? Is multi-factor authentication being used as intended? These reports usually list events or counts for a period and can be filtered by user, application, or outcome.

What these reports typically show

Report

Single sign-on activity

Sign-ins to applications through Okta, with details such as user, application, time, and outcome. Useful for usage trends and unusual behavior.

Report

Failed sign-ins

Attempts that did not succeed, with reasons where available. A rise can mean a forgotten password campaign, a broken integration, or an attack.

Report

Multi-factor usage

Which factors users enroll and use, and how many sign-ins involved them. The basis for coverage figures that auditors request.

Report

Admin Console access

Who opened the administrative area and when. A sensitive view that deserves regular attention.

Reading sign-in reports well

Numbers without context mislead. A rise in sign-ins on Monday morning is normal. A rise at three in the morning from an unusual country is not. Compare the current period with a similar earlier period, such as this Monday against the previous four Mondays. Look for the shape of the change, not just its size: a gradual climb in failures differs from a sudden spike, and each points to a different cause.

1

Pick a baseline

Run the report for a calm, typical period and note normal volumes for each day and hour.

2

Run the period you care about

Choose the window that matches your question, such as the week since a policy change.

3

Compare

Look at differences from baseline: volume, timing, applications, outcomes, and users.

4

Drill into anomalies

For any unusual pattern, move to the System Log and investigate individual events.

5

Record the conclusion

Write a short note: what you saw, what it meant, what you did. Save the export as evidence.

Everyday Analogy

A shopkeeper counts customers each day. Fifty people on a Saturday is normal, and fifty on a quiet Tuesday is exciting news. Only because the shopkeeper knows the usual pattern can they tell whether today’s number is good, bad, or just ordinary. Baselines turn numbers into meaning.

!
Practical Tip

Note when you change a policy or roll out a new application. Those dates explain many changes in sign-in reports, and without them you may chase false alarms.

10The Password Health Report

A report that looks at the quality of passwords people use for applications, without exposing the passwords themselves.

Some applications are connected to Okta through Secure Web Authentication, where Okta stores a username and password for the user and fills them into the application’s sign-in page. When users choose those passwords themselves, the passwords may be weak, reused across applications, or similar to each other. A password health report examines this population and highlights risky patterns. It is meant to show where passwords look risky, not to display the passwords.

What it helps you find

Finding

Weak passwords

Passwords that are short, simple, or easy to guess. They are the most likely to be broken by attackers.

Finding

Reused passwords

The same password used across several applications. A breach in one application then threatens all the others.

Finding

Shared across users

Where applicable, the same password appearing for many accounts, which suggests a shared habit or a default value never changed.

Finding

Applications at risk

Applications where weak or reused passwords are concentrated, which guides where to act first.

Turning findings into action

FindingPossible action
Many weak passwords in one applicationMove that application to federation, or switch to administrator-set random passwords
Passwords reused across applicationsAsk users to change them, and consider removing the ability to choose their own credentials
A shared default password across accountsForce a change and block default values at the application where possible
Risky passwords on sensitive applicationsPrioritize these first, and add stronger sign-on policies in Okta

An important limit

This report covers only credentials that Okta can see in the form of stored application passwords for user-managed applications. It says nothing about passwords for applications outside Okta, or about users’ Okta passwords themselves, which are governed by password policies. Treat it as one useful lens, not a complete picture of password hygiene across the company.

Everyday Analogy

Imagine a building manager who inspects all the keys in a locked cabinet without looking at the key shapes: they only note how many are copies of each other and which ones are cut too simply. They can say, “These twelve keys are all the same,” without being able to copy any of them. The report gives the same kind of privacy-preserving warning.

i
Good to Know

Availability, wording, and coverage of password health reporting depend on your Okta plan and release, and on how your applications are connected. Confirm what your org offers.

11Application Usage and Assignment Reports

Who has access, and who actually uses it. The foundation of access reviews and cost control.

Two questions come up in nearly every access conversation. The first is about assignments: who is currently allowed to open an application. The second is about usage: who actually does. The gap between those two numbers is where money is wasted and risk accumulates.

Assignment reports

Assignment reports list the current relationship between users and applications. You can usually view them by application, to see who has access to it, or by user, to see everything a person can open. They are state reports, so they show the present situation. They are central to least-privilege reviews, where the goal is to make sure each person has only the access they need.

Usage reports

Usage reports show how applications are actually used over a period: how many users launched them, how often, and when they were last used. They are activity reports and depend on the time range you choose. A long range, such as ninety days, is better for finding applications that nobody uses.

flowchart TD
  A["Assignment report: who has access"] --> C["Compare the two lists"]
  B["Usage report: who actually used it"] --> C
  C --> D{"Assigned but not used?"}
  D -->|"Yes"| E["Candidates to remove or review"]
  D -->|"No"| F["Access matches use"]
  C --> G{"Used by someone not assigned?"}
  G -->|"Yes"| H["Investigate: shared accounts, direct sign-in or bypass"]
  G -->|"No"| F
    
Fig 2. Comparing assignments with usage reveals both unused access and unexpected use.

What the comparison tells you

Result

Assigned, never used

Wasted licenses and unnecessary risk. Ask owners whether the access is still needed and remove it if not.

Result

Assigned, rarely used

May be genuine occasional need, such as year-end reporting. Confirm with the manager before removal.

Result

Heavily used by few

May indicate shared accounts or an application that is critical to a small team. Check how access is shared.

Result

Used without assignment

A warning sign. It may reflect a different sign-in path that bypasses Okta, or data you have misread.

Everyday Analogy

A gym keeps a list of members (assignments) and a record of who actually swiped in this year (usage). Comparing them reveals members who never come, which a manager can contact or cancel. It might also reveal someone using the gym who is not on the list, which is a problem worth looking into.

!
Practical Tip

Run assignment and usage reports side by side for your most sensitive applications every quarter, and save both exports with the date. The pair is powerful evidence in an audit.

12Lifecycle and Provisioning Reports

Reports about the comings and goings of accounts and access, the heart of joiner, mover, and leaver control.

Identity teams describe the employee journey as joiner, mover, and leaver. Joiners arrive and need accounts and access. Movers change roles and need access adjusted. Leavers depart and need access removed. Lifecycle reports show what happened to accounts and access as these changes occurred, which lets you check that the process works.

What lifecycle reports help you check

1

Joiners received access promptly

New accounts were created and assigned the right applications within the expected time.

2

Movers lost old access

When someone changed roles, access tied to the old role was removed, preventing the slow build-up of unneeded permissions.

3

Leavers were fully deprovisioned

Departing users were deactivated, and their application access was removed, in the expected time.

4

Provisioning to applications succeeded

Where Okta creates or updates accounts in other applications, failures and errors were noticed and fixed.

5

No orphans remain

No accounts exist with no owner or no matching active person in the source of truth.

Common leaver traps

Trap

Deactivated in Okta, still active in the app

With applications that keep their own accounts, deactivation in Okta may not remove the application account. Check each application’s own state.

Trap

Slow deprovisioning

The delay between a departure and removal of access can span days if the process depends on manual steps.

Trap

Failed provisioning actions

An error while removing access can leave an account active, and nobody notices without a report of failures.

Trap

Contractors and temporary staff

People without a regular HR record are often missed in standard leaver processes.

Everyday Analogy

When an employee leaves an office, a good facilities team collects the badge, the keys, the laptop, and the parking pass, and then walks around to confirm that nothing was missed. Lifecycle reports are the walk-around: a check that every item was actually returned.

!
Watch Out

Okta reports show what Okta knows. They cannot show accounts that exist only inside an application and were never connected to Okta. Combine reports with periodic checks of applications themselves.

13Security and Threat Reports

Reports that highlight activity which may indicate an attack or misuse.

Not all activity is equal. Some patterns suggest that someone is probing, guessing, or abusing an account. Security-oriented reports gather these signals into views that make them easier to spot. They may include repeated failures, sign-ins from unusual places, blocked suspicious requests, and findings from Okta’s threat detection features, depending on your plan.

Signals these reports surface

Signal

Bursts of failed sign-ins

Many failures in a short time, especially across many accounts, suggest password spraying or credential stuffing.

Signal

Unusual locations or networks

Sign-ins from places the user has never been, or from anonymizing services, deserve a closer look.

Signal

Suspicious activity reported by users

Where users can report “this was not me,” those reports form a valuable early warning.

Signal

Threat detection findings

Requests blocked or flagged by network-level threat intelligence, where your plan includes it.

Signal

Administrative changes

Changes to policies, administrator roles, or authenticator settings, particularly outside normal change windows.

Signal

Account lockouts

Patterns of lockouts can reveal both attacks and broken integrations that keep sending a wrong password.

From signal to response

What you seeLikely meaningFirst steps
Failures spread across many users from few addressesPassword sprayingCheck threat protections, review lockout and network rules, notify security
Failures for one user from many addressesTargeted guessingContact the user, reset credentials, check for successful sign-ins
Successful sign-in right after many failuresPossible compromiseEnd sessions, reset credentials, review the account’s recent activity
Sign-ins from impossible locationsPossible stolen session or credentialsClear sessions, force re-authentication, investigate
Repeated failures from one internal systemBroken integration with an outdated passwordFind the integration and update its credentials
Everyday Analogy

A night security guard walks a route and looks for patterns: a door tried three times, a car circling the car park, a light on in an empty office. No single sign proves a crime, but a few together tell a story. Security reports collect the signs so a human can see the story.

!
Practical Tip

Reports show what already happened. For fast response, pair them with real-time alerts, so serious events reach a person within minutes instead of at the next weekly review.

14Running a Report Step by Step

What actually happens when an administrator opens a report, in plain language.

sequenceDiagram
  participant A as Administrator
  participant C as Admin Console
  participant R as Reports Engine
  participant D as Data Sources
  A->>C: Open Reports and choose a report
  C->>C: Check the administrator role and permissions
  A->>C: Pick filters and a time range
  C->>R: Request the report
  R->>D: Query logs and directory data
  D-->>R: Return matching records
  R-->>C: Build the results
  C-->>A: Show the report and offer an export
    
Fig 3. A simplified view of what happens when an administrator runs a report.

Step by step

1

Sign in as an administrator

Open the Admin Console with an account whose role allows viewing reports. Okta checks permissions before showing the Reports area.

2

Choose the report

Select the report that matches your question. Read its short description to confirm what it measures.

3

Set the time range and filters

Pick the period and narrow by user, application, group, or outcome where available. Start narrow and widen if needed.

4

Run and wait

Okta queries its data and builds the result. Larger ranges and broader filters take longer.

5

Read the results carefully

Check the headings, counts, and totals. Look for unexpected gaps, such as empty periods or missing applications.

6

Export if needed

Save the results as a file for analysis, sharing, or evidence. Name the file clearly and include the date.

7

Record what you found and did

Write down the question, the report, the settings, the finding, and the action taken, linking the export to a ticket.

Small habits that prevent big mistakes

Habit

Write the question first

Before opening any report, write one sentence describing what you want to know. It keeps you from wandering.

Habit

Note the settings

Record the time range and filters used. A report without its settings cannot be repeated or trusted later.

Habit

Sanity check with a known case

Look for something you know happened, such as your own sign-in, to confirm the report sees what it should.

Habit

Date every export

Include the date and the scope in the file name, so old and new versions are not confused.

Everyday Analogy

Running a report is like ordering from a library’s archive. You fill out a request that says what you want and from which years, a librarian checks that you may see it, fetches the records, and hands you a folder. A vague request produces a thick, confusing folder, and a precise one produces just what you need.

!
Verify Before You Rely

The layout of the Reports area, available filters, limits on report size, and export options differ between releases. Learn your own console’s behavior, including how it handles very large ranges.

15Filters, Time Ranges and Retention

Three settings decide whether a report tells the truth or tells a convenient half-truth.

Time ranges

Almost every activity report depends on the period you choose. A short range answers “what just happened.” A long range answers “what is the pattern.” Choose the range to fit the question, and be consistent when comparing. Comparing a thirty-day report with a seven-day report is a classic mistake that produces false conclusions.

QuestionSuggested rangeWhy
Did last night’s incident affect users?The past day or twoFocuses on the event and avoids noise
How is the new policy working?One to two weeks after the change, compared with the same length beforeGives a fair before-and-after comparison
Which applications are unused?Ninety days or the longest available rangeShort ranges miss seasonal or occasional use
What is our multi-factor coverage?Current state, plus the recent periodShows both enrollment and actual use
Audit evidence for a quarterThe full audit period, exported in parts if neededMatches what the auditor will ask

Filters

Filters narrow a report to what matters. You might filter by one application, a group of users, a particular outcome such as failure, or a single person. Filters make reports faster and results easier to read. They also carry a trap: a filter that is too narrow can hide the very thing you are looking for. If a report shows nothing, check whether your filter is the reason before concluding that nothing happened.

Retention

Okta keeps event data for a limited time. The commonly cited period for the System Log is ninety days, though your plan and release may differ. After that, the data is gone from Okta’s view. Reports built on events cannot look further back than the retained data allows. This matters enormously for audits, which often cover a full year, and for incident investigations, which sometimes uncover problems months after they began.

Risk

Audit period longer than retention

If an auditor asks about last year and you only keep ninety days, you cannot answer without your own archive.

Risk

Slow discovery of old incidents

A breach found six months later cannot be investigated from Okta alone if the relevant events have expired.

Fix

Export on a schedule

Save key reports regularly, so you build a dated archive of your own.

Fix

Stream logs to long-term storage

Send events to a platform that keeps them as long as your policy requires.

Everyday Analogy

A shop’s security cameras might overwrite their footage every month. If a theft is discovered after six weeks, the footage is already gone. Shops that care about such cases copy footage to long-term storage. Identity teams face the same choice for their logs.

i
Good to Know

Retention periods and report limits depend on your plan and can change. Check the current figures for your org, and write them into your audit and incident procedures.

16Exporting and Sharing Reports Safely

The moment a report leaves Okta, it leaves Okta’s protections. From then on, handling is your job.

Exports are valuable. They allow analysis in spreadsheets, sharing with auditors and managers, and long-term evidence. But an export of identity data is a list of real people: names, email addresses, applications, sign-in times, and sometimes network locations. This is personal information, and in some reports it may reveal which sensitive systems a person uses. A careless export can become a privacy incident.

The life of an exported file

1

Created

An administrator exports a report. The file lands in a downloads folder on a laptop.

2

Used

It is opened in a spreadsheet, filtered, and perhaps copied into other documents.

3

Shared

It is attached to an email or placed in a shared folder for managers or auditors.

4

Stored

It remains in inboxes, backups, and folders, often long after its purpose has passed.

5

Forgotten

Nobody remembers it exists until it appears in a breach or an audit finding.

Rules for handling exports

Rule

Export the minimum

Use filters and column choices to include only what the purpose needs. Less data means less risk.

Rule

Store in controlled places

Save exports in a restricted folder or evidence repository, not in personal downloads or open shared drives.

Rule

Share through secure channels

Use access-controlled sharing with expiry, instead of attaching files to email.

Rule

Set a retention period

Decide how long each export is kept and delete it afterward, unless it is required evidence.

Rule

Protect spreadsheet content

Be careful with files from untrusted sources and with formulas, and keep the file’s origin clear.

Rule

Log who exported what

Keep a record of exports of sensitive reports, with the purpose and the owner.

Everyday Analogy

Photocopying a confidential staff list for a meeting makes a second, uncontrolled copy of it. If the copy is left on a printer, in a bin, or in a bag, the original’s careful protection no longer matters. Exports are photocopies of Okta data and deserve the same discipline.

!
Never Do This

Do not leave exports in public or broadly shared folders, send them through personal email accounts, or keep them indefinitely “just in case.” Old exports are a quiet source of data leaks.

17Who Can See Reports: Roles and Permissions

Reports reveal who does what across the organization. Limit who may view them, and what they may do.

Reports contain sensitive information. A person who can see which applications every employee uses, and when, could misuse that knowledge. Okta controls access through administrator roles. Some roles can change settings. Others can only look. A dedicated reporting role exists so that people who need insight, such as auditors and analysts, do not need broad power to change the system.

Kind of roleWhat it generally allowsTypical holder
Super administratorFull control, including all reportsA very small number of trusted administrators
Read-only administratorView most settings and data, no changesAuditors, security analysts
Report administratorView reports without general change rightsAnalysts and managers who need insight only
Help desk or limited rolesPerform specific tasks for specific users, often without report accessSupport staff
Custom roles, where availableTailored combinations of permissions over chosen resourcesTeams with specific duties

Principles for assigning access

1

Least privilege

Give each person the narrowest role that lets them do their job. A report viewer does not need power to change policies.

2

Separate duties

People who change settings should not be the only ones who review reports about those changes.

3

Strong sign-in for report viewers

Require phishing-resistant authentication for administrators, since the reports expose sensitive information.

4

Review role assignments regularly

Check every quarter who holds which administrative role, and remove those who no longer need it.

5

Use temporary access for one-off needs

An auditor who needs access for two weeks should have it for two weeks, not forever.

Everyday Analogy

In a hospital, the records office staff may read charts but cannot prescribe drugs, and a pharmacist may dispense drugs but cannot alter diagnoses. Narrow roles protect patients from mistakes and misuse. Narrow report roles protect your employees’ data in the same way.

!
Practical Tip

Treat the list of who can run reports as a report in its own right. Review it every quarter and keep the dated review as evidence.

18Data Flow and Lifecycle of a Report Request

Follow a single request from idea to evidence, and see what data moves where.

1

Need arises

A manager, auditor, or analyst needs an answer. A ticket or request records who asked and why.

2

Report selected and configured

An authorized administrator chooses the report, time range, and filters, and notes them in the ticket.

3

Data queried

The reports engine reads recorded events or current state and builds the result.

4

Result reviewed

The administrator checks the output for sense, completeness, and surprises.

5

Export stored and shared

The file is saved in a controlled location and shared with the requester using a secure method.

6

Action taken

Findings lead to tickets, access removals, policy changes, or no action with a documented reason.

7

Retention and disposal

The export is kept for its required period and then deleted, with the ticket as the permanent record.

What data moves where

DataWhere it livesSensitivity
Raw eventsOkta System Log, for its retention periodHigh, detailed activity of real people
Current assignments and profilesUniversal DirectoryHigh, reveals who can access what
Report results on screenThe administrator’s browser sessionHigh, viewable by whoever sees the screen
Exported filesLaptops, shared folders, email, evidence repositoriesHigh, now outside Okta’s controls
Ticket and notesTicketing systemModerate, but essential as the record of why and what
Long-term archiveLog platform or storage you controlHigh, needs encryption and access control

Notice that the sensitive data exists in six different places by the end. Each copy multiplies the number of places to protect, which is why the earlier chapter urged exporting the minimum and deleting what you no longer need.

Everyday Analogy

Imagine an invoice moving through a company. It starts in a filing cabinet, is photocopied for accounting, scanned for archives, emailed to a manager, and printed again. Soon five copies exist, and nobody knows where they all are. A tidy company limits copies and tracks them. A tidy identity team does the same with report exports.

19From Reports to Action: The Review Loop

A report that changes nothing is a waste of time. Build a loop that turns findings into fixes.

flowchart TD
  Q["Ask a clear question"] --> R["Choose the right report and time range"]
  R --> F["Review findings and spot anomalies"]
  F --> D{"Is action needed?"}
  D -->|"Yes"| A["Create a ticket and fix the issue"]
  D -->|"No"| N["Record the result as evidence"]
  A --> V["Run the report again to verify the fix"]
  V --> N
    
Fig 4. The review loop: ask, run, review, act, verify, record.

The six steps

Step 1

Ask

State the question in a sentence. “Which sensitive apps have assigned users who have not signed in for ninety days?”

Step 2

Run

Choose the report, range, and filters that match the question, and note them.

Step 3

Review

Read for patterns and surprises, comparing with a baseline or earlier run.

Step 4

Act

Raise tickets, remove unneeded access, adjust policies, or contact users, depending on the finding.

Step 5

Verify

Run the report again after the fix to confirm that the problem is gone.

Step 6

Record

Save the dated exports and a short note as evidence, and schedule the next run.

Making the loop a habit

The best reporting programs are boring. They run on a calendar. Weekly, someone glances at sign-in and failure trends. Monthly, someone reviews multi-factor coverage and lifecycle checks. Quarterly, someone compares assignments with usage for sensitive applications and reviews administrator roles. Annually, someone gathers the evidence pack for the audit. Each task is small, and together they keep the organization honest.

RhythmTypical reviewOwner
WeeklySign-in volumes, failures, suspicious activity, administrator activityIdentity or security operations
MonthlyMulti-factor coverage, lifecycle completeness, password health findingsIdentity team lead
QuarterlyAssignments versus usage for sensitive apps, role assignments, unused appsApplication owners and security
AnnuallyEvidence pack for audits, review of the reporting program itselfSecurity and compliance
Everyday Analogy

A car owner who checks the oil monthly, rotates the tires seasonally, and services the engine yearly rarely faces a breakdown. The checks are cheap, boring, and regular. Reports on a calendar do the same for an identity system.

20Building an Audit Evidence Pack

Auditors do not want promises. They want dated proof. Reports are the raw material of that proof.

Security and compliance frameworks, such as SOC 2 and ISO 27001, along with financial control regimes, commonly expect organizations to show that access is granted appropriately, reviewed regularly, and removed promptly, and that strong authentication is in use. Each framework phrases its requirements differently, but the evidence looks similar: dated records that show a control worked during the audit period.

What an evidence pack usually contains

Evidence

Multi-factor coverage

A dated report or calculation showing how many users are enrolled, and a policy showing where it is required.

Evidence

Access reviews

Assignment reports for sensitive applications, with notes showing who reviewed them and what was changed.

Evidence

Leaver processing

Samples of departures with the dates of deactivation and removal of access, matched to HR records.

Evidence

Administrator roles

A dated list of who holds privileged roles, and the review of whether each is still justified.

Evidence

Monitoring activity

Records showing that sign-in and security reports are reviewed on schedule, with follow-up tickets.

Evidence

Policy configuration

Screenshots or exports of authentication and session policies as they stood during the period.

How to build it without panic

1

Map controls to reports

List each control the auditor will test and name the report that proves it.

2

Collect on the calendar

Run and save the reports every month or quarter, not in the week before the audit.

3

Keep a consistent structure

Use the same folder layout, file names, and notes each time, so evidence is easy to find.

4

Link actions to findings

For each finding, link the ticket that shows what was done, and the follow-up report that shows it was fixed.

5

Protect the evidence

Store it in a restricted repository with access logging and a defined retention period.

Everyday Analogy

A restaurant passes health inspections not because the kitchen is clean on inspection day, but because it keeps temperature logs, cleaning checklists, and training records throughout the year. An evidence pack is the identity team’s set of such logs, built steadily, not scrambled at the last minute.

!
Practical Tip

Ask your auditor early for their list of requested evidence. Match it to your reports, and fix any gaps while there is still time to collect fresh data.

21Access Reviews with Reports

Using reports to keep access lean: removing what is no longer needed before it becomes a risk.

Access tends to grow quietly. People change teams and keep old permissions. Projects end and the applications remain assigned. Temporary access becomes permanent because nobody remembers to remove it. Security teams call this access creep. The cure is a regular access review, in which someone examines who has access to what and confirms that each assignment is still justified.

A simple review process using reports

1

Choose the scope

Start with the most sensitive applications, such as finance, source code, customer data, and administrative tools.

2

Pull the assignment list

Run the assignment report for each application and export it with a date.

3

Add usage information

Run the usage report over ninety days and mark the assigned users who have not used the application.

4

Send to the reviewers

Ask application owners or managers to confirm each person’s access, with a clear deadline.

5

Remove what is not confirmed

Unassign users whose access is not justified, preferably by changing group membership.

6

Verify and record

Run the report again to confirm the changes, and save the dated before-and-after exports.

Signals that deserve extra attention

Signal

Dormant accounts

Users with access who have not signed in for a long time. Common candidates for removal.

Signal

Direct individual assignments

Assignments made one by one, outside group rules. They are easy to forget and hard to audit.

Signal

People in many groups

Users who belong to an unusually large number of groups may have accumulated access across roles.

Signal

Privileged roles and shared accounts

Anything that confers broad power or is used by many people deserves a more frequent review.

Signal

Contractors and temporary workers

People with access tied to a project end date should lose it on time.

Signal

Role changes

Movers whose old team access remains alongside new team access.

Everyday Analogy

Think of the keys held by staff in an office. Over the years, people collect keys to rooms they no longer use: the old storeroom, the previous department’s cabinet. A yearly key audit, where each person lists the keys they hold and returns the ones they do not need, keeps the number of copies small. Access reviews are the identity world’s key audit.

!
Practical Tip

Make removal the default if nobody confirms access by the deadline. A review where silence means “keep” produces a long list of approvals nobody really checked.

i
Good to Know

Some Okta plans include governance features with structured access certification campaigns that automate much of this process. Where available, they can replace manual spreadsheet reviews. Confirm what your plan includes.

22Beyond Built-In Reports: APIs, Workflows and Log Streaming

Built-in reports cover common needs. When yours are not common, other tools take over.

Built-in reports have natural limits. They have fixed shapes, so you cannot easily add a column you invented. They are mostly run on demand, so scheduling takes extra effort. Their retention follows Okta’s rules, not yours. When you hit those limits, Okta offers several ways to go further.

flowchart LR
  OKTA["Okta Org"] --> BUILTIN["Built-in Reports for quick answers"]
  OKTA --> LOGAPI["System Log API for custom queries"]
  OKTA --> STREAM["Log Streaming to long term storage"]
  OKTA --> WF["Okta Workflows for scheduled summaries"]
  STREAM --> SIEM["SIEM and Dashboards"]
  LOGAPI --> WH["Data Warehouse"]
  WF --> MAIL["Email or Chat Summaries"]
    
Fig 5. Built-in reports answer common questions. Other tools extend them for custom, scheduled, and long-term needs.

Choosing the next tool

NeedToolHow it helpsCost of using it
Custom filters and columnsSystem Log APIPrograms can query events and shape the output however they likeNeeds development and care with rate limits
Reports on a scheduleOkta Workflows or your own schedulerRuns queries regularly and sends summaries by email, chat, or a ticketNeeds flow design and monitoring
Keep data longer than Okta doesLog streaming to storage or a SIEMDelivers events continuously to a platform you controlStorage cost and platform setup
Correlate with other systemsSIEM or data warehouseCombines Okta events with network, endpoint, and application logsPlatform expertise and licensing
Alerts in near real timeEvent hooks, workflows, or SIEM rulesSends an alert within moments of a matching eventAlert tuning to avoid noise
Formal access certificationsGovernance features, where includedAutomates review campaigns with approvals and recordsPlan and licensing

When to graduate from built-in reports

Sign

You export the same report weekly

Repetition is a sign that automation will pay off.

Sign

Audits need a year of data

You cannot rely on short retention. Stream or archive.

Sign

You need to join data

If answers need HR data or other system data, a warehouse or SIEM is the right place.

Sign

You need alerts, not reports

Reports are looked at later. Alerts reach people now.

Everyday Analogy

A home cook starts with ready-made recipes from a cookbook, which are quick and reliable. As tastes and guest lists grow, the cook starts adapting recipes, then writing their own, and finally hires a catering team for large events. Built-in reports are the cookbook, and APIs, workflows, and streaming are the later stages.

!
Verify Before You Rely

API limits, supported streaming destinations, Workflows capabilities, and governance features depend on your plan and release. Check current documentation and licensing before designing around any of them.

23Security Considerations

Reports reveal who does what and who can reach which systems. That knowledge is valuable to attackers, too.

It is easy to see reports as harmless summaries. In truth, they are a map of your organization’s access and behavior. An attacker who obtains reports can learn which applications matter, who holds powerful roles, when people usually sign in, and where controls are weak. Protecting reports and the paths to them is part of protecting the organization.

ThreatHow it happensDefense
Compromised administrator accountAn attacker signs in as someone with report accessPhishing-resistant authentication, short sessions, device checks for administrators
Leaked export filesFiles are emailed, left in shared folders, or stored on lost laptopsMinimum exports, secure storage, expiry, deletion, encryption
Over-broad report accessToo many people hold roles that can view reportsLeast privilege, regular role reviews, temporary access
Insider curiosity or abuseA person looks up colleagues’ activity without needNarrow roles, logging of who viewed or exported what, clear policy
Reconnaissance for attacksStolen reports guide an attacker to high-value targetsProtect exports like credentials, and monitor administrator access
Tampering with evidenceSomeone edits exported spreadsheets before they reach auditorsStore originals in controlled repositories, record hashes or access logs, keep exports read-only
Privacy violationsReports are shared more widely than their purpose justifiesPurpose limitation, data minimization, retention rules

Privacy matters too

Reports describe the behavior of real employees. Depending on where you operate, privacy laws and agreements may limit how that data may be collected, used, and retained. Be clear about the purpose of each report, share only with those who need it, and keep it no longer than necessary. A policy that says what reports are used for, and what they are never used for, protects both staff and the organization.

Defense in layers

Protect the accounts that can see reports, with strong authentication. Limit who can export. Store exports in controlled places. Log access. Review roles regularly. And educate staff about the sensitivity of the data. Each layer reduces the chance that a report becomes the first step of an attack or a privacy incident.

Everyday Analogy

A company’s floor plan marked with the location of the safe, the guard schedule, and the camera blind spots is more dangerous in the wrong hands than a lock-pick. Reports are the identity version of that plan, and should be locked in the same drawer.

24Monitoring the Reporting Program Itself

Reports watch the identity system. Someone must also watch the reports: who runs them, what they find, and whether anything changes.

A reporting program can fail quietly. Reviews stop happening. Exports pile up unread. Findings are noted and never fixed. The program needs its own measures, so that its health can be seen at a glance.

Metrics for the program

On time
Share of scheduled reviews completed by their due date
Fixed
Share of findings closed within the agreed time
Fresh
Age of the newest evidence for each control
Coverage

Multi-factor enrollment

Percentage of users enrolled, and of sign-ins that use a second factor. Trend it over time.

Hygiene

Unused assignments

Number of assigned users who have not used each sensitive application in ninety days.

Lifecycle

Time to deprovision

Hours or days between a departure and complete removal of access.

Privilege

Number of privileged administrators

Count and review of people with powerful roles. Fewer is better.

Exposure

Risky passwords

Number of weak or reused application passwords in user-managed applications.

Process

Open findings

Number and age of unresolved findings from reports.

Watching who uses reports

Okta’s System Log records administrative activity, which may include who accessed reports and exports, depending on the event types in your release. Search the log for such activity and decide which events deserve alerts. A sudden series of large exports by an administrator who rarely does that is worth a conversation. So is an administrator accessing reports outside normal working hours from an unfamiliar location.

1

Define the review calendar

List each recurring review, its owner, and its due dates.

2

Track completion

Use a checklist or ticket for each review, closed only when evidence is saved.

3

Report to leadership

Share a short, regular summary of the metrics above, with trends and open risks.

4

Improve the program

Each quarter, retire reports nobody uses and add reports for new questions.

Everyday Analogy

A fire alarm system needs its own testing: someone must check the batteries and run a monthly test. An unattended alarm that has silently failed is worse than none, because it gives false comfort. Reports are your alarm system, and the review calendar is the monthly test.

!
Practical Tip

Keep the program small and real. Five reports reviewed on time beat thirty reports nobody opens.

25Design Patterns That Work

Reliable shapes that many successful reporting programs share.

Pattern: Question-first reporting

Begin every review with a written question and a named owner. The report is chosen to answer the question, not the other way around.

Pattern: A fixed review calendar

Weekly, monthly, quarterly, and annual reviews, each with an owner and a checklist. Regularity beats heroics.

Pattern: Paired state and activity reports

Run an assignment report and a usage report together, so you see both who has access and who actually uses it.

Pattern: Dated evidence repository

Save every important export in a restricted, consistently organized location with a date, a purpose, and a link to the ticket.

Pattern: Stream for the long term, report for the short term

Use built-in reports for quick answers and stream logs to long-term storage for audits and investigations beyond Okta’s retention.

Pattern: Reports feed tickets, not inboxes

Each finding becomes a ticket with an owner and a due date, so nothing depends on someone remembering an email.

Pattern: Narrow roles and reviewed access

Give report access through narrow roles, review who holds them every quarter, and use temporary access for auditors.

How the patterns fit together

Question-first reporting keeps effort focused. The calendar keeps it regular. Paired reports give a complete picture. The evidence repository turns routine work into audit readiness. Streaming extends reach beyond built-in limits. Tickets turn findings into fixes. Narrow roles protect the data that makes all of this possible. Together they make reporting a habit rather than a fire drill.

Everyday Analogy

A well-run household keeps a calendar for bills, files each receipt in a labeled folder, checks bank statements monthly, and pays attention to anything odd. No single task is hard, but together they prevent nasty surprises at tax time. A good reporting program feels the same.

26Anti-Patterns to Avoid

Mistakes seen again and again, so you can skip them.

ANTI-PATTERN 01Avoid
What It Looks Like

Running reports only in the week before an audit.

Why It Hurts

Evidence is hurried, incomplete, and limited by retention. Problems found at that point cannot be fixed in time and are written up as findings.

Do This Instead

Run reports on a calendar and keep dated evidence all year.

ANTI-PATTERN 02Avoid
What It Looks Like

Exporting reports to personal downloads folders and emailing them around.

Why It Hurts

Sensitive data spreads into uncontrolled places, and old copies linger for years.

Do This Instead

Export the minimum, store it in a controlled repository, share through secure links, and delete on schedule.

ANTI-PATTERN 03Avoid
What It Looks Like

Giving super administrator access to everyone who wants to see reports.

Why It Hurts

People who only need to look are given the power to change security settings, which enlarges the attack surface and the risk of mistakes.

Do This Instead

Use report-only or read-only roles, and review role holders quarterly.

ANTI-PATTERN 04Avoid
What It Looks Like

Reading a report’s number without checking its definition, period, or filters.

Why It Hurts

Conclusions are drawn from misread data. Teams chase false alarms or miss real problems.

Do This Instead

Read the report description, record the settings, and compare against a baseline.

ANTI-PATTERN 05Avoid
What It Looks Like

Findings are noted in an email thread and never turned into tickets.

Why It Hurts

Nobody owns the fix, nothing is tracked, and the same finding appears again in the next review.

Do This Instead

Open a ticket for each finding, assign an owner and due date, and verify with a follow-up report.

ANTI-PATTERN 06Avoid
What It Looks Like

Relying on Okta’s built-in retention for annual audits and long investigations.

Why It Hurts

Older events are gone when the question arrives, so you cannot prove or investigate what happened.

Do This Instead

Archive key reports regularly, and stream logs to storage you control for the full period your policies require.

27Advantages, Disadvantages and Trade-offs

Every visibility tool buys something and costs something. Here is the honest ledger for built-in Okta reports.

Advantages

  • Quick answers to common questions without writing searches
  • Approachable for managers, auditors, and analysts, not only experts
  • Built into the Admin Console, so no extra platform is needed
  • Exports support spreadsheets, reviews, and evidence
  • Cover state and activity, helping with both exposure and behavior
  • Role-based access keeps viewing separate from changing
  • A natural starting point for audit readiness

Disadvantages

  • Fixed shapes with limited customization
  • Retention limits restrict how far back you can look
  • Mostly on demand, so scheduling needs other tools
  • Exports leave Okta’s protections and become your responsibility
  • Names, groupings, and availability change between releases and plans
  • Cannot join Okta data with HR or other systems
  • Show what happened but do not alert in real time

Trade-offs to think through

Convenience versus flexibility. Built-in reports are quick but fixed. APIs and streaming are flexible but need engineering time. Start with the built-in reports and graduate when they stop fitting.

Detail versus privacy. More detail helps investigations but exposes more about people. Export only what the purpose needs.

Frequency versus effort. Weekly reviews catch problems sooner but cost more attention. Match frequency to the risk of what is being reviewed.

Reports versus alerts. Reports suit review and evidence. Alerts suit urgent events. A healthy program uses both, with each for its proper job.

Manual versus automated. Manual review is simple to start and error-prone at scale. Automation takes effort to build and pays back over time.

!
Rule of Thumb

Use built-in reports for questions you ask occasionally, and build automation for questions you ask every week.

28Best Practices and Common Mistakes

A checklist to read before every review and every audit.

Best practices

  • Start with a question. Write it down before you open any report.
  • Match the report family to the question, and use the System Log for individual investigations.
  • Record the settings. Always note the report name, time range, and filters.
  • Compare with baselines and similar earlier periods, not only with zero.
  • Pair assignment and usage reports for sensitive applications.
  • Run reports on a calendar and keep dated evidence all year.
  • Export the minimum, store exports in controlled places, and delete them on schedule.
  • Use narrow roles for report viewers, with strong authentication, and review role holders regularly.
  • Turn findings into tickets with owners and due dates, and verify fixes with follow-up reports.
  • Archive beyond retention through scheduled exports or log streaming.
  • Pair reports with real-time alerts for urgent security events.
  • Review the program itself each quarter, and retire reports nobody uses.
  • Verify current behavior in your own console, since names and options change.

Common mistakes

Mistake 01

Misreading definitions

Treating “sign-ins” and “unique users” as the same measure, and drawing wrong conclusions.

Mistake 02

Mismatched time ranges

Comparing a thirty-day report with a seven-day report and calling the difference a trend.

Mistake 03

Over-narrow filters

Concluding that nothing happened when the filter hid it.

Mistake 04

Forgetting retention

Promising auditors a year of data when only ninety days exist.

Mistake 05

Exports everywhere

Files scattered across laptops, inboxes, and shared folders with no owner or expiry.

Mistake 06

Too many report viewers

Broad administrator roles handed out for the sake of convenience.

Mistake 07

Findings with no follow-up

The same issues return in every review because nobody owns the fix.

Mistake 08

Assuming reports see everything

Believing Okta reports cover applications and accounts that exist only outside Okta.

29Real-World Usage Scenarios

Six stories showing reports at work. These are illustrative teaching designs, not descriptions of any named company’s real setup.

Scenario 1: The unused finance licenses

Imagine a company paying for four hundred seats of a finance application. A quarterly assignment and usage review shows that about one hundred and thirty assigned users have not opened it in ninety days. The application owner confirms that most no longer need it. Removing them saves a significant license cost and shrinks the group of people who could be targeted for access to financial data.

Scenario 2: The MFA coverage question

An external auditor asks what share of staff use multi-factor authentication. The identity team runs the usage report, calculates that ninety-four percent of active users are enrolled, and shows the policy that requires it. They also list the remaining six percent by group, which are mostly contractors and service accounts, along with the plan to close the gap. The audit item is closed the same afternoon.

Scenario 3: The Sunday-night spike

During a weekly review, an analyst notices that failed sign-ins jumped several-fold on Sunday night, spread across many accounts from a small number of addresses. They move to the System Log and confirm a password-spraying attempt. Because nothing succeeded, no accounts are compromised. The team tightens network-based protections and sends a note reminding staff to report any unexpected prompts.

Scenario 4: The leaver who lingered

A lifecycle review compares the HR departures list with Okta deactivation dates and finds that contractors are deactivated on average two weeks after their contracts end, because they are not in the HR feed. The team creates an end-date field for contractors and adds a monthly report of expired contractors. The lag drops from weeks to a day.

Scenario 5: The weak legacy passwords

A password health review shows many weak and reused passwords across a handful of legacy applications that users manage themselves. The team moves two of the applications to federation, switches three to administrator-set random passwords, and sends targeted guidance to remaining users. At the next quarterly review, the number of risky passwords has fallen sharply.

Scenario 6: The year-old question

Months after an incident at another company in the same industry, a board member asks whether the organization saw similar activity last spring. Okta’s built-in data only goes back a few months, but because the team has been streaming logs to long-term storage, they can answer with a month-by-month summary. Organizations without that archive could only reply that the data no longer existed.

Everyday Analogy

Each story is the same lesson in different clothes. A shopkeeper who keeps neat ledgers can answer a tax inspector, spot a thief, and notice slow-moving stock, all from the same books. Good reports give an identity team those abilities.

30Troubleshooting Common Problems

Most report trouble falls into a few families. A calm checklist solves most of it.

SymptomLikely causeWhat to check
I cannot see the Reports areaYour administrator role does not include report accessAsk an administrator to review your role, and request the narrowest role that fits
The report is emptyFilter too narrow, wrong time range, or no matching activityWiden the filters and the range, and check that the activity actually occurred
An event I know happened is missingThe event is outside retention, or it has not yet appearedWait a short time, check the range, and search the System Log directly
Numbers differ between two reportsDifferent definitions, time zones, or scopeRead each report’s description and align the settings before comparing
The report is slow or times outThe range or scope is too largeNarrow the range, split into smaller periods, or use the API for large pulls
Export is missing columns I needThe report has a fixed layoutUse the System Log API or a custom query for the extra data
The file opens oddly in a spreadsheetEncoding or formatting issues with exported textImport the file with explicit settings, and treat files from any source with care
A report I used has changed or disappearedOkta reorganized or renamed it in a releaseCheck current documentation, and update your process notes

A simple troubleshooting routine

1

Restate the question

Confirm exactly what you want to know. Many problems vanish when the question is clearer.

2

Check the basics

Confirm your role, the report chosen, the time range, and the filters.

3

Test with a known event

Create or find an event you know about and look for it, to see whether the report can see it.

4

Cross-check in the System Log

Search the log for the same period and event types, and compare with the report.

5

Escalate or build your own

If the built-in report cannot answer the question, use the API, workflows, or streaming, and record why.

Everyday Analogy

When a bank statement seems wrong, a careful customer checks the date range, the account, and whether the transaction has cleared, and then compares with receipts. Only after that do they call the bank. Report troubleshooting follows the same order of cheap checks before expensive ones.

31Frequently Asked Questions

Short answers to the questions that come up most often.

Q1What are Okta reports?
Prepared views in the Admin Console that answer common questions about sign-in activity, multi-factor usage, password health, application usage and assignments, lifecycle activity, and security signals. Many can be exported.
Q2How are reports different from the System Log?
The System Log holds the raw, detailed events and is best for investigation. Reports are curated summaries for quick answers and routine review.
Q3How far back can reports look?
Activity reports are limited by Okta’s data retention, which is commonly cited as about ninety days for the System Log. Confirm the current figure for your plan, and archive anything you need for longer.
Q4Who can view reports?
Administrators whose roles allow it, including super administrators, read-only administrators, and a role focused on reports. Use the narrowest role that fits and review it regularly.
Q5Can I schedule reports automatically?
Built-in reports are mostly run on demand. For scheduled output, use the API, Okta Workflows, or log streaming, depending on your plan and needs.
Q6Are exports safe to email?
Not usually. Exports contain personal data and describe access. Share through access-controlled channels, export the minimum, and delete on schedule.
Q7What does the password health report show?
Patterns of weak or reused passwords in user-managed application credentials that Okta stores, without revealing the passwords. It does not cover applications outside Okta.
Q8How do I prove multi-factor coverage to an auditor?
Provide a dated usage or enrollment report, the policy that requires multi-factor authentication, and a list of exceptions with a plan to close them.
Q9Can reports find users with access they do not use?
Yes, by comparing an assignment report with a usage report over a long period, such as ninety days, and reviewing assigned users who have not used the application.
Q10Do reports show accounts that exist only inside applications?
No. Okta reports show what Okta knows. Accounts that were never connected to Okta must be checked in the application itself.
Q11Should I rely on reports for urgent security alerts?
No. Reports are for review. For urgent events, use real-time alerts through event hooks, workflows, or a security monitoring platform.
Q12What if I need a report Okta does not provide?
Use the System Log API or log streaming to build your own, combining Okta data with other sources where needed.
Q13Do report names and menus stay the same?
No. Names, groupings, and availability differ between Okta Identity Engine and Classic Engine, plans, and releases. Check your own console and current documentation.
Q14What is the best first step for a new reporting program?
Pick five questions that matter, match each to a report, set a calendar and an owner for each, and save dated evidence every time.

32Summary and Key Takeaways

If you remember nothing else, remember the box below.

Okta reports turn a flood of identity activity into answers that managers, auditors, and security teams can use. They help you see who signs in, how strongly, who has access to what, whether leavers really left, and whether anything suspicious is happening. But a report is only a starting point. Its value depends on a clear question, careful reading, safe handling of exports, and a habit of turning findings into fixes. Used regularly and protected properly, reports make audits calmer and identity risk smaller. Used carelessly, they become unread files and sensitive leaks.

Key Takeaways

  • Question first. Pick the report to answer a written question, record the report name, range, and filters, and compare against baselines.
  • Know the two kinds. Activity reports show what happened in a period, and state reports show what is true now, so save dated exports to keep history.
  • Pair assignments with usage. Comparing who has access with who actually uses it finds unused access and unexpected use.
  • Respect retention. Built-in data does not go back forever, so archive exports or stream logs for audits and long investigations.
  • Protect the data. Use narrow roles with strong sign-in, export the minimum, store files in controlled places, and delete them on schedule.
  • Close the loop. Turn each finding into a ticket with an owner, verify the fix with a follow-up report, and keep dated evidence all year.
  • Go beyond when needed. Use the System Log, APIs, workflows, and streaming for custom, scheduled, and long-term needs, and verify current names and options in your own console.