3_INSERT_Script.txt

-- Cluster Table

INSERT INTO Cluster_Table (Server_ID, IP_Address, Log_Format, Location) VALUES
(1, '192.168.1.1', 'JSON', 'New York'),
(2, '192.168.1.2', 'XML', 'Mumbai'),
(3, '192.168.1.3', 'PlainText', 'Tokyo');


-- Server 1 Logs

INSERT INTO Server_ID_1_Logs (Startup, Shutdown, Cost, Server_ID) VALUES -- 12 per hour
('2025-04-01 06:00:00', '2025-04-01 09:00:00', 36.00, 1),
('2025-04-01 10:00:00', '2025-04-01 13:30:00', 42.00, 1),
('2025-04-01 14:30:00', '2025-04-01 18:30:00', 48.00, 1),
('2025-04-01 20:00:00', '2025-04-02 00:00:00', 48.00, 1),
('2025-04-02 01:00:00', '2025-04-02 03:00:00', 24.00, 1),
('2025-04-02 05:00:00', '2025-04-02 08:00:00', 36.00, 1),
('2025-04-02 09:00:00', '2025-04-02 12:00:00', 36.00, 1),
('2025-04-02 13:00:00', '2025-04-02 16:30:00', 42.00, 1),
('2025-04-02 17:30:00', '2025-04-02 20:30:00', 36.00, 1),
('2025-04-03 00:00:00', '2025-04-03 04:00:00', 48.00, 1),
('2025-04-03 06:00:00', '2025-04-03 09:00:00', 36.00, 1),
('2025-04-03 10:00:00', '2025-04-03 14:00:00', 48.00, 1),
('2025-04-03 15:00:00', '2025-04-03 17:00:00', 24.00, 1),
('2025-04-03 18:00:00', '2025-04-03 20:00:00', 24.00, 1),
('2025-04-04 00:00:00', '2025-04-04 03:30:00', 42.00, 1),
('2025-04-04 04:30:00', '2025-04-04 08:30:00', 48.00, 1),
('2025-04-04 09:30:00', '2025-04-04 11:30:00', 24.00, 1),
('2025-04-04 13:00:00', '2025-04-04 15:30:00', 30.00, 1),
('2025-04-04 16:00:00', '2025-04-04 18:00:00', 24.00, 1),
('2025-04-04 19:00:00', '2025-04-04 22:00:00', 36.00, 1),
('2025-04-05 01:00:00', '2025-04-05 03:00:00', 24.00, 1),
('2025-04-05 04:00:00', '2025-04-05 07:30:00', 42.00, 1),
('2025-04-05 09:00:00', '2025-04-05 13:00:00', 48.00, 1),
('2025-04-05 14:00:00', '2025-04-05 16:00:00', 24.00, 1),
('2025-04-05 17:00:00', '2025-04-05 20:00:00', 36.00, 1),
('2025-04-06 00:00:00', '2025-04-06 03:00:00', 36.00, 1),
('2025-04-06 04:30:00', '2025-04-06 08:30:00', 48.00, 1),
('2025-04-06 09:30:00', '2025-04-06 13:00:00', 42.00, 1),
('2025-04-06 14:00:00', '2025-04-06 18:00:00', 48.00, 1),
('2025-04-06 19:00:00', NULL, NULL, 1); -- server currently running


-- Server 1 Server Logs

INSERT INTO Server_ID_1_Server_Logs (TimestampSL1, Temperature, Disk_Space_Usage, Memory_Space_Usage, CPU_Utilization, Startup) VALUES
('2025-04-01 06:15:00', '80°C', 320000, 16000, '45%', '2025-04-01 06:00:00'),
('2025-04-01 07:00:00', '75°C', 340000, 16384, '52%', '2025-04-01 06:00:00'),
('2025-04-01 08:15:00', '78°C', 350000, 15800, '49%', '2025-04-01 06:00:00'),

('2025-04-01 10:15:00', '70°C', 3100100, 15400, '38%', '2025-04-01 10:00:00'),
('2025-04-01 11:30:00', '73°C', 330000, 15000, '42%', '2025-04-01 10:00:00'),
('2025-04-01 12:45:00', '76°C', 360000, 141900, '55%', '2025-04-01 10:00:00'),
('2025-04-01 13:15:00', '80°C', 370000, 14500, '61%', '2025-04-01 10:00:00'),

('2025-04-01 15:00:00', '69°C', 300000, 14000, '35%', '2025-04-01 14:30:00'),
('2025-04-01 16:30:00', '85°C', 300005, 14200, '40%', '2025-04-01 14:30:00'),
('2025-04-01 17:45:00', '74°C', 310000, 14300, '46%', '2025-04-01 14:30:00'),
('2025-04-01 18:15:00', '77°C', 320000, 14600, '51%', '2025-04-01 14:30:00'),

('2025-04-01 20:30:00', '68°C', 290005, 13800, '37%', '2025-04-01 20:00:00'),
('2025-04-01 21:15:00', '70°C', 300000, 14000, '41%', '2025-04-01 20:00:00'),
('2025-04-01 22:00:00', '74°C', 300005, 14250, '50%', '2025-04-01 20:00:00'),

('2025-04-02 01:00:00', '71°C', 310000, 14300, '47%', '2025-04-02 01:00:00'),
('2025-04-02 02:00:00', '73°C', 320000, 14400, '55%', '2025-04-02 01:00:00'),
('2025-04-02 03:00:00', '75°C', 330000, 14500, '60%', '2025-04-02 01:00:00'),

('2025-04-02 05:30:00', '83°C', 280000, 13500, '30%', '2025-04-02 05:00:00'),
('2025-04-02 06:30:00', '68°C', 2901000, 13750, '36%', '2025-04-02 05:00:00'),
('2025-04-02 07:30:00', '70°C', 300000, 138010, '41%', '2025-04-02 05:00:00'),
('2025-04-02 08:30:00', '72°C', 310000, 14000, '48%', '2025-04-02 05:00:00'),
('2025-04-02 09:00:00', '73°C', 320000, 14100, '51%', '2025-04-02 05:00:00'),

('2025-04-02 12:30:00', '74°C', 300005, 14200, '49%', '2025-04-02 12:00:00'),
('2025-04-02 13:45:00', '67°C', 310005, 14450, '53%', '2025-04-02 12:00:00'),
('2025-04-02 14:30:00', '80°C', 320005, 14600, '57%', '2025-04-02 12:00:00'),
('2025-04-02 15:45:00', '82°C', 330000, 14700, '61%', '2025-04-02 12:00:00'),

('2025-04-02 18:00:00', '70°C', 290005, 13800, '42%', '2025-04-02 17:30:00'),
('2025-04-02 19:00:00', '72°C', 300000, 14000, '47%', '2025-04-02 17:30:00'),
('2025-04-02 20:00:00', '75°C', 305000, 14100, '52%', '2025-04-02 17:30:00'),

('2025-04-03 00:30:00', '69°C', 290000, 13700, '39%', '2025-04-03 00:00:00'),
('2025-04-03 01:30:00', '71°C', 295000, 13850, '43%', '2025-04-03 00:00:00'),
('2025-04-03 02:30:00', '74°C', 300000, 13900, '48%', '2025-04-03 00:00:00'),
('2025-04-03 03:30:00', '86°C', 300005, 14000, '54%', '2025-04-03 00:00:00'),

('2025-04-03 06:15:00', '67°C', 280005, 13500, '36%', '2025-04-03 06:00:00'),
('2025-04-03 07:15:00', '80°C', 290000, 13700, '41%', '2025-04-03 06:00:00'),
('2025-04-03 08:15:00', '72°C', 290005, 13850, '46%', '2025-04-03 06:00:00'),

('2025-04-03 11:30:00', '73°C', 300000, 14000, '49%', '2025-04-03 11:00:00'),
('2025-04-03 12:30:00', '75°C', 3000110, 14150, '53%', '2025-04-03 11:00:00'),
('2025-04-03 13:30:00', '78°C', 310005, 14300, '57%', '2025-04-03 11:00:00'),
('2025-04-03 14:30:00', '80°C', 320000, 114400, '62%', '2025-04-03 11:00:00'),

('2025-04-03 17:00:00', '69°C', 285000, 13600, '40%', '2025-04-03 16:30:00'),
('2025-04-03 18:00:00', '71°C', 290000, 13750, '45%', '2025-04-03 16:30:00'),
('2025-04-03 19:00:00', '74°C', 295000, 13800, '50%', '2025-04-03 16:30:00'),

('2025-04-04 00:00:00', '68°C', 280000, 13500, '34%', '2025-04-03 23:30:00'),
('2025-04-04 01:15:00', '70°C', 285000, 13650, '39%', '2025-04-03 23:30:00'),
('2025-04-04 02:15:00', '83°C', 290000, 13800, '44%', '2025-04-03 23:30:00'),
('2025-04-04 03:15:00', '74°C', 295000, 13900, '48%', '2025-04-03 23:30:00'),

('2025-04-04 06:00:00', '67°C', 270005, 13200, '32%', '2025-04-04 05:30:00'),
('2025-04-04 07:00:00', '69°C', 280000, 13400, '36%', '2025-04-04 05:30:00'),
('2025-04-04 08:00:00', '71°C', 280005, 13550, '41%', '2025-04-04 05:30:00'),

('2025-04-04 11:30:00', '73°C', 290005, 13700, '46%', '2025-04-04 11:00:00'),
('2025-04-04 12:45:00', '76°C', 300005, 13900, '51%', '2025-04-04 11:00:00'),
('2025-04-04 14:00:00', '78°C', 310000, 14050, '55%', '2025-04-04 11:00:00'),

('2025-04-04 17:00:00', '68°C', 285000, 13550, '40%', '2025-04-04 16:30:00'),
('2025-04-04 18:15:00', '70°C', 290000, 13700, '45%', '2025-04-04 16:30:00'),
('2025-04-04 19:30:00', '72°C', 295000, 13800, '50%', '2025-04-04 16:30:00'),

('2025-04-05 00:30:00', '66°C', 275000, 13300, '33%', '2025-04-05 00:00:00'),
('2025-04-05 01:30:00', '69°C', 280000, 134150, '38%', '2025-04-05 00:00:00'),
('2025-04-05 02:30:00', '71°C', 285000, 13600, '43%', '2025-04-05 00:00:00'),
('2025-04-05 03:30:00', '74°C', 290000, 13750, '48%', '2025-04-05 00:00:00'),

('2025-04-05 06:15:00', '67°C', 278000, 13350, '36%', '2025-04-05 06:00:00'),
('2025-04-05 07:15:00', '69°C', 2821000, 13480, '40%', '2025-04-05 06:00:00'),
('2025-04-05 08:15:00', '71°C', 286000, 13620, '45%', '2025-04-05 06:00:00'),
('2025-04-05 09:15:00', '73°C', 290000, 13700, '49%', '2025-04-05 06:00:00'),

('2025-04-05 12:30:00', '74°C', 295000, 13750, '51%', '2025-04-05 12:00:00'),
('2025-04-05 13:30:00', '84°C', 300000, 13900, '55%', '2025-04-05 12:00:00'),
('2025-04-05 14:30:00', '78°C', 305000, 14050, '60%', '2025-04-05 12:00:00'),

('2025-04-05 17:00:00', '70°C', 280005, 13500, '42%', '2025-04-05 16:30:00'),
('2025-04-05 18:00:00', '72°C', 290000, 13650, '46%', '2025-04-05 16:30:00'),
('2025-04-05 19:00:00', '81°C', 290005, 13800, '50%', '2025-04-05 16:30:00'),
('2025-04-05 20:00:00', '76°C', 300000, 13950, '54%', '2025-04-05 16:30:00'),

('2025-04-06 00:30:00', '68°C', 280000, 13400, '36%', '2025-04-06 00:00:00'),
('2025-04-06 01:30:00', '70°C', 285000, 13550, '40%', '2025-04-06 00:00:00'),
('2025-04-06 02:30:00', '72°C', 290000, 13700, '45%', '2025-04-06 00:00:00'),
('2025-04-06 03:30:00', '74°C', 295000, 13850, '49%', '2025-04-06 00:00:00'),
('2025-04-06 04:30:00', '76°C', 300000, 14000, '53%', '2025-04-06 00:00:00'),

('2025-04-06 06:45:00', '69°C', 2813000, 134180, '38%', '2025-04-06 06:30:00'),
('2025-04-06 07:45:00', '71°C', 288000, 13620, '42%', '2025-04-06 06:30:00'),
('2025-04-06 08:45:00', '74°C', 293000, 13760, '47%', '2025-04-06 06:30:00'),
('2025-04-06 09:45:00', '76°C', 298000, 13900, '52%', '2025-04-06 06:30:00'),

('2025-04-06 12:30:00', '75°C', 294000, 13750, '49%', '2025-04-06 12:00:00'),
('2025-04-06 13:30:00', '85°C', 299000, 13900, '53%', '2025-04-06 12:00:00'),
('2025-04-06 14:30:00', '79°C', 3041000, 14050, '57%', '2025-04-06 12:00:00'),
('2025-04-06 15:30:00', '81°C', 309000, 14200, '61%', '2025-04-06 12:00:00'),

('2025-04-06 18:30:00', '70°C', 285000, 135100, '40%', '2025-04-06 18:00:00'),
('2025-04-06 19:30:00', '72°C', 290000, 13620, '44%', '2025-04-06 18:00:00'),
('2025-04-06 20:30:00', '74°C', 295000, 13740, '48%', '2025-04-06 18:00:00'),

('2025-04-07 00:15:00', '69°C', 283000, 13400, '35%', '2025-04-07 00:00:00'),
('2025-04-07 01:15:00', '71°C', 287000, 13550, '40%', '2025-04-07 00:00:00'),
('2025-04-07 02:15:00', '73°C', 2911000, 13700, '45%', '2025-04-07 00:00:00'),
('2025-04-07 03:15:00', '75°C', 295000, 113850, '50%', '2025-04-07 00:00:00'),

('2025-04-07 06:15:00', '68°C', 280000, 13300, '34%', '2025-04-07 06:00:00'),
('2025-04-07 07:15:00', '70°C', 284000, 13450, '38%', '2025-04-07 06:00:00'),
('2025-04-07 08:15:00', '72°C', 288000, 13600, '43%', '2025-04-07 06:00:00'),
('2025-04-07 09:15:00', '81°C', 292000, 13750, '47%', '2025-04-07 06:00:00'),

('2025-04-07 12:30:00', '76°C', 296000, 13800, '50%', '2025-04-07 12:00:00'),
('2025-04-07 13:30:00', '78°C', 301000, 13950, '54%', '2025-04-07 12:00:00'),
('2025-04-07 14:30:00', '80°C', 306000, 14100, '58%', '2025-04-07 12:00:00'),
('2025-04-07 15:30:00', '82°C', 311000, 14250, '62%', '2025-04-07 12:00:00'),
('2025-04-07 16:30:00', '84°C', 316000, 14400, '66%', '2025-04-07 12:00:00'),

('2025-04-07 19:30:00', '71°C', 286000, 13480, '41%', '2025-04-07 19:00:00'),
('2025-04-07 20:30:00', '73°C', 2911000, 13630, '45%', '2025-04-07 19:00:00'),
('2025-04-07 21:30:00', '75°C', 296000, 13780, '49%', '2025-04-07 19:00:00'),

('2025-04-08 00:15:00', '69°C', 283000, 13420, '36%', '2025-04-08 00:00:00'),
('2025-04-08 01:15:00', '71°C', 288000, 13570, '40%', '2025-04-08 00:00:00'),
('2025-04-08 02:15:00', '73°C', 293000, 13720, '45%', '2025-04-08 00:00:00'),
('2025-04-08 03:15:00', '75°C', 290008, 13870, '49%', '2025-04-08 00:00:00'),

('2025-04-08 06:30:00', '70°C', 285000, 13500, '39%', '2025-04-08 06:00:00'),
('2025-04-08 07:30:00', '72°C', 290000, 113640, '43%', '2025-04-08 06:00:00'),
('2025-04-08 08:30:00', '74°C', 295000, 13780, '47%', '2025-04-08 06:00:00'),
('2025-04-08 09:30:00', '76°C', 300000, 13920, '52%', '2025-04-08 06:00:00'),
('2025-04-08 10:30:00', '78°C', 305000, 14060, '56%', '2025-04-08 06:00:00');


-- Server 1 Application  Logs

