-- eCW Charge Validation: look at the Portal tables and Started By (read-only).
-- Run in SSMS against MECARE331\MECARE331; the bot's Windows login is enough.
-- Added 2026-10-22 (EEWA-32 / EEWA-33). The password hash and salt are left
-- out of the user query on purpose, so a screenshot of it shares nothing.
USE Charge_Validation;
GO

-- Portal Users
SELECT username, display_name, role, must_change, disabled,
       failed_count, locked_until, created_at, created_by, changed_at
FROM dbo.CV_PortalUser
ORDER BY username;

-- Sign-in history, newest first
SELECT TOP 200 at, username, event, by_user
FROM dbo.CV_PortalSignIn
ORDER BY id DESC;

-- Results with Started By, newest run first (NULL before 2026-10-22)
SELECT TOP 200 run_at, run_mode, started_by, s_no, claim_no, category,
       current_status
FROM dbo.CV_ChargeSummary
ORDER BY run_at DESC, s_no;

-- One row per run: who started it and its counts
SELECT run_at, MAX(started_by) AS started_by, COUNT(*) AS claims,
       SUM(CASE WHEN category = 'Pass'   THEN 1 ELSE 0 END) AS pass_count,
       SUM(CASE WHEN category = 'Fail'   THEN 1 ELSE 0 END) AS fail_count,
       SUM(CASE WHEN category = 'Review' THEN 1 ELSE 0 END) AS review_count
FROM dbo.CV_ChargeSummary
GROUP BY run_at
ORDER BY run_at DESC;