Add Reporting page with Ivanti host findings table

Backend: - New route /api/ivanti/findings (GET cached data, POST /sync, PUT /:id/note) - Fetches all pages of hostFinding/search filtered to NTS-AEO groups, severity 8.5-9.9, Open state - SQLite cache (ivanti_findings_cache) stores slimmed findings across syncs - Separate ivanti_finding_notes table persists user notes by finding ID - Daily auto-sync on startup + 24h interval, manual sync endpoint - Notes capped at 255 chars server-side Frontend (ReportingPage): - Panel 1: Metric graphs placeholder (full width, amber theme) - Panel 2: Sortable findings table (all columns click-to-sort with ASC/DESC toggle) - Columns: Severity (color-coded badge), Title, Host, IP, DNS, SLA, Discovered, Last Found, Source, Notes - Notes column: inline editable input, saves on blur via PUT endpoint - Sync button with spinner, last-synced timestamp, error banner Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Merge feature/navigation: Add hamburger nav menu with 4-page navigation structure
2026-03-11 11:56:37 -06:00 · 2026-03-11 11:47:47 -06:00 · 2026-03-11 11:47:03 -06:00 · 2026-03-11 11:36:55 -06:00 · 2026-03-11 11:32:39 -06:00 · 2026-03-11 11:26:19 -06:00
25 changed files with 2455 additions and 2767 deletions
--- a/COLOR_SCHEME_MODERNIZATION.md
+++ b/COLOR_SCHEME_MODERNIZATION.md
@@ -1,79 +0,0 @@
-# CVE Dashboard - Color Scheme Modernization
-
-## Overview
-Successfully modernized the color scheme from retro 80s/neon arcade aesthetic to a professional, sophisticated tactical intelligence platform look.
-
-## Color Palette Changes
-
-### Before (Neon/Retro)
- **Accent**: `#00D9FF` - Bright cyan (too neon)
- **Warning**: `#FFB800` - Bright yellow/orange (too saturated)
- **Danger**: `#FF3366` - Neon pink/red
- **Success**: `#00FF88` - Bright green (too bright)
- **Background Dark**: `#0A0E27`, `#131937`, `#1E2749`
-
-### After (Modern Professional)
- **Accent**: `#0EA5E9` - Sky Blue (professional, refined cyan)
- **Warning**: `#F59E0B` - Amber (sophisticated, warm)
- **Danger**: `#EF4444` - Modern Red (urgent but refined)
- **Success**: `#10B981` - Emerald (professional green)
- **Background Dark**: `#0F172A`, `#1E293B`, `#334155` (Tailwind Slate palette)
-
-## Design Philosophy
-
-### Refinement Approach
-1. **Reduced Glow Intensity**: Lowered opacity and blur radius on all glows from 0.9 to 0.4-0.5
-2. **Subtler Borders**: Changed from 3px bright borders to 1.5-2px refined borders
-3. **Professional Gradients**: Updated background gradients to use slate tones instead of stark blues
-4. **Sophisticated Shadows**: Reduced shadow intensity while maintaining depth
-5. **Text Shadow Refinement**: Reduced from aggressive glows to subtle halos
-
-### Key Changes
-
-#### Severity Badges
- **Critical**: Neon pink → Modern red with refined glow
- **High**: Bright yellow → Amber with warm tones
- **Medium**: Bright cyan → Sky blue professional
- **Low**: Bright green → Emerald sophisticated
-
-#### Interactive Elements
- **Buttons**: Reduced glow from 25px to 20px radius, lowered opacity
- **Input Fields**: More subtle focus states, refined borders
- **Cards**: Gentler hover effects, professional elevation
- **Stat Cards**: Refined top accent lines, subtle glows
-
-#### Layout Components
- **Wiki Panel**: Updated to emerald accent with professional borders
- **Calendar**: Sky blue accent with refined styling
- **Tickets Panel**: Amber accent maintaining urgency without neon feel
- **CVE Cards**: Slate-based gradients with professional depth
-
-## Technical Implementation
-
-### Files Modified
-1. **App.css**: Updated all CSS variables, component styles, and utility classes
-2. **App.js**: Updated inline STYLES object and all JSX color references
-
-### CSS Variables Updated
-```css
--intel-darkest: #0F172A
--intel-dark: #1E293B
--intel-medium: #334155
--intel-accent: #0EA5E9
--intel-warning: #F59E0B
--intel-danger: #EF4444
--intel-success: #10B981
--intel-grid: rgba(14, 165, 233, 0.08)
-```
-
-### Maintained Features
-✓ Pulsing button effects on hover/click
-✓ Scanning line animation
-✓ Card hover elevations
-✓ Badge glow dots
-✓ Grid background effect
-✓ Three-column layout
-✓ All interactive functionality
-
-## Result
-The dashboard now presents a modern, professional tactical intelligence platform aesthetic while preserving all the visual interest, depth, and functionality that made the original design engaging. The color scheme feels premium and sophisticated rather than arcade-like, suitable for enterprise security operations.
--- a/DESIGN_SYSTEM.md
+++ b/DESIGN_SYSTEM.md
@@ -1,6 +1,6 @@
 # CVE Intelligence Dashboard - Design System Reference

-## 🎨 Color Palette
+## Color Palette

 ### Primary Colors
 ```css
@@ -33,7 +33,7 @@
 | **Medium** | `#0EA5E9` | `rgba(14, 165, 233, 0.25)` | `#7DD3FC` | `#0EA5E9` |
 | **Low** | `#10B981` | `rgba(16, 185, 129, 0.25)` | `#6EE7B7` | `#10B981` |

-## 📐 Layout Structure
+## Layout Structure

 ### Three-Column Grid Layout
 ```
@@ -60,7 +60,7 @@
 - **Desktop (lg+)**: 3-column layout (3-6-3 grid)
 - **Tablet/Mobile**: Stacked single column

-## 🎯 Component Specifications
+## Component Specifications

 ### Stat Cards
 ```css
@@ -117,7 +117,7 @@ Letter Spacing: 0.5px
 Glow Dot: 8px circle with pulse animation
 ```

-## ✨ Interactions & Animations
+## Interactions & Animations

 ### Hover Effects
 - **Cards**: `translateY(-2px)`, enhanced border, subtle glow
@@ -151,7 +151,7 @@ Fast: all 0.2s ease
 Ripple: width/height 0.5s
 ```

-## 🔤 Typography
+## Typography

 ### Font Families
 ```css
@@ -178,7 +178,7 @@ Accent Headings: 0 0 16px rgba(14, 165, 233, 0.3), 0 0 32px rgba(14, 165, 233, 0
 Badge Text: 0 0 8px rgba([color], 0.5)
 ```

-## 🎨 Visual Effects
+## Visual Effects

 ### Shadows
 ```css
@@ -223,7 +223,7 @@ linear-gradient(rgba(14, 165, 233, 0.025) 1px, transparent 1px)
 Size: 20px × 20px
 ```

-## 🧩 Specific Component Patterns
+## Specific Component Patterns

 ### Wiki/Knowledge Base Entry
 ```css
@@ -261,7 +261,7 @@ Chevron: Rotate -90deg (collapsed) to 0deg (expanded)
 Vendor Cards: Nested with reduced opacity borders
 ```

-## 📱 Accessibility
+## Accessibility

 ### Contrast Ratios
 - Primary text on dark: 18.5:1 (AAA)
@@ -278,7 +278,7 @@ Vendor Cards: Nested with reduced opacity borders
 - Line height: 1.5 for body text
 - Letter spacing: Generous for uppercase labels

-## 🎯 Design Principles
+## Design Principles

 1. **Professional Sophistication**: Modern enterprise feel, not arcade
 2. **Tactical Intelligence**: Purpose-driven, information-dense
@@ -288,7 +288,3 @@ Vendor Cards: Nested with reduced opacity borders
 6. **Monospace Data**: Technical data uses JetBrains Mono for clarity
 7. **Generous Spacing**: Breathing room prevents overwhelming density

---
-
-**Last Updated**: February 10, 2026
-**Version**: 2.0 (Modern Professional Redesign)
--- a/README.md
+++ b/README.md
--- a/WEEKLY_REPORT_FEATURE.md
+++ b/WEEKLY_REPORT_FEATURE.md
@@ -48,13 +48,13 @@ A new feature has been added to the CVE Dashboard that allows users to upload th

 1. **Backend:**
   ```bash
-   cd /home/admin/cve-dashboard/backend
+   cd backend
   node server.js
   ```

 2. **Frontend:**
   ```bash
-   cd /home/admin/cve-dashboard/frontend
+   cd frontend
   npm start
   ```

--- a/backend/.env.example
+++ b/backend/.env.example
@@ -6,3 +6,12 @@ CORS_ORIGINS=http://localhost:3000
 # NVD API Key (optional - increases rate limit from 5 to 50 requests per 30s)
 # Request one at https://nvd.nist.gov/developers/request-an-api-key
 NVD_API_KEY=
