// Wi-Fi Rogue Access Point and Deauthentication Event Logs (wi-fi-rogue-access-point-and-deauthentication-event-logs) v1 — Prisma seed // Synthetic sample data, CC0-1.0. Generated deterministically; re-running the // generator with the same spec and seed reproduces this file exactly. // // Delegates are named after the tables (prisma.rogue_profiles), which assumes models // mapped to those table names. Rename the delegates if your models differ. import { PrismaClient } from '@prisma/client'; const prisma = new PrismaClient(); async function main() { await prisma.rogue_profiles.createMany({ data: [ { id: 1, catalogue: "rogue-kinds", ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal" }, { id: 2, catalogue: "rogue-kinds", ssid: "CorpGuest", classification: "evil_twin", security: "open" }, { id: 3, catalogue: "rogue-kinds", ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal" }, { id: 4, catalogue: "rogue-kinds", ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open" }, { id: 5, catalogue: "rogue-kinds", ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal" }, { id: 6, catalogue: "rogue-kinds", ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal" }, ], }); await prisma.sites.createMany({ data: [ { id: 1, estate: "company-sites", name: "HQ Tower A", site_type: "office" }, { id: 2, estate: "company-sites", name: "HQ Tower B", site_type: "office" }, { id: 3, estate: "company-sites", name: "Warehouse North", site_type: "warehouse" }, { id: 4, estate: "company-sites", name: "Retail Store 12", site_type: "retail" }, { id: 5, estate: "company-sites", name: "Research Lab", site_type: "laboratory" }, ], }); await prisma.authorized_aps.createMany({ data: [ { id: 1, site_id: 2, bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", channel: "6", installed_on: "2022-09-05" }, { id: 2, site_id: 4, bssid: "02:51:50:42:d1:b4", ssid: "CorpNet", channel: "44", installed_on: "2023-07-03" }, { id: 3, site_id: 5, bssid: "02:63:a1:65:63:08", ssid: "CorpNet", channel: "44", installed_on: "2023-02-12" }, { id: 4, site_id: 5, bssid: "02:5b:b5:32:71:cb", ssid: "CorpNet", channel: "36", installed_on: "2021-09-15" }, { id: 5, site_id: 4, bssid: "02:7a:62:c1:e1:66", ssid: "CorpIoT", channel: "1", installed_on: "2023-03-15" }, { id: 6, site_id: 5, bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", channel: "1", installed_on: "2021-08-21" }, { id: 7, site_id: 4, bssid: "02:74:d2:5c:f8:fa", ssid: "CorpNet", channel: "6", installed_on: "2023-08-21" }, { id: 8, site_id: 3, bssid: "02:b4:ef:5d:f7:cb", ssid: "CorpIoT", channel: "149", installed_on: "2023-09-09" }, { id: 9, site_id: 5, bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", channel: "157", installed_on: "2024-11-04" }, { id: 10, site_id: 5, bssid: "02:8e:b4:e6:a4:cd", ssid: "CorpNet", channel: "1", installed_on: "2021-11-15" }, { id: 11, site_id: 2, bssid: "02:ac:41:aa:f0:ab", ssid: "CorpGuest", channel: "157", installed_on: "2025-01-17" }, { id: 12, site_id: 1, bssid: "02:f7:b1:27:f1:87", ssid: "CorpGuest", channel: "11", installed_on: "2023-01-20" }, { id: 13, site_id: 3, bssid: "02:c4:d7:1d:76:bd", ssid: "CorpGuest", channel: "157", installed_on: "2022-10-23" }, { id: 14, site_id: 4, bssid: "02:01:0e:b0:f9:0b", ssid: "CorpIoT", channel: "36", installed_on: "2021-12-02" }, { id: 15, site_id: 3, bssid: "02:23:1b:35:d8:88", ssid: "CorpNet", channel: "149", installed_on: "2023-12-30" }, { id: 16, site_id: 3, bssid: "02:e2:ef:ec:6b:0d", ssid: "CorpGuest", channel: "36", installed_on: "2025-02-22" }, { id: 17, site_id: 1, bssid: "02:b8:61:a9:84:3a", ssid: "CorpGuest", channel: "36", installed_on: "2023-05-28" }, { id: 18, site_id: 2, bssid: "02:ce:23:df:7b:11", ssid: "CorpGuest", channel: "1", installed_on: "2024-12-23" }, { id: 19, site_id: 5, bssid: "02:f6:ec:4c:40:2c", ssid: "CorpNet", channel: "6", installed_on: "2022-02-19" }, { id: 20, site_id: 4, bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", channel: "11", installed_on: "2022-09-09" }, { id: 21, site_id: 3, bssid: "02:92:24:10:77:76", ssid: "CorpGuest", channel: "11", installed_on: "2021-10-05" }, { id: 22, site_id: 1, bssid: "02:5e:59:77:cb:a7", ssid: "CorpNet", channel: "157", installed_on: "2021-07-01" }, { id: 23, site_id: 4, bssid: "02:48:d8:25:80:00", ssid: "CorpNet", channel: "149", installed_on: "2021-09-01" }, { id: 24, site_id: 5, bssid: "02:72:22:9e:d0:30", ssid: "CorpNet", channel: "11", installed_on: "2023-07-05" }, { id: 25, site_id: 2, bssid: "02:41:45:6e:16:d3", ssid: "CorpNet", channel: "44", installed_on: "2023-05-03" }, { id: 26, site_id: 3, bssid: "02:9f:bf:27:5b:64", ssid: "CorpNet", channel: "36", installed_on: "2023-02-24" }, { id: 27, site_id: 4, bssid: "02:4a:24:5b:72:a2", ssid: "CorpGuest", channel: "149", installed_on: "2022-02-11" }, { id: 28, site_id: 4, bssid: "02:42:e2:3d:41:2b", ssid: "CorpGuest", channel: "1", installed_on: "2024-04-13" }, { id: 29, site_id: 4, bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", channel: "6", installed_on: "2023-04-21" }, { id: 30, site_id: 5, bssid: "02:74:76:1c:21:4e", ssid: "CorpNet", channel: "36", installed_on: "2023-07-16" }, { id: 31, site_id: 3, bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", channel: "11", installed_on: "2024-02-22" }, { id: 32, site_id: 1, bssid: "02:b9:4a:fa:32:43", ssid: "CorpNet", channel: "6", installed_on: "2024-11-17" }, { id: 33, site_id: 2, bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", channel: "149", installed_on: "2023-08-11" }, { id: 34, site_id: 3, bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", channel: "11", installed_on: "2023-09-03" }, { id: 35, site_id: 4, bssid: "02:5c:37:99:db:f9", ssid: "CorpNet", channel: "36", installed_on: "2022-02-28" }, { id: 36, site_id: 5, bssid: "02:e6:2c:73:2d:66", ssid: "CorpNet", channel: "44", installed_on: "2022-01-15" }, { id: 37, site_id: 3, bssid: "02:cf:0a:b8:a7:d3", ssid: "CorpGuest", channel: "6", installed_on: "2022-12-25" }, ], }); await prisma.deauth_events.createMany({ data: [ { id: 1, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:28:f5:7a:7e:d0", reason_code: "2", frame_count: 87, burst_started_at: new Date("2025-05-17T18:58:36Z"), burst_seconds: 348 }, { id: 2, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:9b:1f:35:78:1d", reason_code: "1", frame_count: 2391, burst_started_at: new Date("2025-04-04T12:09:18Z"), burst_seconds: 86 }, { id: 3, ap_id: 9, site_id: 5, spoofed_bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:a9:a4:32:f8:db", reason_code: "3", frame_count: 3751, burst_started_at: new Date("2025-04-25T11:03:24Z"), burst_seconds: 506 }, { id: 4, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 783, burst_started_at: new Date("2025-06-15T17:28:29Z"), burst_seconds: 579 }, { id: 5, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:9e:3b:f3:32:3a", reason_code: "7", frame_count: 514, burst_started_at: new Date("2025-05-21T07:34:35Z"), burst_seconds: 11 }, { id: 6, ap_id: 1, site_id: 2, spoofed_bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 61, burst_started_at: new Date("2025-05-10T12:15:06Z"), burst_seconds: 171 }, { id: 7, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:80:3e:a0:dc:fc", reason_code: "1", frame_count: 2754, burst_started_at: new Date("2025-04-21T19:11:54Z"), burst_seconds: 461 }, { id: 8, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 1158, burst_started_at: new Date("2025-04-28T20:57:57Z"), burst_seconds: 168 }, { id: 9, ap_id: 13, site_id: 3, spoofed_bssid: "02:c4:d7:1d:76:bd", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:f8:7b:0f:bb:f7", reason_code: "7", frame_count: 382, burst_started_at: new Date("2025-04-30T11:15:09Z"), burst_seconds: 309 }, { id: 10, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 2842, burst_started_at: new Date("2025-05-07T19:32:33Z"), burst_seconds: 334 }, { id: 11, ap_id: 29, site_id: 4, spoofed_bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:36:0a:6b:e8:d2", reason_code: "3", frame_count: 3182, burst_started_at: new Date("2025-06-24T10:08:39Z"), burst_seconds: 473 }, { id: 12, ap_id: 24, site_id: 5, spoofed_bssid: "02:72:22:9e:d0:30", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:7b:ca:f7:ba:23", reason_code: "7", frame_count: 1516, burst_started_at: new Date("2025-04-08T14:15:10Z"), burst_seconds: 113 }, { id: 13, ap_id: 27, site_id: 4, spoofed_bssid: "02:4a:24:5b:72:a2", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 1892, burst_started_at: new Date("2025-06-15T22:30:26Z"), burst_seconds: 450 }, { id: 14, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:07:70:6b:c9:62", reason_code: "3", frame_count: 421, burst_started_at: new Date("2025-04-28T10:15:39Z"), burst_seconds: 242 }, { id: 15, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 2354, burst_started_at: new Date("2025-04-14T13:41:28Z"), burst_seconds: 306 }, { id: 16, ap_id: 29, site_id: 4, spoofed_bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:91:89:eb:ce:28", reason_code: "3", frame_count: 40, burst_started_at: new Date("2025-05-21T17:10:43Z"), burst_seconds: 73 }, { id: 17, ap_id: 19, site_id: 5, spoofed_bssid: "02:f6:ec:4c:40:2c", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 3587, burst_started_at: new Date("2025-04-21T07:13:11Z"), burst_seconds: 12 }, { id: 18, ap_id: 24, site_id: 5, spoofed_bssid: "02:72:22:9e:d0:30", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:ed:b1:a6:68:04", reason_code: "7", frame_count: 2425, burst_started_at: new Date("2025-05-30T21:50:28Z"), burst_seconds: 178 }, { id: 19, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:1b:44:12:a7:c9", reason_code: "3", frame_count: 12, burst_started_at: new Date("2025-05-16T11:55:33Z"), burst_seconds: 17 }, { id: 20, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:11:05:80:cc:46", reason_code: "1", frame_count: 2646, burst_started_at: new Date("2025-05-30T12:10:29Z"), burst_seconds: 15 }, { id: 21, ap_id: 1, site_id: 2, spoofed_bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 246, burst_started_at: new Date("2025-06-27T22:23:46Z"), burst_seconds: 551 }, { id: 22, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:9b:e3:a2:1d:3e", reason_code: "7", frame_count: 1020, burst_started_at: new Date("2025-05-20T13:47:50Z"), burst_seconds: 5 }, { id: 23, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:94:56:9d:43:a2", reason_code: "1", frame_count: 666, burst_started_at: new Date("2025-04-20T12:30:40Z"), burst_seconds: 4 }, { id: 24, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:be:52:b6:f7:3a", reason_code: "7", frame_count: 2849, burst_started_at: new Date("2025-04-03T21:09:17Z"), burst_seconds: 148 }, { id: 25, ap_id: 25, site_id: 2, spoofed_bssid: "02:41:45:6e:16:d3", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 2014, burst_started_at: new Date("2025-05-29T09:21:19Z"), burst_seconds: 30 }, { id: 26, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:6c:e5:9e:98:90", reason_code: "3", frame_count: 487, burst_started_at: new Date("2025-05-21T06:27:05Z"), burst_seconds: 28 }, { id: 27, ap_id: 11, site_id: 2, spoofed_bssid: "02:ac:41:aa:f0:ab", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 3182, burst_started_at: new Date("2025-06-18T12:21:32Z"), burst_seconds: 107 }, { id: 28, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:ad:95:c0:a8:c2", reason_code: "2", frame_count: 862, burst_started_at: new Date("2025-04-16T16:01:45Z"), burst_seconds: 372 }, { id: 29, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 151, burst_started_at: new Date("2025-06-06T14:17:54Z"), burst_seconds: 77 }, { id: 30, ap_id: 9, site_id: 5, spoofed_bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:8d:72:50:3b:29", reason_code: "7", frame_count: 992, burst_started_at: new Date("2025-04-29T11:36:29Z"), burst_seconds: 519 }, { id: 31, ap_id: 25, site_id: 2, spoofed_bssid: "02:41:45:6e:16:d3", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:88:74:73:87:21", reason_code: "7", frame_count: 592, burst_started_at: new Date("2025-06-01T12:25:36Z"), burst_seconds: 11 }, { id: 32, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 232, burst_started_at: new Date("2025-04-04T14:21:13Z"), burst_seconds: 44 }, { id: 33, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:cb:ee:2d:41:a6", reason_code: "7", frame_count: 3211, burst_started_at: new Date("2025-05-07T10:45:27Z"), burst_seconds: 8 }, { id: 34, ap_id: 24, site_id: 5, spoofed_bssid: "02:72:22:9e:d0:30", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:72:81:9a:b9:25", reason_code: "7", frame_count: 982, burst_started_at: new Date("2025-04-20T08:00:24Z"), burst_seconds: 338 }, { id: 35, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 1435, burst_started_at: new Date("2025-04-28T09:09:28Z"), burst_seconds: 254 }, { id: 36, ap_id: 9, site_id: 5, spoofed_bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:2d:b8:46:f1:b3", reason_code: "3", frame_count: 572, burst_started_at: new Date("2025-06-23T08:34:28Z"), burst_seconds: 248 }, { id: 37, ap_id: 16, site_id: 3, spoofed_bssid: "02:e2:ef:ec:6b:0d", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:bf:57:cd:a7:37", reason_code: "7", frame_count: 190, burst_started_at: new Date("2025-05-08T12:54:11Z"), burst_seconds: 5 }, { id: 38, ap_id: 11, site_id: 2, spoofed_bssid: "02:ac:41:aa:f0:ab", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:8e:d1:15:17:60", reason_code: "2", frame_count: 1478, burst_started_at: new Date("2025-06-04T19:38:43Z"), burst_seconds: 85 }, { id: 39, ap_id: 25, site_id: 2, spoofed_bssid: "02:41:45:6e:16:d3", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:3c:bf:30:cc:49", reason_code: "3", frame_count: 3841, burst_started_at: new Date("2025-06-07T18:00:12Z"), burst_seconds: 515 }, { id: 40, ap_id: 1, site_id: 2, spoofed_bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 3233, burst_started_at: new Date("2025-06-06T15:40:10Z"), burst_seconds: 460 }, { id: 41, ap_id: 13, site_id: 3, spoofed_bssid: "02:c4:d7:1d:76:bd", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 820, burst_started_at: new Date("2025-04-05T15:38:37Z"), burst_seconds: 168 }, { id: 42, ap_id: 10, site_id: 5, spoofed_bssid: "02:8e:b4:e6:a4:cd", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:0b:2e:c8:f3:26", reason_code: "3", frame_count: 302, burst_started_at: new Date("2025-06-25T05:23:52Z"), burst_seconds: 541 }, { id: 43, ap_id: 18, site_id: 2, spoofed_bssid: "02:ce:23:df:7b:11", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:f6:45:38:1d:26", reason_code: "3", frame_count: 479, burst_started_at: new Date("2025-06-21T15:02:31Z"), burst_seconds: 34 }, { id: 44, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 2538, burst_started_at: new Date("2025-06-07T21:03:39Z"), burst_seconds: 154 }, { id: 45, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 194, burst_started_at: new Date("2025-05-26T18:09:38Z"), burst_seconds: 1 }, { id: 46, ap_id: 12, site_id: 1, spoofed_bssid: "02:f7:b1:27:f1:87", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 6, burst_started_at: new Date("2025-05-10T14:25:58Z"), burst_seconds: 3 }, { id: 47, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 323, burst_started_at: new Date("2025-04-08T13:14:20Z"), burst_seconds: 308 }, { id: 48, ap_id: 25, site_id: 2, spoofed_bssid: "02:41:45:6e:16:d3", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 2777, burst_started_at: new Date("2025-05-07T20:09:22Z"), burst_seconds: 2 }, { id: 49, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "2", frame_count: 3468, burst_started_at: new Date("2025-06-23T11:36:17Z"), burst_seconds: 154 }, { id: 50, ap_id: 5, site_id: 4, spoofed_bssid: "02:7a:62:c1:e1:66", ssid: "CorpIoT", target_scope: "single_client", target_mac: "06:f3:b9:0c:21:ee", reason_code: "3", frame_count: 3854, burst_started_at: new Date("2025-04-14T16:47:59Z"), burst_seconds: 282 }, { id: 51, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 1126, burst_started_at: new Date("2025-05-10T17:22:36Z"), burst_seconds: 581 }, { id: 52, ap_id: 29, site_id: 4, spoofed_bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:9a:45:fc:72:77", reason_code: "3", frame_count: 2395, burst_started_at: new Date("2025-06-29T19:11:51Z"), burst_seconds: 56 }, { id: 53, ap_id: 29, site_id: 4, spoofed_bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 43, burst_started_at: new Date("2025-05-29T18:43:59Z"), burst_seconds: 15 }, { id: 54, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 2058, burst_started_at: new Date("2025-06-27T15:55:01Z"), burst_seconds: 506 }, { id: 55, ap_id: 14, site_id: 4, spoofed_bssid: "02:01:0e:b0:f9:0b", ssid: "CorpIoT", target_scope: "single_client", target_mac: "06:c5:79:c6:b8:d4", reason_code: "1", frame_count: 14, burst_started_at: new Date("2025-06-04T23:37:02Z"), burst_seconds: 386 }, { id: 56, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 36, burst_started_at: new Date("2025-04-26T18:38:06Z"), burst_seconds: 48 }, { id: 57, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "2", frame_count: 2723, burst_started_at: new Date("2025-05-04T18:10:34Z"), burst_seconds: 70 }, { id: 58, ap_id: 27, site_id: 4, spoofed_bssid: "02:4a:24:5b:72:a2", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "3", frame_count: 2079, burst_started_at: new Date("2025-04-04T22:54:31Z"), burst_seconds: 4 }, { id: 59, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:36:87:d4:cf:d9", reason_code: "7", frame_count: 3425, burst_started_at: new Date("2025-05-31T13:32:31Z"), burst_seconds: 585 }, { id: 60, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:3b:c7:61:1c:b7", reason_code: "3", frame_count: 1082, burst_started_at: new Date("2025-06-18T10:56:52Z"), burst_seconds: 99 }, { id: 61, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:12:25:ae:14:64", reason_code: "2", frame_count: 365, burst_started_at: new Date("2025-06-14T12:31:17Z"), burst_seconds: 394 }, { id: 62, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 2482, burst_started_at: new Date("2025-06-13T09:07:06Z"), burst_seconds: 191 }, { id: 63, ap_id: 34, site_id: 3, spoofed_bssid: "02:9f:c7:53:63:72", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:3c:c0:1f:58:7d", reason_code: "1", frame_count: 2292, burst_started_at: new Date("2025-05-25T04:40:35Z"), burst_seconds: 141 }, { id: 64, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:93:08:3a:68:dc", reason_code: "1", frame_count: 1443, burst_started_at: new Date("2025-06-19T10:39:38Z"), burst_seconds: 82 }, { id: 65, ap_id: 36, site_id: 5, spoofed_bssid: "02:e6:2c:73:2d:66", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:32:d0:8f:b0:c7", reason_code: "3", frame_count: 221, burst_started_at: new Date("2025-04-06T22:06:18Z"), burst_seconds: 130 }, { id: 66, ap_id: 3, site_id: 5, spoofed_bssid: "02:63:a1:65:63:08", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 1816, burst_started_at: new Date("2025-05-03T13:52:00Z"), burst_seconds: 220 }, { id: 67, ap_id: 1, site_id: 2, spoofed_bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", target_scope: "single_client", target_mac: "06:f4:03:85:17:10", reason_code: "3", frame_count: 3424, burst_started_at: new Date("2025-06-26T11:29:52Z"), burst_seconds: 123 }, { id: 68, ap_id: 28, site_id: 4, spoofed_bssid: "02:42:e2:3d:41:2b", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:27:ab:37:19:61", reason_code: "3", frame_count: 44, burst_started_at: new Date("2025-05-11T20:19:24Z"), burst_seconds: 112 }, { id: 69, ap_id: 9, site_id: 5, spoofed_bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:43:3e:e5:a1:d0", reason_code: "3", frame_count: 10, burst_started_at: new Date("2025-05-13T20:47:38Z"), burst_seconds: 192 }, { id: 70, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 1747, burst_started_at: new Date("2025-06-04T12:44:39Z"), burst_seconds: 21 }, { id: 71, ap_id: 9, site_id: 5, spoofed_bssid: "02:64:8b:51:87:a8", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 1009, burst_started_at: new Date("2025-04-27T18:28:42Z"), burst_seconds: 138 }, { id: 72, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:2a:d6:7e:57:47", reason_code: "7", frame_count: 2747, burst_started_at: new Date("2025-04-26T18:22:37Z"), burst_seconds: 119 }, { id: 73, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:0e:02:70:e1:1b", reason_code: "7", frame_count: 183, burst_started_at: new Date("2025-04-13T21:22:03Z"), burst_seconds: 115 }, { id: 74, ap_id: 12, site_id: 1, spoofed_bssid: "02:f7:b1:27:f1:87", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "2", frame_count: 330, burst_started_at: new Date("2025-04-19T18:57:19Z"), burst_seconds: 11 }, { id: 75, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:ed:76:18:96:a2", reason_code: "1", frame_count: 78, burst_started_at: new Date("2025-06-14T19:00:46Z"), burst_seconds: 2 }, { id: 76, ap_id: 31, site_id: 3, spoofed_bssid: "02:5f:89:26:f7:8d", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:b6:3b:cf:3a:b7", reason_code: "1", frame_count: 2244, burst_started_at: new Date("2025-06-13T10:40:24Z"), burst_seconds: 5 }, { id: 77, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:7f:2d:f6:74:59", reason_code: "7", frame_count: 1336, burst_started_at: new Date("2025-05-03T20:28:20Z"), burst_seconds: 551 }, { id: 78, ap_id: 28, site_id: 4, spoofed_bssid: "02:42:e2:3d:41:2b", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 197, burst_started_at: new Date("2025-04-06T09:56:22Z"), burst_seconds: 9 }, { id: 79, ap_id: 29, site_id: 4, spoofed_bssid: "02:b1:87:c9:18:93", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:52:11:b2:b5:ca", reason_code: "7", frame_count: 1337, burst_started_at: new Date("2025-05-29T17:30:29Z"), burst_seconds: 1 }, { id: 80, ap_id: 28, site_id: 4, spoofed_bssid: "02:42:e2:3d:41:2b", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:57:63:d4:a6:17", reason_code: "7", frame_count: 727, burst_started_at: new Date("2025-05-01T15:11:34Z"), burst_seconds: 68 }, { id: 81, ap_id: 20, site_id: 4, spoofed_bssid: "02:39:f7:ae:65:5f", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:cd:b4:f0:6f:6e", reason_code: "3", frame_count: 3470, burst_started_at: new Date("2025-04-17T16:04:56Z"), burst_seconds: 48 }, { id: 82, ap_id: 11, site_id: 2, spoofed_bssid: "02:ac:41:aa:f0:ab", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 1288, burst_started_at: new Date("2025-04-03T04:19:34Z"), burst_seconds: 275 }, { id: 83, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:87:22:9a:66:a7", reason_code: "2", frame_count: 284, burst_started_at: new Date("2025-05-21T07:34:50Z"), burst_seconds: 54 }, { id: 84, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 52, burst_started_at: new Date("2025-06-05T17:17:41Z"), burst_seconds: 101 }, { id: 85, ap_id: 14, site_id: 4, spoofed_bssid: "02:01:0e:b0:f9:0b", ssid: "CorpIoT", target_scope: "single_client", target_mac: "06:a7:97:40:a4:94", reason_code: "7", frame_count: 3646, burst_started_at: new Date("2025-06-04T21:07:37Z"), burst_seconds: 28 }, { id: 86, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:98:bc:ba:65:c9", reason_code: "1", frame_count: 548, burst_started_at: new Date("2025-06-12T08:20:27Z"), burst_seconds: 586 }, { id: 87, ap_id: 18, site_id: 2, spoofed_bssid: "02:ce:23:df:7b:11", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:86:32:45:9c:53", reason_code: "3", frame_count: 1495, burst_started_at: new Date("2025-06-04T17:13:58Z"), burst_seconds: 177 }, { id: 88, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 3975, burst_started_at: new Date("2025-05-03T17:41:20Z"), burst_seconds: 196 }, { id: 89, ap_id: 33, site_id: 2, spoofed_bssid: "02:40:b8:d7:0e:52", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:6b:cb:43:ac:7d", reason_code: "7", frame_count: 77, burst_started_at: new Date("2025-06-12T16:28:08Z"), burst_seconds: 523 }, { id: 90, ap_id: 6, site_id: 5, spoofed_bssid: "02:c6:67:c5:9e:91", ssid: "CorpNet", target_scope: "single_client", target_mac: "06:17:dd:2a:65:2d", reason_code: "7", frame_count: 1555, burst_started_at: new Date("2025-04-28T09:10:29Z"), burst_seconds: 4 }, { id: 91, ap_id: 1, site_id: 2, spoofed_bssid: "02:ef:d6:2e:ee:85", ssid: "CorpIoT", target_scope: "broadcast", target_mac: null, reason_code: "1", frame_count: 1628, burst_started_at: new Date("2025-06-29T12:54:43Z"), burst_seconds: 407 }, { id: 92, ap_id: 5, site_id: 4, spoofed_bssid: "02:7a:62:c1:e1:66", ssid: "CorpIoT", target_scope: "single_client", target_mac: "06:b8:f7:9a:da:76", reason_code: "3", frame_count: 3121, burst_started_at: new Date("2025-04-13T11:02:23Z"), burst_seconds: 394 }, { id: 93, ap_id: 27, site_id: 4, spoofed_bssid: "02:4a:24:5b:72:a2", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:39:e0:99:0c:2e", reason_code: "1", frame_count: 402, burst_started_at: new Date("2025-06-21T20:25:32Z"), burst_seconds: 366 }, { id: 94, ap_id: 11, site_id: 2, spoofed_bssid: "02:ac:41:aa:f0:ab", ssid: "CorpGuest", target_scope: "single_client", target_mac: "06:b1:c8:a7:a6:0b", reason_code: "3", frame_count: 180, burst_started_at: new Date("2025-05-07T02:23:21Z"), burst_seconds: 27 }, { id: 95, ap_id: 12, site_id: 1, spoofed_bssid: "02:f7:b1:27:f1:87", ssid: "CorpGuest", target_scope: "broadcast", target_mac: null, reason_code: "7", frame_count: 2391, burst_started_at: new Date("2025-05-23T20:22:17Z"), burst_seconds: 59 }, ], }); await prisma.sensors.createMany({ data: [ { id: 1, site_id: 3, sensor_code: "WIDS-092", radio: "dual_band", installed_on: "2023-12-10" }, { id: 2, site_id: 1, sensor_code: "WIDS-919", radio: "tri_band", installed_on: "2024-10-18" }, { id: 3, site_id: 2, sensor_code: "WIDS-386", radio: "tri_band", installed_on: "2024-01-03" }, { id: 4, site_id: 1, sensor_code: "WIDS-211", radio: "dual_band", installed_on: "2023-08-26" }, { id: 5, site_id: 2, sensor_code: "WIDS-226", radio: "dual_band", installed_on: "2023-08-09" }, { id: 6, site_id: 4, sensor_code: "WIDS-184", radio: "dual_band", installed_on: "2023-10-09" }, { id: 7, site_id: 3, sensor_code: "WIDS-650", radio: "dual_band", installed_on: "2023-08-24" }, { id: 8, site_id: 5, sensor_code: "WIDS-589", radio: "dual_band", installed_on: "2023-11-21" }, { id: 9, site_id: 2, sensor_code: "WIDS-626", radio: "dual_band", installed_on: "2023-05-25" }, { id: 10, site_id: 3, sensor_code: "WIDS-477", radio: "dual_band", installed_on: "2024-12-22" }, { id: 11, site_id: 4, sensor_code: "WIDS-377", radio: "tri_band", installed_on: "2023-04-29" }, { id: 12, site_id: 1, sensor_code: "WIDS-115", radio: "dual_band", installed_on: "2023-10-30" }, { id: 13, site_id: 3, sensor_code: "WIDS-791", radio: "dual_band", installed_on: "2023-05-30" }, { id: 14, site_id: 2, sensor_code: "WIDS-511", radio: "tri_band", installed_on: "2024-03-26" }, { id: 15, site_id: 3, sensor_code: "WIDS-399", radio: "dual_band", installed_on: "2024-09-30" }, { id: 16, site_id: 5, sensor_code: "WIDS-611", radio: "tri_band", installed_on: "2024-04-06" }, { id: 17, site_id: 2, sensor_code: "WIDS-854", radio: "tri_band", installed_on: "2024-06-23" }, ], }); await prisma.rogue_detections.createMany({ data: [ { id: 1, sensor_id: 14, site_id: 2, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:3c:4b:3c:31:f8", channel: "157", rssi_dbm: -64, detected_at: new Date("2025-06-23T13:07:20Z"), status: "dismissed", resolved_at: new Date("2025-06-25T04:10:40Z") }, { id: 2, sensor_id: 13, site_id: 3, rogue_profile_id: 2, ssid: "CorpGuest", classification: "evil_twin", security: "open", bssid: "0a:03:5d:0a:87:74", channel: "44", rssi_dbm: -53, detected_at: new Date("2025-05-09T11:16:49Z"), status: "dismissed", resolved_at: new Date("2025-05-10T16:41:50Z") }, { id: 3, sensor_id: 10, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:c8:3f:a5:b4:32", channel: "1", rssi_dbm: -83, detected_at: new Date("2025-06-02T10:14:38Z"), status: "dismissed", resolved_at: new Date("2025-06-07T02:05:01Z") }, { id: 4, sensor_id: 10, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:79:44:4b:07:ac", channel: "149", rssi_dbm: -68, detected_at: new Date("2025-05-23T11:44:39Z"), status: "contained", resolved_at: new Date("2025-05-26T22:45:46Z") }, { id: 5, sensor_id: 15, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:b5:00:85:03:03", channel: "149", rssi_dbm: -65, detected_at: new Date("2025-05-08T15:26:25Z"), status: "contained", resolved_at: new Date("2025-05-09T23:57:29Z") }, { id: 6, sensor_id: 10, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:1e:19:4b:85:d0", channel: "6", rssi_dbm: -37, detected_at: new Date("2025-06-23T13:07:02Z"), status: "dismissed", resolved_at: new Date("2025-06-26T07:51:36Z") }, { id: 7, sensor_id: 17, site_id: 2, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:a2:2b:8f:47:49", channel: "11", rssi_dbm: -80, detected_at: new Date("2025-06-22T12:19:02Z"), status: "open", resolved_at: null }, { id: 8, sensor_id: 1, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:23:9d:f0:92:be", channel: "36", rssi_dbm: -37, detected_at: new Date("2025-06-16T10:52:46Z"), status: "open", resolved_at: null }, { id: 9, sensor_id: 15, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:01:8d:17:a6:28", channel: "36", rssi_dbm: -80, detected_at: new Date("2025-06-22T18:41:41Z"), status: "open", resolved_at: null }, { id: 10, sensor_id: 7, site_id: 3, rogue_profile_id: 2, ssid: "CorpGuest", classification: "evil_twin", security: "open", bssid: "0a:0b:78:eb:dc:7b", channel: "1", rssi_dbm: -50, detected_at: new Date("2025-04-08T17:18:08Z"), status: "open", resolved_at: null }, { id: 11, sensor_id: 13, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:cd:b4:9d:9c:a9", channel: "6", rssi_dbm: -82, detected_at: new Date("2025-06-15T20:44:07Z"), status: "dismissed", resolved_at: new Date("2025-06-16T00:30:48Z") }, { id: 12, sensor_id: 2, site_id: 1, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:cc:fb:ad:bd:bf", channel: "11", rssi_dbm: -45, detected_at: new Date("2025-04-13T19:32:53Z"), status: "contained", resolved_at: new Date("2025-04-16T14:53:07Z") }, { id: 13, sensor_id: 10, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:ca:3c:45:44:92", channel: "36", rssi_dbm: -84, detected_at: new Date("2025-05-16T16:41:17Z"), status: "open", resolved_at: null }, { id: 14, sensor_id: 10, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:6d:d4:49:59:12", channel: "149", rssi_dbm: -81, detected_at: new Date("2025-05-15T16:02:15Z"), status: "open", resolved_at: null }, { id: 15, sensor_id: 13, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:e0:33:21:67:f1", channel: "6", rssi_dbm: -68, detected_at: new Date("2025-05-03T11:09:28Z"), status: "dismissed", resolved_at: new Date("2025-05-04T20:15:06Z") }, { id: 16, sensor_id: 7, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:d1:4e:30:3c:ec", channel: "1", rssi_dbm: -85, detected_at: new Date("2025-05-20T00:56:53Z"), status: "dismissed", resolved_at: new Date("2025-05-23T13:38:48Z") }, { id: 17, sensor_id: 3, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:26:33:c6:0d:ee", channel: "157", rssi_dbm: -55, detected_at: new Date("2025-04-15T14:05:23Z"), status: "dismissed", resolved_at: new Date("2025-04-19T18:31:18Z") }, { id: 18, sensor_id: 14, site_id: 2, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:96:43:fc:e3:28", channel: "44", rssi_dbm: -52, detected_at: new Date("2025-05-02T09:51:27Z"), status: "dismissed", resolved_at: new Date("2025-05-07T02:08:53Z") }, { id: 19, sensor_id: 12, site_id: 1, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:1e:7f:c3:79:69", channel: "157", rssi_dbm: -82, detected_at: new Date("2025-04-28T17:24:35Z"), status: "open", resolved_at: null }, { id: 20, sensor_id: 17, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:4f:bc:92:ca:1f", channel: "11", rssi_dbm: -91, detected_at: new Date("2025-04-06T17:16:40Z"), status: "dismissed", resolved_at: new Date("2025-04-11T11:03:58Z") }, { id: 21, sensor_id: 2, site_id: 1, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:73:20:fd:5e:11", channel: "149", rssi_dbm: -39, detected_at: new Date("2025-04-04T13:34:26Z"), status: "dismissed", resolved_at: new Date("2025-04-09T03:23:02Z") }, { id: 22, sensor_id: 6, site_id: 4, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:bc:06:7b:cf:c1", channel: "44", rssi_dbm: -35, detected_at: new Date("2025-04-18T15:46:46Z"), status: "open", resolved_at: null }, { id: 23, sensor_id: 13, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:ff:52:b9:ba:41", channel: "1", rssi_dbm: -74, detected_at: new Date("2025-06-14T09:27:25Z"), status: "dismissed", resolved_at: new Date("2025-06-17T07:38:55Z") }, { id: 24, sensor_id: 7, site_id: 3, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:e0:41:e8:23:8b", channel: "36", rssi_dbm: -53, detected_at: new Date("2025-04-15T16:57:33Z"), status: "dismissed", resolved_at: new Date("2025-04-16T07:43:25Z") }, { id: 25, sensor_id: 10, site_id: 3, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:0c:a2:c2:fc:9f", channel: "11", rssi_dbm: -42, detected_at: new Date("2025-06-11T19:59:33Z"), status: "dismissed", resolved_at: new Date("2025-06-13T13:23:52Z") }, { id: 26, sensor_id: 3, site_id: 2, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:40:52:ed:35:11", channel: "11", rssi_dbm: -41, detected_at: new Date("2025-05-02T15:54:37Z"), status: "contained", resolved_at: new Date("2025-05-04T20:16:47Z") }, { id: 27, sensor_id: 16, site_id: 5, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:57:bb:cb:3c:bd", channel: "6", rssi_dbm: -50, detected_at: new Date("2025-04-11T08:25:20Z"), status: "dismissed", resolved_at: new Date("2025-04-15T16:21:40Z") }, { id: 28, sensor_id: 13, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:4d:9f:4e:76:58", channel: "157", rssi_dbm: -90, detected_at: new Date("2025-05-17T13:10:51Z"), status: "dismissed", resolved_at: new Date("2025-05-22T04:54:46Z") }, { id: 29, sensor_id: 11, site_id: 4, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:2c:89:e5:99:65", channel: "44", rssi_dbm: -38, detected_at: new Date("2025-04-02T01:54:04Z"), status: "contained", resolved_at: new Date("2025-04-04T23:34:11Z") }, { id: 30, sensor_id: 14, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:a0:8b:3f:40:53", channel: "1", rssi_dbm: -88, detected_at: new Date("2025-04-15T11:19:34Z"), status: "contained", resolved_at: new Date("2025-04-15T15:48:32Z") }, { id: 31, sensor_id: 14, site_id: 2, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:5a:53:4c:27:c7", channel: "6", rssi_dbm: -56, detected_at: new Date("2025-06-05T20:19:03Z"), status: "dismissed", resolved_at: new Date("2025-06-07T00:15:33Z") }, { id: 32, sensor_id: 8, site_id: 5, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:4d:ab:98:cc:8f", channel: "157", rssi_dbm: -79, detected_at: new Date("2025-06-03T09:03:47Z"), status: "dismissed", resolved_at: new Date("2025-06-04T01:11:23Z") }, { id: 33, sensor_id: 12, site_id: 1, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:5b:d1:84:35:bd", channel: "1", rssi_dbm: -59, detected_at: new Date("2025-04-14T19:46:54Z"), status: "open", resolved_at: null }, { id: 34, sensor_id: 15, site_id: 3, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:43:a0:72:7d:2f", channel: "44", rssi_dbm: -42, detected_at: new Date("2025-04-21T23:32:58Z"), status: "contained", resolved_at: new Date("2025-04-24T15:29:49Z") }, { id: 35, sensor_id: 2, site_id: 1, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:e8:d0:e1:ad:e5", channel: "149", rssi_dbm: -87, detected_at: new Date("2025-05-25T12:03:44Z"), status: "dismissed", resolved_at: new Date("2025-05-26T11:37:23Z") }, { id: 36, sensor_id: 14, site_id: 2, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:94:c0:60:3e:89", channel: "1", rssi_dbm: -54, detected_at: new Date("2025-06-24T20:10:54Z"), status: "open", resolved_at: null }, { id: 37, sensor_id: 8, site_id: 5, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:ea:a4:de:57:c3", channel: "1", rssi_dbm: -42, detected_at: new Date("2025-06-12T14:56:20Z"), status: "contained", resolved_at: new Date("2025-06-16T07:55:06Z") }, { id: 38, sensor_id: 8, site_id: 5, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:88:e7:32:99:7e", channel: "149", rssi_dbm: -85, detected_at: new Date("2025-06-11T16:23:43Z"), status: "dismissed", resolved_at: new Date("2025-06-15T06:36:07Z") }, { id: 39, sensor_id: 2, site_id: 1, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:f8:3b:60:fa:e4", channel: "36", rssi_dbm: -57, detected_at: new Date("2025-04-15T12:56:35Z"), status: "contained", resolved_at: new Date("2025-04-20T09:06:09Z") }, { id: 40, sensor_id: 13, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:29:58:41:f8:ea", channel: "1", rssi_dbm: -49, detected_at: new Date("2025-06-02T01:34:44Z"), status: "dismissed", resolved_at: new Date("2025-06-02T17:35:42Z") }, { id: 41, sensor_id: 10, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:22:b0:d6:17:0f", channel: "11", rssi_dbm: -70, detected_at: new Date("2025-06-26T10:25:53Z"), status: "dismissed", resolved_at: new Date("2025-06-30T11:16:03Z") }, { id: 42, sensor_id: 13, site_id: 3, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:c3:3a:81:f9:cc", channel: "44", rssi_dbm: -82, detected_at: new Date("2025-05-13T21:39:47Z"), status: "contained", resolved_at: new Date("2025-05-16T10:42:28Z") }, { id: 43, sensor_id: 13, site_id: 3, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:05:d0:bb:92:db", channel: "6", rssi_dbm: -83, detected_at: new Date("2025-05-28T13:17:34Z"), status: "dismissed", resolved_at: new Date("2025-05-30T06:27:17Z") }, { id: 44, sensor_id: 7, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:c4:cd:19:75:02", channel: "149", rssi_dbm: -39, detected_at: new Date("2025-06-03T17:16:43Z"), status: "contained", resolved_at: new Date("2025-06-07T07:16:43Z") }, { id: 45, sensor_id: 5, site_id: 2, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:65:42:a7:81:0e", channel: "11", rssi_dbm: -87, detected_at: new Date("2025-04-20T12:35:41Z"), status: "dismissed", resolved_at: new Date("2025-04-23T18:53:18Z") }, { id: 46, sensor_id: 2, site_id: 1, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:55:b2:28:d0:d2", channel: "6", rssi_dbm: -41, detected_at: new Date("2025-04-21T16:15:59Z"), status: "contained", resolved_at: new Date("2025-04-25T00:40:14Z") }, { id: 47, sensor_id: 15, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:5f:42:1a:dd:24", channel: "1", rssi_dbm: -80, detected_at: new Date("2025-06-18T22:16:17Z"), status: "dismissed", resolved_at: new Date("2025-06-20T04:32:05Z") }, { id: 48, sensor_id: 17, site_id: 2, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:8e:70:ff:67:bb", channel: "36", rssi_dbm: -43, detected_at: new Date("2025-06-27T21:41:40Z"), status: "dismissed", resolved_at: new Date("2025-06-29T10:04:00Z") }, { id: 49, sensor_id: 17, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:c5:3a:83:86:32", channel: "1", rssi_dbm: -55, detected_at: new Date("2025-06-05T16:32:49Z"), status: "dismissed", resolved_at: new Date("2025-06-07T07:55:14Z") }, { id: 50, sensor_id: 9, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:a6:b0:65:0e:7e", channel: "36", rssi_dbm: -85, detected_at: new Date("2025-06-16T14:07:08Z"), status: "open", resolved_at: null }, { id: 51, sensor_id: 7, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:ff:68:8c:9d:74", channel: "1", rssi_dbm: -51, detected_at: new Date("2025-05-01T20:59:18Z"), status: "contained", resolved_at: new Date("2025-05-05T19:26:24Z") }, { id: 52, sensor_id: 7, site_id: 3, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:5e:1e:ee:0d:15", channel: "1", rssi_dbm: -87, detected_at: new Date("2025-06-27T22:10:53Z"), status: "contained", resolved_at: new Date("2025-07-02T06:21:00Z") }, { id: 53, sensor_id: 10, site_id: 3, rogue_profile_id: 2, ssid: "CorpGuest", classification: "evil_twin", security: "open", bssid: "0a:ef:b9:8a:18:98", channel: "11", rssi_dbm: -54, detected_at: new Date("2025-05-04T11:10:11Z"), status: "dismissed", resolved_at: new Date("2025-05-08T09:26:12Z") }, { id: 54, sensor_id: 4, site_id: 1, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:c9:fb:34:28:1a", channel: "6", rssi_dbm: -46, detected_at: new Date("2025-05-22T17:32:11Z"), status: "dismissed", resolved_at: new Date("2025-05-26T14:31:43Z") }, { id: 55, sensor_id: 7, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:32:63:65:43:61", channel: "1", rssi_dbm: -79, detected_at: new Date("2025-05-30T08:24:13Z"), status: "dismissed", resolved_at: new Date("2025-05-31T00:20:26Z") }, { id: 56, sensor_id: 8, site_id: 5, rogue_profile_id: 4, ssid: "Free_Airport_WiFi", classification: "open_lure", security: "open", bssid: "0a:3e:6b:10:92:40", channel: "36", rssi_dbm: -84, detected_at: new Date("2025-04-03T21:14:45Z"), status: "open", resolved_at: null }, { id: 57, sensor_id: 6, site_id: 4, rogue_profile_id: 1, ssid: "CorpNet", classification: "evil_twin", security: "wpa2_personal", bssid: "0a:c4:ee:d3:b9:92", channel: "36", rssi_dbm: -41, detected_at: new Date("2025-04-10T17:17:39Z"), status: "dismissed", resolved_at: new Date("2025-04-14T17:02:00Z") }, { id: 58, sensor_id: 17, site_id: 2, rogue_profile_id: 2, ssid: "CorpGuest", classification: "evil_twin", security: "open", bssid: "0a:28:8a:76:2e:90", channel: "36", rssi_dbm: -78, detected_at: new Date("2025-06-03T17:37:44Z"), status: "contained", resolved_at: new Date("2025-06-06T16:26:25Z") }, { id: 59, sensor_id: 7, site_id: 3, rogue_profile_id: 6, ssid: "Pixel_7731", classification: "personal_hotspot", security: "wpa3_personal", bssid: "0a:0e:39:24:27:74", channel: "11", rssi_dbm: -59, detected_at: new Date("2025-04-08T18:26:26Z"), status: "dismissed", resolved_at: new Date("2025-04-12T05:12:13Z") }, { id: 60, sensor_id: 14, site_id: 2, rogue_profile_id: 5, ssid: "PRINTER-4B21", classification: "neighbour_device", security: "wpa2_personal", bssid: "0a:f1:96:b1:2b:7c", channel: "149", rssi_dbm: -82, detected_at: new Date("2025-04-21T16:54:42Z"), status: "dismissed", resolved_at: new Date("2025-04-24T08:55:21Z") }, { id: 61, sensor_id: 14, site_id: 2, rogue_profile_id: 3, ssid: "CorpNet-5G", classification: "lookalike", security: "wpa2_personal", bssid: "0a:3e:6e:1d:da:60", channel: "6", rssi_dbm: -60, detected_at: new Date("2025-06-30T22:35:30Z"), status: "dismissed", resolved_at: new Date("2025-07-05T00:14:53Z") }, ], }); } main() .then(() => prisma.$disconnect()) .catch(async error => { console.error(error); await prisma.$disconnect(); process.exit(1); });