INSERT INTO Server_ID_1_Application_Logs (TimestampAL1, Client_IP_AddressAL1, HTTP_Method, Event_TypeAL1, End_PointAL1, Status_CodeAL1, Startup) VALUES
('2025-04-01 08:39:00', '192.168.1.158', 'GET', 'Logout', '/api/settings', 404, '2025-04-01 08:00:00'),
('2025-04-01 09:20:00', '192.168.1.128', 'DELETE', 'Error', '/api/upload', 200, '2025-04-01 08:00:00'),
('2025-04-01 09:23:00', '192.168.1.110', 'GET', 'DataFetch', '/api/settings', 200, '2025-04-01 08:00:00'),
('2025-04-01 09:28:00', '192.168.1.180', 'GET', 'Update', '/api/download', 403, '2025-04-01 08:00:00'),
('2025-04-01 09:06:00', '192.168.1.142', 'POST', 'Error', '/api/upload', 500, '2025-04-01 08:00:00'),
('2025-04-01 15:57:00', '192.168.1.182', 'PUT', 'Update', '/api/user', 400, '2025-04-01 15:54:00'),
('2025-04-01 16:15:00', '192.168.1.175', 'DELETE', 'Update', '/api/settings', 404, '2025-04-01 15:54:00'),
('2025-04-01 16:08:00', '192.168.1.114', 'GET', 'DataFetch', '/api/data', 400, '2025-04-01 15:54:00'),
('2025-04-01 16:38:00', '192.168.1.191', 'GET', 'Update', '/api/upload', 201, '2025-04-01 15:54:00'),
('2025-04-01 17:08:00', '192.168.1.198', 'DELETE', 'Login', '/api/upload', 403, '2025-04-01 15:54:00'),
('2025-04-01 17:23:00', '192.168.1.158', 'POST', 'Update', '/api/data', 200, '2025-04-01 17:06:00'),
('2025-04-01 18:10:00', '192.168.1.135', 'POST', 'Logout', '/api/settings', 404, '2025-04-01 17:06:00'),
('2025-04-01 17:34:00', '192.168.1.147', 'DELETE', 'Error', '/api/user', 201, '2025-04-01 17:06:00'),
('2025-04-01 17:13:00', '192.168.1.169', 'GET', 'Logout', '/api/settings', 404, '2025-04-01 17:06:00'),
('2025-04-01 17:45:00', '192.168.1.193', 'POST', 'DataFetch', '/api/settings', 201, '2025-04-01 17:06:00'),
('2025-04-02 01:42:00', '192.168.1.107', 'POST', 'Error', '/api/upload', 403, '2025-04-02 01:21:00'),
('2025-04-02 01:50:00', '192.168.1.134', 'POST', 'Logout', '/api/settings', 401, '2025-04-02 01:21:00'),
('2025-04-02 01:35:00', '192.168.1.147', 'PUT', 'Update', '/api/user', 400, '2025-04-02 01:21:00'),
('2025-04-02 02:28:00', '192.168.1.140', 'POST', 'DataFetch', '/api/upload', 404, '2025-04-02 01:21:00'),
('2025-04-02 07:10:00', '192.168.1.100', 'PUT', 'DataFetch', '/api/settings', 500, '2025-04-02 05:55:00'),
('2025-04-02 07:05:00', '192.168.1.122', 'DELETE', 'Logout', '/api/upload', 200, '2025-04-02 05:55:00'),
('2025-04-02 07:21:00', '192.168.1.198', 'GET', 'Update', '/api/user', 403, '2025-04-02 05:55:00'),
('2025-04-02 07:05:00', '192.168.1.140', 'DELETE', 'Logout', '/api/upload', 201, '2025-04-02 05:55:00'),
('2025-04-02 06:36:00', '192.168.1.119', 'POST', 'Error', '/api/upload', 400, '2025-04-02 05:55:00'),
('2025-04-02 13:50:00', '192.168.1.107', 'PUT', 'Logout', '/api/settings', 403, '2025-04-02 12:51:00'),
('2025-04-02 14:07:00', '192.168.1.160', 'GET', 'DataFetch', '/api/data', 200, '2025-04-02 12:51:00'),
('2025-04-02 14:11:00', '192.168.1.145', 'POST', 'Logout', '/api/upload', 401, '2025-04-02 12:51:00'),
('2025-04-02 13:54:00', '192.168.1.153', 'GET', 'Update', '/api/user', 500, '2025-04-02 12:51:00'),
('2025-04-02 13:56:00', '192.168.1.188', 'DELETE', 'Login', '/api/data', 200, '2025-04-02 12:51:00'),
('2025-04-02 14:09:00', '192.168.1.130', 'PUT', 'Update', '/api/settings', 403, '2025-04-02 12:51:00'),
('2025-04-02 20:32:00', '192.168.1.103', 'GET', 'DataFetch', '/api/data', 200, '2025-04-02 19:42:00'),
('2025-04-02 20:15:00', '192.168.1.123', 'DELETE', 'Update', '/api/data', 404, '2025-04-02 19:42:00'),
('2025-04-02 20:19:00', '192.168.1.165', 'POST', 'Error', '/api/settings', 500, '2025-04-02 19:42:00'),
('2025-04-02 20:04:00', '192.168.1.148', 'POST', 'Logout', '/api/upload', 400, '2025-04-02 19:42:00'),
('2025-04-02 20:22:00', '192.168.1.196', 'GET', 'Login', '/api/settings', 401, '2025-04-02 19:42:00'),
('2025-04-03 03:10:00', '192.168.1.149', 'PUT', 'Logout', '/api/user', 404, '2025-04-03 02:23:00'),
('2025-04-03 03:25:00', '192.168.1.180', 'GET', 'DataFetch', '/api/settings', 403, '2025-04-03 02:23:00'),
('2025-04-03 03:19:00', '192.168.1.128', 'POST', 'Logout', '/api/settings', 400, '2025-04-03 02:23:00'),
('2025-04-03 03:16:00', '192.168.1.133', 'DELETE', 'Error', '/api/upload', 500, '2025-04-03 02:23:00'),
('2025-04-03 03:28:00', '192.168.1.122', 'POST', 'Login', '/api/user', 200, '2025-04-03 02:23:00'),
('2025-04-03 08:07:00', '192.168.1.150', 'PUT', 'Login', '/api/user', 404, '2025-04-03 06:52:00'),
('2025-04-03 08:03:00', '192.168.1.144', 'GET', 'Logout', '/api/upload', 200, '2025-04-03 06:52:00'),
('2025-04-03 08:06:00', '192.168.1.155', 'DELETE', 'Update', '/api/user', 403, '2025-04-03 06:52:00'),
('2025-04-03 07:55:00', '192.168.1.118', 'POST', 'Logout', '/api/data', 401, '2025-04-03 06:52:00'),
('2025-04-03 07:48:00', '192.168.1.183', 'GET', 'DataFetch', '/api/data', 200, '2025-04-03 06:52:00'),
('2025-04-03 14:33:00', '192.168.1.109', 'PUT', 'Login', '/api/upload', 500, '2025-04-03 13:50:00'),
('2025-04-03 14:01:00', '192.168.1.197', 'DELETE', 'Error', '/api/upload', 403, '2025-04-03 13:50:00'),
('2025-04-03 14:02:00', '192.168.1.120', 'GET', 'Logout', '/api/user', 200, '2025-04-03 13:50:00'),
('2025-04-03 14:11:00', '192.168.1.179', 'POST', 'Error', '/api/data', 401, '2025-04-03 13:50:00'),
('2025-04-03 14:13:00', '192.168.1.169', 'POST', 'Logout', '/api/upload', 404, '2025-04-03 13:50:00'),
('2025-04-03 20:21:00', '192.168.1.106', 'GET', 'Login', '/api/upload', 500, '2025-04-03 19:26:00'),
('2025-04-03 20:19:00', '192.168.1.131', 'DELETE', 'Error', '/api/settings', 404, '2025-04-03 19:26:00'),
('2025-04-03 20:15:00', '192.168.1.170', 'POST', 'Logout', '/api/data', 403, '2025-04-03 19:26:00'),
('2025-04-03 20:28:00', '192.168.1.195', 'PUT', 'Login', '/api/user', 401, '2025-04-03 19:26:00'),
('2025-04-03 20:13:00', '192.168.1.181', 'GET', 'DataFetch', '/api/upload', 200, '2025-04-03 19:26:00'),
('2025-04-04 01:55:00', '192.168.1.127', 'POST', 'Logout', '/api/settings', 404, '2025-04-04 01:05:00'),
('2025-04-04 01:48:00', '192.168.1.112', 'GET', 'DataFetch', '/api/settings', 200, '2025-04-04 01:05:00'),
('2025-04-04 01:57:00', '192.168.1.134', 'PUT', 'Login', '/api/upload', 403, '2025-04-04 01:05:00'),
('2025-04-04 01:41:00', '192.168.1.171', 'DELETE', 'Error', '/api/user', 401, '2025-04-04 01:05:00'),
('2025-04-04 01:52:00', '192.168.1.114', 'POST', 'Update', '/api/data', 500, '2025-04-04 01:05:00'),
('2025-04-04 08:31:00', '192.168.1.159', 'GET', 'Login', '/api/user', 200, '2025-04-04 07:50:00'),
('2025-04-04 08:22:00', '192.168.1.101', 'PUT', 'Update', '/api/data', 404, '2025-04-04 07:50:00'),
('2025-04-04 08:20:00', '192.168.1.186', 'POST', 'Error', '/api/settings', 403, '2025-04-04 07:50:00'),
('2025-04-04 08:12:00', '192.168.1.141', 'DELETE', 'Logout', '/api/settings', 500, '2025-04-04 07:50:00'),
('2025-04-04 08:28:00', '192.168.1.192', 'GET', 'DataFetch', '/api/upload', 401, '2025-04-04 07:50:00'),
('2025-04-04 14:33:00', '192.168.1.147', 'PUT', 'Update', '/api/user', 500, '2025-04-04 13:49:00'),
('2025-04-04 14:12:00', '192.168.1.140', 'POST', 'Login', '/api/data', 200, '2025-04-04 13:49:00'),
('2025-04-04 14:05:00', '192.168.1.135', 'DELETE', 'Logout', '/api/settings', 404, '2025-04-04 13:49:00'),
('2025-04-04 14:28:00', '192.168.1.115', 'GET', 'Error', '/api/user', 403, '2025-04-04 13:49:00'),
('2025-04-04 14:18:00', '192.168.1.152', 'POST', 'Logout', '/api/upload', 401, '2025-04-04 13:49:00'),
('2025-04-04 21:24:00', '192.168.1.193', 'POST', 'DataFetch', '/api/settings', 500, '2025-04-04 20:17:00'),
('2025-04-04 21:06:00', '192.168.1.146', 'DELETE', 'Update', '/api/settings', 403, '2025-04-04 20:17:00'),
('2025-04-04 21:14:00', '192.168.1.173', 'GET', 'Logout', '/api/user', 200, '2025-04-04 20:17:00'),
('2025-04-04 21:18:00', '192.168.1.151', 'PUT', 'Login', '/api/user', 404, '2025-04-04 20:17:00'),
('2025-04-04 21:21:00', '192.168.1.157', 'GET', 'Error', '/api/data', 401, '2025-04-04 20:17:00'),
('2025-04-05 03:09:00', '192.168.1.109', 'GET', 'Login', '/api/user', 200, '2025-04-05 02:11:00'),
('2025-04-05 03:00:00', '192.168.1.172', 'PUT', 'Update', '/api/upload', 500, '2025-04-05 02:11:00'),
('2025-04-05 03:13:00', '192.168.1.167', 'POST', 'Error', '/api/user', 403, '2025-04-05 02:11:00'),
('2025-04-05 03:12:00', '192.168.1.184', 'GET', 'DataFetch', '/api/settings', 404, '2025-04-05 02:11:00'),
('2025-04-05 03:18:00', '192.168.1.110', 'DELETE', 'Logout', '/api/settings', 401, '2025-04-05 02:11:00'),
('2025-04-05 11:05:00', '192.168.1.102', 'GET', 'Login', '/api/data', 200, '2025-04-05 10:23:00'),
('2025-04-05 11:11:00', '192.168.1.165', 'PUT', 'Update', '/api/upload', 404, '2025-04-05 10:23:00'),
('2025-04-05 11:19:00', '192.168.1.198', 'DELETE', 'Logout', '/api/user', 500, '2025-04-05 10:23:00'),
('2025-04-05 11:16:00', '192.168.1.128', 'POST', 'Error', '/api/user', 401, '2025-04-05 10:23:00'),
('2025-04-05 11:00:00', '192.168.1.138', 'GET', 'DataFetch', '/api/settings', 403, '2025-04-05 10:23:00'),
('2025-04-05 18:22:00', '192.168.1.124', 'POST', 'Update', '/api/upload', 200, '2025-04-05 17:15:00'),
('2025-04-05 18:25:00', '192.168.1.149', 'GET', 'Error', '/api/data', 404, '2025-04-05 17:15:00'),
('2025-04-05 18:26:00', '192.168.1.150', 'PUT', 'Login', '/api/user', 401, '2025-04-05 17:15:00'),
('2025-04-05 18:33:00', '192.168.1.133', 'DELETE', 'Logout', '/api/user', 500, '2025-04-05 17:15:00'),
('2025-04-05 18:19:00', '192.168.1.153', 'GET', 'DataFetch', '/api/settings', 403, '2025-04-05 17:15:00'),
('2025-04-06 01:42:00', '192.168.1.119', 'POST', 'Login', '/api/data', 404, '2025-04-06 00:59:00'),
('2025-04-06 01:44:00', '192.168.1.104', 'GET', 'DataFetch', '/api/upload', 200, '2025-04-06 00:59:00'),
('2025-04-06 01:53:00', '192.168.1.125', 'PUT', 'Update', '/api/user', 403, '2025-04-06 00:59:00'),
('2025-04-06 01:38:00', '192.168.1.189', 'DELETE', 'Logout', '/api/settings', 401, '2025-04-06 00:59:00'),
('2025-04-06 01:36:00', '192.168.1.182', 'POST', 'Error', '/api/settings', 500, '2025-04-06 00:59:00'),
('2025-04-06 09:31:00', '192.168.1.145', 'GET', 'Login', '/api/upload', 403, '2025-04-06 08:43:00'),
('2025-04-06 09:18:00', '192.168.1.130', 'PUT', 'Update', '/api/user', 200, '2025-04-06 08:43:00'),
('2025-04-06 09:21:00', '192.168.1.100', 'DELETE', 'Logout', '/api/settings', 404, '2025-04-06 08:43:00'),
('2025-04-06 09:17:00', '192.168.1.144', 'POST', 'Error', '/api/data', 500, '2025-04-06 08:43:00'),
('2025-04-06 09:29:00', '192.168.1.158', 'GET', 'DataFetch', '/api/user', 401, '2025-04-06 08:43:00'),
('2025-04-06 16:20:00', '192.168.1.157', 'POST', 'Login', '/api/user', 200, '2025-04-06 15:34:00'),
('2025-04-06 16:28:00', '192.168.1.114', 'GET', 'DataFetch', '/api/data', 401, '2025-04-06 15:34:00'),
('2025-04-06 16:25:00', '192.168.1.199', 'DELETE', 'Logout', '/api/settings', 404, '2025-04-06 15:34:00'),
('2025-04-06 16:33:00', '192.168.1.134', 'PUT', 'Update', '/api/upload', 500, '2025-04-06 15:34:00'),
('2025-04-06 16:24:00', '192.168.1.176', 'POST', 'Error', '/api/user', 403, '2025-04-06 15:34:00'),
('2025-04-06 23:45:00', '192.168.1.183', 'GET', 'Login', '/api/user', 200, '2025-04-06 22:50:00'),
('2025-04-06 23:51:00', '192.168.1.166', 'DELETE', 'Logout', '/api/settings', 404, '2025-04-06 22:50:00'),
('2025-04-06 23:55:00', '192.168.1.131', 'POST', 'Error', '/api/data', 401, '2025-04-06 22:50:00'),
('2025-04-06 23:57:00', '192.168.1.161', 'PUT', 'Update', '/api/upload', 403, '2025-04-06 22:50:00'),
('2025-04-07 07:04:00', '192.168.1.187', 'POST', 'Login', '/api/user', 500, '2025-04-07 06:17:00'),
('2025-04-07 07:07:00', '192.168.1.175', 'GET', 'DataFetch', '/api/settings', 404, '2025-04-07 06:17:00'),
('2025-04-07 07:14:00', '192.168.1.118', 'PUT', 'Update', '/api/upload', 200, '2025-04-07 06:17:00'),
('2025-04-07 07:10:00', '192.168.1.113', 'DELETE', 'Logout', '/api/user', 403, '2025-04-07 06:17:00'),
('2025-04-07 07:13:00', '192.168.1.180', 'POST', 'Error', '/api/settings', 401, '2025-04-07 06:17:00'),
('2025-04-07 15:33:00', '192.168.1.190', 'POST', 'Login', '/api/data', 404, '2025-04-07 14:45:00'),
('2025-04-07 15:38:00', '192.168.1.136', 'PUT', 'Update', '/api/user', 500, '2025-04-07 14:45:00'),
('2025-04-07 15:35:00', '192.168.1.117', 'GET', 'DataFetch', '/api/upload', 403, '2025-04-07 14:45:00'),
('2025-04-07 15:42:00', '192.168.1.195', 'DELETE', 'Logout', '/api/settings', 401, '2025-04-07 14:45:00'),
('2025-04-07 22:56:00', '192.168.1.111', 'POST', 'Login', '/api/user', 404, '2025-04-07 22:07:00'),
('2025-04-07 22:58:00', '192.168.1.105', 'GET', 'DataFetch', '/api/data', 200, '2025-04-07 22:07:00'),
('2025-04-07 23:04:00', '192.168.1.126', 'PUT', 'Update', '/api/user', 403, '2025-04-07 22:07:00');


-- Server 1 Production Logs

