SentriQ

Web-based configuration drift detection platform for server fleets

Overview

A web-based configuration drift detection platform for server fleets. Import server parameter data and baseline configurations from Excel, define per-Data-Center override rules, run automated scans, and visualize compliance across the fleet via dashboards with charts, leaderboards, and drill-down views.

Features

• Excel import for parameters and baselines (auto-creates servers + parameter definitions)
• Per-DC override rules (override baseline values per data center)
• Drift detection engine comparing current vs baseline with rule overrides
• Leaderboard page with KPIs, charts, filters, and drill-down
• Server detail page with drift findings and scan history
• Export to Excel (color-coded), CSV (Power BI-compatible), and HTML

Tech Stack

Installation

git clone https://github.com/MeGaurav4/SentriQ.git
cd SentriQ
cp .env.example .env
# Edit .env with your DB credentials
docker compose up

Open http://localhost:8000

Database migrations

SentriQ uses Alembic to track schema changes in version control. After updating app/models.py, generate a new migration and apply it:

alembic revision --autogenerate -m "describe the change"
alembic upgrade head

Usage

1. Seed test data — python scripts/seed_data.py
2. Import parameters — Upload data/test_params_*.xlsx via Parameters page
3. Import baselines — Upload data/test_baselines_*.xlsx via Baselines page
4. Run drift scan — Triggered automatically or via API
5. View results — Leaderboard shows top-drifted servers; drill into Server Detail

Testing

pip install -r requirements.txt
pytest tests/

Roadmap

• Alembic migrations setup
• Authentication / user roles
• Real-time drift alerts via webhook
• Multi-tenant fleet isolation

License

MIT — see LICENSE.