Home , Operations Center to TXT/XLS/CSV or to MySQL table

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
zaji_nms
Posts: 616
Joined: Tue Oct 16, 2012 12:28 am

Home , Operations Center to TXT/XLS/CSV or to MySQL table

Post by zaji_nms »

Hi

Home , Operations Center to TXT/XLS/CSV or to MySQL table

We fully depend on Home, Operations Center to keep eyes on all alerts. What is the best way to fetch this info via our own script?

assume our Front-End server = 172.16.x.x or 10.10.x.x <<<<<<< from this server we want to fetch data from below server
our NagiosXI server = 192.168.x.x

You can guide via below and let us know if some other better than these following.

REST API
cURL
MySQL-Query
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Home , Operations Center to TXT/XLS/CSV or to MySQL tabl

Post by scottwilkerson »

These statuses are all able to be collected from the API
See instructions on calling in
Help -> API Docs -> Objects Reference

Primarily you would be working with the following API's
objects/hoststatus
objects/servicestatus
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
zaji_nms
Posts: 616
Joined: Tue Oct 16, 2012 12:28 am

Re: Home,Operations Center to TXT/XLS/CSV or to MySQL table

Post by zaji_nms »

Hi scottwilkerson

do you have any document providing detail step by step via example? please share the document URL

if you don't have, I am providing these three fields, how you will make the URL using below , host, service, APIkey

QyRouterOne
QyGREtunnTwo
QyAPIkeyThree

it will fetch just one info in single query or multiple Host/multiple Services in single Query? Multiple Hosts , Multiple Services using RegExpr

QyRouter*
QyGREtunn*
QyAPIkeyThree

also possible to fetch all HOSTS , all SERVICES in single query? how?
Last edited by zaji_nms on Wed Nov 27, 2019 8:40 am, edited 1 time in total.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Home , Operations Center to TXT/XLS/CSV or to MySQL tabl

Post by scottwilkerson »

The documentation can be found in the XI interface under
Help -> API Docs -> Objects Reference

Other than what it shows we do not have any further documentation, as this is an API (Application programming interface) it will require a programmer to write a program to interpret the results.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked