diff options
| author | tanghao <[email protected]> | 2024-11-21 17:18:57 +0800 |
|---|---|---|
| committer | tanghao <[email protected]> | 2024-11-21 17:18:57 +0800 |
| commit | 9d15b6e5caf6d2ee7497b77497ad2bcbaab2c9cb (patch) | |
| tree | f4c87c5ffff6e04c574159726b5b669b5d5cd6de | |
| parent | 2a9f0fd6eb2df2a16599fe47380c0351dd6be189 (diff) | |
fix: 更新sources profiles配置key名称
4 files changed, 8 insertions, 8 deletions
diff --git a/cn-admin/src/main/java/net/geedge/common/utils/Constant.java b/cn-admin/src/main/java/net/geedge/common/utils/Constant.java index 69a6ecd..2cf55d2 100644 --- a/cn-admin/src/main/java/net/geedge/common/utils/Constant.java +++ b/cn-admin/src/main/java/net/geedge/common/utils/Constant.java @@ -365,8 +365,8 @@ public class Constant { public static final String SOURCE_NAME = "UDF"; public static final String SOURCE_ID = "35c19f09-2a2c-44f4-bca1-fe0cd0c447cb"; - public static final String ENTITY_SOURCES_DATAID ="sources.json"; - public static final String ENTITY_PROFILES_DATAID ="entity_profiles.json"; + public static final String ENTITY_SOURCES_DATAID ="data_sources.json"; + public static final String ENTITY_PROFILES_DATAID ="entity_integrations.json"; public static final String NACOS_ENTITY_CONFIG_GROUP = "DEFAULT_GROUP"; public static final String ENTITY_SOURCES_UPLOAD_STATUS = "entity_sources_upload_status"; public static final String ENTITY_PROFILES_UPLOAD_STATUS = "entity_profiles_upload_status"; diff --git a/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntityProfilesServiceImpl.java b/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntityProfilesServiceImpl.java index d5b7c0b..29cb43e 100644 --- a/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntityProfilesServiceImpl.java +++ b/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntityProfilesServiceImpl.java @@ -109,7 +109,7 @@ public class EntityProfilesServiceImpl extends ServiceImpl<EntityProfilesDao, En map.put("update_time",profile.getUtime()); profilesList.add(map); } - profileMap.put("entity_profiles",profilesList); + profileMap.put("entity_integrations",profilesList); return profileMap; } diff --git a/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntitySourcesServiceImpl.java b/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntitySourcesServiceImpl.java index 7a4cc62..1a7b50b 100644 --- a/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntitySourcesServiceImpl.java +++ b/cn-admin/src/main/java/net/geedge/modules/entity/service/impl/EntitySourcesServiceImpl.java @@ -137,7 +137,7 @@ public class EntitySourcesServiceImpl extends ServiceImpl<EntitySourcesDao, Enti map.put("update_time",source.getUtime()); sourcesList.add(map); } - sourceMap.put("entity_sources",sourcesList); + sourceMap.put("data_sources",sourcesList); return sourceMap; } diff --git a/cn-admin/src/main/resources/db/R__AZ_entity_config.sql b/cn-admin/src/main/resources/db/R__AZ_entity_config.sql index 0de0d86..da901d0 100644 --- a/cn-admin/src/main/resources/db/R__AZ_entity_config.sql +++ b/cn-admin/src/main/resources/db/R__AZ_entity_config.sql @@ -1,12 +1,12 @@ /* entity sources 内置数据 */ -INSERT INTO `entity_profiles` VALUES (1, 1, '[{\"index\":1,\"type\":\"ip\",\"name\":\"IP\",\"list\":[{\"entityField\":\"ip\",\"sourceField\":\"server_ip\"},{\"entityField\":\"ports\",\"sourceField\":\"server_port\"},{\"entityField\":\"ip_country\",\"sourceField\":\"server_ip_country\"},{\"entityField\":\"ip_super_admin_area\",\"sourceField\":\"server_ip_province\"},{\"entityField\":\"ip_admin_area\",\"sourceField\":\"server_ip_city\"},{\"entityField\":\"ip_asn\",\"sourceField\":\"server_ip_asn\"},{\"entityField\":\"ip_isp\",\"sourceField\":\"server_ip_isp\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"ip\":\"server_ip\",\"ports\":\"server_port\",\"ip_country\":\"server_ip_country\",\"ip_super_admin_area\":\"server_ip_province\",\"ip_admin_area\":\"server_ip_city\",\"ip_asn\":\"server_ip_asn\",\"ip_isp\":\"server_ip_isp\",\"seen_time\":\"recv_time\"},\"disabled\":false},{\"index\":2,\"type\":\"domain\",\"name\":\"Domain\",\"list\":[{\"entityField\":\"domain\",\"sourceField\":\"server_fqdn\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"domain\":\"server_fqdn\",\"seen_time\":\"recv_time\"},\"disabled\":false},{\"index\":3,\"type\":\"app\",\"name\":\"APP\",\"list\":[{\"entityField\":\"app\",\"sourceField\":\"app\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"app\":\"app\",\"seen_time\":\"recv_time\"},\"disabled\":false}]', '[{\"from_entity_index\":2,\"to_entity_index\":1,\"type\":\"RESOLVE_DOMAIN_IP\",\"fromDisabled\":true,\"toDisabled\":true},{\"from_entity_index\":3,\"to_entity_index\":1,\"type\":\"CARRY_APP_IP\",\"fromDisabled\":true,\"toDisabled\":true},{\"from_entity_index\":3,\"to_entity_index\":2,\"type\":\"CARRY_APP_DOMAIN\",\"fromDisabled\":true,\"toDisabled\":true}]', '2024-11-20 03:37:27', '2024-11-20 06:31:11', 1, 1); -INSERT INTO `entity_profiles` VALUES (2, 2, '[{\"index\":1,\"type\":\"subscriber\",\"name\":\"Subscriber\",\"list\":[{\"entityField\":\"subscriber_id\",\"sourceField\":\"subscriber_id\"},{\"entityField\":\"subscriber_imsi\",\"sourceField\":\"imsi\"},{\"entityField\":\"subscriber_imei\",\"sourceField\":\"imei\"},{\"entityField\":\"subscriber_apns\",\"sourceField\":\"apn\"},{\"entityField\":\"seen_time\",\"sourceField\":\"ingestion_time\"}],\"mapping\":{\"subscriber_id\":\"subscriber_id\",\"subscriber_imsi\":\"imsi\",\"subscriber_imei\":\"imei\",\"subscriber_apns\":\"apn\",\"seen_time\":\"ingestion_time\"}}]', '[]', '2024-11-20 06:29:34', '2024-11-20 08:10:07', 1, 1); +INSERT INTO `entity_sources` VALUES (1, 'SESSION-RECORD', 'json', '[{\"name\":\"recv_time\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"log_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"flags\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"start_timestamp_ms\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"end_timestamp_ms\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"duration_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"decoded_as\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"client_ip\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"server_ip\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"client_port\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"server_port\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"app\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"app_transition\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"decoded_path\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ip_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"l7_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"out_link_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"in_link_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"subscriber_id\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imsi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"phone_number\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"apn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_host\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_url\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_response_line\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_status_code\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"ssl_sni\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_san\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_ja3_hash\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_ja3s_hash\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_cert_issuer\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_cert_subject\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"dns_qr\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_opcode\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_aa\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_rcode\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_qname\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"dns_qtype\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_qclass\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_sub\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_rr\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"sent_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"sent_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"received_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"received_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_lost_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_lost_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_o3_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_o3_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_rtx_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_rtx_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_rtx_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_rtx_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_rtt_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"http_response_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"ssl_handshake_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_response_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"server_fqdn\",\"type\":\"string\",\"default\":\"\"}]', '[{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"COUNTRY\",\"output_field\":\"server_ip_country\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"PROVINCE\",\"output_field\":\"server_ip_province\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"CITY\",\"output_field\":\"server_ip_city\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"ISP\",\"output_field\":\"server_ip_isp\"},{\"function\":\"ASN_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"ASN\",\"output_field\":\"server_ip_asn\"}]', '', '2024-11-20 03:35:05', '2024-11-20 03:35:05', 1, 0); +INSERT INTO `entity_sources` VALUES (2, 'SUBSCRIBER-LOCATION-MAPPING ', 'json', '[{\"name\":\"source_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"message_type\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"procedure_code\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"subscriber_id\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imsi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"msisdn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"mei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imeisv\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"apn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"tai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"lai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"rai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"sai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"uli_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"uli_tai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"gci_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"last_visited_gci_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ingestion_time\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"generate_time\",\"type\":\"long\",\"default\":\"\"}]', '[]', '', '2024-11-20 06:26:04', '2024-11-20 06:26:04', 1, 0); /* entity profiles 内置数据 */ -INSERT INTO `entity_sources` VALUES (1, 'SESSION-RECORD', 'json', '[{\"name\":\"recv_time\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"log_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"flags\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"start_timestamp_ms\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"end_timestamp_ms\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"duration_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"decoded_as\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"client_ip\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"server_ip\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"client_port\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"server_port\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"app\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"app_transition\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"decoded_path\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ip_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"l7_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"out_link_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"in_link_id\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"subscriber_id\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imsi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"phone_number\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"apn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_host\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_url\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_response_line\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"http_status_code\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"ssl_sni\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_san\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_ja3_hash\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_ja3s_hash\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_cert_issuer\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ssl_cert_subject\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"dns_qr\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_opcode\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_aa\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_rcode\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_qname\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"dns_qtype\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_qclass\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_sub\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_rr\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"sent_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"sent_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"received_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"received_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_lost_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_lost_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_o3_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_o3_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_rtx_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_rtx_bytes\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_c2s_rtx_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_s2c_rtx_pkts\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"tcp_rtt_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"http_response_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"ssl_handshake_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"dns_response_latency_ms\",\"type\":\"int\",\"default\":\"\"},{\"name\":\"server_fqdn\",\"type\":\"string\",\"default\":\"\"}]', '[{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"COUNTRY\",\"output_field\":\"server_ip_country\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"PROVINCE\",\"output_field\":\"server_ip_province\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"CITY\",\"output_field\":\"server_ip_city\"},{\"function\":\"GEOIP_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"ISP\",\"output_field\":\"server_ip_isp\"},{\"function\":\"ASN_LOOKUP\",\"lookup_field\":\"server_ip\",\"output_type\":\"ASN\",\"output_field\":\"server_ip_asn\"}]', '', '2024-11-20 03:35:05', '2024-11-20 03:35:05', 1, 1); -INSERT INTO `entity_sources` VALUES (2, 'SUBSCRIBER-LOCATION-MAPPING ', 'json', '[{\"name\":\"source_protocol\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"message_type\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"procedure_code\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"subscriber_id\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imsi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"msisdn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"mei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imei\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"imeisv\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"apn\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"tai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"lai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"rai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"sai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"uli_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"uli_tai\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"gci_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"last_visited_gci_e_cgi\",\"type\":\"string\",\"default\":\"\"},{\"name\":\"ingestion_time\",\"type\":\"long\",\"default\":\"\"},{\"name\":\"generate_time\",\"type\":\"long\",\"default\":\"\"}]', '[]', '', '2024-11-20 06:26:04', '2024-11-20 06:26:04', 1, 1); +INSERT INTO `entity_profiles` VALUES (1, 1, '[{\"index\":1,\"type\":\"ip\",\"name\":\"IP\",\"list\":[{\"entityField\":\"ip\",\"sourceField\":\"server_ip\"},{\"entityField\":\"ports\",\"sourceField\":\"server_port\"},{\"entityField\":\"ip_country\",\"sourceField\":\"server_ip_country\"},{\"entityField\":\"ip_super_admin_area\",\"sourceField\":\"server_ip_province\"},{\"entityField\":\"ip_admin_area\",\"sourceField\":\"server_ip_city\"},{\"entityField\":\"ip_asn\",\"sourceField\":\"server_ip_asn\"},{\"entityField\":\"ip_isp\",\"sourceField\":\"server_ip_isp\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"ip\":\"server_ip\",\"ports\":\"server_port\",\"ip_country\":\"server_ip_country\",\"ip_super_admin_area\":\"server_ip_province\",\"ip_admin_area\":\"server_ip_city\",\"ip_asn\":\"server_ip_asn\",\"ip_isp\":\"server_ip_isp\",\"seen_time\":\"recv_time\"},\"disabled\":false},{\"index\":2,\"type\":\"domain\",\"name\":\"Domain\",\"list\":[{\"entityField\":\"domain\",\"sourceField\":\"server_fqdn\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"domain\":\"server_fqdn\",\"seen_time\":\"recv_time\"},\"disabled\":false},{\"index\":3,\"type\":\"app\",\"name\":\"APP\",\"list\":[{\"entityField\":\"app\",\"sourceField\":\"app\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"app\":\"app\",\"seen_time\":\"recv_time\"},\"disabled\":false},{\"index\":4,\"type\":\"subscriber\",\"name\":\"Subscriber\",\"list\":[{\"entityField\":\"subscriber_id\",\"sourceField\":\"subscriber_id\"},{\"entityField\":\"subscriber_phone_number\",\"sourceField\":\"phone_number\"},{\"entityField\":\"subscriber_imsi\",\"sourceField\":\"imsi\"},{\"entityField\":\"subscriber_imei\",\"sourceField\":\"imei\"},{\"entityField\":\"subscriber_apns\",\"sourceField\":\"apn\"},{\"entityField\":\"seen_time\",\"sourceField\":\"recv_time\"}],\"mapping\":{\"subscriber_id\":\"subscriber_id\",\"subscriber_phone_number\":\"phone_number\",\"subscriber_imsi\":\"imsi\",\"subscriber_imei\":\"imei\",\"subscriber_apns\":\"apn\",\"seen_time\":\"recv_time\"},\"disabled\":false}]', '[{\"from_entity_index\":2,\"to_entity_index\":1,\"type\":\"RESOLVE_DOMAIN_IP\",\"fromDisabled\":true,\"toDisabled\":true},{\"from_entity_index\":3,\"to_entity_index\":1,\"type\":\"CARRY_APP_IP\",\"fromDisabled\":true,\"toDisabled\":true},{\"from_entity_index\":3,\"to_entity_index\":2,\"type\":\"CARRY_APP_DOMAIN\",\"fromDisabled\":true,\"toDisabled\":true},{\"from_entity_index\":4,\"to_entity_index\":3,\"type\":\"VISIT_SUBSCRIBER_APP\"}]', '2024-11-20 03:37:27', '2024-11-21 07:07:27', 1, 0); +INSERT INTO `entity_profiles` VALUES (2, 2, '[{\"index\":1,\"type\":\"subscriber\",\"name\":\"Subscriber\",\"list\":[{\"entityField\":\"subscriber_id\",\"sourceField\":\"subscriber_id\"},{\"entityField\":\"subscriber_imsi\",\"sourceField\":\"imsi\"},{\"entityField\":\"subscriber_imei\",\"sourceField\":\"imei\"},{\"entityField\":\"subscriber_apns\",\"sourceField\":\"apn\"},{\"entityField\":\"seen_time\",\"sourceField\":\"ingestion_time\"}],\"mapping\":{\"subscriber_id\":\"subscriber_id\",\"subscriber_imsi\":\"imsi\",\"subscriber_imei\":\"imei\",\"subscriber_apns\":\"apn\",\"seen_time\":\"ingestion_time\"}}]', '[]', '2024-11-20 06:29:34', '2024-11-20 08:10:07', 1, 0); |