INSERT INTO Server_ID_1_Production_Logs (TimestampPL1, Status_codePL1, MessagePL1,  Developer_ID, Process_ID, Startup) VALUES
('2025-03-01 10:10:00', 200, 'Process initialized', 101, 501, '2025-03-01 09:00:00'),
('2025-03-01 10:15:00', 201, 'Task queued', 102, 502, '2025-03-01 09:00:00'),
('2025-03-01 18:50:00', 500, 'System crash', 103, 503, '2025-03-01 18:00:00'),
('2025-03-01 18:52:00', 503, 'Recovery initiated', 104, 504, '2025-03-01 18:00:00'),
('2025-03-02 03:12:00', 200, 'Cache flushed', 105, 505, '2025-03-02 02:14:00'),
('2025-03-02 03:20:00', 201, 'Restarted process', 106, 506, '2025-03-02 02:14:00'),
('2025-03-02 11:42:00', 404, 'Missing resource', 107, 507, '2025-03-02 10:30:00'),
('2025-03-02 11:50:00', 200, 'Service resumed', 108, 508, '2025-03-02 10:30:00'),
('2025-03-02 20:25:00', 200, 'Deployment successful', 109, 509, '2025-03-02 19:10:00'),
('2025-03-02 20:32:00', 201, 'Validation complete', 110, 510, '2025-03-02 19:10:00'),
('2025-03-03 05:50:00', 202, 'New config applied', 111, 511, '2025-03-03 04:45:00'),
('2025-03-03 06:00:00', 500, 'Dependency failure', 112, 512, '2025-03-03 04:45:00'),
('2025-03-03 14:00:00', 200, 'Scheduled job run', 113, 513, '2025-03-03 12:55:00'),
('2025-03-03 14:05:00', 201, 'Script executed', 114, 514, '2025-03-03 12:55:00'),
('2025-03-03 22:20:00', 403, 'Permission denied', 115, 515, '2025-03-03 21:10:00'),
('2025-03-03 22:25:00', 200, 'Process continued', 116, 516, '2025-03-03 21:10:00'),
('2025-03-04 06:10:00', 500, 'Overflow detected', 117, 517, '2025-03-04 05:00:00'),
('2025-03-04 06:18:00', 200, 'Auto recovery', 118, 518, '2025-03-04 05:00:00'),
('2025-03-04 13:35:00', 201, 'Trigger complete', 119, 519, '2025-03-04 12:30:00'),
('2025-03-04 13:40:00', 200, 'Flag updated', 120, 520, '2025-03-04 12:30:00'),
('2025-03-04 22:03:00', 200, 'Start complete', 121, 521, '2025-03-04 21:00:00'),
('2025-03-04 22:08:00', 500, 'Null pointer error', 122, 522, '2025-03-04 21:00:00'),
('2025-03-05 06:25:00', 200, 'Hotfix pushed', 123, 523, '2025-03-05 05:20:00'),
('2025-03-05 06:30:00', 201, 'Update check complete', 124, 524, '2025-03-05 05:20:00'),
('2025-03-05 14:44:00', 200, 'Job completed', 125, 525, '2025-03-05 13:30:00'),
('2025-03-05 14:48:00', 404, 'Resource not found', 126, 526, '2025-03-05 13:30:00'),
('2025-03-06 00:07:00', 503, 'Service interrupted', 127, 527, '2025-03-05 23:00:00'),
('2025-03-06 00:10:00', 200, 'Recovery success', 128, 528, '2025-03-05 23:00:00'),
('2025-03-06 07:22:00', 201, 'Log archived', 129, 529, '2025-03-06 06:00:00'),
('2025-03-06 07:30:00', 200, 'Heartbeat OK', 130, 530, '2025-03-06 06:00:00'),
('2025-03-06 14:50:00', 200, 'Queue processed', 131, 531, '2025-03-06 13:30:00'),
('2025-03-06 14:55:00', 202, 'Task resubmitted', 132, 532, '2025-03-06 13:30:00'),
('2025-03-07 01:15:00', 500, 'Script timeout', 133, 533, '2025-03-07 00:10:00'),
('2025-03-07 01:22:00', 200, 'Resolved and resumed', 134, 534, '2025-03-07 00:10:00'),
('2025-03-07 08:47:00', 200, 'All checks passed', 135, 535, '2025-03-07 07:30:00'),
('2025-03-07 08:50:00', 503, 'Service overloaded', 136, 536, '2025-03-07 07:30:00'),
('2025-03-07 15:54:00', 200, 'Environment reset', 137, 537, '2025-03-07 14:50:00'),
('2025-03-07 15:59:00', 201, 'Script validated', 138, 538, '2025-03-07 14:50:00'),
('2025-03-08 00:32:00', 202, 'Init param loaded', 139, 539, '2025-03-07 23:30:00'),
('2025-03-08 00:35:00', 200, 'Param validation OK', 140, 540, '2025-03-07 23:30:00'),
('2025-03-08 08:10:00', 404, 'Missing param detected', 141, 541, '2025-03-08 07:00:00'),
('2025-03-08 08:15:00', 200, 'Fallback loaded', 142, 542, '2025-03-08 07:00:00'),
('2025-03-08 15:25:00', 500, 'Core dump occurred', 143, 543, '2025-03-08 14:10:00'),
('2025-03-08 15:32:00', 200, 'System recovered', 144, 544, '2025-03-08 14:10:00'),
('2025-03-09 00:42:00', 201, 'Token updated', 145, 545, '2025-03-08 23:30:00'),
('2025-03-09 00:45:00', 202, 'Session logged', 146, 546, '2025-03-08 23:30:00'),
('2025-03-09 07:55:00', 200, 'API deployed', 147, 547, '2025-03-09 06:40:00'),
('2025-03-09 08:02:00', 201, 'New handlers ready', 148, 548, '2025-03-09 06:40:00'),
('2025-03-09 16:10:00', 200, 'Trigger acknowledged', 149, 549, '2025-03-09 15:00:00'),
('2025-03-09 16:12:00', 500, 'Cycle limit breach', 150, 550, '2025-03-09 15:00:00'),
('2025-03-10 00:30:00', 200, 'Metrics collected', 151, 551, '2025-03-09 23:15:00'),
('2025-03-10 00:36:00', 201, 'Index built', 152, 552, '2025-03-09 23:15:00'),
('2025-03-10 08:30:00', 200, 'Server warmed up', 153, 553, '2025-03-10 07:20:00'),
('2025-03-10 08:37:00', 202, 'Patch pending', 154, 554, '2025-03-10 07:20:00'),
('2025-03-10 16:55:00', 500, 'Script freeze', 155, 555, '2025-03-10 15:40:00'),
('2025-03-10 17:02:00', 200, 'Thread restarted', 156, 556, '2025-03-10 15:40:00'),
('2025-03-11 00:50:00', 200, 'Process isolated', 157, 557, '2025-03-10 23:30:00'),
('2025-03-11 00:58:00', 404, 'Alias missing', 158, 558, '2025-03-10 23:30:00'),
('2025-03-11 08:22:00', 201, 'Trigger validated', 159, 559, '2025-03-11 07:00:00'),
('2025-03-11 08:30:00', 200, 'Startup scan clear', 160, 560, '2025-03-11 07:00:00'),
('2025-03-11 17:10:00', 500, 'Out-of-memory error', 161, 561, '2025-03-11 16:00:00'),
('2025-03-11 17:18:00', 200, 'Memory cleared', 162, 562, '2025-03-11 16:00:00'),
('2025-03-12 01:05:00', 200, 'Daemon checked in', 163, 563, '2025-03-11 23:55:00'),
('2025-03-12 01:15:00', 202, 'Cleanup finished', 164, 564, '2025-03-11 23:55:00'),
('2025-03-12 09:45:00', 200, 'New cert applied', 165, 565, '2025-03-12 08:20:00'),
('2025-03-12 09:52:00', 201, 'TLS handshake OK', 166, 566, '2025-03-12 08:20:00'),
('2025-03-12 18:32:00', 503, 'Rate limit hit', 167, 567, '2025-03-12 17:10:00'),
('2025-03-12 18:40:00', 200, 'Rate limit reset', 168, 568, '2025-03-12 17:10:00'),
('2025-03-13 03:10:00', 200, 'Health check passed', 169, 569, '2025-03-13 02:00:00'),
('2025-03-13 03:15:00', 500, 'Unexpected token', 170, 570, '2025-03-13 02:00:00'),
('2025-03-13 10:40:00', 200, 'All pipelines green', 171, 571, '2025-03-13 09:20:00'),
('2025-03-13 10:47:00', 202, 'Env config locked', 172, 572, '2025-03-13 09:20:00'),
('2025-03-13 19:55:00', 200, 'Global config verified', 173, 573, '2025-03-13 18:45:00'),
('2025-03-13 20:00:00', 503, 'Unexpected disconnect', 174, 574, '2025-03-13 18:45:00'),
('2025-03-14 04:20:00', 201, 'Handler reloaded', 175, 575, '2025-03-14 03:10:00'),
('2025-03-14 04:25:00', 200, 'Load check stable', 176, 576, '2025-03-14 03:10:00'),
('2025-03-14 11:45:00', 404, 'Endpoint outdated', 177, 577, '2025-03-14 10:30:00'),
('2025-03-14 11:48:00', 200, 'Routing fixed', 178, 578, '2025-03-14 10:30:00'),
('2025-03-14 20:20:00', 500, 'Access violation', 179, 579, '2025-03-14 19:00:00'),
('2025-03-14 20:28:00', 200, 'Role updated', 180, 580, '2025-03-14 19:00:00'),
('2025-03-15 05:35:00', 201, 'Schedule synced', 181, 581, '2025-03-15 04:30:00'),
('2025-03-15 05:38:00', 200, 'Permissions verified', 182, 582, '2025-03-15 04:30:00'),
('2025-03-15 14:15:00', 503, 'Object not serialized', 183, 583, '2025-03-15 13:00:00'),
('2025-03-15 14:18:00', 200, 'Object serialized again', 184, 584, '2025-03-15 13:00:00'),
('2025-03-15 22:48:00', 200, 'Final logs archived', 185, 585, '2025-03-15 21:40:00'),
('2025-03-15 22:50:00', 201, 'Night backup queued', 186, 586, '2025-03-15 21:40:00');


-- Server 1 Security Logs

INSERT INTO Server_ID_1_Security_Logs (TimestampSCL1, Client_IP_AddressSCL1, Security_Level, End_PointSCL1, Event_TypeSCL1, MessageSCL1, Startup) VALUES
('2025-04-01 06:05:00', '10.0.0.1', 'High', '/login', 101, 'Login attempt failed', '2025-04-01 06:00:00'),
('2025-04-01 06:20:00', '10.0.0.2', 'Medium', '/data', 102, 'Accessed sensitive data', '2025-04-01 06:00:00'),
('2025-04-01 06:45:00', '10.0.0.3', 'Low', '/status', 103, NULL, '2025-04-01 06:00:00'),

('2025-04-01 10:05:00', '10.0.0.4', 'Medium', '/update', 104, 'Update started', '2025-04-01 10:00:00'),
('2025-04-01 10:45:00', '10.0.0.5', 'High', '/admin', 105, 'Unauthorized access attempt', '2025-04-01 10:00:00'),

('2025-04-01 14:35:00', '10.0.0.6', 'Low', '/fetch', 106, NULL, '2025-04-01 14:30:00'),
('2025-04-01 14:50:00', '10.0.0.7', 'Medium', '/upload', 107, 'Upload complete', '2025-04-01 14:30:00'),

('2025-04-01 20:10:00', '10.0.0.8', 'High', '/config', 108, 'Configuration change', '2025-04-01 20:00:00'),
('2025-04-01 20:30:00', '10.0.0.9', 'Low', '/home', 109, NULL, '2025-04-01 20:00:00'),

('2025-04-02 01:05:00', '10.0.0.10', 'Medium', '/scan', 110, 'Routine scan started', '2025-04-02 01:00:00'),
('2025-04-02 01:30:00', '10.0.0.11', 'Low', '/metrics', 111, NULL, '2025-04-02 01:00:00'),

('2025-04-02 05:05:00', '10.0.0.12', 'High', '/reboot', 112, 'System reboot initiated', '2025-04-02 05:00:00'),
('2025-04-02 05:25:00', '10.0.0.13', 'Medium', '/login', 113, 'Successful login', '2025-04-02 05:00:00'),

('2025-04-02 09:10:00', '10.0.0.14', 'Low', '/status', 114, NULL, '2025-04-02 09:00:00'),
('2025-04-02 09:45:00', '10.0.0.15', 'High', '/update', 115, 'Critical patch applied', '2025-04-02 09:00:00'),

('2025-04-02 13:10:00', '10.0.0.16', 'Medium', '/network', 116, 'Network settings changed', '2025-04-02 13:00:00'),
('2025-04-02 13:30:00', '10.0.0.17', 'Low', '/info', 117, NULL, '2025-04-02 13:00:00'),
('2025-04-02 13:50:00', '10.0.0.18', 'High', '/auth', 118, 'Token expired', '2025-04-02 13:00:00'),

('2025-04-02 17:35:00', '10.0.0.19', 'Medium', '/sync', 119, 'Data sync started', '2025-04-02 17:30:00'),
('2025-04-02 17:55:00', '10.0.0.20', 'High', '/users', 120, 'User role changed', '2025-04-02 17:30:00'),

('2025-04-03 00:05:00', '10.0.0.21', 'Low', '/jobs', 121, NULL, '2025-04-03 00:00:00'),
('2025-04-03 00:25:00', '10.0.0.22', 'Medium', '/cron', 122, 'Cron job executed', '2025-04-03 00:00:00'),
('2025-04-03 00:50:00', '10.0.0.23', 'High', '/secure', 123, 'Security scan complete', '2025-04-03 00:00:00'),
('2025-04-03 06:10:00', '10.0.0.24', 'Medium', '/login', 124, 'Login attempt successful', '2025-04-03 06:00:00'),
('2025-04-03 06:35:00', '10.0.0.25', 'Low', '/status', 125, NULL, '2025-04-03 06:00:00'),

('2025-04-03 10:10:00', '10.0.0.26', 'High', '/admin', 126, 'Privilege escalation detected', '2025-04-03 10:00:00'),
('2025-04-03 10:30:00', '10.0.0.27', 'Medium', '/reports', 127, 'Report generated', '2025-04-03 10:00:00'),

('2025-04-03 15:10:00', '10.0.0.28', 'Low', '/dashboard', 128, NULL, '2025-04-03 15:00:00'),
('2025-04-03 15:25:00', '10.0.0.29', 'Medium', '/summary', 129, 'Summary pulled', '2025-04-03 15:00:00'),

('2025-04-03 18:10:00', '10.0.0.30', 'Medium', '/access', 130, 'Access granted', '2025-04-03 18:00:00'),
('2025-04-03 18:40:00', '10.0.0.31', 'Low', '/home', 131, NULL, '2025-04-03 18:00:00'),

('2025-04-04 00:10:00', '10.0.0.32', 'High', '/alerts', 132, 'Alert triggered', '2025-04-04 00:00:00'),
('2025-04-04 00:30:00', '10.0.0.33', 'Medium', '/events', 133, 'Event processed', '2025-04-04 00:00:00'),

('2025-04-04 04:35:00', '10.0.0.34', 'Low', '/status', 134, NULL, '2025-04-04 04:30:00'),
('2025-04-04 04:55:00', '10.0.0.35', 'Medium', '/logs', 135, 'Log archived', '2025-04-04 04:30:00'),
('2025-04-04 05:20:00', '10.0.0.36', 'High', '/error', 136, 'Critical error reported', '2025-04-04 04:30:00'),

('2025-04-04 09:35:00', '10.0.0.37', 'Medium', '/api', 137, 'API request logged', '2025-04-04 09:30:00'),
('2025-04-04 09:50:00', '10.0.0.38', 'Low', '/metrics', 138, NULL, '2025-04-04 09:30:00'),

('2025-04-04 13:05:00', '10.0.0.39', 'High', '/gateway', 139, 'Gateway timeout', '2025-04-04 13:00:00'),
('2025-04-04 13:40:00', '10.0.0.40', 'Medium', '/dns', 140, 'DNS cache cleared', '2025-04-04 13:00:00'),

('2025-04-04 16:05:00', '10.0.0.41', 'Low', '/info', 141, NULL, '2025-04-04 16:00:00'),
('2025-04-04 16:30:00', '10.0.0.42', 'Medium', '/sync', 142, 'Sync complete', '2025-04-04 16:00:00'),

('2025-04-04 19:10:00', '10.0.0.43', 'High', '/vault', 143, 'Accessed secure vault', '2025-04-04 19:00:00'),
('2025-04-04 19:45:00', '10.0.0.44', 'Medium', '/audit', 144, 'Audit trail verified', '2025-04-04 19:00:00'),

('2025-04-05 01:05:00', '10.0.0.45', 'Low', '/uptime', 145, NULL, '2025-04-05 01:00:00'),
('2025-04-05 01:30:00', '10.0.0.46', 'Medium', '/auth', 146, 'Auth session started', '2025-04-05 01:00:00'),

('2025-04-05 04:05:00', '10.0.0.47', 'High', '/config', 147, 'Backup config accessed', '2025-04-05 04:00:00'),
('2025-04-05 04:45:00', '10.0.0.48', 'Medium', '/update', 148, 'Update patch verified', '2025-04-05 04:00:00'),
('2025-04-05 05:10:00', '10.0.0.49', 'Low', '/ping', 149, NULL, '2025-04-05 04:00:00'),

('2025-04-05 09:05:00', '10.0.0.50', 'High', '/root', 150, 'Root access flagged', '2025-04-05 09:00:00'),
('2025-04-05 09:45:00', '10.0.0.51', 'Medium', '/kernel', 151, 'Kernel logs parsed', '2025-04-05 09:00:00'),
('2025-04-05 10:10:00', '10.0.0.52', 'Low', '/cache', 152, NULL, '2025-04-05 09:00:00'),

('2025-04-05 14:05:00', '10.0.0.53', 'Low', '/query', 153, NULL, '2025-04-05 14:00:00'),
('2025-04-05 14:25:00', '10.0.0.54', 'Medium', '/search', 154, 'Search request made', '2025-04-05 14:00:00'),

('2025-04-05 17:05:00', '10.0.0.55', 'High', '/lock', 155, 'Lock acquired', '2025-04-05 17:00:00'),
('2025-04-05 17:35:00', '10.0.0.56', 'Medium', '/release', 156, 'Lock released', '2025-04-05 17:00:00'),

('2025-04-06 00:10:00', '10.0.0.57', 'High', '/shutdown', 157, 'Shutdown initiated', '2025-04-06 00:00:00'),
('2025-04-06 00:35:00', '10.0.0.58', 'Medium', '/status', 158, 'System status OK', '2025-04-06 00:00:00'),

('2025-04-06 04:35:00', '10.0.0.59', 'Medium', '/temp', 159, 'Temperature logged', '2025-04-06 04:30:00'),
('2025-04-06 04:55:00', '10.0.0.60', 'High', '/cpu', 160, 'CPU usage spiked', '2025-04-06 04:30:00'),
('2025-04-06 05:10:00', '10.0.0.61', 'Low', '/logs', 161, NULL, '2025-04-06 04:30:00'),

('2025-04-06 09:35:00', '10.0.0.62', 'Medium', '/queue', 162, 'Task added to queue', '2025-04-06 09:30:00'),
('2025-04-06 09:55:00', '10.0.0.63', 'Low', '/peek', 163, NULL, '2025-04-06 09:30:00'),

('2025-04-06 14:05:00', '10.0.0.64', 'Medium', '/monitor', 164, 'Monitoring activated', '2025-04-06 14:00:00'),
('2025-04-06 14:35:00', '10.0.0.65', 'Low', '/api', 165, NULL, '2025-04-06 14:00:00'),
('2025-04-06 15:10:00', '10.0.0.66', 'High', '/admin', 166, 'Multiple failed logins', '2025-04-06 14:00:00'),

('2025-04-06 19:05:00', '10.0.0.67', 'Medium', '/recovery', 167, 'Recovery mode initiated', '2025-04-06 19:00:00'),
('2025-04-06 19:30:00', '10.0.0.68', 'Low', '/probe', 168, NULL, '2025-04-06 19:00:00');


-- Server 2 Logs

