Nagios Support Forum

Hello! We need provide the availability indicator of a specific HostGroup in QlikView tool. This information can be obtained in the Availability Summary Report. But if possible we need query to obtain this information directly on the Database because through API is not available. it is possible you guys provide this query?

Best Regards

TCP - BR

The easiest way would be to make use of the json api in core 4 (XI 2014 or newer). Browse to the following url and choose "archive cgi" and then "availability". Set the other required options and submit the query. This tool will allow you to check to see if the json api has in the info you are looking for.

http://<ip>/nagios/jsonquery.html

abrist wrote:The easiest way would be to make use of the json api in core 4 (XI 2014 or newer). Browse to the following url and choose "archive cgi" and then "availability". Set the other required options and submit the query. This tool will allow you to check to see if the json api has in the info you are looking for.

http://<ip>/nagios/jsonquery.hmtl

currently we use the Nagios XI 2012R2.7 version

Well, other than just parsing the webpage generated by the availability cgi (gross), an upgrade would be your best option.

abrist wrote:Well, other than just parsing the webpage generated by the availability cgi (gross), an upgrade would be your best option.

OK. It is not possible to obtain this information through a query in the database?

Not really, most of what you would need to so is there in the db, but the query would be a ridiculous 6 join with a bunch of math afterwards. My best suggestion is to upgrade.

abrist wrote:Not really, most of what you would need to so is there in the db, but the query would be a ridiculous 6 join with a bunch of math afterwards. My best suggestion is to upgrade.

OK. What is the best way to perform the upgrade? We want to also change the server. Perform the upgrade on the old server and restore on the new server with a fresh install?
The operating system version will also be updated. Another detail: In the current server the path of mysql database as been changed.

Here's what I would recommend:
1. Backup your old Nagios XI instance, following this document:
http://assets.nagios.com/downloads/nagi ... ios-XI.pdf
2. Install Nagios XI 2012R2.7 on the new server. We can provide you with a download link to 2012R2.7 tarball.
3. Move the backup from the old to the new server
4. Restore from the backup following the same document (from step 1)
5. Upgrade your Nagios XI instance to the latest
http://assets.nagios.com/downloads/nagi ... nstall.pdf

Hints:
1. Use the same IP for the new server if possible. This will eliminate the need to add the new IP on all remote machines that you are monitoring via NRPE, NSClient++, etc.
2. It is preferable to have a "clean" install on the same OS/Architecture as on the old server. If you must change OS/Architecture, please read the "Things to Consider" section from the document from step 1, and this post.
2. Disable notifications temporarily, until you make sure that everything works fine
3. Don't remove the old instance, before you make sure the new one functions properly.

Each Nagios XI license is approved for up to three installations: one primary monitoring/production, one backup/failover, and one test environment.
As long as you are only using one install for production monitoring, you are within the boundaries of our licensing policy.
If you eventually activate Nagios XI on three IP's and need to migrate one of them to a new IP, simply contact our sales department at [email protected]. They can typically offer additional installs.

Let us know if you run into some issues during the upgrade.

lmiltchev wrote:Here's what I would recommend:
1. Backup your old Nagios XI instance, following this document:
http://assets.nagios.com/downloads/nagi ... ios-XI.pdf
2. Install Nagios XI 2012R2.7 on the new server. We can provide you with a download link to 2012R2.7 tarball.
3. Move the backup from the old to the new server
4. Restore from the backup following the same document (from step 1)
5. Upgrade your Nagios XI instance to the latest
http://assets.nagios.com/downloads/nagi ... nstall.pdf

Hints:
1. Use the same IP for the new server if possible. This will eliminate the need to add the new IP on all remote machines that you are monitoring via NRPE, NSClient++, etc.
2. It is preferable to have a "clean" install on the same OS/Architecture as on the old server. If you must change OS/Architecture, please read the "Things to Consider" section from the document from step 1, and this post.
2. Disable notifications temporarily, until you make sure that everything works fine
3. Don't remove the old instance, before you make sure the new one functions properly.

Each Nagios XI license is approved for up to three installations: one primary monitoring/production, one backup/failover, and one test environment.
As long as you are only using one install for production monitoring, you are within the boundaries of our licensing policy.
If you eventually activate Nagios XI on three IP's and need to migrate one of them to a new IP, simply contact our sales department at [email protected]. They can typically offer additional installs.

Let us know if you run into some issues during the upgrade.

Tank you !!! Can you provide please the link for download of Nagios XI 2012R2.7 ?

Regards