sql-vulnerability-management-analytics/sample_data.sql at main · gabryellewalker/sql-vulnerability-management-analytics · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
INSERT INTO assets VALUES
(1, 'AD-SRV-01', 'Domain Controller', 'IT', 'Critical', 'Infrastructure Team'),
(2, 'DB-PROD-01', 'Database Server', 'Finance', 'Critical', 'Database Team'),
(3, 'HR-FILE-01', 'File Server', 'Human Resources', 'High', 'Infrastructure Team'),
(4, 'WEB-EXT-01', 'Web Server', 'Digital', 'High', 'Web Operations'),
(5, 'OPS-WS-04', 'Workstation', 'Operations', 'Medium', 'Endpoint Team'),
(6, 'FIN-WS-01', 'Workstation', 'Finance', 'High', 'Endpoint Team');

INSERT INTO vulnerabilities VALUES
(101, 'Windows SMB Remote Code Execution', 'CVE-2020-0796', 10.0, 'Critical', TRUE),
(102, 'Unsupported SQL Server Version', NULL, 9.0, 'Critical', FALSE),
(103, 'Weak TLS Cipher Suites', NULL, 7.5, 'High', FALSE),
(104, 'Default Administrative Credentials', NULL, 9.8, 'Critical', TRUE),
(105, 'Missing Critical OS Patches', NULL, 8.8, 'High', TRUE),
(106, 'Exposed RDP Service', NULL, 8.1, 'High', TRUE),
(107, 'Outdated Web Framework', NULL, 6.5, 'Medium', FALSE),
(108, 'Weak Certificate Signature', NULL, 5.9, 'Medium', FALSE);

INSERT INTO findings VALUES
(1001, 1, 101, '2026-06-01', 'Open', '2026-06-08', '2026-08-15'),
(1002, 2, 102, '2026-05-10', 'In Progress', '2026-06-10', '2026-08-15'),
(1003, 4, 103, '2026-07-01', 'Open', '2026-07-31', '2026-08-15'),
(1004, 1, 104, '2026-07-15', 'Open', '2026-07-22', '2026-08-15'),
(1005, 3, 105, '2026-07-20', 'Resolved', '2026-08-03', '2026-08-15'),
(1006, 5, 106, '2026-08-01', 'Open', '2026-08-15', '2026-08-15'),
(1007, 4, 107, '2026-08-03', 'Open', '2026-09-02', '2026-08-15'),
(1008, 6, 105, '2026-07-28', 'In Progress', '2026-08-11', '2026-08-15'),
(1009, 2, 103, '2026-07-18', 'Open', '2026-08-17', '2026-08-15'),
(1010, 3, 108, '2026-08-05', 'Open', '2026-09-04', '2026-08-15'),
(1011, 2, 104, '2026-08-02', 'Open', '2026-08-09', '2026-08-15'),
(1012, 1, 105, '2026-08-06', 'In Progress', '2026-08-20', '2026-08-15');

INSERT INTO remediation VALUES
(1, 1001, 'Alex Kim', 'Test and deploy vendor SMB security updates.', NULL, 'Pending'),
(2, 1002, 'Morgan Lee', 'Plan SQL Server upgrade and migration.', NULL, 'Pending'),
(3, 1003, 'Taylor Reed', 'Disable weak TLS ciphers and validate configuration.', NULL, 'Pending'),
(4, 1004, 'Alex Kim', 'Remove default credentials and enforce strong authentication.', NULL, 'Pending'),
(5, 1005, 'Jordan Patel', 'Deploy missing OS patches and rescan.', '2026-08-01', 'Verified'),
(6, 1006, 'Jordan Patel', 'Restrict RDP exposure and review remote access controls.', NULL, 'Pending'),
(7, 1007, 'Taylor Reed', 'Upgrade web framework after compatibility testing.', NULL, 'Pending'),
(8, 1008, 'Jordan Patel', 'Deploy OS updates and validate endpoint health.', NULL, 'Pending'),
(9, 1009, 'Morgan Lee', 'Update database TLS configuration.', NULL, 'Pending'),
(10, 1010, 'Alex Kim', 'Replace weak certificate signature algorithm.', NULL, 'Pending'),
(11, 1011, 'Morgan Lee', 'Remove default database credentials.', NULL, 'Pending'),
(12, 1012, 'Alex Kim', 'Patch domain controller and verify remediation.', NULL, 'Pending');