INSERT INTO Server_ID_2_Logs (Startup, Shutdown, Cost, Server_ID) VALUES -- 15 per hour
('2025-01-01 00:00:00', '2025-01-01 06:00:00', 90.00, 2),
('2025-01-01 18:00:00', '2025-01-02 02:00:00', 120.00, 2),
('2025-01-02 14:00:00', '2025-01-02 22:00:00', 120.00, 2),
('2025-01-03 12:00:00', '2025-01-03 16:00:00', 60.00, 2),
('2025-01-04 04:00:00', '2025-01-04 13:00:00', 135.00, 2),
('2025-01-05 02:00:00', '2025-01-05 07:00:00', 75.00, 2),
('2025-01-05 20:00:00', '2025-01-06 05:00:00', 135.00, 2),
('2025-01-06 18:00:00', '2025-01-07 01:00:00', 105.00, 2),
('2025-01-07 12:00:00', '2025-01-07 19:00:00', 105.00, 2),
('2025-01-08 08:00:00', '2025-01-08 16:00:00', 120.00, 2),
('2025-01-09 06:00:00', '2025-01-09 15:00:00', 135.00, 2),
('2025-01-10 04:00:00', '2025-01-10 10:00:00', 90.00, 2),
('2025-01-11 00:00:00', '2025-01-11 08:00:00', 120.00, 2),
('2025-01-11 22:00:00', '2025-01-12 04:00:00', 90.00, 2),
('2025-01-12 16:00:00', '2025-01-13 00:00:00', 120.00, 2),
('2025-01-13 14:00:00', '2025-01-13 21:00:00', 105.00, 2),
('2025-01-14 10:00:00', '2025-01-14 16:00:00', 90.00, 2),
('2025-01-15 06:00:00', '2025-01-15 15:00:00', 135.00, 2),
('2025-01-16 04:00:00', '2025-01-16 12:00:00', 120.00, 2),
('2025-01-17 00:00:00', '2025-01-17 05:00:00', 75.00, 2),
('2025-01-17 20:00:00', '2025-01-18 02:00:00', 90.00, 2),
('2025-01-18 16:00:00', '2025-01-19 01:00:00', 135.00, 2),
('2025-01-19 14:00:00', '2025-01-20 00:00:00', 150.00, 2),
('2025-01-20 10:00:00', '2025-01-20 16:00:00', 90.00, 2),
('2025-01-21 08:00:00', '2025-01-21 14:00:00', 90.00, 2),
('2025-01-22 06:00:00', '2025-01-22 12:00:00', 90.00, 2),
('2025-01-23 04:00:00', '2025-01-23 09:00:00', 75.00, 2),
('2025-01-24 00:00:00', '2025-01-24 06:00:00', 90.00, 2),
('2025-01-24 20:00:00', '2025-01-25 04:00:00', 120.00, 2),
('2025-01-25 18:00:00', NULL, NULL, 2);


-- Server 2 Server Logs

INSERT INTO Server_ID_2_Server_Logs (TimestampSL2, Temperature, Disk_Space_Usage, Memory_Space_Usage, CPU_Utilization, Startup) VALUES
('2025-01-01 01:28:00', '71°C', 198501, 26396, '75%', '2025-01-01 00:00:00'),
('2025-01-01 01:50:00', '71°C', 275207, 60680, '46%', '2025-01-01 00:00:00'),
('2025-01-01 03:43:00', '76°C', 367867, 20661, '36%', '2025-01-01 00:00:00'),
('2025-01-01 18:46:00', '85°C', 3110121, 313087, '85%', '2025-01-01 18:00:00'),
('2025-01-01 19:04:00', '61°C', 246398, 36490, '77%', '2025-01-01 18:00:00'),
('2025-01-01 21:35:00', '66°C', 167888, 57660, '35%', '2025-01-01 18:00:00'),
('2025-01-02 15:16:00', '64°C', 203616, 9568, '50%', '2025-01-02 14:00:00'),
('2025-01-02 15:16:00', '85°C', 446958, 12193, '85%', '2025-01-02 14:00:00'),
('2025-01-02 15:29:00', '66°C', 1196174, 50700, '40%', '2025-01-02 14:00:00'),
('2025-01-03 13:13:00', '76°C', 426430, 39427, '63%', '2025-01-03 12:00:00'),
('2025-01-03 14:44:00', '70°C', 111765, 62977, '53%', '2025-01-03 12:00:00'),
('2025-01-03 15:44:00', '65°C', 476289, 20123, '58%', '2025-01-03 12:00:00'),
('2025-01-04 04:25:00', '72°C', 367063, 28960, '41%', '2025-01-04 04:00:00'),
('2025-01-04 04:59:00', '77°C', 405155, 34860, '75%', '2025-01-04 04:00:00'),
('2025-01-04 05:51:00', '74°C', 261196, 61641, '31%', '2025-01-04 04:00:00'),
('2025-01-05 03:06:00', '74°C', 323968, 27931, '31%', '2025-01-05 02:00:00'),
('2025-01-05 03:55:00', '67°C', 4134740, 311260, '70%', '2025-01-05 02:00:00'),
('2025-01-05 04:27:00', '76°C', 105179, 10702, '62%', '2025-01-05 02:00:00'),
('2025-01-05 20:41:00', '84°C', 445812, 30683, '34%', '2025-01-05 20:00:00'),
('2025-01-05 21:13:00', '66°C', 346573, 24918, '85%', '2025-01-05 20:00:00'),
('2025-01-05 22:24:00', '82°C', 239153, 14008, '36%', '2025-01-05 20:00:00'),
('2025-01-06 20:41:00', '79°C', 377072, 37725, '53%', '2025-01-06 18:00:00'),
('2025-01-06 21:25:00', '78°C', 471740, 50710, '89%', '2025-01-06 18:00:00'),
('2025-01-06 22:34:00', '73°C', 367446, 37611, '41%', '2025-01-06 18:00:00'),
('2025-01-07 13:37:00', '77°C', 394299, 64045, '80%', '2025-01-07 12:00:00'),
('2025-01-07 14:00:00', '88°C', 183035, 18000, '33%', '2025-01-07 12:00:00'),
('2025-01-07 14:07:00', '89°C', 446428, 19167, '42%', '2025-01-07 12:00:00'),
('2025-01-08 08:53:00', '75°C', 108211, 40674, '49%', '2025-01-08 08:00:00'),
('2025-01-08 09:42:00', '62°C', 229723, 29494, '64%', '2025-01-08 08:00:00'),
('2025-01-08 10:38:00', '66°C', 487688, 12584, '41%', '2025-01-08 08:00:00'),
('2025-01-09 06:18:00', '79°C', 308432, 31277, '88%', '2025-01-09 06:00:00'),
('2025-01-09 08:00:00', '71°C', 351578, 24414, '37%', '2025-01-09 06:00:00'),
('2025-01-09 08:29:00', '67°C', 331133, 291104, '59%', '2025-01-09 06:00:00'),
('2025-01-10 05:38:00', '84°C', 204032, 46285, '42%', '2025-01-10 04:00:00'),
('2025-01-10 05:43:00', '69°C', 325850, 23283, '70%', '2025-01-10 04:00:00'),
('2025-01-10 06:34:00', '70°C', 194202, 37092, '88%', '2025-01-10 04:00:00'),
('2025-01-11 00:57:00', '86°C', 230226, 23496, '83%', '2025-01-11 00:00:00'),
('2025-01-11 02:30:00', '68°C', 158812, 22512, '80%', '2025-01-11 00:00:00'),
('2025-01-11 03:16:00', '79°C', 207201, 43350, '35%', '2025-01-11 00:00:00'),
('2025-01-11 22:47:00', '61°C', 319013, 37386, '65%', '2025-01-11 22:00:00'),
('2025-01-12 00:18:00', '89°C', 358063, 35803, '48%', '2025-01-11 22:00:00'),
('2025-01-12 00:26:00', '62°C', 288142, 30091, '87%', '2025-01-11 22:00:00'),
('2025-01-12 17:47:00', '73°C', 4716894, 35884, '88%', '2025-01-12 16:00:00'),
('2025-01-12 19:30:00', '64°C', 391171, 13441, '70%', '2025-01-12 16:00:00'),
('2025-01-12 20:29:00', '65°C', 474584, 54630, '42%', '2025-01-12 16:00:00'),
('2025-01-25 21:28:00', '79°C', 302920, 21085, '68%', '2025-01-25 18:00:00'),
('2025-01-13 04:15:00', '87°C', 345827, 28810, '71%', '2025-01-13 04:00:00'),
('2025-01-13 05:46:00', '76°C', 232157, 21609, '84%', '2025-01-13 04:00:00'),
('2025-01-13 07:33:00', '61°C', 332075, 13615, '67%', '2025-01-13 04:00:00'),
('2025-01-14 00:20:00', '63°C', 381965, 41856, '38%', '2025-01-14 00:00:00'),
('2025-01-14 01:24:00', '85°C', 414895, 24471, '50%', '2025-01-14 00:00:00'),
('2025-01-14 03:03:00', '62°C', 247257, 51244, '56%', '2025-01-14 00:00:00'),
('2025-01-15 07:32:00', '67°C', 271837, 63452, '66%', '2025-01-15 06:00:00'),
('2025-01-15 09:04:00', '73°C', 237470, 23892, '83%', '2025-01-15 06:00:00'),
('2025-01-15 09:36:00', '64°C', 359364, 20866, '75%', '2025-01-15 06:00:00'),
('2025-01-16 15:22:00', '65°C', 368524, 54660, '44%', '2025-01-16 14:00:00'),
('2025-01-16 15:44:00', '72°C', 303137, 15090, '68%', '2025-01-16 14:00:00'),
('2025-01-16 17:20:00', '60°C', 244180, 11624, '89%', '2025-01-16 14:00:00'),
('2025-01-17 14:40:00', '77°C', 2451266, 63692, '48%', '2025-01-17 14:00:00'),
('2025-01-17 15:44:00', '62°C', 361174, 36347, '82%', '2025-01-17 14:00:00'),
('2025-01-17 17:06:00', '66°C', 118982, 62015, '57%', '2025-01-17 14:00:00'),
('2025-01-18 18:44:00', '71°C', 268960, 12166, '73%', '2025-01-18 18:00:00'),
('2025-01-18 20:16:00', '63°C', 329230, 64430, '41%', '2025-01-18 18:00:00'),
('2025-01-18 20:57:00', '60°C', 238574, 28210, '78%', '2025-01-18 18:00:00'),
('2025-01-19 20:01:00', '86°C', 389183, 371364, '66%', '2025-01-19 20:00:00'),
('2025-01-19 21:33:00', '68°C', 160349, 24656, '74%', '2025-01-19 20:00:00'),
('2025-01-19 22:00:00', '72°C', 293814, 21172, '37%', '2025-01-19 20:00:00'),
('2025-01-20 17:41:00', '78°C', 396792, 42147, '53%', '2025-01-20 16:00:00'),
('2025-01-20 19:21:00', '65°C', 307582, 37429, '81%', '2025-01-20 16:00:00'),
('2025-01-20 20:55:00', '80°C', 411045, 15304, '67%', '2025-01-20 16:00:00');


-- Server 2 Application Logs

INSERT INTO Server_ID_2_Application_Logs (TimestampAL2, Client_IP_AddressAL2, HTTP_Method, Event_TypeAL2, End_PointAL2, Status_CodeAL2, Startup) VALUES
('2025-01-01 00:05:00', '203.0.113.10', 'GET', 'LoginAttempt', '/api/login', 200, '2025-01-01 00:00:00'),
('2025-01-01 00:06:12', '203.0.113.15', 'POST', 'FormSubmit', '/api/contact', 201, '2025-01-01 00:00:00'),
('2025-01-01 00:08:45', '203.0.113.22', 'GET', 'FetchData', '/api/data', 200, '2025-01-01 00:00:00'),
('2025-01-01 00:10:03', '203.0.113.35', 'DELETE', 'DeleteRecord', '/api/delete', 204, '2025-01-01 00:00:00'),
('2025-01-01 00:11:40', '203.0.113.40', 'PUT', 'UpdateSettings', '/api/settings', 200, '2025-01-01 00:00:00'),

('2025-01-02 09:03:00', '198.51.100.101', 'GET', 'DashboardView', '/dashboard', 200, '2025-01-02 09:00:00'),
('2025-01-02 09:05:10', '198.51.100.105', 'POST', 'CreateUser', '/api/user', 201, '2025-01-02 09:00:00'),
('2025-01-02 09:06:55', '198.51.100.110', 'GET', 'FetchLogs', '/logs', 200, '2025-01-02 09:00:00'),
('2025-01-02 09:07:30', '198.51.100.120', 'POST', 'AuthSuccess', '/auth', 200, '2025-01-02 09:00:00'),
('2025-01-02 09:09:22', '198.51.100.130', 'PUT', 'UpdateProfile', '/profile', 200, '2025-01-02 09:00:00'),

('2025-01-03 15:04:30', '192.0.2.10', 'POST', 'UploadFile', '/files/upload', 201, '2025-01-03 15:00:00'),
('2025-01-03 15:06:14', '192.0.2.11', 'GET', 'FileList', '/files', 200, '2025-01-03 15:00:00'),
('2025-01-03 15:07:50', '192.0.2.12', 'DELETE', 'RemoveFile', '/files/remove', 204, '2025-01-03 15:00:00'),
('2025-01-03 15:09:00', '192.0.2.13', 'GET', 'PreviewFile', '/files/preview', 200, '2025-01-03 15:00:00'),
('2025-01-03 15:10:35', '192.0.2.14', 'POST', 'EmailFile', '/files/email', 200, '2025-01-03 15:00:00'),

('2025-01-04 18:30:00', '198.18.0.1', 'GET', 'AccessPage', '/home', 200, '2025-01-04 18:00:00'),
('2025-01-04 18:31:50', '198.18.0.2', 'POST', 'SubmitFeedback', '/feedback', 201, '2025-01-04 18:00:00'),
('2025-01-04 18:33:10', '198.18.0.3', 'GET', 'HelpPage', '/help', 200, '2025-01-04 18:00:00'),
('2025-01-04 18:35:00', '198.18.0.4', 'PUT', 'SettingsChange', '/user/settings', 200, '2025-01-04 18:00:00'),
('2025-01-04 18:36:45', '198.18.0.5', 'POST', 'UserInvite', '/invite', 200, '2025-01-04 18:00:00'),

('2025-01-05 20:00:10', '192.168.5.2', 'GET', 'FetchReport', '/reports', 200, '2025-01-05 20:00:00'),
('2025-01-05 20:01:25', '192.168.5.3', 'POST', 'GeneratePDF', '/pdf', 201, '2025-01-05 20:00:00'),
('2025-01-05 20:03:05', '192.168.5.4', 'GET', 'DataExport', '/export', 200, '2025-01-05 20:00:00'),
('2025-01-05 20:04:44', '192.168.5.5', 'DELETE', 'CancelJob', '/job/cancel', 204, '2025-01-05 20:00:00'),
('2025-01-05 20:06:12', '192.168.5.6', 'POST', 'RetryJob', '/job/retry', 200, '2025-01-05 20:00:00'),

('2025-01-06 23:00:30', '172.16.0.1', 'GET', 'ViewPost', '/post/1', 200, '2025-01-06 23:00:00'),
('2025-01-06 23:01:45', '172.16.0.2', 'POST', 'CommentSubmit', '/post/1/comment', 201, '2025-01-06 23:00:00'),
('2025-01-06 23:03:21', '172.16.0.3', 'GET', 'LikePost', '/post/1/like', 200, '2025-01-06 23:00:00'),
('2025-01-06 23:04:40', '172.16.0.4', 'DELETE', 'DeleteComment', '/comment/22', 204, '2025-01-06 23:00:00'),
('2025-01-06 23:06:30', '172.16.0.5', 'PUT', 'EditPost', '/post/1/edit', 200, '2025-01-06 23:00:00'),

('2025-01-07 12:00:01', '203.0.113.100', 'GET', 'SessionStart', '/session', 200, '2025-01-07 12:00:00'),
('2025-01-07 12:02:15', '203.0.113.101', 'POST', 'SessionTrack', '/session/track', 201, '2025-01-07 12:00:00'),
('2025-01-07 12:03:30', '203.0.113.102', 'GET', 'SessionPing', '/session/ping', 200, '2025-01-07 12:00:00'),
('2025-01-07 12:04:50', '203.0.113.103', 'PUT', 'UpdateSession', '/session/update', 200, '2025-01-07 12:00:00'),
('2025-01-07 12:06:05', '203.0.113.104', 'POST', 'SessionEnd', '/session/end', 200, '2025-01-07 12:00:00'),

('2025-01-08 11:00:55', '198.51.100.200', 'GET', 'ReportOpen', '/reports/monthly', 200, '2025-01-08 11:00:00'),
('2025-01-08 11:02:10', '198.51.100.201', 'POST', 'RequestDownload', '/reports/download', 201, '2025-01-08 11:00:00'),
('2025-01-08 11:04:00', '198.51.100.202', 'GET', 'FetchStats', '/stats', 200, '2025-01-08 11:00:00'),
('2025-01-08 11:05:20', '198.51.100.203', 'DELETE', 'PurgeLogs', '/logs/old', 204, '2025-01-08 11:00:00'),
('2025-01-08 11:06:45', '198.51.100.204', 'PUT', 'ResetFilter', '/filters/reset', 200, '2025-01-08 11:00:00'),

('2025-01-09 10:01:00', '192.0.2.50', 'GET', 'PingTest', '/api/ping', 200, '2025-01-09 10:00:00'),
('2025-01-09 10:02:20', '192.0.2.51', 'POST', 'StartWorkflow', '/api/workflow', 201, '2025-01-09 10:00:00'),
('2025-01-09 10:03:45', '192.0.2.52', 'GET', 'WorkflowStatus', '/api/workflow/status', 200, '2025-01-09 10:00:00'),
('2025-01-09 10:05:00', '192.0.2.53', 'PUT', 'UpdateWorkflow', '/api/workflow', 200, '2025-01-09 10:00:00'),
('2025-01-09 10:06:15', '192.0.2.54', 'DELETE', 'AbortWorkflow', '/api/workflow', 204, '2025-01-09 10:00:00'),

('2025-01-10 13:00:40', '198.51.100.50', 'GET', 'PageLoad', '/main', 200, '2025-01-10 13:00:00'),
('2025-01-10 13:02:05', '198.51.100.51', 'POST', 'SaveDraft', '/draft', 201, '2025-01-10 13:00:00'),
('2025-01-10 13:03:30', '198.51.100.52', 'PUT', 'EditDraft', '/draft/edit', 200, '2025-01-10 13:00:00'),
('2025-01-10 13:04:50', '198.51.100.53', 'DELETE', 'DeleteDraft', '/draft', 204, '2025-01-10 13:00:00'),
('2025-01-10 13:06:12', '198.51.100.54', 'POST', 'SubmitDraft', '/draft/submit', 200, '2025-01-10 13:00:00'),

