We now have a new endpoint that exports the agent data (hardcoded columns) into CSV format directly.
All you have to do is use Agents Endpoint and add a .csv at the end:
https://{MY_HOST}/agents.csv?
The output looks like this:
id,name,default_name,category,agent_class,active,software_version,logged_in_user,wired_mac_address,wired_ip_address,wired_gateway,wired_dns_server1,wired_dns_server2,external_ip_address,wireless_mac_address,wireless_ip_address,wireless_gateway,wireless_dns_server1,wireless_dns_server2,isp_name,isp_asn,last_seen_at
140,dummy wired,[1.2.3.41-00:41],network_agent,faste,true,12.0.1,,00:00:00:00:00:41,1.2.3.41,192.168.0.1,1.1.1.1,,108.32.61.173,,,,,,Verizon Business,AS701,2024-03-25 23:14:38 -0400
139,dummy WiFi,[1.2.3.43-00:43],network_agent,wireless,true,12.0.1,,00:00:00:00:00:43,1.2.3.43,192.168.0.1,1.1.1.1,,108.32.61.173,00:00:00:00:01:43,10.2.3.43,192.168.0.1,1.1.1.1,,Verizon Business,AS701,2024-03-25 23:14:43 -0400