+
+# Ivanti / RiskSense API (platform4.risksense.com)
+# API key from your profile settings — does not expire like session cookies
+IVANTI_API_KEY=
+IVANTI_CLIENT_ID=1550
+IVANTI_FIRST_NAME=
+IVANTI_LAST_NAME=
+# Set to true if behind Charter's SSL inspection proxy (replicates Python verify=False)
+IVANTI_SKIP_TLS=false
--- a/backend/helpers/excelProcessor.js
+++ b/backend/helpers/excelProcessor.js
@@ -1,93 +0,0 @@
-const { spawn } = require('child_process');
-const path = require('path');
-const fs = require('fs');
-
-/**
- * Process vulnerability report Excel file by splitting CVE IDs into separate rows
- * @param {string} inputPath - Path to original Excel file
- * @param {string} outputPath - Path for processed Excel file
- * @returns {Promise<{original_rows: number, processed_rows: number, output_path: string}>}
- */
-function processVulnerabilityReport(inputPath, outputPath) {
-  return new Promise((resolve, reject) => {
-    const scriptPath = path.join(__dirname, '..', 'scripts', 'split_cve_report.py');
-
-    // Verify script exists
-    if (!fs.existsSync(scriptPath)) {
-      return reject(new Error(`Python script not found: ${scriptPath}`));
-    }
-
-    // Verify input file exists
-    if (!fs.existsSync(inputPath)) {
-      return reject(new Error(`Input file not found: ${inputPath}`));
-    }
-
-    const python = spawn('python3', [scriptPath, inputPath, outputPath]);
-
-    let stdout = '';
-    let stderr = '';
-    let timedOut = false;
-
-    // 30 second timeout
-    const timeout = setTimeout(() => {
-      timedOut = true;
-      python.kill();
-      reject(new Error('Processing timed out. File may be too large or corrupted.'));
-    }, 30000);
-
-    python.stdout.on('data', (data) => {
-      stdout += data.toString();
-    });
-
-    python.stderr.on('data', (data) => {
-      stderr += data.toString();
-    });
-
-    python.on('close', (code) => {
-      clearTimeout(timeout);
-
-      if (timedOut) return;
-
-      if (code !== 0) {
-        // Parse Python error messages
-        if (stderr.includes('Sheet') && stderr.includes('not found')) {
-          return reject(new Error('Invalid Excel file. Expected "Vulnerabilities" sheet with "CVE ID" column.'));
-        }
-        if (stderr.includes('pandas') || stderr.includes('openpyxl')) {
-          return reject(new Error('Python dependencies missing. Run: pip3 install pandas openpyxl'));
-        }
-        return reject(new Error(`Python script failed: ${stderr || 'Unknown error'}`));
-      }
-
-      // Parse output for row counts
-      const originalMatch = stdout.match(/Original rows:\s*(\d+)/);
-      const newMatch = stdout.match(/New rows:\s*(\d+)/);
-
-      if (!originalMatch || !newMatch) {
-        return reject(new Error('Failed to parse row counts from Python output'));
-      }
-
-      // Verify output file was created
-      if (!fs.existsSync(outputPath)) {
-        return reject(new Error('Processed file was not created'));
-      }
-
-      resolve({
-        original_rows: parseInt(originalMatch[1]),
-        processed_rows: parseInt(newMatch[1]),
-        output_path: outputPath
-      });
-    });
-
-    python.on('error', (err) => {
-      clearTimeout(timeout);
-      if (err.code === 'ENOENT') {
-        reject(new Error('Python 3 is required but not found. Please install Python.'));
-      } else {
-        reject(err);
-      }
-    });
-  });
-}
-
-module.exports = { processVulnerabilityReport };
--- a/backend/migrations/add_archer_tickets_table.js
+++ b/backend/migrations/add_archer_tickets_table.js
@@ -0,0 +1,50 @@
+// Migration: Add archer_tickets table
+const sqlite3 = require('sqlite3').verbose();
+const path = require('path');
+
+const dbPath = path.join(__dirname, '..', 'cve_database.db');
+const db = new sqlite3.Database(dbPath);
+
+console.log('Starting Archer tickets migration...');
+
+db.serialize(() => {
+  // Create archer_tickets table
+  db.run(`
+    CREATE TABLE IF NOT EXISTS archer_tickets (
+      id INTEGER PRIMARY KEY AUTOINCREMENT,
+      exc_number TEXT NOT NULL UNIQUE,
+      archer_url TEXT,
+      status TEXT DEFAULT 'Draft' CHECK(status IN ('Draft', 'Open', 'Under Review', 'Accepted')),
+      cve_id TEXT NOT NULL,
+      vendor TEXT NOT NULL,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      FOREIGN KEY (cve_id, vendor) REFERENCES cves(cve_id, vendor) ON DELETE CASCADE
+    )
+  `, (err) => {
+    if (err) console.error('Error creating table:', err);
+    else console.log('✓ archer_tickets table created');
+  });
+
+  // Create indexes
+  db.run('CREATE INDEX IF NOT EXISTS idx_archer_tickets_cve ON archer_tickets(cve_id, vendor)', (err) => {
+    if (err) console.error('Error creating CVE index:', err);
+    else console.log('✓ CVE index created');
+  });
+
+  db.run('CREATE INDEX IF NOT EXISTS idx_archer_tickets_status ON archer_tickets(status)', (err) => {
+    if (err) console.error('Error creating status index:', err);
+    else console.log('✓ Status index created');
+  });
+
+  db.run('CREATE INDEX IF NOT EXISTS idx_archer_tickets_exc ON archer_tickets(exc_number)', (err) => {
+    if (err) console.error('Error creating EXC number index:', err);
+    else console.log('✓ EXC number index created');
+  });
+
+  console.log('✓ Indexes created');
+});
+
+db.close(() => {
+  console.log('Migration complete!');
+});
--- a/backend/migrations/add_ivanti_findings_tables.js
+++ b/backend/migrations/add_ivanti_findings_tables.js
@@ -0,0 +1,58 @@
+// Migration: Add ivanti_findings_cache and ivanti_finding_notes tables
+const sqlite3 = require('sqlite3').verbose();
+const path = require('path');
+
+const dbPath = path.join(__dirname, '..', 'cve_database.db');
+const db = new sqlite3.Database(dbPath);
+
+console.log('Starting Ivanti findings tables migration...');
+
+db.serialize(() => {
+    // Cache table — single row holding the latest sync result
+    db.run(`
+        CREATE TABLE IF NOT EXISTS ivanti_findings_cache (
+            id INTEGER PRIMARY KEY CHECK (id = 1),
+            total INTEGER DEFAULT 0,
+            findings_json TEXT DEFAULT '[]',
+            synced_at DATETIME,
+            sync_status TEXT DEFAULT 'never',
+            error_message TEXT
+        )
+    `, (err) => {
+        if (err) console.error('Error creating findings cache table:', err);
+        else console.log('✓ ivanti_findings_cache table created');
+    });
+
+    db.run(`
+        INSERT OR IGNORE INTO ivanti_findings_cache (id, total, findings_json, sync_status)
+        VALUES (1, 0, '[]', 'never')
+    `, (err) => {
+        if (err) console.error('Error seeding findings cache row:', err);
+        else console.log('✓ ivanti_findings_cache row seeded');
+    });
+
+    // Notes table — one row per finding, persists across cache refreshes
+    db.run(`
+        CREATE TABLE IF NOT EXISTS ivanti_finding_notes (
+            id INTEGER PRIMARY KEY AUTOINCREMENT,
+            finding_id TEXT NOT NULL UNIQUE,
+            note TEXT NOT NULL DEFAULT '',
+            updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
+        )
+    `, (err) => {
+        if (err) console.error('Error creating finding notes table:', err);
+        else console.log('✓ ivanti_finding_notes table created');
+    });
+
+    db.run(`
+        CREATE INDEX IF NOT EXISTS idx_finding_notes_finding_id
+        ON ivanti_finding_notes(finding_id)
+    `, (err) => {
+        if (err) console.error('Error creating notes index:', err);
+        else console.log('✓ finding_id index created');
+    });
+});
+
+db.close(() => {
+    console.log('Migration complete!');
+});
--- a/backend/migrations/add_ivanti_sync_table.js
+++ b/backend/migrations/add_ivanti_sync_table.js
@@ -0,0 +1,37 @@
+// Migration: Add ivanti_sync_state table
+const sqlite3 = require('sqlite3').verbose();
+const path = require('path');
+
+const dbPath = path.join(__dirname, '..', 'cve_database.db');
+const db = new sqlite3.Database(dbPath);
+
+console.log('Starting Ivanti sync state migration...');
+
+db.serialize(() => {
+    db.run(`
+        CREATE TABLE IF NOT EXISTS ivanti_sync_state (
+            id INTEGER PRIMARY KEY CHECK (id = 1),
+            total INTEGER DEFAULT 0,
+            workflows_json TEXT DEFAULT '[]',
+            synced_at DATETIME,
+            sync_status TEXT DEFAULT 'never',
+            error_message TEXT
+        )
+    `, (err) => {
+        if (err) console.error('Error creating table:', err);
+        else console.log('✓ ivanti_sync_state table created');
+    });
+
+    // Seed the single-row state record
+    db.run(`
+        INSERT OR IGNORE INTO ivanti_sync_state (id, total, workflows_json, sync_status)
+        VALUES (1, 0, '[]', 'never')
+    `, (err) => {
+        if (err) console.error('Error seeding state row:', err);
+        else console.log('✓ ivanti_sync_state row seeded');
+    });
+});
+
+db.close(() => {
+    console.log('Migration complete!');
+});
--- a/backend/migrations/add_weekly_reports_table.js
+++ b/backend/migrations/add_weekly_reports_table.js
@@ -1,59 +0,0 @@
-// Migration: Add weekly_reports table for vulnerability report uploads
-
-const sqlite3 = require('sqlite3').verbose();
-const path = require('path');
-
-const dbPath = path.join(__dirname, '..', 'cve_database.db');
-const db = new sqlite3.Database(dbPath);
-
-console.log('Running migration: add_weekly_reports_table');
-
-db.serialize(() => {
-  db.run(`
-    CREATE TABLE IF NOT EXISTS weekly_reports (
-      id INTEGER PRIMARY KEY AUTOINCREMENT,
-      upload_date DATE NOT NULL,
-      week_label VARCHAR(50),
-      original_filename VARCHAR(255),
-      processed_filename VARCHAR(255),
-      original_file_path VARCHAR(500),
-      processed_file_path VARCHAR(500),
-      row_count_original INTEGER,
-      row_count_processed INTEGER,
-      uploaded_by INTEGER,
-      uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-      is_current BOOLEAN DEFAULT 0,
-      FOREIGN KEY (uploaded_by) REFERENCES users(id)
-    )
-  `, (err) => {
-    if (err) {
-      console.error('Error creating weekly_reports table:', err);
-      process.exit(1);
-    }
-    console.log('✓ Created weekly_reports table');
-  });
-
-  db.run(`
-    CREATE INDEX IF NOT EXISTS idx_weekly_reports_date
-    ON weekly_reports(upload_date DESC)
-  `, (err) => {
-    if (err) {
-      console.error('Error creating date index:', err);
-      process.exit(1);
-    }
-    console.log('✓ Created index on upload_date');
-  });
-
-  db.run(`
-    CREATE INDEX IF NOT EXISTS idx_weekly_reports_current
-    ON weekly_reports(is_current)
-  `, (err) => {
-    if (err) {
-      console.error('Error creating current index:', err);
-      process.exit(1);
-    }
-    console.log('✓ Created index on is_current');
-    console.log('\nMigration completed successfully!');
-    db.close();
-  });
-});
--- a/backend/routes/archerTickets.js
+++ b/backend/routes/archerTickets.js
@@ -0,0 +1,223 @@
+// routes/archerTickets.js
+const express = require('express');
+const { requireAuth, requireRole } = require('../middleware/auth');
+const logAudit = require('../helpers/auditLog');
+
+// Validation helpers
+const CVE_ID_PATTERN = /^CVE-\d{4}-\d{4,}$/;
+function isValidCveId(cveId) {
+  return typeof cveId === 'string' && CVE_ID_PATTERN.test(cveId);
+}
+
+function isValidVendor(vendor) {
+  return typeof vendor === 'string' && vendor.trim().length > 0 && vendor.length <= 200;
+}
+
+function createArcherTicketsRouter(db) {
+  const router = express.Router();
+
+  // Get all Archer tickets (with optional filters)
+  router.get('/', requireAuth(db), (req, res) => {
+    const { cve_id, vendor, status } = req.query;
+
+    let query = 'SELECT * FROM archer_tickets WHERE 1=1';
+    const params = [];
+
+    if (cve_id) {
+      query += ' AND cve_id = ?';
+      params.push(cve_id);
+    }
+    if (vendor) {
+      query += ' AND vendor = ?';
+      params.push(vendor);
+    }
+    if (status) {
+      query += ' AND status = ?';
+      params.push(status);
+    }
+
+    query += ' ORDER BY created_at DESC';
+
+    db.all(query, params, (err, rows) => {
+      if (err) {
+        console.error('Error fetching Archer tickets:', err);
+        return res.status(500).json({ error: 'Internal server error.' });
+      }
+      res.json(rows);
+    });
+  });
+
+  // Create Archer ticket
+  router.post('/', requireAuth(db), requireRole('editor', 'admin'), (req, res) => {
+    const { exc_number, archer_url, status, cve_id, vendor } = req.body;
+
+    // Validation
+    if (!exc_number || typeof exc_number !== 'string' || exc_number.trim().length === 0) {
+      return res.status(400).json({ error: 'EXC number is required.' });
+    }
+    if (!/^EXC-\d+$/.test(exc_number.trim())) {
+      return res.status(400).json({ error: 'EXC number must be in format EXC-XXXX (e.g., EXC-5754).' });
+    }
+    if (!cve_id || !isValidCveId(cve_id)) {
+      return res.status(400).json({ error: 'Valid CVE ID is required.' });
+    }
+    if (!vendor || !isValidVendor(vendor)) {
+      return res.status(400).json({ error: 'Valid vendor is required.' });
+    }
+    if (archer_url && (typeof archer_url !== 'string' || archer_url.length > 500)) {
+      return res.status(400).json({ error: 'Archer URL must be under 500 characters.' });
+    }
+    if (status && !['Draft', 'Open', 'Under Review', 'Accepted'].includes(status)) {
+      return res.status(400).json({ error: 'Invalid status. Must be Draft, Open, Under Review, or Accepted.' });
+    }
+
+    const validatedStatus = status || 'Draft';
+
+    db.run(
+      `INSERT INTO archer_tickets (exc_number, archer_url, status, cve_id, vendor)
+       VALUES (?, ?, ?, ?, ?)`,
+      [exc_number.trim(), archer_url || null, validatedStatus, cve_id, vendor],
+      function(err) {
+        if (err) {
+          console.error('Error creating Archer ticket:', err);
+          if (err.message.includes('UNIQUE constraint failed')) {
+            return res.status(409).json({ error: 'An Archer ticket with this EXC number already exists.' });
+          }
+          return res.status(500).json({ error: 'Internal server error.' });
+        }
+
+        logAudit(db, {
+          userId: req.user.id,
+          action: 'CREATE_ARCHER_TICKET',
+          targetType: 'archer_ticket',
+          targetId: this.lastID,
+          details: { exc_number, archer_url, status: validatedStatus, cve_id, vendor },
+          ipAddress: req.ip
+        });
+
+        res.status(201).json({
+          id: this.lastID,
+          message: 'Archer ticket created successfully'
+        });
+      }
+    );
+  });
+
+  // Update Archer ticket
+  router.put('/:id', requireAuth(db), requireRole('editor', 'admin'), (req, res) => {
+    const { id } = req.params;
+    const { exc_number, archer_url, status } = req.body;
+
+    // Validation
+    if (exc_number !== undefined) {
+      if (typeof exc_number !== 'string' || exc_number.trim().length === 0) {
+        return res.status(400).json({ error: 'EXC number cannot be empty.' });
+      }
+      if (!/^EXC-\d+$/.test(exc_number.trim())) {
+        return res.status(400).json({ error: 'EXC number must be in format EXC-XXXX (e.g., EXC-5754).' });
+      }
+    }
+    if (archer_url !== undefined && archer_url !== null && (typeof archer_url !== 'string' || archer_url.length > 500)) {
+      return res.status(400).json({ error: 'Archer URL must be under 500 characters.' });
+    }
+    if (status !== undefined && !['Draft', 'Open', 'Under Review', 'Accepted'].includes(status)) {
+      return res.status(400).json({ error: 'Invalid status. Must be Draft, Open, Under Review, or Accepted.' });
+    }
+
+    // Get existing ticket
+    db.get('SELECT * FROM archer_tickets WHERE id = ?', [id], (err, existing) => {
+      if (err) {
+        console.error(err);
+        return res.status(500).json({ error: 'Internal server error.' });
+      }
+      if (!existing) {
+        return res.status(404).json({ error: 'Archer ticket not found.' });
+      }
+
+      const updates = [];
+      const params = [];
+
+      if (exc_number !== undefined) {
+        updates.push('exc_number = ?');
+        params.push(exc_number.trim());
+      }
+      if (archer_url !== undefined) {
+        updates.push('archer_url = ?');
+        params.push(archer_url || null);
+      }
+      if (status !== undefined) {
+        updates.push('status = ?');
+        params.push(status);
+      }
+
+      if (updates.length === 0) {
+        return res.status(400).json({ error: 'No fields to update.' });
+      }
+
+      updates.push('updated_at = CURRENT_TIMESTAMP');
+      params.push(id);
+
+      db.run(
+        `UPDATE archer_tickets SET ${updates.join(', ')} WHERE id = ?`,
+        params,
+        function(err) {
+          if (err) {
+            console.error(err);
+            if (err.message.includes('UNIQUE constraint failed')) {
+              return res.status(409).json({ error: 'An Archer ticket with this EXC number already exists.' });
+            }
+            return res.status(500).json({ error: 'Internal server error.' });
+          }
+
+          logAudit(db, {
+            userId: req.user.id,
+            action: 'UPDATE_ARCHER_TICKET',
+            targetType: 'archer_ticket',
+            targetId: id,
+            details: { before: existing, changes: req.body },
+            ipAddress: req.ip
+          });
+
+          res.json({ message: 'Archer ticket updated successfully', changes: this.changes });
+        }
+      );
+    });
+  });
+
+  // Delete Archer ticket
+  router.delete('/:id', requireAuth(db), requireRole('editor', 'admin'), (req, res) => {
+    const { id } = req.params;
+
+    db.get('SELECT * FROM archer_tickets WHERE id = ?', [id], (err, ticket) => {
+      if (err) {
+        console.error(err);
+        return res.status(500).json({ error: 'Internal server error.' });
+      }
+      if (!ticket) {
+        return res.status(404).json({ error: 'Archer ticket not found.' });
+      }
+
+      db.run('DELETE FROM archer_tickets WHERE id = ?', [id], function(err) {
+        if (err) {
+          console.error(err);
+          return res.status(500).json({ error: 'Internal server error.' });
+        }
+
+        logAudit(db, {
+          userId: req.user.id,
+          action: 'DELETE_ARCHER_TICKET',
+          targetType: 'archer_ticket',
+          targetId: id,
+          details: { deleted: ticket },
+          ipAddress: req.ip
+        });
+
+        res.json({ message: 'Archer ticket deleted successfully' });
+      });
+    });
+  });
+
+  return router;
+}
+
+module.exports = createArcherTicketsRouter;
--- a/backend/routes/ivantiFindings.js
+++ b/backend/routes/ivantiFindings.js
@@ -0,0 +1,315 @@
+// Ivanti / RiskSense Host Findings Routes
+// Caches hostFinding/search results in SQLite with daily auto-sync.
+// Notes are stored separately so they survive cache refreshes.
+
+const express = require('express');
+const https = require('https');
+
+const IVANTI_URL_BASE = 'https://platform4.risksense.com/api/v1';
+const SYNC_INTERVAL_MS = 24 * 60 * 60 * 1000;
+
+const FINDINGS_FILTERS = [
+    {
+        field: 'assetCustomAttributes.1550_host_1.value',
+        exclusive: false,
+        operator: 'IN',
+        orWithPrevious: false,
+        implicitFilters: [],
+        value: 'NTS-AEO-ACCESS-ENG,NTS-AEO-STEAM',
+        caseSensitive: false
+    },
+    {
+        field: 'severity',
+        exclusive: false,
+        operator: 'RANGE',
+        orWithPrevious: false,
+        implicitFilters: [],
+        value: '8.5,9.9',
+        caseSensitive: false
+    },
+    {
+        field: 'generic_state',
+        exclusive: false,
+        operator: 'EXACT',
+        orWithPrevious: false,
+        implicitFilters: [],
+        value: 'Open',
+        caseSensitive: false
+    }
+];
+
+// ---------------------------------------------------------------------------
+// HTTP helper — mirrors the one in ivantiWorkflows.js
+// ---------------------------------------------------------------------------
+function ivantiPost(urlPath, body, apiKey, skipTls) {
+    const bodyStr = JSON.stringify(body);
+    const fullUrl = new URL(IVANTI_URL_BASE + urlPath);
+
+    return new Promise((resolve, reject) => {
+        const options = {
+            hostname: fullUrl.hostname,
+            path: fullUrl.pathname + fullUrl.search,
+            method: 'POST',
+            headers: {
+                'accept': '*/*',
+                'content-type': 'application/json',
+                'x-api-key': apiKey,
+                'x-http-client-type': 'browser',
+                'content-length': Buffer.byteLength(bodyStr)
+            },
+            rejectUnauthorized: !skipTls,
+            timeout: 20000
+        };
+
+        const req = https.request(options, (res) => {
+            let data = '';
+            res.on('data', (chunk) => { data += chunk; });
+            res.on('end', () => resolve({ status: res.statusCode, body: data }));
+        });
+
+        req.on('timeout', () => req.destroy(new Error('Request timed out')));
+        req.on('error', reject);
+        req.write(bodyStr);
+        req.end();
+    });
+}
+
+// ---------------------------------------------------------------------------
+// Table init
+// ---------------------------------------------------------------------------
+function initTables(db) {
+    return new Promise((resolve, reject) => {
+        db.serialize(() => {
+            db.run(`
+                CREATE TABLE IF NOT EXISTS ivanti_findings_cache (
+                    id INTEGER PRIMARY KEY CHECK (id = 1),
+                    total INTEGER DEFAULT 0,
+                    findings_json TEXT DEFAULT '[]',
+                    synced_at DATETIME,
+                    sync_status TEXT DEFAULT 'never',
+                    error_message TEXT
+                )
+            `, (err) => { if (err) return reject(err); });
+
+            db.run(`
+                INSERT OR IGNORE INTO ivanti_findings_cache (id, total, findings_json, sync_status)
+                VALUES (1, 0, '[]', 'never')
+            `, (err) => { if (err) return reject(err); });
+
+            db.run(`
+                CREATE TABLE IF NOT EXISTS ivanti_finding_notes (
+                    id INTEGER PRIMARY KEY AUTOINCREMENT,
+                    finding_id TEXT NOT NULL UNIQUE,
+                    note TEXT NOT NULL DEFAULT '',
+                    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
+                )
+            `, (err) => { if (err) return reject(err); });
+
+            db.run(`
+                CREATE INDEX IF NOT EXISTS idx_finding_notes_finding_id
+                ON ivanti_finding_notes(finding_id)
+            `, (err) => {
+                if (err) reject(err);
+                else resolve();
+            });
+        });
+    });
+}
+
+// ---------------------------------------------------------------------------
+// Extract only the fields we need from a raw finding object
+// ---------------------------------------------------------------------------
+function extractFinding(f) {
+    return {
+        id: String(f.id),
+        title: f.title || '',
+        severity: typeof f.severity === 'number' ? f.severity : parseFloat(f.severity) || 0,
+        vrrGroup: f.vrrGroup || f.severityGroup || '',
+        hostName: f.host?.hostName || '',
+        ipAddress: f.host?.ipAddress || '',
+        dns: f.dns || f.host?.fqdn || '',
+        status: f.status || '',
+        slaStatus: f.slaStatus || '',
+        discoveredOn: f.discoveredOn || '',
+        lastFoundOn: f.lastFoundOn || '',
+        source: f.scannerPrettyName || f.scannerName || f.source || '',
+        pluginFamily: f.pluginFamily || '',
+        findingType: f.findingType || ''
+    };
+}
+
+// ---------------------------------------------------------------------------
+// Core sync — fetches ALL pages, stores slimmed findings in SQLite
+// ---------------------------------------------------------------------------
+async function syncFindings(db) {
+    const apiKey = process.env.IVANTI_API_KEY;
+    const clientId = process.env.IVANTI_CLIENT_ID || '1550';
+    const skipTls = process.env.IVANTI_SKIP_TLS === 'true';
+
+    if (!apiKey) {
+        const errMsg = 'IVANTI_API_KEY not set in .env — skipping sync';
+        console.warn('[Ivanti Findings]', errMsg);
+        await dbRun(db, `UPDATE ivanti_findings_cache SET sync_status='error', error_message=?, synced_at=datetime('now') WHERE id=1`, [errMsg]);
+        return;
+    }
+
+    console.log('[Ivanti Findings] Starting sync...');
+
+    const urlPath = `/client/${encodeURIComponent(clientId)}/hostFinding/search`;
+    let allFindings = [];
+    let page = 0;
+    let totalPages = 1;
+
+    try {
+        do {
+            const body = {
+                filters: FINDINGS_FILTERS,
+                projection: 'internal',
+                sort: [{ field: 'severity', direction: 'ASC' }],
+                page,
+                size: 100
+            };
+
+            const result = await ivantiPost(urlPath, body, apiKey, skipTls);
+
+            if (result.status === 401) throw new Error('Invalid or missing API key (401)');
+            if (result.status === 419) throw new Error('Insufficient privileges (419) — API key lacks hostFinding access');
+            if (result.status === 429) throw new Error('Rate limited (429) — try again later');
+            if (result.status !== 200) throw new Error(`Ivanti API returned status ${result.status}`);
+
+            const data = JSON.parse(result.body);
+            totalPages = data.page?.totalPages || 1;
+            const findings = data._embedded?.hostFindings || [];
+            allFindings = allFindings.concat(findings.map(extractFinding));
+
+            console.log(`[Ivanti Findings] Page ${page + 1}/${totalPages} — ${allFindings.length} findings so far`);
+            page++;
+        } while (page < totalPages);
+
+        await dbRun(db,
+            `UPDATE ivanti_findings_cache SET total=?, findings_json=?, synced_at=datetime('now'), sync_status='success', error_message=NULL WHERE id=1`,
+            [allFindings.length, JSON.stringify(allFindings)]
+        );
+
+        console.log(`[Ivanti Findings] Sync complete — ${allFindings.length} findings`);
+    } catch (err) {
+        const msg = err.message || 'Unknown error';
+        console.error('[Ivanti Findings] Sync failed:', msg);
+        await dbRun(db, `UPDATE ivanti_findings_cache SET sync_status='error', error_message=?, synced_at=datetime('now') WHERE id=1`, [msg]);
+    }
+}
+
+// ---------------------------------------------------------------------------
+// Scheduler
+// ---------------------------------------------------------------------------
+function scheduleSync(db) {
+    db.get('SELECT synced_at FROM ivanti_findings_cache WHERE id = 1', (err, row) => {
+        if (err || !row || !row.synced_at) {
+            syncFindings(db);
+        } else {
+            const lastSync = new Date(row.synced_at.replace(' ', 'T') + 'Z');
+            const hoursSince = (Date.now() - lastSync.getTime()) / (1000 * 60 * 60);
+            if (hoursSince >= 24) {
+                syncFindings(db);
+            } else {
+                console.log(`[Ivanti Findings] Last sync ${hoursSince.toFixed(1)}h ago — next auto-sync in ${(24 - hoursSince).toFixed(1)}h`);
+            }
+        }
+    });
+
+    setInterval(() => syncFindings(db), SYNC_INTERVAL_MS);
+}
+
+// ---------------------------------------------------------------------------
+// DB helpers
+// ---------------------------------------------------------------------------
+function dbRun(db, sql, params = []) {
+    return new Promise((resolve, reject) => {
+        db.run(sql, params, (err) => { if (err) reject(err); else resolve(); });
+    });
+}
+
+function readState(db) {
+    return new Promise((resolve, reject) => {
+        db.get(
+            'SELECT total, findings_json, synced_at, sync_status, error_message FROM ivanti_findings_cache WHERE id = 1',
+            (err, row) => {
+                if (err) return reject(err);
+                if (!row) return resolve({ total: 0, findings: [], synced_at: null, sync_status: 'never', error_message: null });
+                let findings = [];
+                try { findings = JSON.parse(row.findings_json || '[]'); } catch (_) { /* leave empty */ }
+                resolve({ total: row.total || 0, findings, synced_at: row.synced_at, sync_status: row.sync_status, error_message: row.error_message });
+            }
+        );
+    });
+}
+
+function readNotes(db) {
+    return new Promise((resolve, reject) => {
+        db.all('SELECT finding_id, note FROM ivanti_finding_notes', (err, rows) => {
+            if (err) return reject(err);
+            const map = {};
+            (rows || []).forEach((r) => { map[r.finding_id] = r.note; });
+            resolve(map);
+        });
+    });
+}
+
+async function readStateWithNotes(db) {
+    const [state, notes] = await Promise.all([readState(db), readNotes(db)]);
+    state.findings = state.findings.map((f) => ({ ...f, note: notes[f.id] || '' }));
+    return state;
+}
+
+// ---------------------------------------------------------------------------
+// Router
+// ---------------------------------------------------------------------------
+function createIvantiFindingsRouter(db, requireAuth) {
+    const router = express.Router();
+
+    initTables(db)
+        .then(() => scheduleSync(db))
+        .catch((err) => console.error('[Ivanti Findings] Init failed:', err));
+
+    router.use(requireAuth(db));
+
+    // GET / — cached findings with notes merged in
+    router.get('/', async (req, res) => {
+        try {
+            res.json(await readStateWithNotes(db));
+        } catch {
+            res.status(500).json({ error: 'Database error reading findings' });
+        }
+    });
+
+    // POST /sync — trigger immediate sync, return fresh state
+    router.post('/sync', async (req, res) => {
+        await syncFindings(db);
+        try {
+            res.json(await readStateWithNotes(db));
+        } catch {
+            res.status(500).json({ error: 'Sync ran but could not read updated state' });
+        }
+    });
+
+    // PUT /:findingId/note — save or update a note (max 255 chars enforced here)
+    router.put('/:findingId/note', (req, res) => {
+        const { findingId } = req.params;
+        const note = String(req.body.note || '').slice(0, 255);
+
+        db.run(
+            `INSERT INTO ivanti_finding_notes (finding_id, note, updated_at)
+             VALUES (?, ?, datetime('now'))
+             ON CONFLICT(finding_id) DO UPDATE SET note=excluded.note, updated_at=datetime('now')`,
+            [findingId, note],
+            (err) => {
+                if (err) return res.status(500).json({ error: 'Failed to save note' });
+                res.json({ finding_id: findingId, note });
+            }
+        );
+    });
+
+    return router;
+}
+
+module.exports = createIvantiFindingsRouter;
--- a/backend/routes/ivantiWorkflows.js
+++ b/backend/routes/ivantiWorkflows.js
@@ -0,0 +1,274 @@
+// Ivanti / RiskSense Workflow Routes
+// Data is cached in SQLite and refreshed on a daily schedule or on-demand.
+// Auth: x-api-key header (confirmed via platform4.risksense.com/doc/swagger.json)
+// Error codes: 401 bad key, 419 insufficient privileges, 429 rate limited
+
+const express = require('express');
+const https = require('https');
+
+const IVANTI_URL_BASE = 'https://platform4.risksense.com/api/v1';
+const SYNC_INTERVAL_MS = 24 * 60 * 60 * 1000; // 24 hours
+
+// ---------------------------------------------------------------------------
+// HTTP helper — uses Node's https module directly so we can toggle
+// rejectUnauthorized for Charter's SSL inspection proxy (IVANTI_SKIP_TLS=true)
+// ---------------------------------------------------------------------------
+function ivantiPost(urlPath, body, apiKey, skipTls) {
+    const bodyStr = JSON.stringify(body);
+    const fullUrl = new URL(IVANTI_URL_BASE + urlPath);
+
+    return new Promise((resolve, reject) => {
+        const options = {
+            hostname: fullUrl.hostname,
+            path: fullUrl.pathname + fullUrl.search,
+            method: 'POST',
+            headers: {
+                'accept': '*/*',
+                'content-type': 'application/json',
+                'x-api-key': apiKey,
+                'x-http-client-type': 'browser',
+                'content-length': Buffer.byteLength(bodyStr)
+            },
+            rejectUnauthorized: !skipTls,
+            timeout: 15000
+        };
+
+        const req = https.request(options, (res) => {
+            let data = '';
+            res.on('data', (chunk) => { data += chunk; });
+            res.on('end', () => resolve({ status: res.statusCode, body: data }));
+        });
+
+        req.on('timeout', () => req.destroy(new Error('Request timed out')));
+        req.on('error', reject);
+        req.write(bodyStr);
+        req.end();
+    });
+}
+
+// ---------------------------------------------------------------------------
+// Ensure the sync state table exists (idempotent — safe to call on every start)
+// ---------------------------------------------------------------------------
+function initTable(db) {
+    return new Promise((resolve, reject) => {
+        db.serialize(() => {
+            db.run(`
+                CREATE TABLE IF NOT EXISTS ivanti_sync_state (
+                    id INTEGER PRIMARY KEY CHECK (id = 1),
+                    total INTEGER DEFAULT 0,
+                    workflows_json TEXT DEFAULT '[]',
+                    synced_at DATETIME,
+                    sync_status TEXT DEFAULT 'never',
+                    error_message TEXT
+                )
+            `, (err) => { if (err) return reject(err); });
+
+            db.run(`
+                INSERT OR IGNORE INTO ivanti_sync_state (id, total, workflows_json, sync_status)
+                VALUES (1, 0, '[]', 'never')
+            `, (err) => {
+                if (err) reject(err);
+                else resolve();
+            });
+        });
+    });
+}
+
+// ---------------------------------------------------------------------------
+// Core sync — calls Ivanti API, stores result in SQLite
+// ---------------------------------------------------------------------------
+async function syncWorkflows(db) {
+    const apiKey = process.env.IVANTI_API_KEY;
+    const clientId = process.env.IVANTI_CLIENT_ID || '1550';
+    const firstName = process.env.IVANTI_FIRST_NAME || '';
+    const lastName = process.env.IVANTI_LAST_NAME || '';
+    const skipTls = process.env.IVANTI_SKIP_TLS === 'true';
+
+    if (!apiKey) {
+        const errMsg = 'IVANTI_API_KEY not set in .env — skipping sync';
+        console.warn('[Ivanti]', errMsg);
+        await new Promise((resolve) => {
+            db.run(
+                `UPDATE ivanti_sync_state SET sync_status='error', error_message=?, synced_at=datetime('now') WHERE id=1`,
+                [errMsg], resolve
+            );
+        });
+        return;
+    }
+
+    console.log('[Ivanti] Syncing workflows...');
+
+    const urlPath = `/client/${encodeURIComponent(clientId)}/workflowBatch/search`;
+    const body = {
+        filters: [
+            {
+                field: 'created_by_last_name',
+                exclusive: false,
+                operator: 'IN',
+                orWithPrevious: false,
+                implicitFilters: [],
+                value: lastName,
+                caseSensitive: false
+            },
+            {
+                field: 'created_by_first_name',
+                exclusive: false,
+                operator: 'IN',
+                orWithPrevious: false,
+                implicitFilters: [],
+                value: firstName,
+                caseSensitive: false
+            }
+        ],
+        projection: 'internal',
+        sort: [{ field: 'created', direction: 'DESC' }],
+        page: 0,
+        size: 50
+    };
+
+    try {
+        const result = await ivantiPost(urlPath, body, apiKey, skipTls);
+
+        if (result.status === 401) {
+            throw new Error('Invalid or missing API key (401) — check IVANTI_API_KEY in .env');
+        }
+        if (result.status === 419) {
+            throw new Error('Insufficient privileges (419) — API key lacks workflow access');
+        }
+        if (result.status === 429) {
+            throw new Error('Rate limited (429) — will retry at next scheduled sync');
+        }
+        if (result.status !== 200) {
+            throw new Error(`Ivanti API returned unexpected status ${result.status}`);
+        }
+
+        const data = JSON.parse(result.body);
+
+        // Spring Data REST format: { _embedded: { workflowBatches: [...] }, page: { totalElements, ... } }
+        let total = 0;
+        let workflows = [];
+
+        if (data.page && typeof data.page.totalElements === 'number') {
+            total = data.page.totalElements;
+            workflows = data._embedded?.workflowBatches
+                || data._embedded?.workflowBatch
+                || [];
+        } else if (typeof data.total === 'number') {
+            total = data.total;
+            workflows = data.data || data.content || data.results || [];
+        } else if (typeof data.totalElements === 'number') {
+            total = data.totalElements;
+            workflows = data.content || data.data || [];
+        } else if (Array.isArray(data)) {
+            workflows = data;
+            total = data.length;
+        }
+
+        await new Promise((resolve, reject) => {
+            db.run(
+                `UPDATE ivanti_sync_state
+                 SET total=?, workflows_json=?, synced_at=datetime('now'), sync_status='success', error_message=NULL
+                 WHERE id=1`,
+                [total, JSON.stringify(workflows)],
+                (err) => { if (err) reject(err); else resolve(); }
+            );
+        });
+
+        console.log(`[Ivanti] Sync complete — ${total} workflows`);
+    } catch (err) {
+        const msg = err.message || 'Unknown error';
+        console.error('[Ivanti] Sync failed:', msg);
+        await new Promise((resolve) => {
+            db.run(
+                `UPDATE ivanti_sync_state SET sync_status='error', error_message=?, synced_at=datetime('now') WHERE id=1`,
+                [msg], resolve
+            );
+        });
+    }
+}
+
+// ---------------------------------------------------------------------------
+// Scheduler — runs sync immediately if >24h stale, then every 24h
+// ---------------------------------------------------------------------------
+function scheduleSync(db) {
+    db.get('SELECT synced_at FROM ivanti_sync_state WHERE id = 1', (err, row) => {
+        if (err || !row || !row.synced_at) {
+            syncWorkflows(db);
+        } else {
+            const lastSync = new Date(row.synced_at.replace(' ', 'T') + 'Z');
+            const hoursSince = (Date.now() - lastSync.getTime()) / (1000 * 60 * 60);
+            if (hoursSince >= 24) {
+                syncWorkflows(db);
+            } else {
+                const hoursUntil = (24 - hoursSince).toFixed(1);
+                console.log(`[Ivanti] Last sync ${hoursSince.toFixed(1)}h ago — next auto-sync in ${hoursUntil}h`);
+            }
+        }
+    });
+
+    setInterval(() => syncWorkflows(db), SYNC_INTERVAL_MS);
+}
+
+// ---------------------------------------------------------------------------
+// Helper — read current state from DB and return as JSON-ready object
+// ---------------------------------------------------------------------------
+function readState(db) {
+    return new Promise((resolve, reject) => {
+        db.get(
+            'SELECT total, workflows_json, synced_at, sync_status, error_message FROM ivanti_sync_state WHERE id = 1',
+            (err, row) => {
+                if (err) return reject(err);
+                if (!row) return resolve({ total: 0, workflows: [], synced_at: null, sync_status: 'never', error_message: null });
+
+                let workflows = [];
+                try { workflows = JSON.parse(row.workflows_json || '[]'); } catch (_) { /* leave empty */ }
+
+                resolve({
+                    total: row.total || 0,
+                    workflows,
+                    synced_at: row.synced_at,
+                    sync_status: row.sync_status,
+                    error_message: row.error_message
+                });
+            }
+        );
+    });
+}
+
+// ---------------------------------------------------------------------------
+// Router
+// ---------------------------------------------------------------------------
+function createIvantiWorkflowsRouter(db, requireAuth) {
+    const router = express.Router();
+
+    // Init table and kick off scheduler (fire-and-forget on startup)
+    initTable(db)
+        .then(() => scheduleSync(db))
+        .catch((err) => console.error('[Ivanti] Init failed:', err));
+
+    // All routes require authentication
+    router.use(requireAuth(db));
+
+    // GET / — return cached data (fast, no external call)
+    router.get('/', async (req, res) => {
+        try {
+            res.json(await readState(db));
+        } catch {
+            res.status(500).json({ error: 'Database error reading sync state' });
+        }
+    });
+
+    // POST /sync — trigger an immediate sync, await completion, return fresh state
+    router.post('/sync', async (req, res) => {
+        await syncWorkflows(db);
+        try {
+            res.json(await readState(db));
+        } catch {
+            res.status(500).json({ error: 'Sync ran but could not read updated state' });
+        }
+    });
+
+    return router;
+}
+
+module.exports = createIvantiWorkflowsRouter;
--- a/backend/routes/weeklyReports.js
+++ b/backend/routes/weeklyReports.js
@@ -1,261 +0,0 @@
-const express = require('express');
-const path = require('path');
-const fs = require('fs');
-const { requireAuth, requireRole } = require('../middleware/auth');
-const logAudit = require('../helpers/auditLog');
-const { processVulnerabilityReport } = require('../helpers/excelProcessor');
-
-function createWeeklyReportsRouter(db, upload) {
-  const router = express.Router();
-
-  // Helper to sanitize filename
-  function sanitizePathSegment(segment) {
-    if (!segment || typeof segment !== 'string') return '';
-    return segment
-      .replace(/\0/g, '')
-      .replace(/\.\./g, '')
-      .replace(/[\/\\]/g, '')
-      .trim();
-  }
-
-  // Helper to generate week label
-  function getWeekLabel(date) {
-    const now = new Date();
-    const uploadDate = new Date(date);
-    const daysDiff = Math.floor((now - uploadDate) / (1000 * 60 * 60 * 24));
-
-    if (daysDiff < 7) {
-      return "This week's report";
-    } else if (daysDiff < 14) {
-      return "Last week's report";
-    } else {
-      const month = uploadDate.getMonth() + 1;
-      const day = uploadDate.getDate();
-      const year = uploadDate.getFullYear();
-      return `Week of ${month.toString().padStart(2, '0')}/${day.toString().padStart(2, '0')}/${year}`;
-    }
-  }
-
-  // POST /api/weekly-reports/upload - Upload and process vulnerability report
-  router.post('/upload', requireAuth(db), requireRole(db, 'editor', 'admin'), upload.single('file'), async (req, res) => {
-    const uploadedFile = req.file;
-
-    if (!uploadedFile) {
-      return res.status(400).json({ error: 'No file uploaded' });
-    }
-
-    // Validate file extension
-    const ext = path.extname(uploadedFile.originalname).toLowerCase();
-    if (ext !== '.xlsx') {
-      fs.unlinkSync(uploadedFile.path); // Clean up temp file
-      return res.status(400).json({ error: 'Only .xlsx files are allowed' });
-    }
-
-    const timestamp = Date.now();
-    const sanitizedName = sanitizePathSegment(uploadedFile.originalname);
-    const reportsDir = path.join(__dirname, '..', 'uploads', 'weekly_reports');
-
-    // Create directory if it doesn't exist
-    if (!fs.existsSync(reportsDir)) {
-      fs.mkdirSync(reportsDir, { recursive: true });
-    }
-
-    const originalFilename = `${timestamp}_original_${sanitizedName}`;
-    const processedFilename = `${timestamp}_processed_${sanitizedName}`;
-    const originalPath = path.join(reportsDir, originalFilename);
-    const processedPath = path.join(reportsDir, processedFilename);
-
-    try {
-      // Move uploaded file to permanent location
-      fs.renameSync(uploadedFile.path, originalPath);
-
-      // Process the file with Python script
-      const result = await processVulnerabilityReport(originalPath, processedPath);
-
-      const uploadDate = new Date().toISOString().split('T')[0];
-
-      // Update previous current reports to not current
-      db.run('UPDATE weekly_reports SET is_current = 0 WHERE is_current = 1', (err) => {
-        if (err) {
-          console.error('Error updating previous current reports:', err);
-        }
-      });
-
-      // Insert new report record
-      const insertSql = `
-        INSERT INTO weekly_reports (
-          upload_date, week_label, original_filename, processed_filename,
-          original_file_path, processed_file_path, row_count_original,
-          row_count_processed, uploaded_by, is_current
-        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 1)
-      `;
-
-      const weekLabel = getWeekLabel(uploadDate);
-
-      db.run(
-        insertSql,
-        [
-          uploadDate,
-          weekLabel,
-          sanitizedName,
-          processedFilename,
-          originalPath,
-          processedPath,
-          result.original_rows,
-          result.processed_rows,
-          req.user.id
-        ],
-        function (err) {
-          if (err) {
-            console.error('Error inserting weekly report:', err);
-            return res.status(500).json({ error: 'Failed to save report metadata' });
-          }
-
-          // Log audit entry
-          logAudit(
-            db,
-            req.user.id,
-            req.user.username,
-            'UPLOAD_WEEKLY_REPORT',
-            'weekly_reports',
-            this.lastID,
-            JSON.stringify({ filename: sanitizedName, rows: result.processed_rows }),
-            req.ip
-          );
-
-          res.json({
-            success: true,
-            id: this.lastID,
-            original_rows: result.original_rows,
-            processed_rows: result.processed_rows,
-            week_label: weekLabel
-          });
-        }
-      );
-    } catch (error) {
-      // Clean up files on error
-      if (fs.existsSync(originalPath)) fs.unlinkSync(originalPath);
-      if (fs.existsSync(processedPath)) fs.unlinkSync(processedPath);
-
-      console.error('Error processing vulnerability report:', error);
-      res.status(500).json({ error: error.message || 'Failed to process report' });
-    }
-  });
-
-  // GET /api/weekly-reports - List all reports
-  router.get('/', requireAuth(db), (req, res) => {
-    const sql = `
-      SELECT id, upload_date, week_label, original_filename, processed_filename,
-             row_count_original, row_count_processed, is_current, uploaded_at
-      FROM weekly_reports
-      ORDER BY upload_date DESC, uploaded_at DESC
-    `;
-
-    db.all(sql, [], (err, rows) => {
-      if (err) {
-        console.error('Error fetching weekly reports:', err);
-        return res.status(500).json({ error: 'Failed to fetch reports' });
-      }
-
-      res.json(rows);
-    });
-  });
-
-  // GET /api/weekly-reports/:id/download/:type - Download report file
-  router.get('/:id/download/:type', requireAuth(db), (req, res) => {
-    const { id, type } = req.params;
-
-    if (type !== 'original' && type !== 'processed') {
-      return res.status(400).json({ error: 'Invalid download type. Use "original" or "processed"' });
-    }
-
-    const sql = `SELECT original_file_path, processed_file_path, original_filename FROM weekly_reports WHERE id = ?`;
-
-    db.get(sql, [id], (err, row) => {
-      if (err) {
-        console.error('Error fetching report:', err);
-        return res.status(500).json({ error: 'Failed to fetch report' });
-      }
-
-      if (!row) {
-        return res.status(404).json({ error: 'Report not found' });
-      }
-
-      const filePath = type === 'original' ? row.original_file_path : row.processed_file_path;
-
-      if (!fs.existsSync(filePath)) {
-        return res.status(404).json({ error: 'File not found on disk' });
-      }
-
-      // Log audit entry
-      logAudit(
-        db,
-        req.user.id,
-        req.user.username,
-        'DOWNLOAD_WEEKLY_REPORT',
-        'weekly_reports',
-        id,
-        JSON.stringify({ type }),
-        req.ip
-      );
-
-      const downloadName = type === 'original' ? row.original_filename : row.original_filename.replace('.xlsx', '_processed.xlsx');
-
-      res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
-      res.setHeader('Content-Disposition', `attachment; filename="${downloadName}"`);
-      res.sendFile(filePath);
-    });
-  });
-
-  // DELETE /api/weekly-reports/:id - Delete report (admin only)
-  router.delete('/:id', requireAuth(db), requireRole(db, 'admin'), (req, res) => {
-    const { id } = req.params;
-
-    const sql = 'SELECT original_file_path, processed_file_path FROM weekly_reports WHERE id = ?';
-
-    db.get(sql, [id], (err, row) => {
-      if (err) {
-        console.error('Error fetching report for deletion:', err);
-        return res.status(500).json({ error: 'Failed to fetch report' });
-      }
-
-      if (!row) {
-        return res.status(404).json({ error: 'Report not found' });
-      }
-
-      // Delete database record
-      db.run('DELETE FROM weekly_reports WHERE id = ?', [id], (err) => {
-        if (err) {
-          console.error('Error deleting report:', err);
-          return res.status(500).json({ error: 'Failed to delete report' });
-        }
-
-        // Delete files
-        if (fs.existsSync(row.original_file_path)) {
-          fs.unlinkSync(row.original_file_path);
-        }
-        if (fs.existsSync(row.processed_file_path)) {
-          fs.unlinkSync(row.processed_file_path);
-        }
-
-        // Log audit entry
-        logAudit(
-          db,
-          req.user.id,
-          req.user.username,
-          'DELETE_WEEKLY_REPORT',
-          'weekly_reports',
-          id,
-          null,
-          req.ip
-        );
-
-        res.json({ success: true });
-      });
-    });
-  });
-
-  return router;
-}
-
-module.exports = createWeeklyReportsRouter;
--- a/backend/scripts/split_cve_report.py
+++ b/backend/scripts/split_cve_report.py
@@ -1,83 +0,0 @@
-#!/usr/bin/env python3
-"""
-CVE Report Splitter
-Splits multiple CVE IDs in a single row into separate rows for easier filtering and analysis.
-"""
-
-import pandas as pd
-import sys
-from pathlib import Path
-
-def split_cve_report(input_file, output_file=None, sheet_name='Vulnerabilities', cve_column='CVE ID'):
-    """
-    Split CVE IDs into separate rows.
-
-    Args:
-        input_file: Path to input Excel file
-        output_file: Path to output file (default: adds '_Split' to input filename)
-        sheet_name: Name of sheet with vulnerability data (default: 'Vulnerabilities')
-        cve_column: Name of column containing CVE IDs (default: 'CVE ID')
-    """
-    input_path = Path(input_file)
-
-    if not input_path.exists():
-        print(f"Error: File not found: {input_file}")
-        sys.exit(1)
-
-    if output_file is None:
-        output_file = input_path.parent / f"{input_path.stem}_Split{input_path.suffix}"
-
-    print(f"Reading: {input_file}")
-
-    try:
-        df = pd.read_excel(input_file, sheet_name=sheet_name)
-    except ValueError as e:
-        print(f"Error: Sheet '{sheet_name}' not found in workbook")
-        print(f"Available sheets: {pd.ExcelFile(input_file).sheet_names}")
-        sys.exit(1)
-
-    if cve_column not in df.columns:
-        print(f"Error: Column '{cve_column}' not found")
-        print(f"Available columns: {list(df.columns)}")
-        sys.exit(1)
-
-    original_rows = len(df)
-    print(f"Original rows: {original_rows}")
-
-    # Split CVE IDs by comma
-    df[cve_column] = df[cve_column].astype(str).str.split(',')
-
-    # Explode to create separate rows
-    df_exploded = df.explode(cve_column)
-
-    # Clean up CVE IDs
-    df_exploded[cve_column] = df_exploded[cve_column].str.strip()
-    df_exploded = df_exploded[df_exploded[cve_column].notna()]
-    df_exploded = df_exploded[df_exploded[cve_column] != 'nan']
-    df_exploded = df_exploded[df_exploded[cve_column] != '']
-
-    # Reset index
-    df_exploded = df_exploded.reset_index(drop=True)
-
-    new_rows = len(df_exploded)
-    print(f"New rows: {new_rows}")
-    print(f"Added {new_rows - original_rows} rows from splitting CVEs")
-
-    # Save output
-    df_exploded.to_excel(output_file, index=False, sheet_name=sheet_name)
-    print(f"\n✓ Success! Saved to: {output_file}")
-
-    return output_file
-
-if __name__ == "__main__":
-    if len(sys.argv) < 2:
-        print("Usage: python3 split_cve_report.py <input_file.xlsx> [output_file.xlsx]")
-        print("\nExample:")
-        print("  python3 split_cve_report.py 'Vulnerability Workbook.xlsx'")
-        print("  python3 split_cve_report.py 'input.xlsx' 'output.xlsx'")
-        sys.exit(1)
-
-    input_file = sys.argv[1]
-    output_file = sys.argv[2] if len(sys.argv) > 2 else None
-
-    split_cve_report(input_file, output_file)
--- a/backend/server.js
+++ b/backend/server.js
@@ -18,8 +18,10 @@ const createUsersRouter = require('./routes/users');
 const createAuditLogRouter = require('./routes/auditLog');
 const logAudit = require('./helpers/auditLog');
 const createNvdLookupRouter = require('./routes/nvdLookup');