('2025-01-11 17:01:10', '203.0.113.88', 'GET', 'APIStatus', '/status', 200, '2025-01-11 17:00:00'),
('2025-01-11 17:03:00', '203.0.113.89', 'POST', 'ReportIssue', '/issue', 201, '2025-01-11 17:00:00'),
('2025-01-11 17:04:25', '203.0.113.90', 'PUT', 'IssueUpdate', '/issue/1', 200, '2025-01-11 17:00:00'),
('2025-01-11 17:06:15', '203.0.113.91', 'GET', 'IssueFetch', '/issue/1', 200, '2025-01-11 17:00:00'),
('2025-01-11 17:08:00', '203.0.113.92', 'DELETE', 'IssueDelete', '/issue/1', 204, '2025-01-11 17:00:00'),

('2025-01-12 16:00:30', '172.16.10.1', 'GET', 'ProductPage', '/product/1', 200, '2025-01-12 16:00:00'),
('2025-01-12 16:01:45', '172.16.10.2', 'POST', 'AddToCart', '/cart', 201, '2025-01-12 16:00:00'),
('2025-01-12 16:03:10', '172.16.10.3', 'GET', 'CartView', '/cart', 200, '2025-01-12 16:00:00'),
('2025-01-12 16:05:00', '172.16.10.4', 'PUT', 'UpdateCart', '/cart/update', 200, '2025-01-12 16:00:00'),
('2025-01-12 16:06:40', '172.16.10.5', 'POST', 'Checkout', '/checkout', 200, '2025-01-12 16:00:00'),

('2025-01-13 22:00:20', '10.10.10.1', 'GET', 'SearchQuery', '/search?q=data', 200, '2025-01-13 22:00:00'),
('2025-01-13 22:01:55', '10.10.10.2', 'POST', 'SubmitQuery', '/query', 201, '2025-01-13 22:00:00'),
('2025-01-13 22:03:40', '10.10.10.3', 'GET', 'ResultsFetch', '/results', 200, '2025-01-13 22:00:00'),
('2025-01-13 22:04:50', '10.10.10.4', 'DELETE', 'ClearQuery', '/query/clear', 204, '2025-01-13 22:00:00'),
('2025-01-13 22:06:25', '10.10.10.5', 'PUT', 'ModifyQuery', '/query/edit', 200, '2025-01-13 22:00:00'),

('2025-01-14 08:00:00', '192.0.2.100', 'GET', 'ProfileView', '/user/profile', 200, '2025-01-14 08:00:00'),
('2025-01-14 08:01:20', '192.0.2.101', 'PUT', 'ProfileUpdate', '/user/profile', 200, '2025-01-14 08:00:00'),
('2025-01-14 08:03:00', '192.0.2.102', 'GET', 'Notifications', '/notifications', 200, '2025-01-14 08:00:00'),
('2025-01-14 08:04:30', '192.0.2.103', 'DELETE', 'ClearNotifications', '/notifications/clear', 204, '2025-01-14 08:00:00'),
('2025-01-14 08:06:05', '192.0.2.104', 'POST', 'SendMessage', '/message', 201, '2025-01-14 08:00:00'),

('2025-01-15 14:00:40', '203.0.113.200', 'GET', 'SettingsPage', '/settings', 200, '2025-01-15 14:00:00'),
('2025-01-15 14:02:05', '203.0.113.201', 'PUT', 'ChangePassword', '/settings/password', 200, '2025-01-15 14:00:00'),
('2025-01-15 14:03:50', '203.0.113.202', 'POST', 'Enable2FA', '/settings/2fa', 201, '2025-01-15 14:00:00'),
('2025-01-15 14:05:10', '203.0.113.203', 'DELETE', 'RemoveDevice', '/settings/device', 204, '2025-01-15 14:00:00'),
('2025-01-15 14:06:40', '203.0.113.204', 'GET', 'SecurityCheck', '/settings/security', 200, '2025-01-15 14:00:00'),

('2025-01-16 19:01:10', '198.18.1.1', 'GET', 'HomeLoad', '/', 200, '2025-01-16 19:00:00'),
('2025-01-16 19:02:40', '198.18.1.2', 'POST', 'CreateAccount', '/register', 201, '2025-01-16 19:00:00'),
('2025-01-16 19:04:05', '198.18.1.3', 'GET', 'FAQAccess', '/faq', 200, '2025-01-16 19:00:00'),
('2025-01-16 19:05:30', '198.18.1.4', 'PUT', 'UpdateAccount', '/account', 200, '2025-01-16 19:00:00'),
('2025-01-16 19:07:00', '198.18.1.5', 'DELETE', 'CloseAccount', '/account/close', 204, '2025-01-16 19:00:00');


-- Server 2 Production Logs

INSERT INTO Server_ID_2_Production_Logs (TimestampPL2, Status_codePL2, MessagePL2, Developer_ID, Process_ID, Startup) VALUES
('2023-01-01 08:15:00', 200, 'Build successful', 5012, 312, '2023-01-01 08:00:00'),
('2023-01-01 08:30:00', 500, 'Compilation error', 5013, 313, '2023-01-01 08:00:00'),
('2023-01-01 08:45:00', 201, 'Minor warnings', 5012, 314, '2023-01-01 08:00:00'),

('2023-01-05 09:20:00', 200, 'Build passed', 5014, 315, '2023-01-05 09:00:00'),
('2023-01-05 09:40:00', 400, 'Missing dependencies', 5015, 316, '2023-01-05 09:00:00'),

('2023-01-10 07:50:00', 200, 'Build okay', 5011, 317, '2023-01-10 07:30:00'),
('2023-01-10 08:10:00', 404, 'Source not found', 5012, 318, '2023-01-10 07:30:00'),
('2023-01-10 08:25:00', 201, 'Patched warning', 5011, 319, '2023-01-10 07:30:00'),

('2023-01-15 10:10:00', 200, 'Successful integration', 5016, 320, '2023-01-15 10:00:00'),
('2023-01-15 10:30:00', 500, 'Fatal error', 5016, 321, '2023-01-15 10:00:00'),

('2023-01-20 11:20:00', 200, 'No issues', 5018, 322, '2023-01-20 11:00:00'),
('2023-01-20 11:45:00', 401, 'Unauthorized access', 5019, 323, '2023-01-20 11:00:00'),
('2023-01-20 12:05:00', 200, 'Access granted', 5018, 324, '2023-01-20 11:00:00'),

('2023-01-25 06:10:00', 200, 'Service initialized', 5020, 325, '2023-01-25 06:00:00'),
('2023-01-25 06:30:00', 500, 'Service failed to start', 5021, 326, '2023-01-25 06:00:00'),

('2023-02-01 08:45:00', 200, 'Build completed', 5022, 327, '2023-02-01 08:30:00'),
('2023-02-01 09:05:00', 403, 'Access denied', 5022, 328, '2023-02-01 08:30:00'),
('2023-02-01 09:25:00', 200, 'Permissions updated', 5023, 329, '2023-02-01 08:30:00'),

('2023-02-06 10:10:00', 200, 'Container deployed', 5024, 330, '2023-02-06 10:00:00'),
('2023-02-06 10:30:00', 200, 'Health check passed', 5024, 331, '2023-02-06 10:00:00'),

('2023-02-10 07:45:00', 500, 'System crash', 5025, 332, '2023-02-10 07:30:00'),
('2023-02-10 08:05:00', 200, 'Recovery complete', 5026, 333, '2023-02-10 07:30:00'),

('2023-02-15 09:50:00', 200, 'Testing started', 5027, 334, '2023-02-15 09:30:00'),
('2023-02-15 10:10:00', 200, 'Testing passed', 5027, 335, '2023-02-15 09:30:00'),
('2023-02-15 10:30:00', 500, 'One test failed', 5028, 336, '2023-02-15 09:30:00'),

('2023-02-20 06:05:00', 200, 'Startup routine okay', 5029, 337, '2023-02-20 06:00:00'),
('2023-02-20 06:25:00', 401, 'Token expired', 5029, 338, '2023-02-20 06:00:00'),

('2023-02-25 12:20:00', 200, 'Build complete', 5030, 339, '2023-02-25 12:00:00'),
('2023-02-25 12:40:00', 500, 'Timeout during build', 5031, 340, '2023-02-25 12:00:00'),
('2023-02-25 13:00:00', 200, 'Retry successful', 5031, 341, '2023-02-25 12:00:00'),

('2023-03-02 14:15:00', 200, 'Startup routine successful', 5032, 342, '2023-03-02 14:00:00'),
('2023-03-02 14:35:00', 503, 'Startup retry required', 5032, 343, '2023-03-02 14:00:00'),

('2023-03-07 08:10:00', 200, 'Initialized storage', 5033, 344, '2023-03-07 08:00:00'),
('2023-03-07 08:30:00', 200, 'Storage mounted', 5034, 345, '2023-03-07 08:00:00'),

('2023-03-12 10:40:00', 200, 'Process started', 5035, 346, '2023-03-12 10:30:00'),
('2023-03-12 11:00:00', 500, 'Process interrupted', 5035, 347, '2023-03-12 10:30:00'),

('2023-03-17 06:25:00', 200, 'Boot successful', 5036, 348, '2023-03-17 06:00:00'),
('2023-03-17 06:45:00', 401, 'Boot auth failed', 5036, 349, '2023-03-17 06:00:00'),
('2023-03-17 07:05:00', 200, 'Auth retry succeeded', 5037, 350, '2023-03-17 06:00:00'),

('2023-03-23 07:40:00', 200, 'Started deployment', 5038, 351, '2023-03-23 07:30:00'),
('2023-03-23 08:00:00', 200, 'Deployment complete', 5039, 352, '2023-03-23 07:30:00'),

('2023-03-28 09:00:00', 200, 'Database migration started', 5040, 353, '2023-03-28 08:45:00'),
('2023-03-28 09:20:00', 500, 'Migration failed', 5041, 354, '2023-03-28 08:45:00'),
('2023-03-28 09:40:00', 200, 'Rollback complete', 5042, 355, '2023-03-28 08:45:00'),

('2023-04-01 11:15:00', 200, 'System initialized', 5043, 356, '2023-04-01 11:00:00'),
('2023-04-01 11:35:00', 200, 'Warmup complete', 5043, 357, '2023-04-01 11:00:00'),

('2023-04-06 13:10:00', 403, 'Permission denied for API', 5044, 358, '2023-04-06 13:00:00'),
('2023-04-06 13:30:00', 200, 'Permission granted', 5045, 359, '2023-04-06 13:00:00'),

('2023-04-12 15:20:00', 200, 'Init sequence started', 5046, 360, '2023-04-12 15:00:00'),
('2023-04-12 15:40:00', 200, 'Init successful', 5046, 361, '2023-04-12 15:00:00'),

('2023-04-18 10:05:00', 500, 'Unexpected shutdown', 5047, 362, '2023-04-18 10:00:00'),
('2023-04-18 10:25:00', 200, 'System restored', 5048, 363, '2023-04-18 10:00:00'),

('2023-04-24 07:10:00', 200, 'Ready to serve', 5049, 364, '2023-04-24 07:00:00'),
('2023-04-24 07:30:00', 200, 'First request received', 5050, 365, '2023-04-24 07:00:00'),

('2023-04-29 09:50:00', 503, 'High latency warning', 5051, 366, '2023-04-29 09:30:00'),
('2023-04-29 10:10:00', 200, 'Latency stabilized', 5051, 367, '2023-04-29 09:30:00');


-- Server 2 Security Logs

INSERT INTO Server_ID_2_Security_Logs (TimestampSCL2, Client_IP_AddressSCL2, Security_Level, End_PointSCL2, Event_TypeSCL2, MessageSCL2, Startup) VALUES
('2023-01-01 09:10:00', '172.16.0.101', 'High', '/admin', 101, 'Unauthorized access attempt', '2023-01-01 09:00:00'),
('2023-01-01 09:20:00', '172.16.0.102', 'Medium', '/login', 102, 'Failed login', '2023-01-01 09:00:00'),

('2023-01-04 10:05:00', '172.16.0.103', 'Low', '/api/token', 103, 'Token request success', '2023-01-04 10:00:00'),
('2023-01-04 10:15:00', '172.16.0.104', 'Medium', '/api/token', 104, 'Rate limit warning', '2023-01-04 10:00:00'),
('2023-01-04 10:25:00', '172.16.0.105', 'High', '/login', 105, 'Multiple failed attempts', '2023-01-04 10:00:00'),

('2023-01-08 11:10:00', '172.16.0.106', 'Medium', '/admin', 106, 'Session timeout', '2023-01-08 11:00:00'),
('2023-01-08 11:30:00', '172.16.0.107', 'Low', '/dashboard', 107, 'Successful login', '2023-01-08 11:00:00'),
('2023-01-08 11:50:00', '172.16.0.108', 'High', '/admin', 108, 'Suspicious access', '2023-01-08 11:00:00'),
('2023-01-08 12:00:00', '172.16.0.109', 'Low', '/api/user', 109, 'Profile access', '2023-01-08 11:00:00'),

('2023-01-12 13:10:00', '172.16.0.110', 'Medium', '/settings', 110, 'Settings update', '2023-01-12 13:00:00'),
('2023-01-12 13:20:00', '172.16.0.111', 'High', '/admin/logs', 111, 'Log access granted', '2023-01-12 13:00:00'),

('2023-01-16 14:10:00', '172.16.0.112', 'Medium', '/login', 112, '2FA enabled', '2023-01-16 14:00:00'),
('2023-01-16 14:20:00', '172.16.0.113', 'Low', '/profile', 113, 'Profile updated', '2023-01-16 14:00:00'),
('2023-01-16 14:30:00', '172.16.0.114', 'High', '/admin', 114, 'Admin rights escalation', '2023-01-16 14:00:00'),

('2023-01-21 07:05:00', '172.16.0.115', 'Low', '/logout', 115, 'Logout successful', '2023-01-21 07:00:00'),
('2023-01-21 07:15:00', '172.16.0.116', 'Medium', '/dashboard', 116, 'New session started', '2023-01-21 07:00:00'),
('2023-01-21 07:25:00', '172.16.0.117', 'High', '/login', 117, 'Suspicious login', '2023-01-21 07:00:00'),
('2023-01-21 07:35:00', '172.16.0.118', 'Medium', '/admin', 118, 'Admin logout', '2023-01-21 07:00:00'),

('2023-01-26 08:10:00', '172.16.0.119', 'Medium', '/api/logs', 119, 'Log retrieval', '2023-01-26 08:00:00'),
('2023-01-26 08:20:00', '172.16.0.120', 'High', '/admin/users', 120, 'User role changed', '2023-01-26 08:00:00'),

('2023-02-01 15:10:00', '172.16.0.121', 'Medium', '/login', 121, 'Successful login', '2023-02-01 15:00:00'),
('2023-02-01 15:20:00', '172.16.0.122', 'Low', '/help', 122, 'Help accessed', '2023-02-01 15:00:00'),
('2023-02-01 15:30:00', '172.16.0.123', 'High', '/admin/panel', 123, 'Access blocked', '2023-02-01 15:00:00'),

('2023-02-06 16:15:00', '172.16.0.124', 'Medium', '/settings/password', 124, 'Password change', '2023-02-06 16:00:00'),
('2023-02-06 16:25:00', '172.16.0.125', 'High', '/admin', 125, 'Login failed', '2023-02-06 16:00:00'),
('2023-02-06 16:35:00', '172.16.0.126', 'Low', '/logout', 126, 'Logout', '2023-02-06 16:00:00'),
('2023-02-06 16:45:00', '172.16.0.127', 'Medium', '/profile/view', 127, 'Profile view', '2023-02-06 16:00:00'),

('2023-02-11 17:05:00', '172.16.0.128', 'Low', '/dashboard', 128, 'View dashboard', '2023-02-11 17:00:00'),
('2023-02-11 17:20:00', '172.16.0.129', 'High', '/admin/settings', 129, 'Settings attempt', '2023-02-11 17:00:00'),

('2023-02-16 18:10:00', '172.16.0.130', 'Low', '/api/data', 130, 'Data access', '2023-02-16 18:00:00'),
('2023-02-16 18:20:00', '172.16.0.131', 'Medium', '/api/user', 131, 'User info requested', '2023-02-16 18:00:00'),
('2023-02-16 18:30:00', '172.16.0.132', 'High', '/admin/users', 132, 'Unauthorized access attempt', '2023-02-16 18:00:00'),

('2023-02-21 08:05:00', '172.16.0.133', 'Low', '/login', 133, 'Login form accessed', '2023-02-21 08:00:00'),
('2023-02-21 08:15:00', '172.16.0.134', 'Medium', '/login', 134, 'Login success', '2023-02-21 08:00:00'),
('2023-02-21 08:25:00', '172.16.0.135', 'High', '/admin', 135, 'Suspicious activity detected', '2023-02-21 08:00:00'),
('2023-02-21 08:35:00', '172.16.0.136', 'Low', '/logout', 136, 'Logout completed', '2023-02-21 08:00:00'),

('2023-02-26 09:05:00', '172.16.0.137', 'Medium', '/api/files', 137, 'File upload attempt', '2023-02-26 09:00:00'),
('2023-02-26 09:15:00', '172.16.0.138', 'High', '/admin/logs', 138, 'Unauthorized file access', '2023-02-26 09:00:00'),

('2023-03-03 10:10:00', '172.16.0.139', 'Low', '/status', 139, 'Status checked', '2023-03-03 10:00:00'),
('2023-03-03 10:20:00', '172.16.0.140', 'Medium', '/login', 140, 'Login attempt', '2023-03-03 10:00:00'),
('2023-03-03 10:30:00', '172.16.0.141', 'High', '/admin/dashboard', 141, 'Admin access granted', '2023-03-03 10:00:00'),

('2023-03-08 11:05:00', '172.16.0.142', 'Low', '/logout', 142, 'Session ended', '2023-03-08 11:00:00'),
('2023-03-08 11:15:00', '172.16.0.143', 'High', '/admin', 143, 'Invalid login detected', '2023-03-08 11:00:00'),
('2023-03-08 11:25:00', '172.16.0.144', 'Medium', '/user/settings', 144, 'Settings viewed', '2023-03-08 11:00:00'),

('2023-03-13 12:05:00', '172.16.0.145', 'Low', '/profile', 145, 'Profile viewed', '2023-03-13 12:00:00'),
('2023-03-13 12:15:00', '172.16.0.146', 'Medium', '/activity', 146, 'Activity log accessed', '2023-03-13 12:00:00'),
('2023-03-13 12:25:00', '172.16.0.147', 'High', '/admin/settings', 147, 'Settings changed', '2023-03-13 12:00:00'),
('2023-03-13 12:35:00', '172.16.0.148', 'Low', '/logout', 148, 'Logout completed', '2023-03-13 12:00:00'),

('2023-03-18 13:05:00', '172.16.0.149', 'Medium', '/login', 149, 'Login success', '2023-03-18 13:00:00'),
('2023-03-18 13:15:00', '172.16.0.150', 'High', '/admin', 150, 'Admin access attempt', '2023-03-18 13:00:00'),

('2023-03-23 14:05:00', '172.16.0.151', 'Low', '/api/check', 151, 'Ping', '2023-03-23 14:00:00'),
('2023-03-23 14:15:00', '172.16.0.152', 'High', '/admin', 152, 'Blocked access', '2023-03-23 14:00:00'),
('2023-03-23 14:25:00', '172.16.0.153', 'Medium', '/home', 153, 'Homepage accessed', '2023-03-23 14:00:00'),

('2023-03-28 15:05:00', '172.16.0.154', 'Low', '/status', 154, 'Health check', '2023-03-28 15:00:00'),
('2023-03-28 15:15:00', '172.16.0.155', 'Medium', '/profile', 155, 'Profile access', '2023-03-28 15:00:00'),
('2023-03-28 15:25:00', '172.16.0.156', 'High', '/admin', 156, 'Security alert triggered', '2023-03-28 15:00:00'),
('2023-03-28 15:35:00', '172.16.0.157', 'Medium', '/activity', 157, 'Suspicious activity flagged', '2023-03-28 15:00:00'),

('2023-04-02 16:05:00', '172.16.0.158', 'Low', '/login', 158, 'User login success', '2023-04-02 16:00:00'),
('2023-04-02 16:15:00', '172.16.0.159', 'Medium', '/dashboard', 159, 'User dashboard accessed', '2023-04-02 16:00:00'),

('2023-04-07 17:05:00', '172.16.0.160', 'High', '/admin/config', 160, 'Unauthorized config change', '2023-04-07 17:00:00'),
('2023-04-07 17:15:00', '172.16.0.161', 'Medium', '/logs', 161, 'System logs retrieved', '2023-04-07 17:00:00'),
('2023-04-07 17:25:00', '172.16.0.162', 'Low', '/info', 162, 'System info viewed', '2023-04-07 17:00:00'),

('2023-04-12 18:05:00', '172.16.0.163', 'Medium', '/login', 163, 'User re-authentication', '2023-04-12 18:00:00'),
('2023-04-12 18:15:00', '172.16.0.164', 'Low', '/logout', 164, 'User logged out', '2023-04-12 18:00:00'),

('2023-04-17 19:05:00', '172.16.0.165', 'Low', '/public', 165, 'Public endpoint accessed', '2023-04-17 19:00:00'),
('2023-04-17 19:15:00', '172.16.0.166', 'High', '/admin/logs', 166, 'Admin log audit', '2023-04-17 19:00:00'),
('2023-04-17 19:25:00', '172.16.0.167', 'Medium', '/home', 167, 'Return to homepage', '2023-04-17 19:00:00'),
('2023-04-17 19:35:00', '172.16.0.168', 'Low', '/favicon.ico', 168, 'Favicon requested', '2023-04-17 19:00:00'),

('2023-04-22 20:05:00', '172.16.0.169', 'Medium', '/about', 169, 'Info page accessed', '2023-04-22 20:00:00'),
('2023-04-22 20:15:00', '172.16.0.170', 'High', '/admin/ban', 170, 'IP ban initiated', '2023-04-22 20:00:00');


-- Server 3 Logs

INSERT INTO Server_ID_3_Logs (Startup, Shutdown, Cost, Server_ID) VALUES -- 10 per hour
('2024-10-01 08:00:00', '2024-10-01 12:00:00', 40.00, 3),
('2024-10-02 09:00:00', '2024-10-02 14:00:00', 50.00, 3),
('2024-10-03 07:30:00', '2024-10-03 13:30:00', 60.00, 3),
('2024-10-04 10:00:00', '2024-10-04 12:00:00', 20.00, 3),
('2024-10-05 08:15:00', '2024-10-05 15:15:00', 70.00, 3),
('2024-10-06 09:45:00', '2024-10-06 12:45:00', 30.00, 3),
('2024-10-07 11:00:00', '2024-10-07 17:00:00', 60.00, 3),
('2024-10-08 07:00:00', '2024-10-08 11:30:00', 45.00, 3),
('2024-10-09 06:30:00', '2024-10-09 10:30:00', 40.00, 3),
('2024-10-10 09:00:00', '2024-10-10 15:00:00', 60.00, 3),
('2024-10-11 08:00:00', '2024-10-11 12:30:00', 45.00, 3),
('2024-10-12 07:00:00', '2024-10-12 13:00:00', 60.00, 3),
('2024-10-13 10:00:00', '2024-10-13 14:00:00', 40.00, 3),
('2024-10-14 09:30:00', '2024-10-14 11:30:00', 20.00, 3),
('2024-10-15 06:45:00', '2024-10-15 13:15:00', 65.00, 3),
('2024-10-16 07:30:00', '2024-10-16 12:00:00', 45.00, 3),
('2024-10-17 09:00:00', '2024-10-17 16:00:00', 70.00, 3),
('2024-10-18 08:15:00', '2024-10-18 10:15:00', 20.00, 3),
('2024-10-19 07:45:00', '2024-10-19 11:45:00', 40.00, 3),
('2024-10-20 10:30:00', '2024-10-20 15:30:00', 50.00, 3),
('2024-10-21 09:00:00', '2024-10-21 13:00:00', 40.00, 3),
('2024-10-22 08:00:00', '2024-10-22 11:00:00', 30.00, 3),
('2024-10-23 07:15:00', '2024-10-23 12:15:00', 50.00, 3),
('2024-10-24 10:00:00', '2024-10-24 16:00:00', 60.00, 3),
('2024-10-25 09:30:00', '2024-10-25 13:30:00', 40.00, 3),
('2024-10-26 07:45:00', '2024-10-26 11:15:00', 35.00, 3),
('2024-10-27 08:30:00', '2024-10-27 14:30:00', 60.00, 3),
('2024-10-28 09:00:00', '2024-10-28 12:00:00', 30.00, 3),
('2024-10-29 10:00:00', '2024-10-29 15:00:00', 50.00, 3),
('2024-10-30 08:30:00', NULL, NULL, 3);  -- still running


-- Server 3 Server Logs

INSERT INTO Server_ID_3_Server_Logs (TimestampSL3, Temperature, Disk_Space_Usage, Memory_Space_Usage, CPU_Utilization, Startup) VALUES
('2024-10-01 08:15:00', '65°C', 120000, 80000, '35%', '2024-10-01 08:00:00'),
('2024-10-01 09:30:00', '66°C', 121000, 80500, '40%', '2024-10-01 08:00:00'),
('2024-10-01 11:45:00', '67°C', 122000, 81000, '38%', '2024-10-01 08:00:00'),

('2024-10-02 09:15:00', '64°C', 115000, 79000, '30%', '2024-10-02 09:00:00'),
('2024-10-02 11:00:00', '65°C', 116000, 79500, '33%', '2024-10-02 09:00:00'),
('2024-10-02 13:45:00', '66°C', 117500, 80000, '36%', '2024-10-02 09:00:00'),
('2024-10-02 14:00:00', '67°C', 118000, 80500, '39%', '2024-10-02 09:00:00'),

('2024-10-03 08:00:00', '63°C', 114000, 78000, '28%', '2024-10-03 07:30:00'),
('2024-10-03 10:30:00', '64°C', 115000, 78500, '31%', '2024-10-03 07:30:00'),
('2024-10-03 13:15:00', '65°C', 116500, 79000, '35%', '2024-10-03 07:30:00'),

('2024-10-04 10:15:00', '62°C', 113000, 77000, '29%', '2024-10-04 10:00:00'),
('2024-10-04 11:30:00', '63°C', 113500, 77500, '32%', '2024-10-04 10:00:00'),
('2024-10-04 12:00:00', '64°C', 114000, 78000, '34%', '2024-10-04 10:00:00'),

('2024-10-05 08:45:00', '66°C', 117000, 80000, '36%', '2024-10-05 08:15:00'),
('2024-10-05 10:30:00', '67°C', 118000, 80500, '38%', '2024-10-05 08:15:00'),
('2024-10-05 13:30:00', '68°C', 119000, 81000, '40%', '2024-10-05 08:15:00'),
('2024-10-05 15:00:00', '69°C', 120000, 81500, '42%', '2024-10-05 08:15:00'),

('2024-10-06 07:45:00', '64°C', 114000, 79000, '32%', '2024-10-06 07:30:00'),
('2024-10-06 09:30:00', '65°C', 115000, 79050, '34%', '2024-10-06 07:30:00'),
('2024-10-06 11:15:00', '66°C', 116000, 80000, '36%', '2024-10-06 07:30:00'),

('2024-10-07 08:30:00', '63°C', 113500, 78500, '31%', '2024-10-07 08:00:00'),
('2024-10-07 10:00:00', '64°C', 114500, 709000, '34%', '2024-10-07 08:00:00'),
('2024-10-07 11:30:00', '65°C', 115500, 79500, '37%', '2024-10-07 08:00:00'),
('2024-10-07 13:00:00', '66°C', 116500, 80000, '39%', '2024-10-07 08:00:00'),

('2024-10-08 09:00:00', '62°C', 112000, 77050, '30%', '2024-10-08 08:45:00'),
('2024-10-08 11:00:00', '63°C', 113000, 78000, '32%', '2024-10-08 08:45:00'),
('2024-10-08 12:45:00', '64°C', 114000, 78050, '34%', '2024-10-08 08:45:00'),

('2024-10-09 07:30:00', '66°C', 116000, 80000, '37%', '2024-10-09 07:00:00'),
('2024-10-09 09:30:00', '67°C', 117000, 80500, '39%', '2024-10-09 07:00:00'),
('2024-10-09 11:00:00', '68°C', 118000, 81000, '41%', '2024-10-09 07:00:00'),
('2024-10-09 12:30:00', '69°C', 119000, 81050, '43%', '2024-10-09 07:00:00'),

('2024-10-10 10:00:00', '64°C', 115000, 79050, '35%', '2024-10-10 09:45:00'),
('2024-10-10 12:00:00', '65°C', 116000, 80000, '37%', '2024-10-10 09:45:00'),
('2024-10-10 13:30:00', '66°C', 117000, 80500, '39%', '2024-10-10 09:45:00'),

('2024-10-11 09:15:00', '63°C', 113000, 78000, '33%', '2024-10-11 09:00:00'),
('2024-10-11 11:00:00', '64°C', 114000, 78500, '35%', '2024-10-11 09:00:00'),
('2024-10-11 13:15:00', '65°C', 115000, 79000, '37%', '2024-10-11 09:00:00'),

('2024-10-12 08:30:00', '62°C', 112500, 77000, '31%', '2024-10-12 08:15:00'),
('2024-10-12 10:00:00', '63°C', 113500, 77050, '33%', '2024-10-12 08:15:00'),
('2024-10-12 12:30:00', '64°C', 114500, 78000, '36%', '2024-10-12 08:15:00'),
('2024-10-12 14:00:00', '65°C', 115500, 78050, '38%', '2024-10-12 08:15:00'),

('2024-10-13 09:00:00', '66°C', 116000, 80000, '40%', '2024-10-13 08:30:00'),
('2024-10-13 11:00:00', '67°C', 117000, 80500, '42%', '2024-10-13 08:30:00'),
('2024-10-13 13:00:00', '68°C', 118000, 81000, '44%', '2024-10-13 08:30:00'),

('2024-10-14 07:30:00', '64°C', 113000, 78500, '33%', '2024-10-14 07:00:00'),
('2024-10-14 09:30:00', '65°C', 114000, 79000, '36%', '2024-10-14 07:00:00'),
('2024-10-14 11:00:00', '66°C', 115000, 79050, '38%', '2024-10-14 07:00:00'),

('2024-10-15 08:45:00', '62°C', 112000, 77050, '32%', '2024-10-15 08:30:00'),
('2024-10-15 10:30:00', '63°C', 113000, 78000, '34%', '2024-10-15 08:30:00'),
('2024-10-15 12:15:00', '64°C', 114000, 78050, '36%', '2024-10-15 08:30:00'),

('2024-10-16 07:15:00', '67°C', 117000, 80000, '39%', '2024-10-16 07:00:00'),
('2024-10-16 09:00:00', '68°C', 118000, 80050, '41%', '2024-10-16 07:00:00'),
('2024-10-16 10:30:00', '69°C', 119000, 81000, '43%', '2024-10-16 07:00:00'),
('2024-10-16 12:00:00', '70°C', 120000, 81050, '45%', '2024-10-16 07:00:00'),

('2024-10-17 08:00:00', '63°C', 114000, 78050, '35%', '2024-10-17 07:30:00'),
('2024-10-17 10:00:00', '64°C', 115000, 79000, '37%', '2024-10-17 07:30:00'),
('2024-10-17 12:00:00', '65°C', 116000, 79050, '39%', '2024-10-17 07:30:00'),

('2024-10-18 09:15:00', '66°C', 117000, 80000, '38%', '2024-10-18 09:00:00'),
('2024-10-18 11:00:00', '67°C', 118000, 80050, '40%', '2024-10-18 09:00:00'),
('2024-10-18 13:00:00', '68°C', 119000, 81000, '42%', '2024-10-18 09:00:00'),
('2024-10-18 14:30:00', '69°C', 120000, 81050, '44%', '2024-10-18 09:00:00'),

('2024-10-19 08:30:00', '62°C', 112500, 77000, '31%', '2024-10-19 08:15:00'),
('2024-10-19 10:00:00', '63°C', 113500, 77050, '34%', '2024-10-19 08:15:00'),
('2024-10-19 11:30:00', '64°C', 114500, 78000, '36%', '2024-10-19 08:15:00'),
('2024-10-20 07:45:00', '65°C', 115000, 79000, '36%', '2024-10-20 07:30:00'),
('2024-10-20 09:15:00', '66°C', 116000, 79050, '38%', '2024-10-20 07:30:00'),
('2024-10-20 10:45:00', '67°C', 117000, 80000, '40%', '2024-10-20 07:30:00'),

('2024-10-21 09:00:00', '63°C', 113000, 70800, '33%', '2024-10-21 08:45:00'),
('2024-10-21 11:00:00', '64°C', 114000, 70850, '35%', '2024-10-21 08:45:00'),
('2024-10-21 12:30:00', '65°C', 115000, 70900, '37%', '2024-10-21 08:45:00'),
('2024-10-21 14:00:00', '66°C', 116000, 70950, '39%', '2024-10-21 08:45:00'),

('2024-10-22 08:15:00', '67°C', 117000, 80000, '41%', '2024-10-22 08:00:00'),
('2024-10-22 10:00:00', '68°C', 118000, 80050, '43%', '2024-10-22 08:00:00'),
('2024-10-22 11:30:00', '69°C', 119000, 80100, '45%', '2024-10-22 08:00:00'),

('2024-10-23 07:30:00', '64°C', 113000, 78050, '34%', '2024-10-23 07:15:00'),
('2024-10-23 09:00:00', '65°C', 114000, 79000, '36%', '2024-10-23 07:15:00'),
('2024-10-23 10:45:00', '66°C', 115000, 79050, '38%', '2024-10-23 07:15:00'),

('2024-10-24 08:45:00', '62°C', 112000, 77050, '31%', '2024-10-24 08:30:00'),
('2024-10-24 10:30:00', '63°C', 113000, 70800, '33%', '2024-10-24 08:30:00'),
('2024-10-24 12:00:00', '64°C', 114000, 70850, '35%', '2024-10-24 08:30:00'),

('2024-10-25 09:15:00', '66°C', 116000, 79050, '37%', '2024-10-25 09:00:00'),
('2024-10-25 11:00:00', '67°C', 117000, 80000, '39%', '2024-10-25 09:00:00'),
('2024-10-25 13:00:00', '68°C', 118000, 80050, '41%', '2024-10-25 09:00:00'),

('2024-10-26 07:45:00', '65°C', 115000, 79000, '36%', '2024-10-26 07:30:00'),
('2024-10-26 09:15:00', '66°C', 116000, 79500, '38%', '2024-10-26 07:30:00'),
('2024-10-26 10:45:00', '67°C', 1170000, 80000, '40%', '2024-10-26 07:30:00'),

('2024-10-27 08:15:00', '64°C', 113000, 78050, '34%', '2024-10-27 08:00:00'),
('2024-10-27 09:45:00', '65°C', 114000, 79000, '36%', '2024-10-27 08:00:00'),
('2024-10-27 11:15:00', '66°C', 115000, 79500, '38%', '2024-10-27 08:00:00'),

('2024-10-28 07:30:00', '62°C', 112000, 77050, '32%', '2024-10-28 07:00:00'),
('2024-10-28 09:00:00', '63°C', 113000, 78000, '34%', '2024-10-28 07:00:00'),
('2024-10-28 10:30:00', '64°C', 114000, 78500, '36%', '2024-10-28 07:00:00'),
('2024-10-28 12:00:00', '65°C', 115000, 709000, '38%', '2024-10-28 07:00:00'),

('2024-10-29 08:45:00', '66°C', 116000, 70950, '39%', '2024-10-29 08:30:00'),
('2024-10-29 10:30:00', '67°C', 117000, 80000, '41%', '2024-10-29 08:30:00'),
('2024-10-29 12:00:00', '68°C', 118000, 80050, '43%', '2024-10-29 08:30:00'),

('2024-10-30 09:00:00', '64°C', 1140000, 70850, '35%', '2024-10-30 08:45:00'),
('2024-10-30 10:30:00', '65°C', 115000, 70900, '37%', '2024-10-30 08:45:00'),
('2024-10-30 12:15:00', '66°C', 116000, 70950, '39%', '2024-10-30 08:45:00'),

