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.
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.
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
Who can open this application?
A question about current assignments. It matters for least privilege, licensing costs, and incident response.
Is anyone actually using it?
Unused access is wasted money and unnecessary risk. Usage reports reveal applications and assignments that can be retired.
How many people use multi-factor authentication?
A question about coverage. Auditors, insurers, and boards increasingly ask for the number.
Are passwords weak or reused?
A question about exposure. Weak and reused passwords turn one small breach into many.
Has anything suspicious happened?
A question about attacks in progress, such as repeated failures or sign-ins from unusual places.
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.
| Question | Without reports | With reports |
|---|---|---|
| Who is assigned to the finance app? | Click through the application and count by hand | Run a current-assignments report and export it |
| What is our multi-factor coverage? | Guess, or sample a few users | Run a usage report and calculate the share |
| Which apps are unused? | Ask each application owner | Run an application usage report over a long period |
| Is there a spike in failed sign-ins? | Search raw logs and count | Run a failure report for the period |
| Show the auditor evidence | Assemble screenshots at the last minute | Keep a dated set of exported reports |
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.
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.
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.
Central log collection
Organizations began gathering logs from many systems into one place, which made searching possible across the whole estate.
Prepared reports
Products started offering ready-made summaries for common questions, so non-experts could get answers without writing searches.
Compliance pressure
Regulations and frameworks asked organizations to prove, repeatedly, that access was controlled. Reports became evidence, not just curiosity.
APIs and streaming
Platforms added programmatic access and live streaming of logs to security monitoring tools, enabling custom analysis and long-term storage.
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.
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.
Report
A prepared view of Okta data that answers a common question, such as sign-in activity or current application assignments.
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.
Activity Report
A report about what happened over a period, such as sign-ins, failures, or factor use.
State Report
A report about how things are right now, such as current assignments or current password health.
Time Range
The period a report covers. Choosing it carefully matters, since results depend heavily on it.
Filter
A condition that narrows a report, such as a particular user, application, or outcome.
Export
Saving a report’s results as a file, usually a spreadsheet-friendly format, for sharing, analysis, or evidence.
Report Administrator
An administrator role focused on viewing reports, which allows insight without broad permission to change settings.
Retention
How long data remains available. Reports can only show what is still retained, which limits how far back you can look.
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.
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.
| Tool | What it shows | Best for | Limits |
|---|---|---|---|
| Built-in reports | Curated views of common questions | Quick answers, audits, routine reviews | Fixed shapes, limited customization, limited retention |
| System Log | Every recorded event with rich detail | Investigations, custom searches, root cause | Raw and detailed, needs skill to interpret |
| Admin dashboard | High-level snapshots and trends | A daily glance at health and activity | Not detailed enough for evidence |
| System Log API | The same events, for programs to read | Custom reports, automation, pipelines | Needs development effort and care with rate limits |
| Log streaming | A live feed of events to an outside platform | Long retention, security monitoring, correlation with other systems | Requires a destination platform and its cost |
| Governance reporting | Structured access reviews and certifications, on plans that include them | Periodic review of who should keep access | Depends on plan and setup |
A simple rule of choice
Need a quick, common answer?
Use a built-in report. It is the fastest route and needs no skill with log searches.
Investigating something specific?
Use the System Log, where you can search by user, event type, time, and outcome in full detail.
Need something repeated, custom, or long-term?
Use the API or log streaming to build your own reports and keep data longer.
Need a formal review of access?
Use governance features if your plan includes them, or build a review process using assignment reports.
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.
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.
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.
Multi-factor usage
Which factors are enrolled and used, and how widely multi-factor authentication is adopted across users and groups.
Password health
A look at weak, reused, or otherwise risky passwords in user-managed application credentials, without revealing the passwords themselves.
Application usage and assignments
Which applications are used, by whom, and who is currently assigned to what. Central to access reviews and cost control.
Lifecycle and provisioning
Activity around creating, changing, and removing user accounts and application access, important for joiners, movers, and leavers.
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 |
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.
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"]
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.
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.
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.
| Feature | Activity reports | State reports |
|---|---|---|
| Based on | Recorded events over time | The present condition of the org |
| Question answered | What happened between two dates? | What is true right now? |
| Depends on a time range? | Yes, strongly | Not in the same way |
| Limited by retention? | Yes, you cannot look back past what is kept | No, it reads current data |
| Good for | Trends, investigations, usage patterns | Access reviews, exposure checks, inventory |
| How to preserve history | Export or stream regularly | Export on a schedule and compare snapshots |
Why two reports might not match exactly
Different definitions
One report may count launches and another counts distinct users. The labels differ, and so do the numbers.
Different time windows
Reports may use different time zones or boundaries, so a day’s total can shift slightly.
Timing of data
Recent events may take a short time to appear, so a report run immediately after an event may miss it.
Scope differences
A report may include only some kinds of applications, such as those that use particular sign-on methods.
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.
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
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.
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.
Multi-factor usage
Which factors users enroll and use, and how many sign-ins involved them. The basis for coverage figures that auditors request.
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.
Pick a baseline
Run the report for a calm, typical period and note normal volumes for each day and hour.
Run the period you care about
Choose the window that matches your question, such as the week since a policy change.
Compare
Look at differences from baseline: volume, timing, applications, outcomes, and users.
Drill into anomalies
For any unusual pattern, move to the System Log and investigate individual events.
Record the conclusion
Write a short note: what you saw, what it meant, what you did. Save the export as evidence.
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.
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
Weak passwords
Passwords that are short, simple, or easy to guess. They are the most likely to be broken by attackers.
Reused passwords
The same password used across several applications. A breach in one application then threatens all the others.
Shared across users
Where applicable, the same password appearing for many accounts, which suggests a shared habit or a default value never changed.
Applications at risk
Applications where weak or reused passwords are concentrated, which guides where to act first.
Turning findings into action
| Finding | Possible action |
|---|---|
| Many weak passwords in one application | Move that application to federation, or switch to administrator-set random passwords |
| Passwords reused across applications | Ask users to change them, and consider removing the ability to choose their own credentials |
| A shared default password across accounts | Force a change and block default values at the application where possible |
| Risky passwords on sensitive applications | Prioritize 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.
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.
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
What the comparison tells you
Assigned, never used
Wasted licenses and unnecessary risk. Ask owners whether the access is still needed and remove it if not.
Assigned, rarely used
May be genuine occasional need, such as year-end reporting. Confirm with the manager before removal.
Heavily used by few
May indicate shared accounts or an application that is critical to a small team. Check how access is shared.
Used without assignment
A warning sign. It may reflect a different sign-in path that bypasses Okta, or data you have misread.
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.
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
Joiners received access promptly
New accounts were created and assigned the right applications within the expected time.
Movers lost old access
When someone changed roles, access tied to the old role was removed, preventing the slow build-up of unneeded permissions.
Leavers were fully deprovisioned
Departing users were deactivated, and their application access was removed, in the expected time.
Provisioning to applications succeeded
Where Okta creates or updates accounts in other applications, failures and errors were noticed and fixed.
No orphans remain
No accounts exist with no owner or no matching active person in the source of truth.
Common leaver traps
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.
Slow deprovisioning
The delay between a departure and removal of access can span days if the process depends on manual steps.
Failed provisioning actions
An error while removing access can leave an account active, and nobody notices without a report of failures.
Contractors and temporary staff
People without a regular HR record are often missed in standard leaver processes.
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.
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
Bursts of failed sign-ins
Many failures in a short time, especially across many accounts, suggest password spraying or credential stuffing.
Unusual locations or networks
Sign-ins from places the user has never been, or from anonymizing services, deserve a closer look.
Suspicious activity reported by users
Where users can report “this was not me,” those reports form a valuable early warning.
Threat detection findings
Requests blocked or flagged by network-level threat intelligence, where your plan includes it.
Administrative changes
Changes to policies, administrator roles, or authenticator settings, particularly outside normal change windows.
Account lockouts
Patterns of lockouts can reveal both attacks and broken integrations that keep sending a wrong password.
From signal to response
| What you see | Likely meaning | First steps |
|---|---|---|
| Failures spread across many users from few addresses | Password spraying | Check threat protections, review lockout and network rules, notify security |
| Failures for one user from many addresses | Targeted guessing | Contact the user, reset credentials, check for successful sign-ins |
| Successful sign-in right after many failures | Possible compromise | End sessions, reset credentials, review the account’s recent activity |
| Sign-ins from impossible locations | Possible stolen session or credentials | Clear sessions, force re-authentication, investigate |
| Repeated failures from one internal system | Broken integration with an outdated password | Find the integration and update its credentials |
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.
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
Step by step
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.
Choose the report
Select the report that matches your question. Read its short description to confirm what it measures.
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.
Run and wait
Okta queries its data and builds the result. Larger ranges and broader filters take longer.
Read the results carefully
Check the headings, counts, and totals. Look for unexpected gaps, such as empty periods or missing applications.
Export if needed
Save the results as a file for analysis, sharing, or evidence. Name the file clearly and include the date.
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
Write the question first
Before opening any report, write one sentence describing what you want to know. It keeps you from wandering.
Note the settings
Record the time range and filters used. A report without its settings cannot be repeated or trusted later.
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.
Date every export
Include the date and the scope in the file name, so old and new versions are not confused.
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.
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.
| Question | Suggested range | Why |
|---|---|---|
| Did last night’s incident affect users? | The past day or two | Focuses on the event and avoids noise |
| How is the new policy working? | One to two weeks after the change, compared with the same length before | Gives a fair before-and-after comparison |
| Which applications are unused? | Ninety days or the longest available range | Short ranges miss seasonal or occasional use |
| What is our multi-factor coverage? | Current state, plus the recent period | Shows both enrollment and actual use |
| Audit evidence for a quarter | The full audit period, exported in parts if needed | Matches 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.
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.
Slow discovery of old incidents
A breach found six months later cannot be investigated from Okta alone if the relevant events have expired.
Export on a schedule
Save key reports regularly, so you build a dated archive of your own.
Stream logs to long-term storage
Send events to a platform that keeps them as long as your policy requires.
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.
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
Created
An administrator exports a report. The file lands in a downloads folder on a laptop.
Used
It is opened in a spreadsheet, filtered, and perhaps copied into other documents.
Shared
It is attached to an email or placed in a shared folder for managers or auditors.
Stored
It remains in inboxes, backups, and folders, often long after its purpose has passed.
Forgotten
Nobody remembers it exists until it appears in a breach or an audit finding.
Rules for handling exports
Export the minimum
Use filters and column choices to include only what the purpose needs. Less data means less risk.
Store in controlled places
Save exports in a restricted folder or evidence repository, not in personal downloads or open shared drives.
Share through secure channels
Use access-controlled sharing with expiry, instead of attaching files to email.
Set a retention period
Decide how long each export is kept and delete it afterward, unless it is required evidence.
Protect spreadsheet content
Be careful with files from untrusted sources and with formulas, and keep the file’s origin clear.
Log who exported what
Keep a record of exports of sensitive reports, with the purpose and the owner.
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.
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 role | What it generally allows | Typical holder |
|---|---|---|
| Super administrator | Full control, including all reports | A very small number of trusted administrators |
| Read-only administrator | View most settings and data, no changes | Auditors, security analysts |
| Report administrator | View reports without general change rights | Analysts and managers who need insight only |
| Help desk or limited roles | Perform specific tasks for specific users, often without report access | Support staff |
| Custom roles, where available | Tailored combinations of permissions over chosen resources | Teams with specific duties |
Principles for assigning access
Least privilege
Give each person the narrowest role that lets them do their job. A report viewer does not need power to change policies.
Separate duties
People who change settings should not be the only ones who review reports about those changes.
Strong sign-in for report viewers
Require phishing-resistant authentication for administrators, since the reports expose sensitive information.
Review role assignments regularly
Check every quarter who holds which administrative role, and remove those who no longer need it.
Use temporary access for one-off needs
An auditor who needs access for two weeks should have it for two weeks, not forever.
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.
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.
Need arises
A manager, auditor, or analyst needs an answer. A ticket or request records who asked and why.
Report selected and configured
An authorized administrator chooses the report, time range, and filters, and notes them in the ticket.
Data queried
The reports engine reads recorded events or current state and builds the result.
Result reviewed
The administrator checks the output for sense, completeness, and surprises.
Export stored and shared
The file is saved in a controlled location and shared with the requester using a secure method.
Action taken
Findings lead to tickets, access removals, policy changes, or no action with a documented reason.
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
| Data | Where it lives | Sensitivity |
|---|---|---|
| Raw events | Okta System Log, for its retention period | High, detailed activity of real people |
| Current assignments and profiles | Universal Directory | High, reveals who can access what |
| Report results on screen | The administrator’s browser session | High, viewable by whoever sees the screen |
| Exported files | Laptops, shared folders, email, evidence repositories | High, now outside Okta’s controls |
| Ticket and notes | Ticketing system | Moderate, but essential as the record of why and what |
| Long-term archive | Log platform or storage you control | High, 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.
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
The six steps
Ask
State the question in a sentence. “Which sensitive apps have assigned users who have not signed in for ninety days?”
Run
Choose the report, range, and filters that match the question, and note them.
Review
Read for patterns and surprises, comparing with a baseline or earlier run.
Act
Raise tickets, remove unneeded access, adjust policies, or contact users, depending on the finding.
Verify
Run the report again after the fix to confirm that the problem is gone.
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.
| Rhythm | Typical review | Owner |
|---|---|---|
| Weekly | Sign-in volumes, failures, suspicious activity, administrator activity | Identity or security operations |
| Monthly | Multi-factor coverage, lifecycle completeness, password health findings | Identity team lead |
| Quarterly | Assignments versus usage for sensitive apps, role assignments, unused apps | Application owners and security |
| Annually | Evidence pack for audits, review of the reporting program itself | Security and compliance |
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
Multi-factor coverage
A dated report or calculation showing how many users are enrolled, and a policy showing where it is required.
Access reviews
Assignment reports for sensitive applications, with notes showing who reviewed them and what was changed.
Leaver processing
Samples of departures with the dates of deactivation and removal of access, matched to HR records.
Administrator roles
A dated list of who holds privileged roles, and the review of whether each is still justified.
Monitoring activity
Records showing that sign-in and security reports are reviewed on schedule, with follow-up tickets.
Policy configuration
Screenshots or exports of authentication and session policies as they stood during the period.
How to build it without panic
Map controls to reports
List each control the auditor will test and name the report that proves it.
Collect on the calendar
Run and save the reports every month or quarter, not in the week before the audit.
Keep a consistent structure
Use the same folder layout, file names, and notes each time, so evidence is easy to find.
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.
Protect the evidence
Store it in a restricted repository with access logging and a defined retention period.
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.
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
Choose the scope
Start with the most sensitive applications, such as finance, source code, customer data, and administrative tools.
Pull the assignment list
Run the assignment report for each application and export it with a date.
Add usage information
Run the usage report over ninety days and mark the assigned users who have not used the application.
Send to the reviewers
Ask application owners or managers to confirm each person’s access, with a clear deadline.
Remove what is not confirmed
Unassign users whose access is not justified, preferably by changing group membership.
Verify and record
Run the report again to confirm the changes, and save the dated before-and-after exports.
Signals that deserve extra attention
Dormant accounts
Users with access who have not signed in for a long time. Common candidates for removal.
Direct individual assignments
Assignments made one by one, outside group rules. They are easy to forget and hard to audit.
People in many groups
Users who belong to an unusually large number of groups may have accumulated access across roles.
Privileged roles and shared accounts
Anything that confers broad power or is used by many people deserves a more frequent review.
Contractors and temporary workers
People with access tied to a project end date should lose it on time.
Role changes
Movers whose old team access remains alongside new team access.
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.
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.
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"]
Choosing the next tool
| Need | Tool | How it helps | Cost of using it |
|---|---|---|---|
| Custom filters and columns | System Log API | Programs can query events and shape the output however they like | Needs development and care with rate limits |
| Reports on a schedule | Okta Workflows or your own scheduler | Runs queries regularly and sends summaries by email, chat, or a ticket | Needs flow design and monitoring |
| Keep data longer than Okta does | Log streaming to storage or a SIEM | Delivers events continuously to a platform you control | Storage cost and platform setup |
| Correlate with other systems | SIEM or data warehouse | Combines Okta events with network, endpoint, and application logs | Platform expertise and licensing |
| Alerts in near real time | Event hooks, workflows, or SIEM rules | Sends an alert within moments of a matching event | Alert tuning to avoid noise |
| Formal access certifications | Governance features, where included | Automates review campaigns with approvals and records | Plan and licensing |
When to graduate from built-in reports
You export the same report weekly
Repetition is a sign that automation will pay off.
Audits need a year of data
You cannot rely on short retention. Stream or archive.
You need to join data
If answers need HR data or other system data, a warehouse or SIEM is the right place.
You need alerts, not reports
Reports are looked at later. Alerts reach people now.
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.
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.
| Threat | How it happens | Defense |
|---|---|---|
| Compromised administrator account | An attacker signs in as someone with report access | Phishing-resistant authentication, short sessions, device checks for administrators |
| Leaked export files | Files are emailed, left in shared folders, or stored on lost laptops | Minimum exports, secure storage, expiry, deletion, encryption |
| Over-broad report access | Too many people hold roles that can view reports | Least privilege, regular role reviews, temporary access |
| Insider curiosity or abuse | A person looks up colleagues’ activity without need | Narrow roles, logging of who viewed or exported what, clear policy |
| Reconnaissance for attacks | Stolen reports guide an attacker to high-value targets | Protect exports like credentials, and monitor administrator access |
| Tampering with evidence | Someone edits exported spreadsheets before they reach auditors | Store originals in controlled repositories, record hashes or access logs, keep exports read-only |
| Privacy violations | Reports are shared more widely than their purpose justifies | Purpose 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.
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
Multi-factor enrollment
Percentage of users enrolled, and of sign-ins that use a second factor. Trend it over time.
Unused assignments
Number of assigned users who have not used each sensitive application in ninety days.
Time to deprovision
Hours or days between a departure and complete removal of access.
Number of privileged administrators
Count and review of people with powerful roles. Fewer is better.
Risky passwords
Number of weak or reused application passwords in user-managed applications.
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.
Define the review calendar
List each recurring review, its owner, and its due dates.
Track completion
Use a checklist or ticket for each review, closed only when evidence is saved.
Report to leadership
Share a short, regular summary of the metrics above, with trends and open risks.
Improve the program
Each quarter, retire reports nobody uses and add reports for new questions.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
Misreading definitions
Treating “sign-ins” and “unique users” as the same measure, and drawing wrong conclusions.
Mismatched time ranges
Comparing a thirty-day report with a seven-day report and calling the difference a trend.
Over-narrow filters
Concluding that nothing happened when the filter hid it.
Forgetting retention
Promising auditors a year of data when only ninety days exist.
Exports everywhere
Files scattered across laptops, inboxes, and shared folders with no owner or expiry.
Too many report viewers
Broad administrator roles handed out for the sake of convenience.
Findings with no follow-up
The same issues return in every review because nobody owns the fix.
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.
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.
| Symptom | Likely cause | What to check |
|---|---|---|
| I cannot see the Reports area | Your administrator role does not include report access | Ask an administrator to review your role, and request the narrowest role that fits |
| The report is empty | Filter too narrow, wrong time range, or no matching activity | Widen the filters and the range, and check that the activity actually occurred |
| An event I know happened is missing | The event is outside retention, or it has not yet appeared | Wait a short time, check the range, and search the System Log directly |
| Numbers differ between two reports | Different definitions, time zones, or scope | Read each report’s description and align the settings before comparing |
| The report is slow or times out | The range or scope is too large | Narrow the range, split into smaller periods, or use the API for large pulls |
| Export is missing columns I need | The report has a fixed layout | Use the System Log API or a custom query for the extra data |
| The file opens oddly in a spreadsheet | Encoding or formatting issues with exported text | Import the file with explicit settings, and treat files from any source with care |
| A report I used has changed or disappeared | Okta reorganized or renamed it in a release | Check current documentation, and update your process notes |
A simple troubleshooting routine
Restate the question
Confirm exactly what you want to know. Many problems vanish when the question is clearer.
Check the basics
Confirm your role, the report chosen, the time range, and the filters.
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.
Cross-check in the System Log
Search the log for the same period and event types, and compare with the report.
Escalate or build your own
If the built-in report cannot answer the question, use the API, workflows, or streaming, and record why.
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.
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.