Why I Built This

If you’ve ever tried to answer a simple “Who has access to what?” question across
on-prem Active Directory, Azure AD, and Microsoft 365, you know how fast things get messy.
Scripts, partial exports, and one-off dashboards don’t scale. I wanted a single, approachable
web app where admins and business users can generate accurate reports, monitor identity health,
and stop the back-and-forth for routine data requests.

That goal became SimpleAdminReporter—a comprehensive, containerized application that unifies
reporting for AD, Azure AD, and Microsoft 365. It ships with pre-built templates, a visual query builder,
scheduled delivery, one-click exports, and real-time health monitoring.

What It Does (At a Glance)

• Unified interface for AD, Azure AD, and Microsoft 365 reporting.
• Pre-built reports you can run immediately (e.g., inactive users, password expiry, license usage).
• Custom Query Builder with drag-and-drop, advanced filtering, and template sharing—no SQL/LDAP required.
• Scheduled reports and email delivery for regular stakeholders.
• One-click export to Excel, CSV, PDF, and JSON.
• Real-time dashboards with WebSocket updates for system health and logs.
• Enterprise security with multi-source auth, RBAC, encryption, and detailed audit trails.

In short: tasks that used to take hours now take minutes, and teams shift from reactive to proactive
identity governance.

Key Features You Can Use Today

Pre-Built Reports

Choose from a wide set of templates covering AD, Azure AD, and Microsoft 365 scenarios—from inactive users
and lockouts to mailbox and Teams activity.

Visual Query Builder

Build custom reports without writing a line of PowerShell or LDAP. Drag fields, add filters (equals, contains,
greater-than, and more), preview results, and save reusable templates.

Scheduling, History & Export

Schedule recurring reports for stakeholders, keep a complete execution history with status/metrics, and export
in common formats (Excel / CSV / PDF / JSON) for downstream analysis or audits.

Monitoring & Logs

Keep an eye on system health with automatic updates every 30 seconds, and search across audit/system logs when you need
answers quickly.

Architecture & Technology Stack

The app follows a clean, containerized architecture with separate frontend/backend services behind Nginx,
a PostgreSQL database, and Redis for caching/queues. External integrations include Active Directory via LDAP/LDAPS,
Microsoft Graph for Azure AD/M365, and OAuth/OIDC for secure flows.

Security By Design

• Multi-source authentication (LDAP/AD, Azure AD, JWT/cookie modes) with unified auth option.
• RBAC with granular permissions and user management.
• Encrypted secrets and credential management.
• Audit logging across user actions and security events, with log search.
• Rate limiting to protect APIs and authentication endpoints.

Real-Time Observability

The app surfaces component health, query metrics, and logs in real time—health updates are pushed every ~30 seconds,
and there are dedicated screens for health and logs to support fast investigations.

Who Benefits

• IT administrators: fewer custom scripts, faster answers, and consistent exports.
• Security & compliance teams: better visibility via audit trails and scheduled evidence packs.
• Business users: self-service reporting (with permissions) without waiting on IT.

Roadmap (Highlights)

Upcoming features include enhanced PDF export and responsive UI, followed by multi-factor authentication and analytics.
Longer-term goals include SIEM integration, multi-tenant architecture, and machine-learning-driven anomaly detection.

Getting Started (Docker)

1. 1. Install Docker and Docker Compose (WSL2 on Windows or any Linux/macOS environment).
   2. Clone the repository and copy the environment template:

git clone https://github.com/ilyafedotov-ops/SimpleAdminReporter
cd SimpleAdminReporter
cp .env.example .env

1. 1. Update .env (database, secrets, optional AD/Azure credentials).
   2. Build and launch:

docker-compose build
docker-compose up -d
docker-compose ps

1. 1. Open http://localhost in your browser. Create an admin user with:

docker-compose exec backend npm run reset-admin-password

For developers, the README includes additional commands for linting, type-checking, and unit/e2e testing.

Project Status & License

SimpleAdminReporter is production-ready, with CI/CD pipelines, environment templates, and Docker Compose deployment files.
The project is licensed under MIT, making it free for use and modification.

Closing Thoughts

If admin reporting across AD, Azure AD, or Microsoft 365 is a headache in your environment, SimpleAdminReporter can make it fast,
flexible, and user-friendly. It’s built to scale with modern stack components and empower business teams with self-service capabilities.

Explore the project here:
github.com/ilyafedotov-ops/SimpleAdminReporter