('2024-11-01 07:15:00', '63°C', 113000, 78000, '33%', '2024-11-01 07:00:00'),
('2024-11-01 08:45:00', '64°C', 114000, 78050, '35%', '2024-11-01 07:00:00'),
('2024-11-01 10:00:00', '65°C', 115000, 79000, '37%', '2024-11-01 07:00:00');


-- Server 3 Application Logs

INSERT INTO Server_ID_3_Application_Logs  (TimestampAL3, Client_IP_AddressAL3, HTTP_Method, Event_TypeAL3, End_PointAL3, Status_CodeAL3, Startup) VALUES
('2024-10-01 05:10:00', '10.0.0.1', 'GET', 1, '/api/health', 200, '2024-10-01 05:00:00'),
('2024-10-01 06:00:00', '10.0.0.2', 'POST', 2, '/api/login', 201, '2024-10-01 05:00:00'),
('2024-10-01 07:00:00', '10.0.0.3', 'GET', 3, '/api/data', 200, '2024-10-01 05:00:00'),

('2024-10-02 08:30:00', '10.0.1.1', 'GET', 1, '/api/status', 200, '2024-10-02 08:15:00'),
('2024-10-02 09:00:00', '10.0.1.2', 'PUT', 2, '/api/update', 204, '2024-10-02 08:15:00'),
('2024-10-02 10:00:00', '10.0.1.3', 'DELETE', 4, '/api/delete', 202, '2024-10-02 08:15:00'),

('2024-10-03 06:45:00', '10.0.2.1', 'GET', 1, '/api/items', 200, '2024-10-03 06:30:00'),
('2024-10-03 07:30:00', '10.0.2.2', 'POST', 2, '/api/items', 201, '2024-10-03 06:30:00'),
('2024-10-03 08:15:00', '10.0.2.3', 'GET', 3, '/api/items/1', 200, '2024-10-03 06:30:00'),

('2024-10-04 09:00:00', '10.0.3.1', 'GET', 1, '/api/metrics', 200, '2024-10-04 08:45:00'),
('2024-10-04 10:00:00', '10.0.3.2', 'POST', 2, '/api/metrics', 201, '2024-10-04 08:45:00'),
('2024-10-04 11:00:00', '10.0.3.3', 'PATCH', 3, '/api/metrics/1', 204, '2024-10-04 08:45:00'),

('2024-10-05 07:15:00', '10.0.4.1', 'GET', 1, '/api/users', 200, '2024-10-05 07:00:00'),
('2024-10-05 08:00:00', '10.0.4.2', 'POST', 2, '/api/users', 201, '2024-10-05 07:00:00'),
('2024-10-05 09:00:00', '10.0.4.3', 'PUT', 3, '/api/users/1', 204, '2024-10-05 07:00:00'),

('2024-10-06 06:30:00', '10.0.5.1', 'GET', 1, '/api/env', 200, '2024-10-06 06:15:00'),
('2024-10-06 07:30:00', '10.0.5.2', 'POST', 2, '/api/env', 201, '2024-10-06 06:15:00'),
('2024-10-06 08:45:00', '10.0.5.3', 'GET', 3, '/api/env/config', 200, '2024-10-06 06:15:00'),

('2024-10-07 08:15:00', '10.0.6.1', 'GET', 1, '/api/config', 200, '2024-10-07 08:00:00'),
('2024-10-07 09:30:00', '10.0.6.2', 'PATCH', 2, '/api/config/1', 204, '2024-10-07 08:00:00'),
('2024-10-07 10:45:00', '10.0.6.3', 'DELETE', 3, '/api/config/1', 202, '2024-10-07 08:00:00'),

('2024-10-08 07:45:00', '10.0.7.1', 'GET', 1, '/api/logs', 200, '2024-10-08 07:30:00'),
('2024-10-08 08:45:00', '10.0.7.2', 'POST', 2, '/api/logs', 201, '2024-10-08 07:30:00'),
('2024-10-08 10:00:00', '10.0.7.3', 'GET', 3, '/api/logs/1', 200, '2024-10-08 07:30:00'),

('2024-10-09 06:00:00', '10.0.8.1', 'GET', 1, '/api/ping', 200, '2024-10-09 05:45:00'),
('2024-10-09 07:15:00', '10.0.8.2', 'POST', 2, '/api/ping', 201, '2024-10-09 05:45:00'),
('2024-10-09 08:45:00', '10.0.8.3', 'GET', 3, '/api/ping/info', 200, '2024-10-09 05:45:00'),

('2024-10-10 07:30:00', '10.0.9.1', 'GET', 1, '/api/health', 200, '2024-10-10 07:15:00'),
('2024-10-10 08:30:00', '10.0.9.2', 'PUT', 2, '/api/health/settings', 204, '2024-10-10 07:15:00'),
('2024-10-10 09:45:00', '10.0.9.3', 'POST', 3, '/api/health', 201, '2024-10-10 07:15:00'),

('2024-10-11 06:30:00', '10.0.10.1', 'GET', 1, '/api/cache', 200, '2024-10-11 06:15:00'),
('2024-10-11 07:30:00', '10.0.10.2', 'POST', 2, '/api/cache/clear', 200, '2024-10-11 06:15:00'),
('2024-10-11 08:30:00', '10.0.10.3', 'GET', 3, '/api/cache/status', 200, '2024-10-11 06:15:00'),

('2024-10-12 09:15:00', '10.0.11.1', 'GET', 1, '/api/network', 200, '2024-10-12 09:00:00'),
('2024-10-12 10:15:00', '10.0.11.2', 'POST', 2, '/api/network/reset', 201, '2024-10-12 09:00:00'),
('2024-10-12 11:15:00', '10.0.11.3', 'GET', 3, '/api/network/status', 200, '2024-10-12 09:00:00'),

('2024-10-13 07:45:00', '10.0.12.1', 'GET', 1, '/api/auth', 200, '2024-10-13 07:30:00'),
('2024-10-13 08:30:00', '10.0.12.2', 'POST', 2, '/api/auth/login', 201, '2024-10-13 07:30:00'),
('2024-10-13 09:15:00', '10.0.12.3', 'DELETE', 3, '/api/auth/logout', 202, '2024-10-13 07:30:00'),

('2024-10-14 06:30:00', '10.0.13.1', 'GET', 1, '/api/uptime', 200, '2024-10-14 06:15:00'),
('2024-10-14 07:30:00', '10.0.13.2', 'GET', 2, '/api/uptime/history', 200, '2024-10-14 06:15:00'),
('2024-10-14 08:30:00', '10.0.13.3', 'POST', 3, '/api/uptime/log', 201, '2024-10-14 06:15:00'),

('2024-10-15 06:00:00', '10.0.14.1', 'GET', 1, '/api/reboot', 200, '2024-10-15 05:45:00'),
('2024-10-15 07:00:00', '10.0.14.2', 'POST', 2, '/api/reboot/initiate', 201, '2024-10-15 05:45:00'),
('2024-10-15 08:00:00', '10.0.14.3', 'GET', 3, '/api/reboot/status', 200, '2024-10-15 05:45:00'),

('2024-10-16 06:15:00', '10.0.15.1', 'GET', 1, '/api/session', 200, '2024-10-16 06:00:00'),
('2024-10-16 07:15:00', '10.0.15.2', 'POST', 2, '/api/session/create', 201, '2024-10-16 06:00:00'),
('2024-10-16 08:15:00', '10.0.15.3', 'DELETE', 3, '/api/session/terminate', 202, '2024-10-16 06:00:00'),

('2024-10-17 07:00:00', '10.0.16.1', 'GET', 1, '/api/tokens', 200, '2024-10-17 06:45:00'),
('2024-10-17 08:00:00', '10.0.16.2', 'POST', 2, '/api/tokens/generate', 201, '2024-10-17 06:45:00'),
('2024-10-17 09:00:00', '10.0.16.3', 'DELETE', 3, '/api/tokens/revoke', 202, '2024-10-17 06:45:00'),

('2024-10-18 07:30:00', '10.0.17.1', 'GET', 1, '/api/sync', 200, '2024-10-18 07:15:00'),
('2024-10-18 08:30:00', '10.0.17.2', 'POST', 2, '/api/sync/run', 201, '2024-10-18 07:15:00'),
('2024-10-18 09:30:00', '10.0.17.3', 'GET', 3, '/api/sync/status', 200, '2024-10-18 07:15:00'),

('2024-10-19 06:30:00', '10.0.18.1', 'GET', 1, '/api/stats', 200, '2024-10-19 06:15:00'),
('2024-10-19 07:30:00', '10.0.18.2', 'PUT', 2, '/api/stats/reset', 204, '2024-10-19 06:15:00'),
('2024-10-19 08:30:00', '10.0.18.3', 'GET', 3, '/api/stats/view', 200, '2024-10-19 06:15:00'),

('2024-10-20 06:00:00', '10.0.19.1', 'GET', 1, '/api/tasks', 200, '2024-10-20 05:45:00'),
('2024-10-20 07:00:00', '10.0.19.2', 'POST', 2, '/api/tasks/new', 201, '2024-10-20 05:45:00'),
('2024-10-20 08:00:00', '10.0.19.3', 'GET', 3, '/api/tasks/active', 200, '2024-10-20 05:45:00'),

('2024-10-21 06:45:00', '10.0.20.1', 'GET', 1, '/api/files', 200, '2024-10-21 06:30:00'),
('2024-10-21 07:45:00', '10.0.20.2', 'POST', 2, '/api/files/upload', 201, '2024-10-21 06:30:00'),
('2024-10-21 08:45:00', '10.0.20.3', 'DELETE', 3, '/api/files/delete', 202, '2024-10-21 06:30:00'),

('2024-10-22 07:00:00', '10.0.21.1', 'GET', 1, '/api/nodes', 200, '2024-10-22 06:45:00'),
('2024-10-22 08:00:00', '10.0.21.2', 'POST', 2, '/api/nodes/add', 201, '2024-10-22 06:45:00'),
('2024-10-22 09:00:00', '10.0.21.3', 'DELETE', 3, '/api/nodes/remove', 202, '2024-10-22 06:45:00'),

('2024-10-23 06:30:00', '10.0.22.1', 'GET', 1, '/api/report', 200, '2024-10-23 06:15:00'),
('2024-10-23 07:30:00', '10.0.22.2', 'PUT', 2, '/api/report/update', 204, '2024-10-23 06:15:00'),
('2024-10-23 08:30:00', '10.0.22.3', 'GET', 3, '/api/report/view', 200, '2024-10-23 06:15:00'),

('2024-10-24 07:15:00', '10.0.23.1', 'GET', 1, '/api/users', 200, '2024-10-24 07:00:00'),
('2024-10-24 08:15:00', '10.0.23.2', 'POST', 2, '/api/users/create', 201, '2024-10-24 07:00:00'),
('2024-10-24 09:15:00', '10.0.23.3', 'DELETE', 3, '/api/users/delete', 202, '2024-10-24 07:00:00'),

('2024-10-25 06:30:00', '10.0.24.1', 'GET', 1, '/api/settings', 200, '2024-10-25 06:15:00'),
('2024-10-25 07:30:00', '10.0.24.2', 'PUT', 2, '/api/settings/update', 204, '2024-10-25 06:15:00'),
('2024-10-25 08:30:00', '10.0.24.3', 'GET', 3, '/api/settings/reload', 200, '2024-10-25 06:15:00'),

('2024-10-26 06:00:00', '10.0.25.1', 'GET', 1, '/api/auth', 200, '2024-10-26 05:45:00'),
('2024-10-26 07:00:00', '10.0.25.2', 'POST', 2, '/api/auth/login', 200, '2024-10-26 05:45:00'),
('2024-10-26 08:00:00', '10.0.25.3', 'POST', 3, '/api/auth/logout', 200, '2024-10-26 05:45:00'),

('2024-10-27 07:30:00', '10.0.26.1', 'GET', 1, '/api/messages', 200, '2024-10-27 07:15:00'),
('2024-10-27 08:30:00', '10.0.26.2', 'POST', 2, '/api/messages/send', 201, '2024-10-27 07:15:00'),
('2024-10-27 09:30:00', '10.0.26.3', 'GET', 3, '/api/messages/inbox', 200, '2024-10-27 07:15:00'),

('2024-10-28 07:00:00', '10.0.27.1', 'GET', 1, '/api/monitor', 200, '2024-10-28 06:45:00'),
('2024-10-28 08:00:00', '10.0.27.2', 'POST', 2, '/api/monitor/configure', 201, '2024-10-28 06:45:00'),
('2024-10-28 09:00:00', '10.0.27.3', 'GET', 3, '/api/monitor/status', 200, '2024-10-28 06:45:00');


-- Server 3 Production Logs

INSERT INTO Server_ID_3_Production_Logs (TimestampPL3, Status_codePL3, MessagePL3, Developer_ID, Process_ID, Startup) VALUES
('2024-10-01 01:00:00', 200, 'Initialization complete', 1001, 501, '2024-10-01 00:00:00'),
('2024-10-01 01:30:00', 201, 'Resource allocation done', 1002, 502, '2024-10-01 00:00:00'),
('2024-10-01 02:00:00', 202, 'Heartbeat check passed', 1003, 503, '2024-10-01 00:00:00'),

('2024-10-02 01:15:00', 200, 'Production queue started', 1004, 504, '2024-10-02 01:00:00'),
('2024-10-02 02:15:00', 201, 'Task assignment logged', 1005, 505, '2024-10-02 01:00:00'),
('2024-10-02 03:15:00', 202, 'CPU utilization normal', 1006, 506, '2024-10-02 01:00:00'),

('2024-10-03 01:45:00', 200, 'Startup routine clean', 1007, 507, '2024-10-03 01:30:00'),
('2024-10-03 02:45:00', 203, 'Dependencies verified', 1008, 508, '2024-10-03 01:30:00'),

('2024-10-04 03:00:00', 200, 'Update trigger confirmed', 1009, 509, '2024-10-04 02:30:00'),
('2024-10-04 04:00:00', 204, 'Patch level OK', 1010, 510, '2024-10-04 02:30:00'),
('2024-10-04 05:00:00', 205, 'Monitoring daemon running', 1011, 511, '2024-10-04 02:30:00'),

('2024-10-05 03:30:00', 200, 'Job scheduler live', 1012, 512, '2024-10-05 03:00:00'),
('2024-10-05 04:30:00', 201, 'Worker process online', 1013, 513, '2024-10-05 03:00:00'),
('2024-10-05 05:30:00', 202, 'All cores functional', 1014, 514, '2024-10-05 03:00:00'),
('2024-10-05 06:30:00', 203, 'IO latency nominal', 1015, 515, '2024-10-05 03:00:00'),

('2024-10-06 04:15:00', 200, 'Service startup complete', 1016, 516, '2024-10-06 03:45:00'),
('2024-10-06 05:15:00', 202, 'Error thresholds clear', 1017, 517, '2024-10-06 03:45:00'),

('2024-10-07 04:00:00', 200, 'System health check', 1018, 518, '2024-10-07 03:30:00'),
('2024-10-07 05:00:00', 201, 'All configs loaded', 1019, 519, '2024-10-07 03:30:00'),
('2024-10-07 06:00:00', 202, 'Log rotation started', 1020, 520, '2024-10-07 03:30:00'),

('2024-10-08 05:15:00', 200, 'Services deployed', 1021, 521, '2024-10-08 05:00:00'),
('2024-10-08 06:15:00', 203, 'System updated', 1022, 522, '2024-10-08 05:00:00'),

('2024-10-09 06:30:00', 200, 'Build pipeline success', 1023, 523, '2024-10-09 06:15:00'),
('2024-10-09 07:30:00', 201, 'Cache warmed', 1024, 524, '2024-10-09 06:15:00'),
('2024-10-09 08:30:00', 204, 'Message bus connected', 1025, 525, '2024-10-09 06:15:00'),

('2024-10-10 06:45:00', 200, 'Startup latency within range', 1026, 526, '2024-10-10 06:30:00'),
('2024-10-10 07:45:00', 202, 'Elastic service available', 1027, 527, '2024-10-10 06:30:00'),
('2024-10-10 08:45:00', 205, 'Auto-scaling triggered', 1028, 528, '2024-10-10 06:30:00'),

('2024-10-11 08:00:00', 200, 'Backup scheduled', 1029, 529, '2024-10-11 07:30:00'),
('2024-10-11 09:00:00', 203, 'Data validation passed', 1030, 530, '2024-10-11 07:30:00'),
('2024-10-11 10:00:00', 204, 'Dependency injection done', 1031, 531, '2024-10-11 07:30:00'),

('2024-10-12 08:30:00', 200, 'Startup success', 1032, 532, '2024-10-12 08:00:00'),
('2024-10-12 09:30:00', 201, 'Service bindings verified', 1033, 533, '2024-10-12 08:00:00'),
('2024-10-12 10:30:00', 202, 'All checks green', 1034, 534, '2024-10-12 08:00:00'),

('2024-10-13 09:15:00', 200, 'Initial request served', 1035, 535, '2024-10-13 09:00:00'),
('2024-10-13 10:15:00', 204, 'Logging service online', 1036, 536, '2024-10-13 09:00:00'),

('2024-10-14 09:45:00', 200, 'Resources verified', 1037, 537, '2024-10-14 09:30:00'),
('2024-10-14 10:45:00', 201, 'Health ping OK', 1038, 538, '2024-10-14 09:30:00'),
('2024-10-14 11:45:00', 202, 'Monitoring tools initialized', 1039, 539, '2024-10-14 09:30:00'),

('2024-10-15 10:00:00', 200, 'Update cycle started', 1040, 540, '2024-10-15 09:45:00'),
('2024-10-15 11:00:00', 203, 'Metrics streaming', 1041, 541, '2024-10-15 09:45:00'),
('2024-10-15 12:00:00', 204, 'Cronjobs scheduled', 1042, 542, '2024-10-15 09:45:00'),
('2024-10-15 13:00:00', 205, 'Worker nodes activated', 1043, 543, '2024-10-15 09:45:00'),

('2024-10-16 10:15:00', 200, 'Bootstrapping complete', 1044, 544, '2024-10-16 10:00:00'),
('2024-10-16 11:15:00', 201, 'Environment clean', 1045, 545, '2024-10-16 10:00:00'),
('2024-10-16 12:15:00', 202, 'Container sync finished', 1046, 546, '2024-10-16 10:00:00'),

