Morn,
We have XI 2014R2.7.
We are restructuring the way we do services checks. We are just about completed and i would like to run a query against the database that returns the number of services tied to each host. We have approx 1,500 hosts (windows,linux). We have a specific number of service checks for each type of hosts and need to confirm that each has this number of checks. To do this via the XI Gui we take for eva'.
Could you help?
Thx
Query to retrieve services tied to a host
Re: Query to retrieve services tied to a host
I've whipped up a quick script for you, download the attached file, unzip it, and place it on your XI server.
Now go into Admin > Manage Components > Backend API URL > Settings
- Select the nagiosadmin user and click apply settings.
- Under the services URL, copy the entire URL and replace the URL in the file.
- Now run the script:
Now go into Admin > Manage Components > Backend API URL > Settings
- Select the nagiosadmin user and click apply settings.
- Under the services URL, copy the entire URL and replace the URL in the file.
- Now run the script:
Code: Select all
chmod +x hosts_with_service_count.php
./hosts_with_service_count.phpYou do not have the required permissions to view the files attached to this post.
Re: Query to retrieve services tied to a host
Awesome. thanks Mr. SSAX. Please close.