The data format that you're referring to is called JSON. As for getting that data into excel, you might find a tool like the following helpful: http://konklone.io/json/
Thanks!
TwitsBlog Show me a man who lives alone and has a perpetually clean kitchen, and 8 times out of 9 I'll show you a man with detestable spiritual qualities.
BanditBBS wrote:Quick question...using the new API to list all users in XI....what type of format is that? I did the get users and it's showing me the list, but that's not XML for easy importing into Excel, what is it? Will the backend component continue to be included for the foreseeable future?
Yes, the old backend API is available and will remain available. The new API will allow XML output also as an option once some things get added into it.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Fortunately, Nmap includes a huge database of heuristics for identifying thousands of different systems based on how they respond to a selection of TCP/IP probes. Another system (part of version detection) interrogates open TCP or UDP ports to determine device type and OS details. Results of these two systems are reported independently so that you can identify combinations such as a Checkpoint firewall forwarding port 80 to a Windows IIS server.
This means the detection is not 100% accurate. Right?
[root@localhost/]# curl -XPOST "http://localhost/nagiosxi/api/v1/system/user?apikey=edp553lb&pretty=1&username=jmcdouglas&password=testuser&name=Jordan%20McDouglas&email=jmcdouglas@localhost&enabled=1"
null
[root@localhost/]# curl -XDELETE "http://localhost/nagiosxi/api/v1/system/user?apikey=edp553lb&pretty=1&user_id=56"
SQL: SQL Error [nagiosxi] :</b> ERROR: invalid input syntax for integer: "NULL"
LINE 1: SELECT * FROM xi_users WHERE user_id='NULL'
^"User with ID does not exist."