('2024-10-17 11:30:00', 200, 'Session manager ready', 1047, 547, '2024-10-17 11:00:00'),
('2024-10-17 12:30:00', 202, 'Redis configured', 1048, 548, '2024-10-17 11:00:00'),
('2024-10-17 13:30:00', 203, 'Routing verified', 1049, 549, '2024-10-17 11:00:00'),

('2024-10-18 12:45:00', 200, 'Staging checks complete', 1050, 550, '2024-10-18 12:15:00'),
('2024-10-18 13:45:00', 201, 'Security patches applied', 1051, 551, '2024-10-18 12:15:00'),

('2024-10-19 13:00:00', 200, 'Authentication service active', 1052, 552, '2024-10-19 12:45:00'),
('2024-10-19 14:00:00', 204, 'Queue flushed', 1053, 553, '2024-10-19 12:45:00'),
('2024-10-19 15:00:00', 205, 'Temp files cleared', 1054, 554, '2024-10-19 12:45:00'),

('2024-10-20 14:15:00', 200, 'Update notifier live', 1055, 555, '2024-10-20 14:00:00'),
('2024-10-20 15:15:00', 201, 'Load balancer healthy', 1056, 556, '2024-10-20 14:00:00'),
('2024-10-20 16:15:00', 202, 'Autoscaler triggered', 1057, 557, '2024-10-20 14:00:00'),

('2024-10-21 15:00:00', 200, 'Start-of-day script executed', 1058, 558, '2024-10-21 14:30:00'),
('2024-10-21 16:00:00', 203, 'Cleanup complete', 1059, 559, '2024-10-21 14:30:00'),
('2024-10-21 17:00:00', 204, 'Kafka consumers ready', 1060, 560, '2024-10-21 14:30:00'),

('2024-10-22 15:30:00', 200, 'Log rotation started', 1061, 561, '2024-10-22 15:00:00'),
('2024-10-22 16:30:00', 202, 'SSL handshake verified', 1062, 562, '2024-10-22 15:00:00'),
('2024-10-22 17:30:00', 203, 'File watcher online', 1063, 563, '2024-10-22 15:00:00'),

('2024-10-23 16:15:00', 200, 'Worker pool refreshed', 1064, 564, '2024-10-23 16:00:00'),
('2024-10-23 17:15:00', 204, 'Daemon threads stable', 1065, 565, '2024-10-23 16:00:00'),

('2024-10-24 16:30:00', 200, 'API version check passed', 1066, 566, '2024-10-24 16:15:00'),
('2024-10-24 17:30:00', 201, 'Error logs compressed', 1067, 567, '2024-10-24 16:15:00'),
('2024-10-24 18:30:00', 202, 'Async job launched', 1068, 568, '2024-10-24 16:15:00'),

('2024-10-25 17:00:00', 200, 'S3 sync initialized', 1069, 569, '2024-10-25 16:45:00'),
('2024-10-25 18:00:00', 203, 'Retry logic validated', 1070, 570, '2024-10-25 16:45:00'),
('2024-10-25 19:00:00', 204, 'Live status broadcasting', 1071, 571, '2024-10-25 16:45:00'),

('2024-10-26 18:15:00', 200, 'Logs indexed in ELK', 1072, 572, '2024-10-26 18:00:00'),
('2024-10-26 19:15:00', 201, 'Nightly batch queued', 1073, 573, '2024-10-26 18:00:00'),
('2024-10-26 20:15:00', 202, 'Recovery system test passed', 1074, 574, '2024-10-26 18:00:00'),

('2024-10-27 19:30:00', 200, 'Auto backup started', 1075, 575, '2024-10-27 19:00:00'),
('2024-10-27 20:30:00', 202, 'Auth tokens cleared', 1076, 576, '2024-10-27 19:00:00'),
('2024-10-27 21:30:00', 204, 'Memory usage capped', 1077, 577, '2024-10-27 19:00:00'),

('2024-10-28 20:15:00', 200, 'Metrics synced', 1078, 578, '2024-10-28 20:00:00'),
('2024-10-28 21:15:00', 203, 'Policy engine reset', 1079, 579, '2024-10-28 20:00:00'),
('2024-10-28 22:15:00', 204, 'Persistent queue drained', 1080, 580, '2024-10-28 20:00:00'),

('2024-10-29 21:30:00', 200, 'Dependency map updated', 1081, 581, '2024-10-29 21:00:00'),
('2024-10-29 22:30:00', 201, 'Crash dump saved', 1082, 582, '2024-10-29 21:00:00'),

('2024-10-30 22:00:00', 200, 'Alert system configured', 1083, 583, '2024-10-30 21:30:00'),
('2024-10-30 23:00:00', 202, 'Cluster state recorded', 1084, 584, '2024-10-30 21:30:00'),
('2024-10-30 23:59:00', 203, 'Continuous deployment triggered', 1085, 585, '2024-10-30 21:30:00');


-- Server 3 Security Logs

INSERT INTO Server_ID_3_Security_Logs  (TimestampSCL3, Client_IP_AddressSCL3, Security_Level, End_PointSCL3, Event_TypeSCL3, MessageSCL3, Startup) VALUES
('2024-10-01 10:10:00', '172.16.0.10', 'LOW', '/home', 1, 'User session started', '2024-10-01 10:00:00'),
('2024-10-01 10:15:00', '172.16.0.11', 'MEDIUM', '/login', 2, 'Login successful', '2024-10-01 10:00:00'),
('2024-10-01 10:25:00', '172.16.0.12', 'LOW', '/api/token', 3, 'Token issued', '2024-10-01 10:00:00'),

('2024-10-02 11:05:00', '172.16.1.10', 'MEDIUM', '/dashboard', 4, 'Access granted', '2024-10-02 11:00:00'),
('2024-10-02 11:10:00', '172.16.1.11', 'HIGH', '/admin', 5, 'Unauthorized attempt blocked', '2024-10-02 11:00:00'),
('2024-10-02 11:20:00', '172.16.1.12', 'LOW', '/logout', 6, 'User logged out', '2024-10-02 11:00:00'),

('2024-10-03 12:20:00', '172.16.2.10', 'LOW', '/settings', 7, 'Profile updated', '2024-10-03 12:00:00'),
('2024-10-03 12:25:00', '172.16.2.11', 'MEDIUM', '/password-reset', 8, 'Password reset requested', '2024-10-03 12:00:00'),
('2024-10-03 12:35:00', '172.16.2.12', 'LOW', '/confirm', 9, 'Reset link used', '2024-10-03 12:00:00'),

('2024-10-04 12:55:00', '172.16.3.10', 'HIGH', '/admin/logs', 10, 'Logs reviewed', '2024-10-04 12:45:00'),
('2024-10-04 13:00:00', '172.16.3.11', 'MEDIUM', '/session/expire', 11, 'Session expired', '2024-10-04 12:45:00'),
('2024-10-04 13:10:00', '172.16.3.12', 'LOW', '/auth/check', 12, 'Token validation success', '2024-10-04 12:45:00'),

('2024-10-05 14:10:00', '172.16.4.10', 'LOW', '/home', 13, 'User login attempt', '2024-10-05 14:00:00'),
('2024-10-05 14:20:00', '172.16.4.11', 'HIGH', '/data/delete', 14, 'Delete permission denied', '2024-10-05 14:00:00'),
('2024-10-05 14:30:00', '172.16.4.12', 'MEDIUM', '/data/export', 15, 'Export requested', '2024-10-05 14:00:00'),

('2024-10-06 15:05:00', '172.16.5.10', 'LOW', '/profile', 16, 'Profile viewed', '2024-10-06 15:00:00'),
('2024-10-06 15:10:00', '172.16.5.11', 'MEDIUM', '/api/auth', 17, 'Auth token validated', '2024-10-06 15:00:00'),

('2024-10-07 16:15:00', '172.16.6.10', 'HIGH', '/admin/users', 18, 'User management attempted', '2024-10-07 16:00:00'),
('2024-10-07 16:25:00', '172.16.6.11', 'LOW', '/logs', 19, 'Logs downloaded', '2024-10-07 16:00:00'),

('2024-10-08 17:10:00', '172.16.7.10', 'LOW', '/files', 20, 'File access granted', '2024-10-08 17:00:00'),
('2024-10-08 17:15:00', '172.16.7.11', 'MEDIUM', '/files/upload', 21, 'Upload success', '2024-10-08 17:00:00'),

('2024-10-09 18:20:00', '172.16.8.10', 'HIGH', '/security', 22, 'Security policy updated', '2024-10-09 18:00:00'),
('2024-10-09 18:30:00', '172.16.8.11', 'LOW', '/token/refresh', 23, 'Token refreshed', '2024-10-09 18:00:00'),

('2024-10-10 19:10:00', '172.16.9.10', 'MEDIUM', '/contact', 24, 'User contact initiated', '2024-10-10 19:00:00'),
('2024-10-10 19:20:00', '172.16.9.11', 'HIGH', '/alert', 25, 'Alert generated', '2024-10-10 19:00:00'),

('2024-10-11 20:05:00', '172.17.1.10', 'LOW', '/files/view', 26, 'User viewed file', '2024-10-11 20:00:00'),
('2024-10-11 20:10:00', '172.17.1.11', 'MEDIUM', '/auth/verify', 27, 'Token verified', '2024-10-11 20:00:00'),
('2024-10-11 20:15:00', '172.17.1.12', 'HIGH', '/admin/panel', 28, 'Admin access blocked', '2024-10-11 20:00:00'),

('2024-10-12 21:00:00', '172.17.2.10', 'LOW', '/dashboard', 29, 'Dashboard accessed', '2024-10-12 21:00:00'),
('2024-10-12 21:05:00', '172.17.2.11', 'LOW', '/logs/export', 30, 'Logs exported', '2024-10-12 21:00:00'),
('2024-10-12 21:10:00', '172.17.2.12', 'MEDIUM', '/token/request', 31, 'Token request granted', '2024-10-12 21:00:00'),

('2024-10-13 22:00:00', '172.17.3.10', 'HIGH', '/admin/reset', 32, 'Password reset triggered', '2024-10-13 22:00:00'),
('2024-10-13 22:05:00', '172.17.3.11', 'MEDIUM', '/settings', 33, 'Settings changed', '2024-10-13 22:00:00'),
('2024-10-13 22:10:00', '172.17.3.12', 'LOW', '/api/ping', 34, 'Ping received', '2024-10-13 22:00:00'),

('2024-10-14 23:00:00', '172.17.4.10', 'LOW', '/alerts', 35, 'Alert settings modified', '2024-10-14 23:00:00'),
('2024-10-14 23:10:00', '172.17.4.11', 'MEDIUM', '/login', 36, 'Login attempted', '2024-10-14 23:00:00'),
('2024-10-14 23:20:00', '172.17.4.12', 'HIGH', '/firewall', 37, 'Firewall rules changed', '2024-10-14 23:00:00'),

('2024-10-15 00:00:00', '172.17.5.10', 'MEDIUM', '/backup', 38, 'Backup started', '2024-10-15 00:00:00'),
('2024-10-15 00:10:00', '172.17.5.11', 'LOW', '/network/status', 39, 'Status check', '2024-10-15 00:00:00'),
('2024-10-15 00:15:00', '172.17.5.12', 'HIGH', '/security/scan', 40, 'Security scan initiated', '2024-10-15 00:00:00'),

('2024-10-16 01:00:00', '172.17.6.10', 'LOW', '/session/start', 41, 'Session started', '2024-10-16 01:00:00'),
('2024-10-16 01:05:00', '172.17.6.11', 'MEDIUM', '/session/end', 42, 'Session ended', '2024-10-16 01:00:00'),

('2024-10-17 02:00:00', '172.17.7.10', 'HIGH', '/system/restart', 43, 'System restart initiated', '2024-10-17 02:00:00'),
('2024-10-17 02:05:00', '172.17.7.11', 'LOW', '/metrics', 44, 'Metrics viewed', '2024-10-17 02:00:00'),

('2024-10-18 03:00:00', '172.17.8.10', 'LOW', '/access/logs', 45, 'Access logs fetched', '2024-10-18 03:00:00'),
('2024-10-18 03:10:00', '172.17.8.11', 'MEDIUM', '/access/grant', 46, 'Access granted', '2024-10-18 03:00:00'),

('2024-10-19 04:00:00', '172.17.9.10', 'HIGH', '/admin/auth', 47, 'Admin authentication failed', '2024-10-19 04:00:00'),
('2024-10-19 04:05:00', '172.17.9.11', 'LOW', '/config', 48, 'Config viewed', '2024-10-19 04:00:00'),

('2024-10-20 05:00:00', '172.17.10.10', 'LOW', '/network/info', 49, 'Network information accessed', '2024-10-20 05:00:00'),
('2024-10-20 05:10:00', '172.17.10.11', 'MEDIUM', '/dns/update', 50, 'DNS updated', '2024-10-20 05:00:00'),

('2024-10-21 06:00:00', '172.17.11.10', 'LOW', '/user/login', 51, 'Login attempt', '2024-10-21 06:00:00'),
('2024-10-21 06:02:00', '172.17.11.11', 'MEDIUM', '/user/logout', 52, 'Logout successful', '2024-10-21 06:00:00'),
('2024-10-21 06:04:00', '172.17.11.12', 'HIGH', '/user/lockout', 53, 'User locked out after 3 attempts', '2024-10-21 06:00:00'),

('2024-10-22 07:00:00', '172.17.12.10', 'MEDIUM', '/token/refresh', 54, 'Token refreshed', '2024-10-22 07:00:00'),
('2024-10-22 07:02:00', '172.17.12.11', 'LOW', '/token/check', 55, 'Token check successful', '2024-10-22 07:00:00'),
('2024-10-22 07:04:00', '172.17.12.12', 'HIGH', '/token/revoke', 56, 'Token revoked', '2024-10-22 07:00:00'),

('2024-10-23 08:00:00', '172.17.13.10', 'LOW', '/firewall/status', 57, 'Firewall status normal', '2024-10-23 08:00:00'),
('2024-10-23 08:02:00', '172.17.13.11', 'MEDIUM', '/firewall/update', 58, 'Firewall rule updated', '2024-10-23 08:00:00'),
('2024-10-23 08:04:00', '172.17.13.12', 'HIGH', '/firewall/block', 59, 'IP blocked', '2024-10-23 08:00:00'),

('2024-10-24 09:00:00', '172.17.14.10', 'HIGH', '/admin/reset', 60, 'Password reset by admin', '2024-10-24 09:00:00'),
('2024-10-24 09:02:00', '172.17.14.11', 'LOW', '/admin/view', 61, 'Admin panel viewed', '2024-10-24 09:00:00'),
('2024-10-24 09:04:00', '172.17.14.12', 'MEDIUM', '/admin/logs', 62, 'Admin logs accessed', '2024-10-24 09:00:00'),

('2024-10-25 10:00:00', '172.17.15.10', 'LOW', '/session/init', 63, 'Session initialized', '2024-10-25 10:00:00'),
('2024-10-25 10:02:00', '172.17.15.11', 'MEDIUM', '/session/verify', 64, 'Session verification passed', '2024-10-25 10:00:00'),
('2024-10-25 10:04:00', '172.17.15.12', 'HIGH', '/session/terminate', 65, 'Session forcibly terminated', '2024-10-25 10:00:00'),

('2024-10-26 11:00:00', '172.17.16.10', 'MEDIUM', '/device/register', 66, 'New device registered', '2024-10-26 11:00:00'),
('2024-10-26 11:02:00', '172.17.16.11', 'LOW', '/device/confirm', 67, 'Device registration confirmed', '2024-10-26 11:00:00'),

('2024-10-27 12:00:00', '172.17.17.10', 'HIGH', '/backup/initiate', 68, 'Backup started', '2024-10-27 12:00:00'),
('2024-10-27 12:02:00', '172.17.17.11', 'MEDIUM', '/backup/status', 69, 'Backup in progress', '2024-10-27 12:00:00'),

('2024-10-28 13:00:00', '172.17.18.10', 'LOW', '/vpn/connect', 70, 'VPN connection established', '2024-10-28 13:00:00'),
('2024-10-28 13:02:00', '172.17.18.11', 'HIGH', '/vpn/disconnect', 71, 'VPN disconnected unexpectedly', '2024-10-28 13:00:00'),

('2024-10-29 14:00:00', '172.17.19.10', 'MEDIUM', '/cloud/access', 72, 'Cloud resource accessed', '2024-10-29 14:00:00'),
('2024-10-29 14:02:00', '172.17.19.11', 'LOW', '/cloud/logout', 73, 'User logged out of cloud', '2024-10-29 14:00:00'),

('2024-10-30 15:00:00', '172.17.20.10', 'HIGH', '/storage/full', 74, 'Storage capacity full', '2024-10-30 15:00:00'),
('2024-10-30 15:02:00', '172.17.20.11', 'MEDIUM', '/storage/cleanup', 75, 'Storage cleanup initiated', '2024-10-30 15:00:00'),

('2024-10-31 16:00:00', '172.17.21.10', 'LOW', '/api/get-info', 76, 'Data retrieval', '2024-10-31 16:00:00'),
('2024-10-31 16:01:00', '172.17.21.11', 'HIGH', '/api/post-info', 77, 'Data post attempted', '2024-10-31 16:00:00'),
('2024-10-31 16:02:00', '172.17.21.12', 'MEDIUM', '/api/delete-info', 78, 'Record deletion attempted', '2024-10-31 16:00:00'),

('2024-11-01 17:00:00', '172.17.22.10', 'HIGH', '/admin/override', 79, 'Admin override command issued', '2024-11-01 17:00:00'),
('2024-11-01 17:02:00', '172.17.22.11', 'MEDIUM', '/admin/override/confirm', 80, 'Override confirmation required', '2024-11-01 17:00:00'),

('2024-11-02 18:00:00', '172.17.23.10', 'LOW', '/billing/query', 81, 'Billing data accessed', '2024-11-02 18:00:00'),
('2024-11-02 18:02:00', '172.17.23.11', 'HIGH', '/billing/error', 82, 'Billing calculation failed', '2024-11-02 18:00:00'),
('2024-11-02 18:04:00', '172.17.23.12', 'MEDIUM', '/billing/retry', 83, 'Billing retry initiated', '2024-11-02 18:00:00'),

('2024-11-03 19:00:00', '172.17.24.10', 'LOW', '/session/extend', 84, 'Session extension requested', '2024-11-03 19:00:00'),
('2024-11-03 19:02:00', '172.17.24.11', 'HIGH', '/session/timeout', 85, 'Session timed out', '2024-11-03 19:00:00');