Exporting endpoint information

You can export endpoint information from EMS as a CSV file. You can use this data for compliance, software auditing, and so on.

To export endpoint information:

1. In EMS, go to Endpoints > All Endpoints.

2. Go to the desired endpoint group.

3. In the top right corner, click Export CSV.

4. In the confirmation dialog, click Export. This downloads a .zip file to the device which contains endpoint information in .csv format. The following shows an example:

   device_id,name,ip_addr,os_version,cpu,manufacturer,sn,mem,hdd,model,ipv6_addr,mac_addr,host,remote_ip,network_interfaces,group_id,group_name,group_path,orig_group_name,domain_id,installer_name,deployment_state,fgt_sn,forticlient_id,uid,fct_version,diskenc,av_product,is_installed,is_managed,is_migrating,is_ems_registered,is_ems_online,is_ems_onnet,is_excluded,is_quarantined,quarantine_access_code,comparable_fct_version,assigned_tags,last_seen,last_seen_fct_user_id,fct_users,endpoint_policy_name,endpoint_policy_id,ip_list_name,av_enabled,rtp_enabled,ae_enabled,cs_enabled,rm_enabled,fw_enabled,wf_enabled,vpn_enabled,vuln_enabled,ssoma_enabled,sb_enabled,sb_cloud_enabled,rs_enabled,onboarding_supported,client_version_up_to_date,client_av_sig_version_up_to_date,client_policy_synced,client_policy_primary_synced,client_policy_offnet_synced,client_policy_iplist_synced,client_policy_onnet_rule_synced,client_policy_verification_rule_synced,client_policy_certs_synced,av_events_count,wf_events_count,fw_events_count,sb_events_count,ae_events_count,rm_events_count,cs_events_count,unreg_events_count,rs_events_count,nwifsc_events_count,vuln_events_count,vuln_events_max_severity,profile_components,off_net_profile_components
   """4""","""Boromir""","""192.168.0.10""","""Microsoft Windows 10 Enterprise Edition, 32-bit (build 19044)""","""Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz""","""Microsoft Corporation""","""...""","""2047""","""99""","""Virtual Machine""","""""","""...""","""Boromir""","""192.168.0.10""","""[intf_name:Ethernet%203,mac:...,ip:192.168.0.10, gw_ip:192.168.0.100, gw_mac:..., ssid:, route:0]""","""2""","""Other Endpoints""","""All Groups/Other Endpoints""",,,,,,"""1""","""...""","""7.2.0.0690""","""""","""""","""True""","""True""","""False""","""True""","""True""","""True""","""0""","""0""",,"""7002000""","""[all_registered_clients]|[Low]""","""2023-06-15 20:50:37""","""1""","""[brando]""","""Policy01""","""2""",,"""True""","""True""","""False""","""False""","""False""","""True""","""True""","""True""","""True""","""False""","""False""","""True""","""True""","""1""","""True""","""1""","""True""","""True""","""True""","""True""","""True""","""True""","""True""","""2""","""2""","""0""","""0""","""0""","""0""","""0""","""1""","""0""","""1""","""0""",,"""{'malware': {'id': 2, 'name': 'Profile01'}, 'sandbox': {'id': 2, 'name': 'Profile01'}, 'webfilter': {'id': 3, 'name': 'Profile01', 'fp_name': ''}, 'firewall': {'id': 2, 'name': 'Profile01'}, 'vpn': {'id': 2, 'name': 'Profile01'}, 'vulnerability_scan': {'id': 2, 'name': 'Profile01'}, 'system': {'id': 3, 'name': 'Profile01'}, 'ztna': {'id': 2, 'name': 'Profile01'}, 'videofilter': {'id': 2, 'name': 'Profile01'}}""","""{}"""
   """6""","""Legolas""","""192.168.0.15""","""Microsoft Windows 11 Professional Edition, 64-bit (build 22621)""","""Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz""","""Microsoft Corporation""","""...""","""4094""","""69""","""Virtual Machine""","""""","""...""","""Legolas""","""192.168.0.15""","""[intf_name:Ethernet,mac:...,ip:192.168.0.15, gw_ip:192.168.0.100, gw_mac:..., ssid:, route:0]""","""2""","""Other Endpoints""","""All Groups/Other Endpoints""",,,,,,"""2""","""...""","""7.2.1.0779""","""""","""""","""True""","""True""","""False""","""True""","""True""","""True""","""0""","""0""",,"""7002001""","""[all_registered_clients]|[Low]""","""2023-06-15 20:50:37""","""2""","""[Administrator]""","""Policy01""","""2""",,"""True""","""True""","""False""","""False""","""False""","""True""","""True""","""True""","""True""","""False""","""False""","""True""","""True""","""1""","""True""","""1""","""True""","""True""","""True""","""True""","""True""","""True""","""True""","""1""","""0""","""0""","""0""","""0""","""0""","""0""","""0""","""0""","""1""","""2""","""0.0""","""{'malware': {'id': 2, 'name': 'Profile01'}, 'sandbox': {'id': 2, 'name': 'Profile01'}, 'webfilter': {'id': 3, 'name': 'Profile01', 'fp_name': ''}, 'firewall': {'id': 2, 'name': 'Profile01'}, 'vpn': {'id': 2, 'name': 'Profile01'}, 'vulnerability_scan': {'id': 2, 'name': 'Profile01'}, 'system': {'id': 3, 'name': 'Profile01'}, 'ztna': {'id': 2, 'name': 'Profile01'}, 'videofilter': {'id': 2, 'name': 'Profile01'}}""","""{}"""