-- DATA SIMULASI untuk pengujian lokal. Jangan dipakai di produksi.
USE cybersecurity_monitoring;
SET time_zone = '+00:00';

INSERT INTO sensor_status (id,sensor_code,hostname,os,sensor_type,api_key_hash,last_seen_at,status) VALUES (1,'sim-linux-01','web-server-01','linux','bash','110ef7dbe543ac74dc0a7aa5a79c03486a76c04e91eeca00e5a7493a03118ffb',(UTC_TIMESTAMP() - INTERVAL 20 SECOND),'online');
INSERT INTO sensor_status (id,sensor_code,hostname,os,sensor_type,api_key_hash,last_seen_at,status) VALUES (2,'sim-windows-01','app-server-02','windows','powershell','7b05b2eca6d2470972e14dcc8d533123ea55d815a4db335a8f5ddd91627936a1',(UTC_TIMESTAMP() - INTERVAL 40 SECOND),'online');
INSERT INTO sensor_status (id,sensor_code,hostname,os,sensor_type,api_key_hash,last_seen_at,status) VALUES (3,'sim-go-agent-01','edge-gateway','linux','golang','cc41863740b15753402d6b3f90e8133dd8a2c650f1ede81852ee9f351da07a64',(UTC_TIMESTAMP() - INTERVAL 60 SECOND),'online');
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (2,'INC-SIM-000002',(UTC_TIMESTAMP() - INTERVAL 258840 SECOND),'brute_force','sim-go-agent-01','203.0.113.44','high','login gagal berulang dari 203.0.113.44',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (16,'INC-SIM-000010',(UTC_TIMESTAMP() - INTERVAL 257280 SECOND),'sql_injection','sim-windows-01','192.0.2.50','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','false_positive',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (56,'INC-SIM-000038',(UTC_TIMESTAMP() - INTERVAL 257160 SECOND),'port_scan','sim-go-agent-01','192.0.2.50','high','192.0.2.50 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',NULL,'Tinjau aturan firewall.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (39,'INC-SIM-000027',(UTC_TIMESTAMP() - INTERVAL 254940 SECOND),'traffic_spike','sim-linux-01','198.51.100.23','warning','Lonjakan trafik: 540 request/menit (4.8x rata-rata)',NULL,'Periksa IP teratas, aktifkan rate limiting.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (3,'INC-SIM-000003',(UTC_TIMESTAMP() - INTERVAL 252060 SECOND),'system','sim-linux-01','192.0.2.77','normal','Log sistem: sesi SSH diterima',NULL,NULL,'new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (59,'INC-SIM-00003B',(UTC_TIMESTAMP() - INTERVAL 250560 SECOND),'xss','sim-go-agent-01','198.51.100.7','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','resolved',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (52,'INC-SIM-000034',(UTC_TIMESTAMP() - INTERVAL 245700 SECOND),'unusual_admin','sim-windows-01','10.0.0.15','warning','Aktivitas administratif tidak biasa ''delete_user'': di luar jam kerja',NULL,'Konfirmasi dengan admin.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (11,'INC-SIM-00000B',(UTC_TIMESTAMP() - INTERVAL 245220 SECOND),'unusual_admin','sim-go-agent-01','203.0.113.44','warning','Aktivitas administratif tidak biasa ''delete_user'': di luar jam kerja',NULL,'Konfirmasi dengan admin.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (12,'INC-SIM-00000C',(UTC_TIMESTAMP() - INTERVAL 243480 SECOND),'sql_injection','sim-linux-01','192.0.2.77','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','false_positive',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (5,'INC-SIM-000005',(UTC_TIMESTAMP() - INTERVAL 239520 SECOND),'system','sim-go-agent-01','192.0.2.50','warning','Log sistem: Failed password for invalid user test',NULL,NULL,'new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (23,'INC-SIM-000017',(UTC_TIMESTAMP() - INTERVAL 221400 SECOND),'traffic_spike','sim-go-agent-01','198.51.100.7','warning','Lonjakan trafik: 540 request/menit (4.8x rata-rata)',NULL,'Periksa IP teratas, aktifkan rate limiting.','resolved',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (19,'INC-SIM-000013',(UTC_TIMESTAMP() - INTERVAL 221220 SECOND),'traffic_spike','sim-windows-01','192.0.2.50','warning','Lonjakan trafik: 540 request/menit (4.8x rata-rata)',NULL,'Periksa IP teratas, aktifkan rate limiting.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (33,'INC-SIM-000021',(UTC_TIMESTAMP() - INTERVAL 218580 SECOND),'system','sim-linux-01','192.0.2.77','normal','Log sistem: sesi SSH diterima',NULL,NULL,'resolved',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (29,'INC-SIM-00001D',(UTC_TIMESTAMP() - INTERVAL 218400 SECOND),'brute_force','sim-go-agent-01','192.0.2.50','high','login gagal berulang dari 192.0.2.50',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','investigating',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (36,'INC-SIM-000024',(UTC_TIMESTAMP() - INTERVAL 202020 SECOND),'port_scan','sim-linux-01','10.0.0.22','high','10.0.0.22 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',NULL,'Tinjau aturan firewall.','false_positive',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (14,'INC-SIM-00000E',(UTC_TIMESTAMP() - INTERVAL 201720 SECOND),'sql_injection','sim-go-agent-01','192.0.2.50','warning','Pola SQL Injection mencurigakan pada /products.php',NULL,'Gunakan prepared statement; tinjau log DB.','false_positive',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (24,'INC-SIM-000018',(UTC_TIMESTAMP() - INTERVAL 188520 SECOND),'port_scan','sim-linux-01','192.0.2.77','high','192.0.2.77 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',NULL,'Tinjau aturan firewall.','false_positive',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (21,'INC-SIM-000015',(UTC_TIMESTAMP() - INTERVAL 187620 SECOND),'sql_injection','sim-linux-01','198.51.100.7','warning','Pola SQL Injection mencurigakan pada /products.php',NULL,'Gunakan prepared statement; tinjau log DB.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (38,'INC-SIM-000026',(UTC_TIMESTAMP() - INTERVAL 187080 SECOND),'path_traversal','sim-go-agent-01','198.51.100.7','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','false_positive',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (30,'INC-SIM-00001E',(UTC_TIMESTAMP() - INTERVAL 173700 SECOND),'path_traversal','sim-linux-01','203.0.113.9','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','false_positive',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (35,'INC-SIM-000023',(UTC_TIMESTAMP() - INTERVAL 173700 SECOND),'xss','sim-go-agent-01','192.0.2.77','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (34,'INC-SIM-000022',(UTC_TIMESTAMP() - INTERVAL 170340 SECOND),'system','sim-windows-01','10.0.0.15','normal','Log sistem: sesi SSH diterima',NULL,NULL,'new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (55,'INC-SIM-000037',(UTC_TIMESTAMP() - INTERVAL 169200 SECOND),'xss','sim-windows-01','198.51.100.23','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','false_positive',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (42,'INC-SIM-00002A',(UTC_TIMESTAMP() - INTERVAL 167820 SECOND),'brute_force','sim-linux-01','198.51.100.23','high','login gagal berulang dari 198.51.100.23',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (60,'INC-SIM-00003C',(UTC_TIMESTAMP() - INTERVAL 166140 SECOND),'system','sim-linux-01','192.0.2.50','warning','Log sistem: Failed password for invalid user test',NULL,NULL,'new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (6,'INC-SIM-000006',(UTC_TIMESTAMP() - INTERVAL 165060 SECOND),'path_traversal','sim-linux-01','203.0.113.44','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','resolved',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (41,'INC-SIM-000029',(UTC_TIMESTAMP() - INTERVAL 158160 SECOND),'xss','sim-go-agent-01','192.0.2.50','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (48,'INC-SIM-000030',(UTC_TIMESTAMP() - INTERVAL 153120 SECOND),'xss','sim-linux-01','198.51.100.7','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (49,'INC-SIM-000031',(UTC_TIMESTAMP() - INTERVAL 152340 SECOND),'port_scan','sim-windows-01','203.0.113.44','high','203.0.113.44 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',NULL,'Tinjau aturan firewall.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (57,'INC-SIM-000039',(UTC_TIMESTAMP() - INTERVAL 141480 SECOND),'brute_force','sim-linux-01','198.51.100.23','high','login gagal berulang dari 198.51.100.23',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (43,'INC-SIM-00002B',(UTC_TIMESTAMP() - INTERVAL 141240 SECOND),'path_traversal','sim-windows-01','198.51.100.23','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','investigating',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (25,'INC-SIM-000019',(UTC_TIMESTAMP() - INTERVAL 137880 SECOND),'system','sim-windows-01','192.0.2.77','normal','Log sistem: sesi SSH diterima',NULL,NULL,'investigating',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (13,'INC-SIM-00000D',(UTC_TIMESTAMP() - INTERVAL 120480 SECOND),'brute_force','sim-windows-01','203.0.113.9','high','login gagal berulang dari 203.0.113.9',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (18,'INC-SIM-000012',(UTC_TIMESTAMP() - INTERVAL 117600 SECOND),'brute_force','sim-linux-01','198.51.100.7','high','login gagal berulang dari 198.51.100.7',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','false_positive',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (22,'INC-SIM-000016',(UTC_TIMESTAMP() - INTERVAL 116160 SECOND),'traffic_spike','sim-windows-01','192.0.2.77','warning','Lonjakan trafik: 540 request/menit (4.8x rata-rata)',NULL,'Periksa IP teratas, aktifkan rate limiting.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (31,'INC-SIM-00001F',(UTC_TIMESTAMP() - INTERVAL 110700 SECOND),'unusual_admin','sim-windows-01','203.0.113.44','warning','Aktivitas administratif tidak biasa ''delete_user'': di luar jam kerja',NULL,'Konfirmasi dengan admin.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (26,'INC-SIM-00001A',(UTC_TIMESTAMP() - INTERVAL 99000 SECOND),'xss','sim-go-agent-01','203.0.113.9','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','false_positive',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (50,'INC-SIM-000032',(UTC_TIMESTAMP() - INTERVAL 98760 SECOND),'path_traversal','sim-go-agent-01','192.0.2.77','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (51,'INC-SIM-000033',(UTC_TIMESTAMP() - INTERVAL 90960 SECOND),'sql_injection','sim-linux-01','192.0.2.50','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (1,'INC-SIM-000001',(UTC_TIMESTAMP() - INTERVAL 87000 SECOND),'sql_injection','sim-windows-01','192.0.2.50','warning','Pola SQL Injection mencurigakan pada /products.php',NULL,'Gunakan prepared statement; tinjau log DB.','investigating',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (15,'INC-SIM-00000F',(UTC_TIMESTAMP() - INTERVAL 86100 SECOND),'sql_injection','sim-linux-01','203.0.113.9','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (54,'INC-SIM-000036',(UTC_TIMESTAMP() - INTERVAL 85980 SECOND),'system','sim-linux-01','192.0.2.50','normal','Log sistem: sesi SSH diterima',NULL,NULL,'resolved',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (40,'INC-SIM-000028',(UTC_TIMESTAMP() - INTERVAL 79380 SECOND),'sql_injection','sim-windows-01','203.0.113.44','warning','Pola SQL Injection mencurigakan pada /products.php',NULL,'Gunakan prepared statement; tinjau log DB.','false_positive',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (4,'INC-SIM-000004',(UTC_TIMESTAMP() - INTERVAL 78840 SECOND),'sql_injection','sim-windows-01','10.0.0.22','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (37,'INC-SIM-000025',(UTC_TIMESTAMP() - INTERVAL 73260 SECOND),'path_traversal','sim-windows-01','10.0.0.22','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (8,'INC-SIM-000008',(UTC_TIMESTAMP() - INTERVAL 65640 SECOND),'path_traversal','sim-go-agent-01','203.0.113.44','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (20,'INC-SIM-000014',(UTC_TIMESTAMP() - INTERVAL 61800 SECOND),'xss','sim-go-agent-01','198.51.100.7','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','false_positive',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (17,'INC-SIM-000011',(UTC_TIMESTAMP() - INTERVAL 53400 SECOND),'xss','sim-go-agent-01','192.0.2.50','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','false_positive',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (58,'INC-SIM-00003A',(UTC_TIMESTAMP() - INTERVAL 48960 SECOND),'path_traversal','sim-windows-01','198.51.100.7','high','Percobaan akses ../../etc/passwd pada /download.php',NULL,'Validasi path terhadap whitelist.','resolved',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (27,'INC-SIM-00001B',(UTC_TIMESTAMP() - INTERVAL 36060 SECOND),'xss','sim-linux-01','10.0.0.22','warning','Pola XSS mencurigakan pada /comment.php',NULL,'Escape output dan terapkan CSP.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (7,'INC-SIM-000007',(UTC_TIMESTAMP() - INTERVAL 30000 SECOND),'sql_injection','sim-windows-01','192.0.2.50','high','Pola SQL Injection (UNION SELECT) pada /search.php',NULL,'Gunakan prepared statement; blokir IP sementara.','investigating',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (10,'INC-SIM-00000A',(UTC_TIMESTAMP() - INTERVAL 27960 SECOND),'brute_force','sim-windows-01','10.0.0.15','high','login gagal berulang dari 10.0.0.15',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (32,'INC-SIM-000020',(UTC_TIMESTAMP() - INTERVAL 26520 SECOND),'brute_force','sim-go-agent-01','10.0.0.15','high','login gagal berulang dari 10.0.0.15',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (45,'INC-SIM-00002D',(UTC_TIMESTAMP() - INTERVAL 24420 SECOND),'system','sim-linux-01','198.51.100.7','warning','Log sistem: Failed password for invalid user test',NULL,NULL,'new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (53,'INC-SIM-000035',(UTC_TIMESTAMP() - INTERVAL 19020 SECOND),'system','sim-go-agent-01','198.51.100.7','normal','Log sistem: sesi SSH diterima',NULL,NULL,'new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (46,'INC-SIM-00002E',(UTC_TIMESTAMP() - INTERVAL 18960 SECOND),'system','sim-windows-01','203.0.113.44','normal','Log sistem: sesi SSH diterima',NULL,NULL,'investigating',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (9,'INC-SIM-000009',(UTC_TIMESTAMP() - INTERVAL 16680 SECOND),'system','sim-linux-01','192.0.2.50','normal','Log sistem: sesi SSH diterima',NULL,NULL,'resolved',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (44,'INC-SIM-00002C',(UTC_TIMESTAMP() - INTERVAL 13260 SECOND),'system','sim-go-agent-01','192.0.2.77','warning','Log sistem: Failed password for invalid user test',NULL,NULL,'new',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (47,'INC-SIM-00002F',(UTC_TIMESTAMP() - INTERVAL 4800 SECOND),'system','sim-go-agent-01','198.51.100.23','warning','Log sistem: Failed password for invalid user test',NULL,NULL,'investigating',3);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (28,'INC-SIM-00001C',(UTC_TIMESTAMP() - INTERVAL 2040 SECOND),'brute_force','sim-windows-01','10.0.0.22','high','login gagal berulang dari 10.0.0.22',NULL,'Blokir/ratelimit IP dan aktifkan MFA.','new',2);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (61,'INC-SIM-00003D',(UTC_TIMESTAMP() - INTERVAL 720 SECOND),'file_tampering','sim-linux-01',NULL,'critical','Berkas penting berubah: /etc/ssh/sshd_config','/etc/ssh/sshd_config','Bandingkan dengan backup; jika tidak sah isolasi sistem.','new',1);
INSERT INTO security_events (id,incident_code,event_time,event_type,source,ip_address,risk_level,summary,evidence,recommendation,handling_status,sensor_id) VALUES (62,'INC-SIM-00003E',(UTC_TIMESTAMP() - INTERVAL 180 SECOND),'sensor_failure','engine',NULL,'high','Sensor ''sim-go-agent-01'' berhenti mengirim data',NULL,'Periksa layanan sensor dan jaringan.','new',3);
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (1,16,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 257280 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (2,59,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 250560 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (3,12,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 243480 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (4,14,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 201720 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (5,21,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 187620 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (6,38,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 187080 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (7,30,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 173700 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (8,35,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 173700 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (9,55,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 169200 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (10,6,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 165060 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (11,41,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 158160 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (12,48,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 153120 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (13,43,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 141240 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (14,26,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 99000 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (15,50,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 98760 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (16,51,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 90960 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (17,1,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 87000 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (18,15,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 86100 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (19,40,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 79380 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (20,4,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 78840 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (21,37,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 73260 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (22,8,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 65640 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (23,20,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 61800 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (24,17,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 53400 SECOND),'confirmed');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (25,58,'path_traversal','/download.php','../ atau ..\\',(UTC_TIMESTAMP() - INTERVAL 48960 SECOND),'false_positive');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (26,27,'xss','/comment.php','tag <script>',(UTC_TIMESTAMP() - INTERVAL 36060 SECOND),'suspected');
INSERT INTO attack_attempts (id,event_id,attack_type,endpoint,indicator,detected_at,verification_status) VALUES (27,7,'sql_injection','/products.php','union select, tautologi OR/AND 1=1',(UTC_TIMESTAMP() - INTERVAL 30000 SECOND),'suspected');
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 116460 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 171120 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 239640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.9',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 78060 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 183840 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 81720 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 216120 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 181560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 20580 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.22',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 225600 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.9',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 161640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 86100 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 134640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 10560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.23',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 25860 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 116280 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 44760 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 115920 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 216780 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 160140 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 158760 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.9',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 239580 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 41820 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.23',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 201960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 15900 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 219600 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 4980 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 122100 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 119940 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 140640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 230880 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 76200 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 241740 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 100560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 84900 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 157620 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 71520 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 170520 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 211380 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 217560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 132660 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 168900 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 57000 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 239640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 206820 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 51660 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 231060 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 204540 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 229080 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 206160 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 33540 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','203.0.113.44',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 117540 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 175380 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 237960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 109740 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 145620 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 61800 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','192.0.2.77',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 206220 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 139560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 147780 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 207000 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 180420 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 70860 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 125160 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 6720 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 196560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 121200 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 219480 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 122160 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','10.0.0.15',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 186840 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.22',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 249960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 258840 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 8580 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 24060 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.22',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 177240 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 208140 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 18600 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 140640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 170280 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 21120 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.77',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 121140 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 258060 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 150960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 116580 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 239760 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 189660 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 180300 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','10.0.0.15',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 198420 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 9900 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 233580 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 224760 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','203.0.113.44',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 123240 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 107400 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','198.51.100.23',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 106980 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','192.0.2.77',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 59100 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 258120 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','198.51.100.23',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 199260 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.15',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 78960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 258960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.22',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 244080 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','198.51.100.23',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 234780 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.9',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 187500 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 243480 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','10.0.0.15',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 161280 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 232560 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 108900 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.9',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 36240 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('root','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 109380 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','198.51.100.7',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 226260 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.15',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 81060 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','10.0.0.15',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2040 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 60240 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 61920 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 140220 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','192.0.2.50',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 19020 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.7',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 151260 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('test','203.0.113.44',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 63720 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','198.51.100.23',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 87960 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('budi','10.0.0.22',1,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 118680 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('analyst','192.0.2.50',0,'Mozilla/5.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 179640 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2400 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2340 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2280 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2220 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2160 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2100 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 2040 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 1980 SECOND));
INSERT INTO login_logs (username,ip_address,success,user_agent,source,created_at) VALUES ('admin','198.51.100.7',0,'curl/8.0 (simulasi)','dashboard',(UTC_TIMESTAMP() - INTERVAL 1920 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,90.99,58.6,58.02,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 0 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,93.59,55.65,55.0,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,91.18,50.93,47.76,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,67.54,51.51,41.09,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,51.05,51.02,53.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,18.93,72.21,43.01,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,20.88,55.57,43.04,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,64.93,44.05,53.6,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,56.63,46.45,55.72,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,49.12,51.2,56.33,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,10.51,51.78,58.54,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,67.86,43.2,40.26,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,14.91,48.53,56.29,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,31.91,64.64,47.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,59.42,38.57,53.69,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,63.4,37.06,42.78,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,36.37,66.78,49.37,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,56.44,40.84,40.49,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,57.44,43.66,43.81,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,18.46,58.12,59.63,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,41.58,66.74,46.59,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,23.37,51.89,49.91,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,43.1,39.24,42.4,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,19.14,62.31,59.86,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,32.29,56.55,42.85,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,53.29,72.69,42.79,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,35.78,57.25,40.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,10.93,61.02,52.13,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,50.59,45.41,58.0,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,15.38,38.79,54.36,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,45.78,52.29,51.91,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,31.07,39.02,58.7,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,48.56,70.32,49.4,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,22.06,54.95,42.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,11.82,55.08,44.48,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,41.49,62.19,58.91,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,49.57,73.05,40.94,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,27.14,62.28,42.86,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,24.66,72.74,41.0,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,12.01,51.26,46.32,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,24.52,43.1,54.7,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,43.24,38.21,41.7,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,24.54,68.12,46.33,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,35.24,49.12,46.22,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,67.95,48.15,56.44,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,51.53,63.29,41.6,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,13.66,61.66,54.43,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,43.18,63.78,51.68,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,20.92,63.53,54.35,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,68.31,71.7,49.31,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,49.55,39.27,50.66,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,62.15,38.65,58.87,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,23.18,68.83,43.41,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,57.89,70.43,51.07,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,59.59,48.97,47.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,58.33,69.1,40.08,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,27.71,56.01,48.89,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,46.67,35.52,57.87,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,27.64,47.3,57.48,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,61.53,51.97,41.68,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,43.18,41.78,59.28,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,41.09,67.09,41.06,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,14.75,65.05,43.63,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,27.46,70.77,47.86,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,43.03,73.11,43.28,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,35.04,58.53,45.77,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,35.57,53.84,56.76,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,66.23,64.63,43.35,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,36.52,69.13,43.46,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,22.86,72.51,57.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,57.78,71.39,51.86,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (1,69.26,57.44,40.31,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,56.07,72.24,49.09,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 0 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,24.78,73.88,56.41,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,53.79,56.51,45.45,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,18.35,48.56,57.09,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,63.42,73.7,59.47,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,19.41,54.61,48.21,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,66.05,39.48,45.81,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,61.55,61.97,45.53,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,36.51,65.88,48.23,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,32.33,64.57,54.35,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,64.87,45.54,43.76,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,11.44,41.48,53.3,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,37.29,51.59,56.36,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,28.73,45.1,49.0,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,19.69,74.27,46.84,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,17.98,64.35,42.78,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,24.91,54.37,43.28,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,69.29,60.93,50.69,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,54.8,43.61,48.17,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,21.88,35.05,59.91,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,44.9,45.17,45.88,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,67.24,58.09,51.06,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,69.33,55.13,48.71,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,24.91,53.37,40.11,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,64.94,69.81,45.32,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,24.92,41.92,48.5,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,20.26,41.47,42.17,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,12.58,53.83,46.62,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,20.68,54.65,40.42,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,37.57,40.41,40.99,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,67.94,68.5,57.1,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,27.46,53.75,42.75,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,50.23,59.47,40.49,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,61.57,58.62,40.12,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,62.1,59.76,54.24,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,66.63,35.39,56.61,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,32.59,38.65,56.15,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,37.75,53.35,58.12,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,58.33,59.96,52.3,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,13.16,48.57,56.59,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,41.95,53.7,54.95,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,51.9,65.3,47.06,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,13.13,41.58,40.09,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,46.32,44.6,42.47,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,43.86,68.02,54.82,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,69.83,53.89,50.17,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,11.78,72.29,51.6,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,30.13,58.29,51.69,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,44.63,58.37,44.05,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,39.71,51.33,51.95,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,47.74,39.04,54.98,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,59.06,73.44,48.03,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,36.71,49.49,42.37,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,32.13,43.63,57.38,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,68.33,42.83,48.76,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,60.72,63.74,59.29,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,33.71,37.55,47.03,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,13.8,74.85,48.53,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,31.74,63.35,49.11,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,28.41,52.45,50.26,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,26.03,37.21,51.77,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,67.84,72.34,50.74,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,46.8,65.81,49.7,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,46.81,36.33,51.24,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,37.58,55.32,52.25,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,63.53,72.2,50.61,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,57.46,60.83,54.08,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,58.17,37.92,52.57,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,59.11,73.3,52.84,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,63.05,60.79,46.1,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,68.09,53.53,49.75,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (2,48.43,58.98,43.25,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,20.32,37.06,57.34,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 0 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,41.84,47.8,41.01,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,39.16,49.77,50.98,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,48.13,70.4,50.4,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,30.94,74.78,42.16,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,29.77,70.59,57.11,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,42.62,54.91,52.97,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 1800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,50.88,36.09,52.62,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,20.26,49.44,43.97,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,14.9,51.21,44.45,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 2700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,45.05,61.86,49.51,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,24.21,52.15,52.18,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,51.37,54.14,49.81,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,14.59,62.59,47.45,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 3900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,50.05,51.47,40.96,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,18.8,55.45,42.21,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,58.09,64.98,54.59,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 4800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,28.05,35.64,51.8,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,68.8,65.5,55.92,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,59.08,74.88,42.21,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 5700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,38.2,72.0,54.04,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,40.93,52.42,46.73,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,23.38,47.36,53.08,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,68.07,69.55,40.55,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 6900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,59.07,63.3,41.25,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,50.94,63.67,57.06,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,11.95,40.05,42.84,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 7800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,17.04,63.57,45.42,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,17.82,46.55,55.47,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,31.15,42.35,44.29,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 8700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,26.77,54.81,42.31,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,58.21,62.36,52.96,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,61.22,66.27,55.75,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,15.94,59.45,41.08,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 9900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,11.84,60.33,46.34,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,61.35,49.38,57.9,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,25.56,44.12,46.66,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 10800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,50.01,65.26,46.97,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,33.62,48.43,49.37,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,36.07,73.11,54.43,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 11700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,45.69,44.86,42.7,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,62.71,55.02,56.82,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,53.45,61.69,59.21,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,64.52,55.65,47.37,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 12900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,17.02,35.21,50.24,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,63.71,59.69,43.47,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,51.34,37.61,51.72,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 13800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,14.92,70.19,48.86,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,18.54,36.63,44.37,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,18.06,72.48,48.6,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 14700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,45.75,59.96,52.43,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,44.86,59.86,57.29,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,65.74,63.24,40.66,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,13.83,74.72,41.42,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 15900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,60.96,36.54,44.02,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,49.75,66.55,57.83,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,64.72,54.16,45.44,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 16800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,26.75,39.4,45.74,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,68.57,72.74,45.22,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,63.88,63.43,40.49,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 17700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,14.79,62.41,53.59,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,34.35,36.87,42.77,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18300 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,26.14,46.05,50.59,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18600 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,39.94,40.61,51.55,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 18900 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,48.39,43.95,54.77,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19200 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,60.6,70.09,53.72,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19500 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,34.44,44.55,59.68,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 19800 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,42.79,38.98,57.51,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20100 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,62.6,46.74,56.62,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20400 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,42.78,37.57,49.72,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 20700 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,67.54,65.56,45.08,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21000 SECOND));
INSERT INTO system_metrics (sensor_id,cpu_percent,mem_percent,disk_percent,services_json,collected_at) VALUES (3,36.22,36.32,49.96,'{"nginx": "running", "mysql": "running"}',(UTC_TIMESTAMP() - INTERVAL 21300 SECOND));
INSERT INTO file_integrity_logs (sensor_id,file_path,baseline_hash,current_hash,status,checked_at) VALUES (1,'/etc/passwd','74acf31844532670be412c65b8251ee55d072549080b1cffdbea6b1a192230a0','74acf31844532670be412c65b8251ee55d072549080b1cffdbea6b1a192230a0','ok',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO file_integrity_logs (sensor_id,file_path,baseline_hash,current_hash,status,checked_at) VALUES (1,'/etc/hosts','4a666ea3a3b04a24f574974df10592d51bd191614ee41b02d09f6d13c0c2f52a','4a666ea3a3b04a24f574974df10592d51bd191614ee41b02d09f6d13c0c2f52a','ok',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO file_integrity_logs (sensor_id,file_path,baseline_hash,current_hash,status,checked_at) VALUES (1,'/var/www/html/index.php','68d6ea62efa67dbc0ef275d27b4c2a0cdb4abb7cebb63ae41489fd1e38b083a3','68d6ea62efa67dbc0ef275d27b4c2a0cdb4abb7cebb63ae41489fd1e38b083a3','ok',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO file_integrity_logs (sensor_id,file_path,baseline_hash,current_hash,status,checked_at) VALUES (1,'/etc/ssh/sshd_config','ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb','3e23e8160039594a33894f6564e1b1348bbd7a0088d42c4acb73eeaed59c009d','modified',(UTC_TIMESTAMP() - INTERVAL 720 SECOND));
INSERT INTO file_integrity_logs (sensor_id,file_path,baseline_hash,current_hash,status,checked_at) VALUES (2,'C:\\Windows\\System32\\drivers\\etc\\hosts','aaa9402664f1a41f40ebbc52c9993eb66aeb366602958fdfaa283b71e64db123','aaa9402664f1a41f40ebbc52c9993eb66aeb366602958fdfaa283b71e64db123','ok',(UTC_TIMESTAMP() - INTERVAL 3600 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (2,'high','login gagal berulang dari 203.0.113.44',0,(UTC_TIMESTAMP() - INTERVAL 258840 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (16,'high','Pola SQL Injection (UNION SELECT) pada /search.php',0,(UTC_TIMESTAMP() - INTERVAL 257280 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (56,'high','192.0.2.50 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',0,(UTC_TIMESTAMP() - INTERVAL 257160 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (12,'high','Pola SQL Injection (UNION SELECT) pada /search.php',0,(UTC_TIMESTAMP() - INTERVAL 243480 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (29,'high','login gagal berulang dari 192.0.2.50',1,(UTC_TIMESTAMP() - INTERVAL 218400 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (36,'high','10.0.0.22 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',0,(UTC_TIMESTAMP() - INTERVAL 202020 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (24,'high','192.0.2.77 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',0,(UTC_TIMESTAMP() - INTERVAL 188520 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (38,'high','Percobaan akses ../../etc/passwd pada /download.php',0,(UTC_TIMESTAMP() - INTERVAL 187080 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (30,'high','Percobaan akses ../../etc/passwd pada /download.php',0,(UTC_TIMESTAMP() - INTERVAL 173700 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (42,'high','login gagal berulang dari 198.51.100.23',0,(UTC_TIMESTAMP() - INTERVAL 167820 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (6,'high','Percobaan akses ../../etc/passwd pada /download.php',1,(UTC_TIMESTAMP() - INTERVAL 165060 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (49,'high','203.0.113.44 menyentuh 24 port berbeda dalam 60 detik (dugaan port scan)',0,(UTC_TIMESTAMP() - INTERVAL 152340 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (57,'high','login gagal berulang dari 198.51.100.23',1,(UTC_TIMESTAMP() - INTERVAL 141480 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (43,'high','Percobaan akses ../../etc/passwd pada /download.php',1,(UTC_TIMESTAMP() - INTERVAL 141240 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (13,'high','login gagal berulang dari 203.0.113.9',1,(UTC_TIMESTAMP() - INTERVAL 120480 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (18,'high','login gagal berulang dari 198.51.100.7',0,(UTC_TIMESTAMP() - INTERVAL 117600 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (50,'high','Percobaan akses ../../etc/passwd pada /download.php',0,(UTC_TIMESTAMP() - INTERVAL 98760 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (51,'high','Pola SQL Injection (UNION SELECT) pada /search.php',0,(UTC_TIMESTAMP() - INTERVAL 90960 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (15,'high','Pola SQL Injection (UNION SELECT) pada /search.php',0,(UTC_TIMESTAMP() - INTERVAL 86100 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (4,'high','Pola SQL Injection (UNION SELECT) pada /search.php',1,(UTC_TIMESTAMP() - INTERVAL 78840 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (37,'high','Percobaan akses ../../etc/passwd pada /download.php',1,(UTC_TIMESTAMP() - INTERVAL 73260 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (8,'high','Percobaan akses ../../etc/passwd pada /download.php',0,(UTC_TIMESTAMP() - INTERVAL 65640 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (58,'high','Percobaan akses ../../etc/passwd pada /download.php',0,(UTC_TIMESTAMP() - INTERVAL 48960 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (7,'high','Pola SQL Injection (UNION SELECT) pada /search.php',0,(UTC_TIMESTAMP() - INTERVAL 30000 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (10,'high','login gagal berulang dari 10.0.0.15',0,(UTC_TIMESTAMP() - INTERVAL 27960 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (32,'high','login gagal berulang dari 10.0.0.15',0,(UTC_TIMESTAMP() - INTERVAL 26520 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (28,'high','login gagal berulang dari 10.0.0.22',1,(UTC_TIMESTAMP() - INTERVAL 2040 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (61,'critical','Berkas penting berubah: /etc/ssh/sshd_config',0,(UTC_TIMESTAMP() - INTERVAL 720 SECOND));
INSERT INTO alerts (event_id,priority,message,is_read,created_at) VALUES (62,'high','Sensor ''sim-go-agent-01'' berhenti mengirim data',0,(UTC_TIMESTAMP() - INTERVAL 180 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (2,'INC-SIM-000002','login gagal berulang dari 203.0.113.44','brute_force','high','Terdeteksi oleh mesin deteksi (data simulasi).','investigating',(UTC_TIMESTAMP() - INTERVAL 258840 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (29,'INC-SIM-00001D','login gagal berulang dari 192.0.2.50','brute_force','high','Terdeteksi oleh mesin deteksi (data simulasi).','open',(UTC_TIMESTAMP() - INTERVAL 218400 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (38,'INC-SIM-000026','Percobaan akses ../../etc/passwd pada /download.php','path_traversal','high','Terdeteksi oleh mesin deteksi (data simulasi).','investigating',(UTC_TIMESTAMP() - INTERVAL 187080 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (30,'INC-SIM-00001E','Percobaan akses ../../etc/passwd pada /download.php','path_traversal','high','Terdeteksi oleh mesin deteksi (data simulasi).','open',(UTC_TIMESTAMP() - INTERVAL 173700 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (42,'INC-SIM-00002A','login gagal berulang dari 198.51.100.23','brute_force','high','Terdeteksi oleh mesin deteksi (data simulasi).','investigating',(UTC_TIMESTAMP() - INTERVAL 167820 SECOND));
INSERT INTO incident_reports (event_id,incident_code,title,category,risk_level,chronology,status,created_at) VALUES (6,'INC-SIM-000006','Percobaan akses ../../etc/passwd pada /download.php','path_traversal','high','Terdeteksi oleh mesin deteksi (data simulasi).','open',(UTC_TIMESTAMP() - INTERVAL 165060 SECOND));