-const createWeeklyReportsRouter = require('./routes/weeklyReports');
 const createKnowledgeBaseRouter = require('./routes/knowledgeBase');
+const createArcherTicketsRouter = require('./routes/archerTickets');
+const createIvantiWorkflowsRouter = require('./routes/ivantiWorkflows');
+const createIvantiFindingsRouter = require('./routes/ivantiFindings');

 const app = express();
 const PORT = process.env.PORT || 3001;
@@ -173,12 +175,18 @@ const upload = multer({
    limits: { fileSize: 10 * 1024 * 1024 } // 10MB limit
 });

-// Weekly reports routes (editor/admin for upload, all authenticated for download)
-app.use('/api/weekly-reports', createWeeklyReportsRouter(db, upload));
-
 // Knowledge base routes (editor/admin for upload/delete, all authenticated for view)
 app.use('/api/knowledge-base', createKnowledgeBaseRouter(db, upload));

+// Archer tickets routes (editor/admin for create/update/delete, all authenticated for view)
+app.use('/api/archer-tickets', createArcherTicketsRouter(db));
+
+// Ivanti / RiskSense workflow routes (all authenticated users)
+app.use('/api/ivanti/workflows', createIvantiWorkflowsRouter(db, requireAuth));
+
+// Ivanti / RiskSense host findings routes (all authenticated users)
+app.use('/api/ivanti/findings', createIvantiFindingsRouter(db, requireAuth));
+
 // ========== CVE ENDPOINTS ==========

 // Get all CVEs with optional filters (authenticated users)
--- a/frontend/README.md
+++ b/frontend/README.md
@@ -1,70 +0,0 @@
-# Getting Started with Create React App
-
-This project was bootstrapped with [Create React App](https://github.com/facebook/create-react-app).
-
-## Available Scripts
-
-In the project directory, you can run:
-
-### `npm start`
-
-Runs the app in the development mode.\
-Open [http://localhost:3000](http://localhost:3000) to view it in your browser.
-
-The page will reload when you make changes.\
-You may also see any lint errors in the console.
-
-### `npm test`
-
-Launches the test runner in the interactive watch mode.\
-See the section about [running tests](https://facebook.github.io/create-react-app/docs/running-tests) for more information.
-
-### `npm run build`
-
-Builds the app for production to the `build` folder.\
-It correctly bundles React in production mode and optimizes the build for the best performance.
-
-The build is minified and the filenames include the hashes.\
-Your app is ready to be deployed!
-
-See the section about [deployment](https://facebook.github.io/create-react-app/docs/deployment) for more information.
-
-### `npm run eject`
-
-**Note: this is a one-way operation. Once you `eject`, you can't go back!**
-
-If you aren't satisfied with the build tool and configuration choices, you can `eject` at any time. This command will remove the single build dependency from your project.
-
-Instead, it will copy all the configuration files and the transitive dependencies (webpack, Babel, ESLint, etc) right into your project so you have full control over them. All of the commands except `eject` will still work, but they will point to the copied scripts so you can tweak them. At this point you're on your own.
-
-You don't have to ever use `eject`. The curated feature set is suitable for small and middle deployments, and you shouldn't feel obligated to use this feature. However we understand that this tool wouldn't be useful if you couldn't customize it when you are ready for it.
-
-## Learn More
-
-You can learn more in the [Create React App documentation](https://facebook.github.io/create-react-app/docs/getting-started).
-
-To learn React, check out the [React documentation](https://reactjs.org/).
-
-### Code Splitting
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/code-splitting](https://facebook.github.io/create-react-app/docs/code-splitting)
-
-### Analyzing the Bundle Size
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/analyzing-the-bundle-size](https://facebook.github.io/create-react-app/docs/analyzing-the-bundle-size)
-
-### Making a Progressive Web App
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/making-a-progressive-web-app](https://facebook.github.io/create-react-app/docs/making-a-progressive-web-app)
-
-### Advanced Configuration
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/advanced-configuration](https://facebook.github.io/create-react-app/docs/advanced-configuration)
-
-### Deployment
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/deployment](https://facebook.github.io/create-react-app/docs/deployment)
-
-### `npm run build` fails to minify
-
-This section has moved here: [https://facebook.github.io/create-react-app/docs/troubleshooting#npm-run-build-fails-to-minify](https://facebook.github.io/create-react-app/docs/troubleshooting#npm-run-build-fails-to-minify)
--- a/frontend/src/App.js
+++ b/frontend/src/App.js
@@ -1,14 +1,17 @@
 import React, { useState, useEffect } from 'react';
-import { Search, FileText, AlertCircle, Download, Upload, Eye, Filter, CheckCircle, XCircle, Loader, Trash2, Plus, RefreshCw, Edit2, ChevronDown } from 'lucide-react';
+import { Search, FileText, AlertCircle, Download, Upload, Eye, Filter, CheckCircle, XCircle, Loader, Trash2, Plus, RefreshCw, Edit2, ChevronDown, Shield, Activity, Menu } from 'lucide-react';
 import { useAuth } from './contexts/AuthContext';
 import LoginForm from './components/LoginForm';
 import UserMenu from './components/UserMenu';
 import UserManagement from './components/UserManagement';
 import AuditLog from './components/AuditLog';
 import NvdSyncModal from './components/NvdSyncModal';
-import WeeklyReportModal from './components/WeeklyReportModal';
 import KnowledgeBaseModal from './components/KnowledgeBaseModal';
 import KnowledgeBaseViewer from './components/KnowledgeBaseViewer';
+import NavDrawer from './components/NavDrawer';
+import ReportingPage from './components/pages/ReportingPage';
+import KnowledgeBasePage from './components/pages/KnowledgeBasePage';
+import ExportsPage from './components/pages/ExportsPage';
 import './App.css';

 const API_BASE = process.env.REACT_APP_API_BASE || 'http://localhost:3001/api';
@@ -172,11 +175,12 @@ export default function App() {
  const [cveDocuments, setCveDocuments] = useState({});
  const [quickCheckCVE, setQuickCheckCVE] = useState('');
  const [quickCheckResult, setQuickCheckResult] = useState(null);
+  const [currentPage, setCurrentPage] = useState('home');
+  const [navOpen, setNavOpen] = useState(false);
  const [showAddCVE, setShowAddCVE] = useState(false);
  const [showUserManagement, setShowUserManagement] = useState(false);
  const [showAuditLog, setShowAuditLog] = useState(false);
  const [showNvdSync, setShowNvdSync] = useState(false);
-  const [showWeeklyReport, setShowWeeklyReport] = useState(false);
  const [showKnowledgeBase, setShowKnowledgeBase] = useState(false);
  const [knowledgeBaseArticles, setKnowledgeBaseArticles] = useState([]);
  const [selectedKBArticle, setSelectedKBArticle] = useState(null);
@@ -200,6 +204,7 @@ export default function App() {
  const [editNvdError, setEditNvdError] = useState(null);
  const [editNvdAutoFilled, setEditNvdAutoFilled] = useState(false);
  const [expandedCVEs, setExpandedCVEs] = useState({});
+  const [visibleCount, setVisibleCount] = useState(5);
  const [jiraTickets, setJiraTickets] = useState([]);
  const [showAddTicket, setShowAddTicket] = useState(false);
  const [showEditTicket, setShowEditTicket] = useState(false);
@@ -210,6 +215,25 @@ export default function App() {
  // For adding ticket from within a CVE card
  const [addTicketContext, setAddTicketContext] = useState(null); // { cve_id, vendor }

+  // Archer tickets state
+  const [archerTickets, setArcherTickets] = useState([]);
+  const [showAddArcherTicket, setShowAddArcherTicket] = useState(false);
+  const [showEditArcherTicket, setShowEditArcherTicket] = useState(false);
+  const [editingArcherTicket, setEditingArcherTicket] = useState(null);
+  const [archerTicketForm, setArcherTicketForm] = useState({
+    exc_number: '', archer_url: '', status: 'Draft', cve_id: '', vendor: ''
+  });
+  const [addArcherTicketContext, setAddArcherTicketContext] = useState(null); // { cve_id, vendor }
+
+  // Ivanti workflows state
+  const [ivantiTotal, setIvantiTotal] = useState(null);
+  const [ivantiWorkflows, setIvantiWorkflows] = useState([]);
+  const [ivantiSyncedAt, setIvantiSyncedAt] = useState(null);
+  const [ivantiSyncStatus, setIvantiSyncStatus] = useState(null);
+  const [ivantiSyncError, setIvantiSyncError] = useState(null);
+  const [ivantiLoading, setIvantiLoading] = useState(false);
+  const [ivantiSyncing, setIvantiSyncing] = useState(false);
+
  const toggleCVEExpand = (cveId) => {
    setExpandedCVEs(prev => ({ ...prev, [cveId]: !prev[cveId] }));
  };
@@ -309,6 +333,56 @@ export default function App() {
    }
  };

+  const fetchArcherTickets = async () => {
+    try {
+      const response = await fetch(`${API_BASE}/archer-tickets`, {
+        credentials: 'include'
+      });
+      if (!response.ok) throw new Error('Failed to fetch Archer tickets');
+      const data = await response.json();
+      setArcherTickets(data);
+    } catch (err) {
+      console.error('Error fetching Archer tickets:', err);
+    }
+  };
+
+  const applyIvantiState = (data) => {
+    setIvantiTotal(data.total ?? 0);
+    setIvantiWorkflows(data.workflows || []);
+    setIvantiSyncedAt(data.synced_at || null);
+    setIvantiSyncStatus(data.sync_status || null);
+    setIvantiSyncError(data.error_message || null);
+  };
+
+  const fetchIvantiWorkflows = async () => {
+    setIvantiLoading(true);
+    try {
+      const response = await fetch(`${API_BASE}/ivanti/workflows`, { credentials: 'include' });
+      const data = await response.json();
+      if (response.ok) applyIvantiState(data);
+    } catch (err) {
+      console.error('Error loading Ivanti workflows:', err);
+    } finally {
+      setIvantiLoading(false);
+    }
+  };
+
+  const syncIvantiWorkflows = async () => {
+    setIvantiSyncing(true);
+    try {
+      const response = await fetch(`${API_BASE}/ivanti/workflows/sync`, {
+        method: 'POST',
+        credentials: 'include'
+      });
+      const data = await response.json();
+      if (response.ok) applyIvantiState(data);
+    } catch (err) {
+      console.error('Error syncing Ivanti workflows:', err);
+    } finally {
+      setIvantiSyncing(false);
+    }
+  };
+
  const fetchDocuments = async (cveId, vendor) => {
    const key = `${cveId}-${vendor}`;
    if (cveDocuments[key]) return;
@@ -745,12 +819,99 @@ export default function App() {
    setShowAddTicket(true);
  };

+  // ========== ARCHER TICKET HANDLERS ==========
+
+  const handleAddArcherTicket = async (e) => {
+    e.preventDefault();
+    try {
+      const response = await fetch(`${API_BASE}/archer-tickets`, {
+        method: 'POST',
+        headers: { 'Content-Type': 'application/json' },
+        credentials: 'include',
+        body: JSON.stringify(archerTicketForm)
+      });
+      if (!response.ok) {
+        const data = await response.json();
+        throw new Error(data.error || 'Failed to create Archer ticket');
+      }
+      alert('Archer ticket added successfully!');
+      setShowAddArcherTicket(false);
+      setAddArcherTicketContext(null);
+      setArcherTicketForm({ exc_number: '', archer_url: '', status: 'Draft', cve_id: '', vendor: '' });
+      fetchArcherTickets();
+    } catch (err) {
+      alert(`Error: ${err.message}`);
+    }
+  };
+
+  const handleEditArcherTicket = (ticket) => {
+    setEditingArcherTicket(ticket);
+    setArcherTicketForm({
+      exc_number: ticket.exc_number,
+      archer_url: ticket.archer_url || '',
+      status: ticket.status,
+      cve_id: ticket.cve_id,
+      vendor: ticket.vendor
+    });
+    setShowEditArcherTicket(true);
+  };
+
+  const handleUpdateArcherTicket = async (e) => {
+    e.preventDefault();
+    try {
+      const response = await fetch(`${API_BASE}/archer-tickets/${editingArcherTicket.id}`, {
+        method: 'PUT',
+        headers: { 'Content-Type': 'application/json' },
+        credentials: 'include',
+        body: JSON.stringify({
+          exc_number: archerTicketForm.exc_number,
+          archer_url: archerTicketForm.archer_url,
+          status: archerTicketForm.status
+        })
+      });
+      if (!response.ok) {
+        const data = await response.json();
+        throw new Error(data.error || 'Failed to update Archer ticket');
+      }
+      alert('Archer ticket updated!');
+      setShowEditArcherTicket(false);
+      setEditingArcherTicket(null);
+      setArcherTicketForm({ exc_number: '', archer_url: '', status: 'Draft', cve_id: '', vendor: '' });
+      fetchArcherTickets();
+    } catch (err) {
+      alert(`Error: ${err.message}`);
+    }
+  };
+
+  const handleDeleteArcherTicket = async (ticket) => {
+    if (!window.confirm(`Delete Archer ticket ${ticket.exc_number}?`)) return;
+    try {
+      const response = await fetch(`${API_BASE}/archer-tickets/${ticket.id}`, {
+        method: 'DELETE',
+        credentials: 'include'
+      });
+      if (!response.ok) throw new Error('Failed to delete Archer ticket');
+      alert('Archer ticket deleted');
+      fetchArcherTickets();
+    } catch (err) {
+      alert(`Error: ${err.message}`);
+    }
+  };
+
+  const openAddArcherTicketForCVE = (cve_id, vendor) => {
+    setAddArcherTicketContext({ cve_id, vendor });
+    setArcherTicketForm({ exc_number: '', archer_url: '', status: 'Draft', cve_id, vendor });
+    setShowAddArcherTicket(true);
+  };
+
  // Fetch CVEs from API when authenticated
  useEffect(() => {
    if (isAuthenticated) {
      fetchCVEs();
      fetchVendors();
      fetchJiraTickets();
+      fetchArcherTickets();
+      fetchIvantiWorkflows();
      fetchKnowledgeBaseArticles();
    }
    // eslint-disable-next-line react-hooks/exhaustive-deps
@@ -760,6 +921,7 @@ export default function App() {
  useEffect(() => {
    if (isAuthenticated) {
      fetchCVEs();
+      setVisibleCount(5);
    }
    // eslint-disable-next-line react-hooks/exhaustive-deps
  }, [searchQuery, selectedVendor, selectedSeverity]);
@@ -794,6 +956,12 @@ export default function App() {

  return (
    <div className="min-h-screen bg-intel-darkest grid-bg p-6 relative overflow-hidden fade-in">
+      <NavDrawer
+        isOpen={navOpen}
+        onClose={() => setNavOpen(false)}
+        currentPage={currentPage}
+        onNavigate={setCurrentPage}
+      />
      {/* Scanning line effect */}
      <div className="scan-line"></div>

@@ -801,11 +969,22 @@ export default function App() {
        {/* Header */}
        <div className="mb-8">
          <div className="flex justify-between items-start mb-6">
-            <div className="flex-1">
-              <h1 className="text-4xl font-bold text-intel-accent mb-1 font-mono tracking-tight">
-                CVE INTEL
-              </h1>
-              <p className="text-gray-400 text-sm font-sans">Threat Intelligence & Vulnerability Command Center</p>
+            <div className="flex items-center gap-4 flex-1">
+              <button
+                onClick={() => setNavOpen(true)}
+                style={{ background: 'none', border: '1px solid rgba(14, 165, 233, 0.25)', borderRadius: '0.375rem', padding: '0.5rem', cursor: 'pointer', color: '#64748B', flexShrink: 0 }}
+                onMouseEnter={e => { e.currentTarget.style.color = '#0EA5E9'; e.currentTarget.style.borderColor = 'rgba(14, 165, 233, 0.6)'; }}
+                onMouseLeave={e => { e.currentTarget.style.color = '#64748B'; e.currentTarget.style.borderColor = 'rgba(14, 165, 233, 0.25)'; }}
+                title="Navigation"
+              >
+                <Menu className="w-5 h-5" />
+              </button>
+              <div>
+                <h1 className="text-4xl font-bold text-intel-accent mb-1 font-mono tracking-tight">
+                  STEAM Security Dashboard
+                </h1>
+                <p className="text-gray-400 text-sm font-sans">NTS Threat Intelligence and Metric Aggregation</p>
+              </div>
            </div>
            <div className="flex items-center gap-3">
              {canWrite() && (
@@ -817,15 +996,6 @@ export default function App() {
                  NVD Sync
                </button>
              )}
-              {canWrite() && (
-                <button
-                  onClick={() => setShowWeeklyReport(true)}
-                  className="intel-button intel-button-success relative z-10 flex items-center gap-2"
-                >
-                  <Upload className="w-4 h-4" />
-                  Weekly Report
-                </button>
-              )}
              {canWrite() && (
                <button
                  onClick={() => setShowAddCVE(true)}
@@ -839,8 +1009,8 @@ export default function App() {
            </div>
          </div>

-          {/* Stats Bar - Modern refined styling */}
-          <div className="grid grid-cols-1 md:grid-cols-4 gap-4">
+          {/* Stats Bar - only shown on Home page */}
+          {currentPage === 'home' && <div className="grid grid-cols-1 md:grid-cols-4 gap-4">
            <div style={STYLES.statCard}>
              <div style={{ position: 'absolute', top: 0, left: 0, right: 0, height: '2px', background: 'linear-gradient(90deg, transparent, #0EA5E9, transparent)', boxShadow: '0 0 8px rgba(14, 165, 233, 0.5)' }}></div>
              <div style={{ fontSize: '0.75rem', textTransform: 'uppercase', letterSpacing: '0.1em', color: '#CBD5E1', marginBottom: '0.25rem' }}>Total CVEs</div>
@@ -861,9 +1031,14 @@ export default function App() {
              <div style={{ fontSize: '0.75rem', textTransform: 'uppercase', letterSpacing: '0.1em', color: '#CBD5E1', marginBottom: '0.25rem' }}>Critical</div>
              <div style={{ fontSize: '1.5rem', fontWeight: '700', fontFamily: 'monospace', color: '#EF4444', textShadow: '0 0 16px rgba(239, 68, 68, 0.4)' }}>{cves.filter(c => c.severity === 'Critical').length}</div>
            </div>
-          </div>
+          </div>}
        </div>

+        {/* Page content */}
+        {currentPage === 'reporting'      && <ReportingPage />}
+        {currentPage === 'knowledge-base' && <KnowledgeBasePage />}
+        {currentPage === 'exports'        && <ExportsPage />}
+
        {/* User Management Modal */}
        {showUserManagement && (
          <UserManagement onClose={() => setShowUserManagement(false)} />
@@ -879,11 +1054,6 @@ export default function App() {
          <NvdSyncModal onClose={() => setShowNvdSync(false)} onSyncComplete={() => fetchCVEs()} />
        )}

-        {/* Weekly Report Modal */}
-        {showWeeklyReport && (
-          <WeeklyReportModal onClose={() => setShowWeeklyReport(false)} />
-        )}
-
        {/* Knowledge Base Modal */}
        {showKnowledgeBase && (
          <KnowledgeBaseModal
@@ -1337,8 +1507,153 @@ export default function App() {
          </div>
        )}

-        {/* Three Column Layout */}
-        <div className="grid grid-cols-12 gap-6">
+        {/* Add Archer Ticket Modal */}
+        {showAddArcherTicket && (
+          <div className="fixed inset-0 modal-overlay flex items-center justify-center z-50 p-4">
+            <div className="intel-card rounded-lg shadow-2xl max-w-md w-full border-purple-500">
+              <div className="p-6">
+                <div className="flex justify-between items-center mb-4">
+                  <h2 className="text-xl font-bold text-purple-400 font-mono">Add Archer Risk Ticket</h2>
+                  <button onClick={() => { setShowAddArcherTicket(false); setAddArcherTicketContext(null); }} className="text-gray-400 hover:text-intel-accent transition-colors">
+                    <XCircle className="w-6 h-6" />
+                  </button>
+                </div>
+                <form onSubmit={handleAddArcherTicket} className="space-y-4">
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">EXC Number *</label>
+                    <input
+                      type="text"
+                      required
+                      placeholder="EXC-5754"
+                      value={archerTicketForm.exc_number}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, exc_number: e.target.value.toUpperCase()})}
+                      className="intel-input w-full"
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">Archer URL</label>
+                    <input
+                      type="url"
+                      placeholder="https://archer.example.com/..."
+                      value={archerTicketForm.archer_url}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, archer_url: e.target.value})}
+                      className="intel-input w-full"
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">CVE ID *</label>
+                    <input
+                      type="text"
+                      required
+                      placeholder="CVE-2024-1234"
+                      value={archerTicketForm.cve_id}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, cve_id: e.target.value.toUpperCase()})}
+                      className="intel-input w-full"
+                      readOnly={!!addArcherTicketContext}
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">Vendor *</label>
+                    <input
+                      type="text"
+                      required
+                      placeholder="Vendor name"
+                      value={archerTicketForm.vendor}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, vendor: e.target.value})}
+                      className="intel-input w-full"
+                      readOnly={!!addArcherTicketContext}
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">Status</label>
+                    <select
+                      value={archerTicketForm.status}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, status: e.target.value})}
+                      className="intel-input w-full"
+                    >
+                      <option value="Draft">Draft</option>
+                      <option value="Open">Open</option>
+                      <option value="Under Review">Under Review</option>
+                      <option value="Accepted">Accepted</option>
+                    </select>
+                  </div>
+                  <div className="flex gap-3 pt-4">
+                    <button type="submit" className="flex-1 intel-button intel-button-primary">
+                      Create Ticket
+                    </button>
+                    <button type="button" onClick={() => { setShowAddArcherTicket(false); setAddArcherTicketContext(null); }} className="px-4 py-2 bg-intel-dark text-gray-400 rounded border border-gray-600 hover:bg-intel-medium transition-colors font-mono text-sm uppercase tracking-wider">
+                      Cancel
+                    </button>
+                  </div>
+                </form>
+              </div>
+            </div>
+          </div>
+        )}
+
+        {/* Edit Archer Ticket Modal */}
+        {showEditArcherTicket && editingArcherTicket && (
+          <div className="fixed inset-0 modal-overlay flex items-center justify-center z-50 p-4">
+            <div className="intel-card rounded-lg shadow-2xl max-w-md w-full border-purple-500">
+              <div className="p-6">
+                <div className="flex justify-between items-center mb-4">
+                  <h2 className="text-xl font-bold text-purple-400 font-mono">Edit Archer Risk Ticket</h2>
+                  <button onClick={() => { setShowEditArcherTicket(false); setEditingArcherTicket(null); }} className="text-gray-400 hover:text-intel-accent transition-colors">
+                    <XCircle className="w-6 h-6" />
+                  </button>
+                </div>
+                <div className="p-3 bg-intel-medium rounded text-sm text-white mb-4 font-mono">
+                  {editingArcherTicket.cve_id} / {editingArcherTicket.vendor}
+                </div>
+                <form onSubmit={handleUpdateArcherTicket} className="space-y-4">
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">EXC Number *</label>
+                    <input
+                      type="text"
+                      required
+                      value={archerTicketForm.exc_number}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, exc_number: e.target.value.toUpperCase()})}
+                      className="intel-input w-full"
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">Archer URL</label>
+                    <input
+                      type="url"
+                      value={archerTicketForm.archer_url}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, archer_url: e.target.value})}
+                      className="intel-input w-full"
+                    />
+                  </div>
+                  <div>
+                    <label className="block text-xs font-medium text-gray-300 mb-2 uppercase tracking-wider">Status</label>
+                    <select
+                      value={archerTicketForm.status}
+                      onChange={(e) => setArcherTicketForm({...archerTicketForm, status: e.target.value})}
+                      className="intel-input w-full"
+                    >
+                      <option value="Draft">Draft</option>
+                      <option value="Open">Open</option>
+                      <option value="Under Review">Under Review</option>
+                      <option value="Accepted">Accepted</option>
+                    </select>
+                  </div>
+                  <div className="flex gap-3 pt-4">
+                    <button type="submit" className="flex-1 intel-button intel-button-primary">
+                      Save Changes
+                    </button>
+                    <button type="button" onClick={() => { setShowEditArcherTicket(false); setEditingArcherTicket(null); }} className="px-4 py-2 bg-intel-dark text-gray-400 rounded border border-gray-600 hover:bg-intel-medium transition-colors font-mono text-sm uppercase tracking-wider">
+                      Cancel
+                    </button>
+                  </div>
+                </form>
+              </div>
+            </div>
+          </div>
+        )}
+
+        {/* Three Column Layout - Home page only */}
+        {currentPage === 'home' && <div className="grid grid-cols-12 gap-6">
          {/* LEFT PANEL - Wiki/Knowledge Base */}
          <div className="col-span-12 lg:col-span-3 space-y-4">
            <div style={{...STYLES.intelCard, padding: '1.5rem', borderLeft: '3px solid #10B981'}} className="rounded-lg">
@@ -1575,7 +1890,7 @@ export default function App() {
              </div>
            ) : (
              <div className="space-y-4">
-            {Object.entries(filteredGroupedCVEs).map(([cveId, vendorEntries]) => {
+            {Object.entries(filteredGroupedCVEs).slice(0, visibleCount).map(([cveId, vendorEntries]) => {
              const isCVEExpanded = expandedCVEs[cveId];
              const severityOrder = { 'Critical': 0, 'High': 1, 'Medium': 2, 'Low': 3 };
              const highestSeverity = vendorEntries.reduce((highest, entry) => {
@@ -1847,6 +2162,40 @@ export default function App() {
              </div>
              );
            })}
+            {/* Show more / pagination footer */}
+            {Object.keys(filteredGroupedCVEs).length > visibleCount && (
+              <div className="flex items-center justify-between pt-2">
+                <span className="text-gray-500 font-mono text-xs">
+                  Showing {visibleCount} of {Object.keys(filteredGroupedCVEs).length} CVEs
+                </span>
+                <div className="flex gap-2">
+                  <button
+                    onClick={() => setVisibleCount(v => v + 5)}
+                    className="intel-button intel-button-primary text-xs px-3 py-1"
+                  >
+                    Show 5 more
+                  </button>
+                  <button
+                    onClick={() => setVisibleCount(Object.keys(filteredGroupedCVEs).length)}
+                    className="intel-button text-xs px-3 py-1"
+                    style={{ background: 'rgba(255,255,255,0.05)', border: '1px solid rgba(255,255,255,0.1)', color: '#94A3B8' }}
+                  >
+                    Show all
+                  </button>
+                </div>
+              </div>
+            )}
+            {visibleCount > 5 && Object.keys(filteredGroupedCVEs).length <= visibleCount && Object.keys(filteredGroupedCVEs).length > 5 && (
+              <div className="flex justify-end pt-2">
+                <button
+                  onClick={() => setVisibleCount(5)}
+                  className="intel-button text-xs px-3 py-1"
+                  style={{ background: 'rgba(255,255,255,0.05)', border: '1px solid rgba(255,255,255,0.1)', color: '#94A3B8' }}
+                >
+                  Collapse
+                </button>
+              </div>
+            )}
              </div>
            )}

@@ -1993,10 +2342,165 @@ export default function App() {
                )}
              </div>
            </div>
+
+            {/* Archer Risk Acceptance Tickets */}
+            <div style={{...STYLES.intelCard, padding: '1.5rem', borderLeft: '3px solid #8B5CF6'}} className="rounded-lg">
+              <div className="flex justify-between items-center mb-4">
+                <h2 style={{ fontSize: '1.125rem', fontWeight: '600', color: '#8B5CF6', display: 'flex', alignItems: 'center', gap: '0.5rem', fontFamily: 'monospace', textTransform: 'uppercase', letterSpacing: '0.1em', textShadow: '0 0 12px rgba(139, 92, 246, 0.4)' }}>
+                  <Shield className="w-5 h-5" />
+                  Archer Risk Tickets
+                </h2>
+                {canWrite() && (
+                  <button
+                    onClick={() => { setAddArcherTicketContext(null); setArcherTicketForm({ exc_number: '', archer_url: '', status: 'Draft', cve_id: '', vendor: '' }); setShowAddArcherTicket(true); }}
+                    className="intel-button intel-button-primary flex items-center gap-1 text-xs px-2 py-1"
+                  >
+                    <Plus className="w-3 h-3" />
+                  </button>
+                )}
+              </div>
+              <div className="text-center mb-3">
+                <div style={{ fontSize: '2rem', fontWeight: '700', fontFamily: 'monospace', color: '#8B5CF6', textShadow: '0 0 16px rgba(139, 92, 246, 0.4)' }}>
+                  {archerTickets.filter(t => t.status !== 'Accepted').length}
+                </div>
+                <div className="text-xs text-gray-400 uppercase tracking-wider">Active</div>
+              </div>
+              <div className="space-y-2 max-h-96 overflow-y-auto">
+                {archerTickets.filter(t => t.status !== 'Accepted').slice(0, 10).map(ticket => (
+                  <div key={ticket.id} style={{ background: 'linear-gradient(135deg, rgba(30, 41, 59, 0.85) 0%, rgba(51, 65, 85, 0.75) 100%)', border: '1px solid rgba(139, 92, 246, 0.25)', borderRadius: '0.375rem', padding: '0.5rem', boxShadow: '0 2px 6px rgba(0, 0, 0, 0.25), inset 0 1px 0 rgba(255, 255, 255, 0.03)' }}>
+                    <div className="flex items-start justify-between gap-2 mb-1">
+                      <a
+                        href={ticket.archer_url || '#'}
+                        target="_blank"
+                        rel="noopener noreferrer"
+                        className="font-mono text-xs font-semibold text-intel-accent hover:text-purple-400 transition-colors"
+                      >
+                        {ticket.exc_number}
+                      </a>
+                      {canWrite() && (
+                        <div className="flex gap-1">
+                          <button onClick={() => handleEditArcherTicket(ticket)} className="text-gray-400 hover:text-purple-400 transition-colors">
+                            <Edit2 className="w-3 h-3" />
+                          </button>
+                          <button onClick={() => handleDeleteArcherTicket(ticket)} className="text-gray-400 hover:text-intel-danger transition-colors">
+                            <Trash2 className="w-3 h-3" />
+                          </button>
+                        </div>
+                      )}
+                    </div>
+                    <div className="text-xs text-white font-mono mb-1">{ticket.cve_id}</div>
+                    <div className="text-xs text-gray-400">{ticket.vendor}</div>
+                    <div className="mt-2">
+                      <span style={{ ...STYLES.badgeHigh, fontSize: '0.65rem', padding: '0.25rem 0.5rem', background: 'rgba(139, 92, 246, 0.2)', borderColor: '#8B5CF6' }}>
+                        <span style={{...STYLES.glowDot('#8B5CF6'), width: '6px', height: '6px'}}></span>
+                        {ticket.status}
+                      </span>
+                    </div>
+                  </div>
+                ))}
+                {archerTickets.filter(t => t.status !== 'Accepted').length === 0 && (
+                  <div className="text-center py-8">
+                    <CheckCircle className="w-8 h-8 text-intel-success mx-auto mb-2" />
+                    <p className="text-sm text-gray-400 italic font-mono">No active Archer tickets</p>
+                  </div>
+                )}
+              </div>
+            </div>
+
+            {/* Ivanti Workflows */}
+            <div style={{...STYLES.intelCard, padding: '1.5rem', borderLeft: '3px solid #0D9488'}} className="rounded-lg">
+              <div className="flex justify-between items-center mb-1">
+                <h2 style={{ fontSize: '1.125rem', fontWeight: '600', color: '#0D9488', display: 'flex', alignItems: 'center', gap: '0.5rem', fontFamily: 'monospace', textTransform: 'uppercase', letterSpacing: '0.1em', textShadow: '0 0 12px rgba(13, 148, 136, 0.4)' }}>
+                  <Activity className="w-5 h-5" />
+                  Ivanti Workflows
+                </h2>
+                <button
+                  onClick={syncIvantiWorkflows}
+                  disabled={ivantiSyncing || ivantiLoading}
+                  className="intel-button intel-button-primary flex items-center gap-1 text-xs px-2 py-1"
+                  title="Sync now"
+                >
+                  <RefreshCw className={`w-3 h-3 ${ivantiSyncing ? 'animate-spin' : ''}`} />
+                  {ivantiSyncing ? 'Syncing…' : 'Sync'}
+                </button>
+              </div>
+
+              {/* Last synced line */}
+              <div className="text-xs text-gray-500 font-mono mb-4">
+                {ivantiSyncedAt
+                  ? `Synced ${new Date(ivantiSyncedAt.replace(' ', 'T') + 'Z').toLocaleString()}`
+                  : 'Never synced'}
+              </div>
+
+              {ivantiLoading ? (
+                <div className="text-center py-8">
+                  <Loader className="w-6 h-6 text-teal-400 animate-spin mx-auto mb-2" />
+                  <p className="text-xs text-gray-400 font-mono">Loading...</p>
+                </div>
+              ) : ivantiSyncStatus === 'error' ? (
+                <>
+                  <div className="text-center mb-3">
+                    <div style={{ fontSize: '2rem', fontWeight: '700', fontFamily: 'monospace', color: '#0D9488', textShadow: '0 0 16px rgba(13, 148, 136, 0.4)' }}>
+                      {ivantiTotal ?? '—'}
+                    </div>
+                    <div className="text-xs text-gray-400 uppercase tracking-wider">Total Workflows</div>
+                  </div>
+                  <div className="flex items-start gap-2 p-2 rounded" style={{ background: 'rgba(239, 68, 68, 0.1)', border: '1px solid rgba(239, 68, 68, 0.3)' }}>
+                    <AlertCircle className="w-4 h-4 text-intel-danger mt-0.5 shrink-0" />
+                    <p className="text-xs text-red-400 font-mono">{ivantiSyncError}</p>
+                  </div>
+                </>
+              ) : (
+                <>
+                  <div className="text-center mb-3">
+                    <div style={{ fontSize: '2rem', fontWeight: '700', fontFamily: 'monospace', color: '#0D9488', textShadow: '0 0 16px rgba(13, 148, 136, 0.4)' }}>
+                      {ivantiSyncStatus === 'never' ? '—' : (ivantiTotal ?? '—')}
+                    </div>
+                    <div className="text-xs text-gray-400 uppercase tracking-wider">Total Workflows</div>
+                  </div>
+                  <div className="space-y-2 max-h-64 overflow-y-auto">
+                    {ivantiWorkflows.slice(0, 10).map((wf, idx) => (
+                      <div key={wf.uuid ?? idx} style={{ background: 'linear-gradient(135deg, rgba(30, 41, 59, 0.85) 0%, rgba(51, 65, 85, 0.75) 100%)', border: '1px solid rgba(13, 148, 136, 0.25)', borderRadius: '0.375rem', padding: '0.5rem', boxShadow: '0 2px 6px rgba(0, 0, 0, 0.25), inset 0 1px 0 rgba(255, 255, 255, 0.03)' }}>
+                        <div className="flex items-start justify-between gap-2 mb-1">
+                          <span className="font-mono text-xs font-semibold text-teal-300">
+                            {wf.id?.value || wf.uuid?.slice(0, 8)}
+                          </span>
+                          {wf.currentState && (
+                            <span style={{ fontSize: '0.65rem', padding: '0.2rem 0.4rem', borderRadius: '0.25rem', background: 'rgba(13, 148, 136, 0.2)', border: '1px solid #0D9488', color: '#0D9488', whiteSpace: 'nowrap', fontFamily: 'monospace' }}>
+                              {wf.currentState}
+                            </span>
+                          )}
+                        </div>
+                        <div className="text-xs text-white truncate mb-1">{wf.name}</div>
+                        <div className="flex items-center justify-between gap-2">
+                          {wf.type && (
+                            <span className="text-xs text-gray-400 font-mono">{wf.type.replace(/_/g, ' ')}</span>
+                          )}
+                          {wf.createdOn && (
+                            <span className="text-xs text-gray-500">{wf.createdOn}</span>
+                          )}
+                        </div>
+                      </div>
+                    ))}
+                    {ivantiSyncStatus !== 'never' && ivantiTotal === 0 && (
+                      <div className="text-center py-8">
+                        <CheckCircle className="w-8 h-8 text-intel-success mx-auto mb-2" />
+                        <p className="text-sm text-gray-400 italic font-mono">No workflows found</p>
+                      </div>
+                    )}
+                    {ivantiSyncStatus === 'never' && (
+                      <div className="text-center py-6">
+                        <p className="text-xs text-gray-500 font-mono">Click Sync to load workflow data</p>
+                      </div>
+                    )}
+                  </div>
+                </>
+              )}
+            </div>
          </div>
          {/* End Right Panel */}

-        </div>
+        </div>}
        {/* End Three Column Layout */}
      </div>
    </div>
--- a/frontend/src/components/NavDrawer.js
+++ b/frontend/src/components/NavDrawer.js
@@ -0,0 +1,127 @@
+import React from 'react';
+import { X, Home, BarChart2, BookOpen, Download } from 'lucide-react';
+
+const NAV_ITEMS = [
+  { id: 'home',           label: 'Home',           icon: Home,     color: '#0EA5E9', description: 'Main dashboard'            },
+  { id: 'reporting',      label: 'Reporting',      icon: BarChart2,color: '#F59E0B', description: 'Reports & analytics'       },
+  { id: 'knowledge-base', label: 'Knowledge Base', icon: BookOpen, color: '#10B981', description: 'Articles & documentation'   },
+  { id: 'exports',        label: 'Exports',        icon: Download, color: '#8B5CF6', description: 'Export data & reports'      },
+];
+
+export default function NavDrawer({ isOpen, onClose, currentPage, onNavigate }) {
+  if (!isOpen) return null;
+
+  return (
+    <>
+      {/* Backdrop */}
+      <div
+        onClick={onClose}
+        style={{
+          position: 'fixed', inset: 0,
+          background: 'rgba(0, 0, 0, 0.65)',
+          backdropFilter: 'blur(3px)',
+          zIndex: 50
+        }}
+      />
+
+      {/* Drawer */}
+      <div style={{
+        position: 'fixed', top: 0, left: 0, bottom: 0, width: '280px',
+        background: 'linear-gradient(180deg, #0F1A2E 0%, #0A1628 100%)',
+        borderRight: '1px solid rgba(14, 165, 233, 0.2)',
+        boxShadow: '6px 0 32px rgba(0, 0, 0, 0.7)',
+        zIndex: 51,
+        display: 'flex', flexDirection: 'column',
+        padding: '1.5rem'
+      }}>
+        {/* Drawer header */}
+        <div style={{ display: 'flex', justifyContent: 'space-between', alignItems: 'flex-start', marginBottom: '2rem' }}>
+          <div>
+            <div style={{ fontFamily: 'monospace', fontSize: '1rem', fontWeight: '700', color: '#0EA5E9', textTransform: 'uppercase', letterSpacing: '0.15em', textShadow: '0 0 12px rgba(14, 165, 233, 0.5)' }}>
+              STEAM
+            </div>
+            <div style={{ fontFamily: 'monospace', fontSize: '0.65rem', color: '#475569', textTransform: 'uppercase', letterSpacing: '0.1em', marginTop: '2px' }}>
+              Security Dashboard
+            </div>
+          </div>
+          <button
+            onClick={onClose}
+            style={{ color: '#475569', padding: '0.25rem', background: 'none', border: 'none', cursor: 'pointer', lineHeight: 1 }}
+            onMouseEnter={e => e.currentTarget.style.color = '#E2E8F0'}
+            onMouseLeave={e => e.currentTarget.style.color = '#475569'}
+          >
+            <X style={{ width: '20px', height: '20px' }} />
+          </button>
+        </div>
+
+        {/* Nav items */}
+        <nav style={{ display: 'flex', flexDirection: 'column', gap: '0.375rem' }}>
+          {NAV_ITEMS.map(({ id, label, icon: Icon, color, description }) => {
+            const active = currentPage === id;
+            return (
+              <button
+                key={id}
+                onClick={() => { onNavigate(id); onClose(); }}
+                style={{
+                  display: 'flex', alignItems: 'center', gap: '0.875rem',
+                  padding: '0.75rem 0.875rem',
+                  borderRadius: '0.5rem',
+                  border: active ? `1px solid ${color}50` : '1px solid transparent',
+                  background: active ? `${color}18` : 'transparent',
+                  cursor: 'pointer', textAlign: 'left', width: '100%',
+                  transition: 'background 0.15s, border-color 0.15s'
+                }}
+                onMouseEnter={e => { if (!active) e.currentTarget.style.background = 'rgba(255,255,255,0.04)'; }}
+                onMouseLeave={e => { if (!active) e.currentTarget.style.background = 'transparent'; }}
+              >
+                {/* Icon box */}
+                <div style={{
+                  width: '36px', height: '36px', flexShrink: 0,
+                  borderRadius: '0.375rem',
+                  background: `${color}18`,
+                  border: `1px solid ${color}40`,
+                  display: 'flex', alignItems: 'center', justifyContent: 'center'
+                }}>
+                  <Icon style={{ width: '17px', height: '17px', color }} />
+                </div>
+
+                {/* Label + description */}
+                <div style={{ flex: 1, minWidth: 0 }}>
+                  <div style={{
+                    fontFamily: 'monospace', fontSize: '0.8rem', fontWeight: '600',
+                    color: active ? color : '#CBD5E1',
+                    textTransform: 'uppercase', letterSpacing: '0.06em'
+                  }}>
+                    {label}
+                  </div>
+                  <div style={{ fontSize: '0.68rem', color: '#475569', marginTop: '1px' }}>
+                    {description}
+                  </div>
+                </div>
+
+                {/* Active indicator dot */}
+                {active && (
+                  <div style={{
+                    width: '6px', height: '6px', borderRadius: '50%',
+                    background: color, boxShadow: `0 0 8px ${color}`, flexShrink: 0
+                  }} />
+                )}
+              </button>
+            );
+          })}
+        </nav>
+
+        {/* Footer */}
+        <div style={{
+          marginTop: 'auto', paddingTop: '1rem',
+          borderTop: '1px solid rgba(255, 255, 255, 0.05)',
+          textAlign: 'center'
+        }}>
+          <div style={{ fontSize: '0.6rem', color: '#1E293B', fontFamily: 'monospace', textTransform: 'uppercase', letterSpacing: '0.1em' }}>
+            NTS Threat Intelligence
+          </div>
+        </div>
+      </div>
+    </>
+  );
+}
--- a/frontend/src/components/WeeklyReportModal.js
+++ b/frontend/src/components/WeeklyReportModal.js
@@ -1,291 +0,0 @@
-import React, { useState, useEffect } from 'react';
-import { X, Loader, AlertCircle, CheckCircle, Upload as UploadIcon, Download, Star } from 'lucide-react';
-
-const API_BASE = process.env.REACT_APP_API_BASE || 'http://localhost:3001/api';
-
-export default function WeeklyReportModal({ onClose }) {
-  const [phase, setPhase] = useState('idle'); // idle, uploading, processing, success, error
-  const [selectedFile, setSelectedFile] = useState(null);
-  const [uploadProgress, setUploadProgress] = useState(0);
-  const [result, setResult] = useState(null);
-  const [existingReports, setExistingReports] = useState([]);
-  const [error, setError] = useState('');
-
-  // Fetch existing reports on mount
-  useEffect(() => {
-    fetchExistingReports();
-  }, []);
-
-  const fetchExistingReports = async () => {
-    try {
-      const response = await fetch(`${API_BASE}/weekly-reports`, { credentials: 'include' });
-      if (!response.ok) throw new Error('Failed to fetch reports');
-      const data = await response.json();
-      setExistingReports(data);
-    } catch (err) {
-      console.error('Error fetching reports:', err);
-    }
-  };
-
-  const handleFileSelect = (e) => {
-    const file = e.target.files[0];
-    if (file) {
-      if (!file.name.endsWith('.xlsx')) {
-        setError('Please select an Excel file (.xlsx)');
-        return;
-      }
-      setSelectedFile(file);
-      setError('');
-    }
-  };
-
-  const handleUpload = async () => {
-    if (!selectedFile) return;
-
-    setPhase('uploading');
-    setUploadProgress(0);
-
-    const formData = new FormData();
-    formData.append('file', selectedFile);
-
-    try {
-      setUploadProgress(50); // Simulated progress
-      setPhase('processing');
-
-      const response = await fetch(`${API_BASE}/weekly-reports/upload`, {
-        method: 'POST',
-        body: formData,
-        credentials: 'include'
-      });
-
-      if (!response.ok) {
-        const errorData = await response.json();
-        throw new Error(errorData.error || 'Upload failed');
-      }
-
-      const data = await response.json();
-      setResult(data);
-      setPhase('success');
-
-      // Refresh the list of existing reports
-      await fetchExistingReports();
-    } catch (err) {
-      setError(err.message);
-      setPhase('error');
-    }
-  };
-
-  const handleDownload = async (id, type) => {
-    try {
-      const response = await fetch(`${API_BASE}/weekly-reports/${id}/download/${type}`, {
-        credentials: 'include'
-      });
-
-      if (!response.ok) throw new Error('Download failed');
-
-      const blob = await response.blob();
-      const url = window.URL.createObjectURL(blob);
-      const a = document.createElement('a');
-      a.href = url;
-      a.download = `vulnerability_report_${type}.xlsx`;
-      document.body.appendChild(a);
-      a.click();
-      window.URL.revokeObjectURL(url);
-      document.body.removeChild(a);
-    } catch (err) {
-      console.error('Error downloading file:', err);
-      setError(`Failed to download ${type} file`);
-    }
-  };
-
-  const resetForm = () => {
-    setPhase('idle');
-    setSelectedFile(null);
-    setUploadProgress(0);
-    setResult(null);
-    setError('');
-  };
-
-  return (
-    <div className="modal-overlay" onClick={onClose}>
-      <div className="modal-content" onClick={(e) => e.stopPropagation()}>
-        {/* Header */}
-        <div className="modal-header">
-          <h2 className="modal-title">Weekly Vulnerability Report</h2>
-          <button onClick={onClose} className="modal-close">
-            <X className="w-5 h-5" />
-          </button>
-        </div>
-
-        {/* Body */}
-        <div className="modal-body">
-          {/* Idle Phase - File Selection */}
-          {phase === 'idle' && (
-            <div className="space-y-6">
-              <div>
-                <label className="block text-sm font-medium mb-2" style={{ color: '#94A3B8' }}>
-                  Upload Excel File (.xlsx)
-                </label>
-                <input
-                  type="file"
-                  accept=".xlsx"
-                  onChange={handleFileSelect}
-                  className="intel-input w-full"
-                />
-                {selectedFile && (
-                  <p className="mt-2 text-sm" style={{ color: '#10B981' }}>
-                    Selected: {selectedFile.name}
-                  </p>
-                )}
-              </div>
-
-              <button
-                onClick={handleUpload}
-                disabled={!selectedFile}
-                className={`intel-button w-full ${selectedFile ? 'intel-button-success' : 'opacity-50 cursor-not-allowed'}`}
-              >
-                <UploadIcon className="w-4 h-4 mr-2" />
-                Upload & Process
-              </button>
-
-              {error && (
-                <div className="flex items-start gap-2 p-3 rounded" style={{ background: 'rgba(239, 68, 68, 0.1)', border: '1px solid #EF4444' }}>
-                  <AlertCircle className="w-5 h-5 flex-shrink-0" style={{ color: '#EF4444' }} />
-                  <p style={{ color: '#FCA5A5' }}>{error}</p>
-                </div>
-              )}
-            </div>
-          )}
-
-          {/* Uploading Phase */}
-          {phase === 'uploading' && (
-            <div className="text-center py-8">
-              <Loader className="w-12 h-12 animate-spin mx-auto mb-4" style={{ color: '#0EA5E9' }} />
-              <p style={{ color: '#94A3B8' }}>Uploading file...</p>
-              <div className="w-full bg-gray-700 rounded-full h-2 mt-4">
-                <div
-                  className="h-2 rounded-full transition-all"
-                  style={{ width: `${uploadProgress}%`, background: '#0EA5E9' }}
-                />
-              </div>
-            </div>
-          )}
-
-          {/* Processing Phase */}
-          {phase === 'processing' && (
-            <div className="text-center py-8">
-              <Loader className="w-12 h-12 animate-spin mx-auto mb-4" style={{ color: '#0EA5E9' }} />
-              <p style={{ color: '#94A3B8' }}>Processing vulnerability report...</p>
-              <p className="text-sm mt-2" style={{ color: '#64748B' }}>Splitting CVE IDs into separate rows</p>
-            </div>
-          )}
-
-          {/* Success Phase */}
-          {phase === 'success' && result && (
-            <div className="space-y-4">
-              <div className="flex items-center gap-2 p-4 rounded" style={{ background: 'rgba(16, 185, 129, 0.1)', border: '1px solid #10B981' }}>
-                <CheckCircle className="w-6 h-6" style={{ color: '#10B981' }} />
-                <div>
-                  <p className="font-medium" style={{ color: '#34D399' }}>Upload Successful!</p>
-                  <p className="text-sm mt-1" style={{ color: '#94A3B8' }}>
-                    Original: {result.original_rows} rows → Processed: {result.processed_rows} rows
-                    <span className="ml-2" style={{ color: '#10B981' }}>
-                      (+{result.processed_rows - result.original_rows} rows from splitting CVEs)
-                    </span>
-                  </p>
-                </div>
-              </div>
-
-              <div className="flex gap-3">
-                <button
-                  onClick={() => handleDownload(result.id, 'original')}
-                  className="intel-button flex-1"
-                >
-                  <Download className="w-4 h-4 mr-2" />
-                  Download Original
-                </button>
-                <button
-                  onClick={() => handleDownload(result.id, 'processed')}
-                  className="intel-button intel-button-success flex-1"
-                >
-                  <Download className="w-4 h-4 mr-2" />
-                  Download Processed
-                </button>
-              </div>
-
-              <button onClick={resetForm} className="intel-button w-full">
-                Upload Another Report
-              </button>
-            </div>
-          )}
-
-          {/* Error Phase */}
-          {phase === 'error' && (
-            <div className="space-y-4">
-              <div className="flex items-start gap-2 p-4 rounded" style={{ background: 'rgba(239, 68, 68, 0.1)', border: '1px solid #EF4444' }}>
-                <AlertCircle className="w-6 h-6 flex-shrink-0" style={{ color: '#EF4444' }} />
-                <div>
-                  <p className="font-medium" style={{ color: '#FCA5A5' }}>Upload Failed</p>
-                  <p className="text-sm mt-1" style={{ color: '#94A3B8' }}>{error}</p>
-                </div>
-              </div>
-              <button onClick={resetForm} className="intel-button w-full">
-                Try Again
-              </button>
-            </div>
-          )}
-
-          {/* Existing Reports Section */}
-          {(phase === 'idle' || phase === 'success') && existingReports.length > 0 && (
-            <div className="mt-8">
-              <h3 className="text-lg font-medium mb-4" style={{ color: '#94A3B8' }}>
-                Previous Reports
-              </h3>
-              <div className="space-y-3">
-                {existingReports.map((report) => (
-                  <div
-                    key={report.id}
-                    className="intel-card p-4"
-                  >
-                    <div className="flex items-start justify-between">
-                      <div className="flex-1">
-                        <div className="flex items-center gap-2 mb-2">
-                          {report.is_current && (
-                            <Star className="w-4 h-4 fill-current" style={{ color: '#F59E0B' }} />
-                          )}
-                          <p className="font-medium" style={{ color: report.is_current ? '#F59E0B' : '#94A3B8' }}>
-                            {report.week_label}
-                          </p>
-                        </div>
-                        <p className="text-sm" style={{ color: '#64748B' }}>
-                          {new Date(report.upload_date).toLocaleDateString()} •
-                          {report.row_count_original} → {report.row_count_processed} rows
-                        </p>
-                      </div>
-                      <div className="flex gap-2">
-                        <button
-                          onClick={() => handleDownload(report.id, 'original')}
-                          className="intel-button intel-button-small"
-                          title="Download Original"
-                        >
-                          <Download className="w-3 h-3" />
-                        </button>
-                        <button
-                          onClick={() => handleDownload(report.id, 'processed')}
-                          className="intel-button intel-button-success intel-button-small"
-                          title="Download Processed"
-                        >
-                          <Download className="w-3 h-3" />
-                        </button>
-                      </div>
-                    </div>
-                  </div>
-                ))}
-              </div>
-            </div>
-          )}
-        </div>
-      </div>
-    </div>
-  );
-}
--- a/frontend/src/components/pages/ExportsPage.js
+++ b/frontend/src/components/pages/ExportsPage.js
@@ -0,0 +1,25 @@
+import React from 'react';
+import { Download } from 'lucide-react';
+
+export default function ExportsPage() {
+  return (
+    <div style={{ display: 'flex', alignItems: 'center', justifyContent: 'center', minHeight: '60vh' }}>
+      <div style={{ textAlign: 'center' }}>
+        <div style={{
+          width: '72px', height: '72px', borderRadius: '1rem', margin: '0 auto 1.5rem',
+          background: 'rgba(139, 92, 246, 0.1)',
+          border: '1px solid rgba(139, 92, 246, 0.3)',
+          display: 'flex', alignItems: 'center', justifyContent: 'center'
+        }}>
+          <Download style={{ width: '36px', height: '36px', color: '#8B5CF6' }} />
+        </div>
+        <h2 style={{ fontFamily: 'monospace', fontSize: '1.5rem', fontWeight: '700', color: '#8B5CF6', textTransform: 'uppercase', letterSpacing: '0.1em', marginBottom: '0.5rem' }}>
+          Exports
+        </h2>
+        <p style={{ color: '#475569', fontSize: '0.875rem', fontFamily: 'monospace' }}>
+          Under construction — coming soon
+        </p>
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/components/pages/KnowledgeBasePage.js
+++ b/frontend/src/components/pages/KnowledgeBasePage.js
@@ -0,0 +1,25 @@
+import React from 'react';
+import { BookOpen } from 'lucide-react';
+
+export default function KnowledgeBasePage() {
+  return (
+    <div style={{ display: 'flex', alignItems: 'center', justifyContent: 'center', minHeight: '60vh' }}>
+      <div style={{ textAlign: 'center' }}>
+        <div style={{
+          width: '72px', height: '72px', borderRadius: '1rem', margin: '0 auto 1.5rem',
+          background: 'rgba(16, 185, 129, 0.1)',
+          border: '1px solid rgba(16, 185, 129, 0.3)',
+          display: 'flex', alignItems: 'center', justifyContent: 'center'
+        }}>
+          <BookOpen style={{ width: '36px', height: '36px', color: '#10B981' }} />
+        </div>
+        <h2 style={{ fontFamily: 'monospace', fontSize: '1.5rem', fontWeight: '700', color: '#10B981', textTransform: 'uppercase', letterSpacing: '0.1em', marginBottom: '0.5rem' }}>
+          Knowledge Base
+        </h2>
+        <p style={{ color: '#475569', fontSize: '0.875rem', fontFamily: 'monospace' }}>
+          Under construction — coming soon
+        </p>
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/components/pages/ReportingPage.js
+++ b/frontend/src/components/pages/ReportingPage.js
@@ -0,0 +1,399 @@
+import React, { useState, useEffect, useCallback } from 'react';
+import { RefreshCw, Loader, AlertCircle, PieChart, ChevronUp, ChevronDown, ChevronsUpDown } from 'lucide-react';
+
+const API_BASE = process.env.REACT_APP_API_BASE || 'http://localhost:3001/api';
+
+// ---------------------------------------------------------------------------
+// Column definitions
+// ---------------------------------------------------------------------------
+const COLUMNS = [
+    { key: 'severity',    label: 'Severity',   accessor: (f) => f.severity,    sortable: true  },
+    { key: 'title',       label: 'Title',      accessor: (f) => f.title,       sortable: true  },
+    { key: 'hostName',    label: 'Host',       accessor: (f) => f.hostName,    sortable: true  },
+    { key: 'ipAddress',   label: 'IP Address', accessor: (f) => f.ipAddress,   sortable: true  },
+    { key: 'dns',         label: 'DNS',        accessor: (f) => f.dns,         sortable: true  },
+    { key: 'slaStatus',   label: 'SLA',        accessor: (f) => f.slaStatus,   sortable: true  },
+    { key: 'discoveredOn',label: 'Discovered', accessor: (f) => f.discoveredOn,sortable: true  },
+    { key: 'lastFoundOn', label: 'Last Found', accessor: (f) => f.lastFoundOn, sortable: true  },
+    { key: 'source',      label: 'Source',     accessor: (f) => f.source,      sortable: true  },
+    { key: 'note',        label: 'Notes',      accessor: (f) => f.note,        sortable: false },
+];
+
+// ---------------------------------------------------------------------------
+// Helpers
+// ---------------------------------------------------------------------------
+function severityColor(vrrGroup) {
+    switch ((vrrGroup || '').toUpperCase()) {
+        case 'CRITICAL': return { bg: 'rgba(239,68,68,0.15)', border: '#EF4444', text: '#EF4444' };
+        case 'HIGH':     return { bg: 'rgba(245,158,11,0.15)', border: '#F59E0B', text: '#F59E0B' };
+        case 'MEDIUM':   return { bg: 'rgba(234,179,8,0.15)', border: '#EAB308', text: '#EAB308' };
+        default:         return { bg: 'rgba(100,116,139,0.15)', border: '#64748B', text: '#94A3B8' };
+    }
+}
+
+function slaColor(slaStatus) {
+    switch ((slaStatus || '').toUpperCase()) {
+        case 'OVERDUE':  return '#EF4444';
+        case 'AT_RISK':  return '#F59E0B';
+        case 'OK':       return '#10B981';
+        default:         return '#64748B';
+    }
+}
+
+function SortIcon({ colKey, sort }) {
+    if (sort.field !== colKey) return <ChevronsUpDown style={{ width: '12px', height: '12px', opacity: 0.3, marginLeft: '4px', flexShrink: 0 }} />;
+    return sort.dir === 'asc'
+        ? <ChevronUp   style={{ width: '12px', height: '12px', color: '#0EA5E9', marginLeft: '4px', flexShrink: 0 }} />
+        : <ChevronDown style={{ width: '12px', height: '12px', color: '#0EA5E9', marginLeft: '4px', flexShrink: 0 }} />;
+}
+
+// ---------------------------------------------------------------------------
+// NoteCell — inline editable, saves on blur
+// ---------------------------------------------------------------------------
+function NoteCell({ findingId, initialNote }) {
+    const [value, setValue] = useState(initialNote || '');
+    const [saving, setSaving] = useState(false);
+
+    const save = useCallback(async () => {
+        if (value === (initialNote || '')) return; // nothing changed
+        setSaving(true);
+        try {
+            await fetch(`${API_BASE}/ivanti/findings/${encodeURIComponent(findingId)}/note`, {
+                method: 'PUT',
+                headers: { 'Content-Type': 'application/json' },
+                credentials: 'include',
+                body: JSON.stringify({ note: value })
+            });
+        } catch (e) {
+            console.error('Failed to save note:', e);
+        } finally {
+            setSaving(false);
+        }
+    }, [findingId, value, initialNote]);
+
+    return (
+        <div style={{ position: 'relative' }}>
+            <input
+                type="text"
+                value={value}
+                maxLength={255}
+                onChange={(e) => setValue(e.target.value)}
+                onBlur={save}
+                placeholder="Add note…"
+                style={{
+                    width: '100%',
+                    minWidth: '160px',
+                    background: 'rgba(14, 165, 233, 0.05)',
+                    border: '1px solid rgba(14, 165, 233, 0.2)',
+                    borderRadius: '4px',
+                    padding: '4px 8px',
+                    color: '#CBD5E1',
+                    fontSize: '0.75rem',
+                    fontFamily: 'inherit',
+                    outline: 'none',
+                    boxSizing: 'border-box'
+                }}
+                onFocus={(e) => { e.target.style.borderColor = 'rgba(14, 165, 233, 0.6)'; e.target.style.background = 'rgba(14, 165, 233, 0.1)'; }}
+            />
+            {saving && <Loader style={{ width: '10px', height: '10px', position: 'absolute', right: '6px', top: '6px', color: '#0EA5E9', animation: 'spin 1s linear infinite' }} />}
+        </div>
+    );
+}
+
+// ---------------------------------------------------------------------------
+// Main ReportingPage component
+// ---------------------------------------------------------------------------
+export default function ReportingPage() {
+    const [findings, setFindings]     = useState([]);
+    const [total, setTotal]           = useState(null);
+    const [syncedAt, setSyncedAt]     = useState(null);
+    const [syncStatus, setSyncStatus] = useState(null);
+    const [syncError, setSyncError]   = useState(null);
+    const [loading, setLoading]       = useState(false);
+    const [syncing, setSyncing]       = useState(false);
+    const [sort, setSort]             = useState({ field: 'severity', dir: 'desc' });
+
+    const applyState = (data) => {
+        setTotal(data.total ?? 0);
+        setFindings(data.findings || []);
+        setSyncedAt(data.synced_at || null);
+        setSyncStatus(data.sync_status || null);
+        setSyncError(data.error_message || null);
+    };
+
+    const fetchFindings = async () => {
+        setLoading(true);
+        try {
+            const res = await fetch(`${API_BASE}/ivanti/findings`, { credentials: 'include' });
+            const data = await res.json();
+            if (res.ok) applyState(data);
+        } catch (e) {
+            console.error('Error loading findings:', e);
+        } finally {
+            setLoading(false);
+        }
+    };
+
+    const syncFindings = async () => {
+        setSyncing(true);
+        try {
+            const res = await fetch(`${API_BASE}/ivanti/findings/sync`, {
+                method: 'POST',
+                credentials: 'include'
+            });
+            const data = await res.json();
+            if (res.ok) applyState(data);
+        } catch (e) {
+            console.error('Error syncing findings:', e);
+        } finally {
+            setSyncing(false);
+        }
+    };
+
+    useEffect(() => { fetchFindings(); }, []); // eslint-disable-line
+
+    // Sort findings
+    const sorted = [...findings].sort((a, b) => {
+        const col = COLUMNS.find((c) => c.key === sort.field);
+        if (!col) return 0;
+        const av = col.accessor(a) ?? '';
+        const bv = col.accessor(b) ?? '';
+        let cmp = 0;
+        if (typeof av === 'number' && typeof bv === 'number') {
+            cmp = av - bv;
+        } else {
+            cmp = String(av).localeCompare(String(bv), undefined, { numeric: true });
+        }
+        return sort.dir === 'asc' ? cmp : -cmp;
+    });
+
+    const toggleSort = (key) => {
+        setSort((prev) =>
+            prev.field === key
+                ? { field: key, dir: prev.dir === 'asc' ? 'desc' : 'asc' }
+                : { field: key, dir: 'asc' }
+        );
+    };
+
+    const syncedDisplay = syncedAt
+        ? new Date(syncedAt.replace(' ', 'T') + 'Z').toLocaleString()
+        : 'Never synced';
+
+    // -------------------------------------------------------------------------
+    // Render
+    // -------------------------------------------------------------------------
+    return (
+        <div style={{ display: 'flex', flexDirection: 'column', gap: '1.5rem' }}>
+
+            {/* ----------------------------------------------------------------
+                Panel 1 — Metrics placeholder (full width)
+            ---------------------------------------------------------------- */}
+            <div style={{
+                background: 'linear-gradient(135deg, rgba(15,26,46,0.95) 0%, rgba(10,22,40,0.9) 100%)',
+                border: '1px solid rgba(245,158,11,0.2)',
+                borderLeft: '3px solid #F59E0B',
+                borderRadius: '0.5rem',
+                padding: '1.5rem',
+                boxShadow: '0 4px 16px rgba(0,0,0,0.4)'
+            }}>
+                <div style={{ display: 'flex', alignItems: 'center', gap: '0.625rem', marginBottom: '1rem' }}>
+                    <PieChart style={{ width: '20px', height: '20px', color: '#F59E0B' }} />
+                    <h2 style={{ fontFamily: 'monospace', fontSize: '1rem', fontWeight: '600', color: '#F59E0B', textTransform: 'uppercase', letterSpacing: '0.1em', textShadow: '0 0 12px rgba(245,158,11,0.4)', margin: 0 }}>
+                        Metric Graphs
+                    </h2>
+                </div>
+                <div style={{
+                    display: 'flex', alignItems: 'center', justifyContent: 'center',
+                    height: '120px',
+                    border: '1px dashed rgba(245,158,11,0.2)',
+                    borderRadius: '0.375rem',
+                    background: 'rgba(245,158,11,0.03)'
+                }}>
+                    <p style={{ fontFamily: 'monospace', fontSize: '0.75rem', color: '#475569', textTransform: 'uppercase', letterSpacing: '0.1em' }}>
+                        Pie charts &amp; metrics — coming soon
+                    </p>
+                </div>
+            </div>
+
+            {/* ----------------------------------------------------------------
+                Panel 2 — Findings table
+            ---------------------------------------------------------------- */}
+            <div style={{
+                background: 'linear-gradient(135deg, rgba(15,26,46,0.95) 0%, rgba(10,22,40,0.9) 100%)',
+                border: '1px solid rgba(14,165,233,0.2)',
+                borderLeft: '3px solid #0EA5E9',
+                borderRadius: '0.5rem',
+                padding: '1.5rem',
+                boxShadow: '0 4px 16px rgba(0,0,0,0.4)'
+            }}>
+                {/* Table header row */}
+                <div style={{ display: 'flex', justifyContent: 'space-between', alignItems: 'flex-start', marginBottom: '0.5rem' }}>
+                    <div>
+                        <h2 style={{ fontFamily: 'monospace', fontSize: '1rem', fontWeight: '600', color: '#0EA5E9', textTransform: 'uppercase', letterSpacing: '0.1em', textShadow: '0 0 12px rgba(14,165,233,0.4)', margin: '0 0 4px 0' }}>
+                            Host Findings
+                        </h2>
+                        <div style={{ fontFamily: 'monospace', fontSize: '0.7rem', color: '#475569' }}>
+                            {syncedDisplay}
+                            {syncStatus === 'success' && total !== null && (
+                                <span style={{ marginLeft: '0.75rem', color: '#64748B' }}>{total} total findings</span>
+                            )}
+                        </div>
+                    </div>
+                    <button
+                        onClick={syncFindings}
+                        disabled={syncing || loading}
+                        style={{
+                            display: 'flex', alignItems: 'center', gap: '0.375rem',
+                            padding: '0.375rem 0.75rem',
+                            background: 'rgba(14,165,233,0.1)',
+                            border: '1px solid rgba(14,165,233,0.35)',
+                            borderRadius: '0.375rem',
+                            color: '#0EA5E9', cursor: 'pointer',
+                            fontFamily: 'monospace', fontSize: '0.75rem', fontWeight: '600',
+                            textTransform: 'uppercase', letterSpacing: '0.05em',
+                            opacity: (syncing || loading) ? 0.6 : 1
+                        }}
+                    >
+                        <RefreshCw style={{ width: '13px', height: '13px', animation: syncing ? 'spin 1s linear infinite' : 'none' }} />
+                        {syncing ? 'Syncing…' : 'Sync'}
+                    </button>
+                </div>
+
+                {/* Error banner */}
+                {syncStatus === 'error' && syncError && (
+                    <div style={{ display: 'flex', alignItems: 'flex-start', gap: '0.5rem', padding: '0.625rem 0.875rem', background: 'rgba(239,68,68,0.08)', border: '1px solid rgba(239,68,68,0.25)', borderRadius: '0.375rem', marginBottom: '1rem' }}>
+                        <AlertCircle style={{ width: '15px', height: '15px', color: '#EF4444', flexShrink: 0, marginTop: '1px' }} />
+                        <span style={{ fontSize: '0.75rem', color: '#FCA5A5', fontFamily: 'monospace' }}>{syncError}</span>
+                    </div>
+                )}
+
+                {/* Loading state */}
+                {loading ? (
+                    <div style={{ textAlign: 'center', padding: '3rem 0' }}>
+                        <Loader style={{ width: '28px', height: '28px', color: '#0EA5E9', animation: 'spin 1s linear infinite', margin: '0 auto 0.75rem' }} />
+                        <p style={{ fontFamily: 'monospace', fontSize: '0.75rem', color: '#475569' }}>Loading findings…</p>
+                    </div>
+                ) : syncStatus === 'never' ? (
+                    <div style={{ textAlign: 'center', padding: '3rem 0' }}>
+                        <p style={{ fontFamily: 'monospace', fontSize: '0.75rem', color: '#475569' }}>Click Sync to load findings data</p>
+                    </div>
+                ) : (
+                    /* Table */
+                    <div style={{ overflowX: 'auto', marginTop: '0.75rem' }}>
+                        <table style={{ width: '100%', borderCollapse: 'collapse', fontSize: '0.75rem', fontFamily: 'sans-serif' }}>
+                            <thead>
+                                <tr style={{ borderBottom: '1px solid rgba(14,165,233,0.2)' }}>
+                                    {COLUMNS.map((col) => (
+                                        <th
+                                            key={col.key}
+                                            onClick={col.sortable ? () => toggleSort(col.key) : undefined}
+                                            style={{
+                                                padding: '0.5rem 0.75rem',
+                                                textAlign: 'left',
+                                                fontFamily: 'monospace',
+                                                fontSize: '0.68rem',
+                                                fontWeight: '600',
+                                                color: sort.field === col.key ? '#0EA5E9' : '#64748B',
+                                                textTransform: 'uppercase',
+                                                letterSpacing: '0.08em',
+                                                whiteSpace: 'nowrap',
+                                                cursor: col.sortable ? 'pointer' : 'default',
+                                                userSelect: 'none',
+                                                background: 'rgba(15,26,46,0.6)'
+                                            }}
+                                        >
+                                            <span style={{ display: 'inline-flex', alignItems: 'center' }}>
+                                                {col.label}
+                                                {col.sortable && <SortIcon colKey={col.key} sort={sort} />}
+                                            </span>
+                                        </th>
+                                    ))}
+                                </tr>
+                            </thead>
+                            <tbody>
+                                {sorted.map((finding, idx) => {
+                                    const sc = severityColor(finding.vrrGroup);
+                                    const rowBg = idx % 2 === 0 ? 'rgba(15,26,46,0.4)' : 'rgba(10,18,32,0.4)';
+                                    return (
+                                        <tr
+                                            key={finding.id}
+                                            style={{ borderBottom: '1px solid rgba(255,255,255,0.04)', background: rowBg }}
+                                            onMouseEnter={(e) => e.currentTarget.style.background = 'rgba(14,165,233,0.05)'}
+                                            onMouseLeave={(e) => e.currentTarget.style.background = rowBg}
+                                        >
+                                            {/* Severity */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap' }}>
+                                                <span style={{ display: 'inline-flex', alignItems: 'center', gap: '0.375rem', padding: '0.2rem 0.5rem', borderRadius: '0.25rem', background: sc.bg, border: `1px solid ${sc.border}40`, fontFamily: 'monospace', fontWeight: '700', color: sc.text, fontSize: '0.72rem' }}>
+                                                    {finding.severity?.toFixed(2)}
+                                                    <span style={{ fontSize: '0.6rem', opacity: 0.8 }}>{finding.vrrGroup}</span>
+                                                </span>
+                                            </td>
+
+                                            {/* Title */}
+                                            <td style={{ padding: '0.5rem 0.75rem', maxWidth: '280px' }}>
+                                                <span style={{ color: '#CBD5E1', display: 'block', overflow: 'hidden', textOverflow: 'ellipsis', whiteSpace: 'nowrap' }} title={finding.title}>
+                                                    {finding.title}
+                                                </span>
+                                            </td>
+
+                                            {/* Host */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap', color: '#94A3B8', fontFamily: 'monospace', fontSize: '0.72rem' }}>
+                                                {finding.hostName || '—'}
+                                            </td>
+
+                                            {/* IP */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap', color: '#94A3B8', fontFamily: 'monospace', fontSize: '0.72rem' }}>
+                                                {finding.ipAddress || '—'}
+                                            </td>
+
+                                            {/* DNS */}
+                                            <td style={{ padding: '0.5rem 0.75rem', maxWidth: '200px' }}>
+                                                <span style={{ color: '#94A3B8', fontFamily: 'monospace', fontSize: '0.72rem', display: 'block', overflow: 'hidden', textOverflow: 'ellipsis', whiteSpace: 'nowrap' }} title={finding.dns}>
+                                                    {finding.dns || '—'}
+                                                </span>
+                                            </td>
+
+                                            {/* SLA */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap' }}>
+                                                <span style={{ fontFamily: 'monospace', fontSize: '0.68rem', fontWeight: '600', color: slaColor(finding.slaStatus) }}>
+                                                    {finding.slaStatus || '—'}
+                                                </span>
+                                            </td>
+
+                                            {/* Discovered */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap', color: '#64748B', fontFamily: 'monospace', fontSize: '0.72rem' }}>
+                                                {finding.discoveredOn || '—'}
+                                            </td>
+
+                                            {/* Last Found */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap', color: '#64748B', fontFamily: 'monospace', fontSize: '0.72rem' }}>
+                                                {finding.lastFoundOn || '—'}
+                                            </td>
+
+                                            {/* Source */}
+                                            <td style={{ padding: '0.5rem 0.75rem', whiteSpace: 'nowrap', color: '#64748B', fontFamily: 'monospace', fontSize: '0.68rem' }}>
+                                                {finding.source || '—'}
+                                            </td>
+
+                                            {/* Notes */}
+                                            <td style={{ padding: '0.5rem 0.75rem' }}>
+                                                <NoteCell findingId={finding.id} initialNote={finding.note} />
+                                            </td>
+                                        </tr>
+                                    );
+                                })}
+                                {sorted.length === 0 && (
+                                    <tr>
+                                        <td colSpan={COLUMNS.length} style={{ textAlign: 'center', padding: '2rem', color: '#475569', fontFamily: 'monospace', fontSize: '0.75rem' }}>
+                                            No findings found
+                                        </td>
+                                    </tr>
+                                )}
+                            </tbody>
+                        </table>
+                    </div>
+                )}
+            </div>
+        </div>
+    );
+}
--- a/plan.md
+++ b/plan.md
@@ -1,297 +0,0 @@
-# NVD Lookup + Retroactive Sync — Implementation Plan
-
-## Overview
-Two capabilities on `feature/nvd-lookup` branch:
-1. **Auto-fill on Add CVE** (DONE, stashed) — onBlur NVD lookup fills description/severity/date in the Add CVE modal
-2. **Sync with NVD** (TO DO) — bulk tool for editors/admins to retroactively update existing CVE entries from NVD, with per-CVE choice to keep or replace description
-
-## Current State
-
-### Git State
- **Branch:** `feature/nvd-lookup` (branched from master post-audit-merge)
- **Stash:** `stash@{0}` contains the auto-fill implementation (4 files)
- **Master** now has audit logging (merged from feature/audit on 2026-01-30)
- Offsite repo is up to date through the feature/audit merge to master
-
-### What's in the Stash
-The stash contains working NVD auto-fill code that needs to be popped and conflict-resolved before continuing:
-
-**`backend/routes/nvdLookup.js` (NEW file)**
- Factory function: `createNvdLookupRouter(db, requireAuth)`
- `GET /lookup/:cveId` endpoint
- Validates CVE ID format (regex: `CVE-YYYY-NNNNN`)
- Calls `https://services.nvd.nist.gov/rest/json/cves/2.0?cveId=...`
- 10-second timeout via `AbortSignal.timeout(10000)`
- Optional `apiKey` header from `NVD_API_KEY` env var
- CVSS severity cascade: v3.1 → v3.0 → v2.0
- Maps NVD uppercase severity to app format (CRITICAL→Critical, etc.)
- Returns: `{ description, severity, published_date }`
-
-**`backend/server.js` (MODIFIED)**
- Adds `const createNvdLookupRouter = require('./routes/nvdLookup');`
- Adds `app.use('/api/nvd', createNvdLookupRouter(db, requireAuth));`
-
-**`frontend/src/App.js` (MODIFIED)**
- New state: `nvdLoading`, `nvdError`, `nvdAutoFilled`
- New function: `lookupNVD(cveId)` — calls backend, auto-fills form fields
- CVE ID input: `onBlur` triggers lookup, `onChange` resets NVD feedback
- Spinner (Loader icon) in CVE ID field while loading
- Green "Auto-filled from NVD" with CheckCircle on success
- Amber warning with AlertCircle on errors (non-blocking)
- Description only fills if currently empty; severity + published_date always update
- NVD state resets on modal close (X, Cancel) and form submit
-
-**`backend/.env.example` (MODIFIED)**
- Adds `NVD_API_KEY=` with comment about rate limits
-
-### Stash Conflict Resolution
-Popping the stash will conflict in `server.js` because master now has audit imports that didn't exist when the stash was created. Resolution:
-
-The conflict is in the imports section. Keep ALL existing audit lines from master:
-```js
-const createAuditLogRouter = require('./routes/auditLog');
-const logAudit = require('./helpers/auditLog');
-```
-AND add the NVD line:
-```js
-const createNvdLookupRouter = require('./routes/nvdLookup');
-```
-
-Similarly, keep the audit route mount and add the NVD mount after it:
-```js
-app.use('/api/audit-logs', createAuditLogRouter(db, requireAuth, requireRole));
-app.use('/api/nvd', createNvdLookupRouter(db, requireAuth));
-```
-
-Then `git add backend/server.js` to mark resolved and `git stash drop`.
-
---
-
-## Step 1: Resolve Stash + Rebase onto Master
-
-```bash
-git checkout feature/nvd-lookup
-git rebase master                    # Get audit changes into the branch
-git stash pop                        # Apply NVD changes (will conflict in server.js)
-# Resolve conflict in server.js as described above
-git add backend/server.js
-git stash drop
-```
-
-Verify: `backend/routes/nvdLookup.js` exists, `server.js` has both audit AND NVD imports/mounts.
-
---
-
-## Step 2: Backend — New Endpoints in `server.js`
-
-### 2A: `GET /api/cves/distinct-ids`
-Place BEFORE `GET /api/cves/check/:cveId` (to avoid route param conflict):
-```js
-app.get('/api/cves/distinct-ids', requireAuth(db), (req, res) => {
-    db.all('SELECT DISTINCT cve_id FROM cves ORDER BY cve_id', [], (err, rows) => {
-        if (err) return res.status(500).json({ error: err.message });
-        res.json(rows.map(r => r.cve_id));
-    });
-});
-```
-
-### 2B: `POST /api/cves/nvd-sync`
-Place after the existing `PATCH /api/cves/:cveId/status`:
-```js
-app.post('/api/cves/nvd-sync', requireAuth(db), requireRole('editor', 'admin'), (req, res) => {
-    const { updates } = req.body;
-    if (!Array.isArray(updates) || updates.length === 0) {
-        return res.status(400).json({ error: 'No updates provided' });
-    }
-
-    let updated = 0;
-    const errors = [];
-    let completed = 0;
-
-    db.serialize(() => {
-        updates.forEach((entry) => {
-            const fields = [];
-            const values = [];
-            if (entry.description !== null && entry.description !== undefined) {
-                fields.push('description = ?');
-                values.push(entry.description);
-            }
-            if (entry.severity !== null && entry.severity !== undefined) {
-                fields.push('severity = ?');
-                values.push(entry.severity);
-            }
-            if (entry.published_date !== null && entry.published_date !== undefined) {
-                fields.push('published_date = ?');
-                values.push(entry.published_date);
-            }
-            if (fields.length === 0) {
-                completed++;
-                if (completed === updates.length) sendResponse();
-                return;
-            }
-            fields.push('updated_at = CURRENT_TIMESTAMP');
-            values.push(entry.cve_id);
-
-            db.run(
-                `UPDATE cves SET ${fields.join(', ')} WHERE cve_id = ?`,
-                values,
-                function(err) {
-                    if (err) {
-                        errors.push({ cve_id: entry.cve_id, error: err.message });
-                    } else {
-                        updated += this.changes;
-                    }
-                    completed++;
-                    if (completed === updates.length) sendResponse();
-                }
-            );
-        });
-    });
-
-    function sendResponse() {
-        logAudit(db, {
-            userId: req.user.id,
-            username: req.user.username,
-            action: 'cve_nvd_sync',
-            entityType: 'cve',
-            entityId: null,
-            details: { count: updated, cve_ids: updates.map(u => u.cve_id) },
-            ipAddress: req.ip
-        });
-        const result = { message: 'NVD sync completed', updated };
-        if (errors.length > 0) result.errors = errors;
-        res.json(result);
-    }
-});
-```
-
-**How "keep existing description" works:** If the user chooses to keep the existing description, the frontend sends `description: null` for that CVE. The backend skips null fields, so the description is not overwritten. Severity and published_date are always sent (auto-update).
-
---
-
-## Step 3: Frontend — New `NvdSyncModal.js` Component
-
-**File:** `frontend/src/components/NvdSyncModal.js`
-
-### Props
-```jsx
-<NvdSyncModal onClose={fn} onSyncComplete={fn} />
-```
-
-### Phase Machine
-| Phase | What's shown |
-|-------|-------------|
-| `idle` | CVE count + "Fetch NVD Data" button |
-| `fetching` | Progress bar, current CVE being fetched, cancel button |
-| `review` | Comparison table with per-CVE description choice |
-| `applying` | Spinner |
-| `done` | Summary (X updated, Y errors) + Close button |
-
-### Fetching Logic
- Iterate CVE IDs sequentially
- Call `GET /api/nvd/lookup/:cveId` for each
- 7-second delay between requests (safe for 5 req/30s without API key)
- On 429: wait 35 seconds, retry once
- On 404: mark as "Not found in NVD" (gray, skipped)
- On timeout/error: mark with warning (skipped)
- Support cancellation via AbortController
-
-### Comparison Table Columns
-| Column | Content |
-|--------|---------|
-| CVE ID | The identifier |
-| Status | Icon: check=found, warning=error, dash=no changes |
-| Severity | `[Current] → [NVD]` with color badges, or "No change" |
-| Published Date | `Current → NVD` or "No change" |
-| Description | Truncated preview with expand toggle. Current (red bg) vs NVD (green bg) when different |
-| Choice | Radio: "Keep existing" (default) / "Use NVD" — only shown when descriptions differ |
-
-### Bulk Controls
-Above the table:
- Summary: `Found: N | Up to date: N | Changes: N | Not in NVD: N | Errors: N`
- Bulk toggle: "Keep All Existing" / "Use All NVD Descriptions"
-
-Below the table:
- "Apply N Changes" button (count updates dynamically)
- "Cancel" button
-
-### Apply Logic
-Build updates array:
- For each CVE with NVD data (no error):
-  - Always include `severity` and `published_date` if different from current
-  - Include `description` only if user chose "Use NVD" — otherwise send `null`
-  - Skip CVEs where nothing changed
- POST to `/api/cves/nvd-sync`
- On success: call `onSyncComplete()` to refresh CVE list, then show done phase
-
---
-
-## Step 4: Frontend — App.js Integration
-
-Minimal changes following `AuditLog`/`UserManagement` pattern:
-
-1. **Import:** Add `NvdSyncModal` and `RefreshCw` icon
-2. **State:** Add `const [showNvdSync, setShowNvdSync] = useState(false);`
-3. **Header button** (next to "Add CVE/Vendor", visible to editors/admins):
-```jsx
-{canWrite() && (
-  <button onClick={() => setShowNvdSync(true)}
-    className="px-4 py-2 bg-green-600 text-white rounded-lg hover:bg-green-700 transition-colors flex items-center gap-2 shadow-md">
-    <RefreshCw className="w-5 h-5" />
-    Sync with NVD
-  </button>
-)}
-```
-4. **Modal render** (alongside other modals):
-```jsx
-{showNvdSync && (
-  <NvdSyncModal onClose={() => setShowNvdSync(false)} onSyncComplete={() => fetchCVEs()} />
-)}
-```
-
---
-
-## Step 5: AuditLog Badge
-
-**File:** `frontend/src/components/AuditLog.js`
-
-Add to the `ACTION_BADGES` object:
-```js
-cve_nvd_sync: { bg: 'bg-green-100', text: 'text-green-800' },
-```
-
---
-
-## Step 6: .env.example (already in stash)
-```
-# NVD API Key (optional - increases rate limit from 5 to 50 requests per 30s)
-# Request one at https://nvd.nist.gov/developers/request-an-api-key
-NVD_API_KEY=
-```
-
---
-
-## File Summary
-
-| File | Action | Lines Changed (est.) |
-|------|--------|---------------------|
-| `backend/server.js` | Modify | +40 (NVD mount + 2 new endpoints) |
-| `backend/routes/nvdLookup.js` | From stash | 0 (already complete) |
-| `backend/.env.example` | From stash | +3 |
-| `frontend/src/components/NvdSyncModal.js` | New | ~350-400 |
-| `frontend/src/App.js` | Modify | +10 (import, state, button, modal) |
-| `frontend/src/components/AuditLog.js` | Modify | +1 (badge entry) |
-
---
-
-## Verification Checklist
-1. Pop stash, resolve conflict, verify `nvdLookup.js` and server.js are correct
-2. Test NVD lookup via curl: `curl -b cookie.txt http://localhost:3001/api/nvd/lookup/CVE-2024-3094`
-3. Test distinct-ids: `curl -b cookie.txt http://localhost:3001/api/cves/distinct-ids`
-4. Open Add CVE modal, type CVE ID, tab out → verify auto-fill works
-5. Click "Sync with NVD" button → modal opens with CVE count
-6. Click "Fetch NVD Data" → progress bar, rate-limited fetching
-7. Review comparison table → verify diffs shown correctly
-8. Toggle description choices, click "Apply" → verify database updated
-9. Confirm main CVE list refreshes with new data
-10. Check audit log for `cve_nvd_sync` entry
--- a/test_cases_auth.md
+++ b/test_cases_auth.md
@@ -1,7 +1,5 @@
 # Authentication Feature - Test Cases

-**Feature Branch:** feature/login
-**Date:** 2026-01-28
 **Tester:** _______________

 ---
Author	SHA1	Message	Date
jramos	d3806e8ce3	Add Reporting page with Ivanti host findings table Backend: - New route /api/ivanti/findings (GET cached data, POST /sync, PUT /:id/note) - Fetches all pages of hostFinding/search filtered to NTS-AEO groups, severity 8.5-9.9, Open state - SQLite cache (ivanti_findings_cache) stores slimmed findings across syncs - Separate ivanti_finding_notes table persists user notes by finding ID - Daily auto-sync on startup + 24h interval, manual sync endpoint - Notes capped at 255 chars server-side Frontend (ReportingPage): - Panel 1: Metric graphs placeholder (full width, amber theme) - Panel 2: Sortable findings table (all columns click-to-sort with ASC/DESC toggle) - Columns: Severity (color-coded badge), Title, Host, IP, DNS, SLA, Discovered, Last Found, Source, Notes - Notes column: inline editable input, saves on blur via PUT endpoint - Sync button with spinner, last-synced timestamp, error banner Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:56:37 -06:00
jramos	931c42faeb	Merge feature/navigation: Add hamburger nav menu with 4-page navigation structure Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:47:47 -06:00
jramos	ea3b72db5c	Add hamburger nav menu with 4-page navigation structure - NavDrawer component: slide-in left drawer with backdrop, matches dark theme - Nav items: Home, Reporting, Knowledge Base, Exports with color-coded icons - Active page highlighted with colored background + indicator dot - Placeholder pages for Reporting (amber), Knowledge Base (green), Exports (purple) - Stats bar and three-column layout conditionally render on Home page only - currentPage state drives all page switching Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:47:03 -06:00
jramos	d63e7cc9b9	Merge feature/remove-weekly-reports: Remove weekly report functionality Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:36:55 -06:00
jramos	37e183543a	Remove weekly report functionality - Delete backend/routes/weeklyReports.js - Delete backend/migrations/add_weekly_reports_table.js - Delete backend/scripts/split_cve_report.py - Delete backend/helpers/excelProcessor.js - Delete frontend/src/components/WeeklyReportModal.js - Remove import, state, button, and modal from App.js - Remove route registration and require from server.js - Drop weekly_reports table from SQLite database Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:32:39 -06:00
jramos	337ffe6f35	Merge feature/cleanup-branding: Rebrand dashboard header to STEAM Security Dashboard Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:26:19 -06:00
jramos	08c8c8a2a1	Rebrand dashboard header to STEAM Security Dashboard - Title: "CVE INTEL" → "STEAM Security Dashboard" - Subtitle: "Threat Intelligence & Vulnerability Command Center" → "NTS Threat Intelligence and Metric Aggregation" Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:25:21 -06:00
jramos	4ed7721a71	Merge feature/workflow: Add Ivanti Workflows panel Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-11 11:22:43 -06:00
jramos	3fb20c147d	Add Ivanti Workflows panel with API key auth and SQLite cache - New panel below Archer tickets showing workflow count and list - Backend proxies platform4.risksense.com workflowBatch/search via x-api-key - SQLite cache table (ivanti_sync_state) stores latest sync result - Auto-syncs on server startup if >24h stale, then every 24h via setInterval - POST /api/ivanti/workflows/sync for on-demand sync with spinner feedback - GET /api/ivanti/workflows returns cached data instantly (no live API call) - Displays id.value, name, currentState, type, createdOn per workflow - Shows last-synced timestamp and error messages inline - IVANTI_SKIP_TLS flag for Charter SSL proxy environments Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-10 15:29:33 -06:00
jramos	f2e6069c08	docs: overhaul documentation for fork readiness - Rewrite README from scratch: accurate stack versions, correct setup sequence, verified feature list, full API reference, architecture overview, and security model — all sourced directly from the codebase - Remove internal/stale docs: COLOR_SCHEME_MODERNIZATION.md, plan.md, frontend/README.md (CRA boilerplate) - Clean up DESIGN_SYSTEM.md: remove emoji headers and version footer - Fix WEEKLY_REPORT_FEATURE.md: replace hardcoded absolute paths with relative paths - Clean up test_cases_auth.md: remove stale branch and date references Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-02-26 14:30:17 -07:00
jramos	c89404cf26	Add CVE list pagination to prevent endless scrolling Shows 5 CVEs by default with 'Show 5 more' and 'Show all' controls. Resets to 5 when filters or search change. Collapses back when fully expanded. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-02-23 12:37:44 -07:00
jramos	af7a5becef	Merge feature/archer: Add Archer Risk Acceptance Tickets	2026-02-23 11:08:28 -07:00
jramos	7145117518	Fix: Correct database filename in Archer tickets migration Changed cve_tracker.db to cve_database.db to match server.js configuration. Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>	2026-02-18 15:14:29 -07:00
jramos	30739dc162	Add Archer Risk Acceptance Tickets feature - Add archer_tickets table with EXC number, Archer URL, status, CVE, and vendor - Create backend routes for CRUD operations on Archer tickets - Add right panel section displaying active Archer tickets - Implement modals for creating and editing Archer tickets - Validate EXC number format (EXC-XXXX) - Support statuses: Draft, Open, Under Review, Accepted - Purple theme (#8B5CF6) to distinguish from JIRA tickets - Role-based access control for create/edit/delete operations Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>	2026-02-18 15:07:07 -07:00
jramos	b0d2f915bd	added migration and feature set for archer ticekts	2026-02-18 15:02:25 -07:00