Export service details

[Ayush Jain]

Hi Team,

Is it possible to export service details which we are monitoring, in csv or xls format from NagiosXI.

for ex:

Host Service
A CPU_LOAD
A Memory
B Tomcat Process

Thanks,
Ayush Jain

[kyang]

Are you looking for something like this?

Capture.PNG

This can be done in the state history report. XI home --> Reports --> State history report under available reports section.

What service details are you looking for? Previous or current?

Does this help?

[Ayush Jain]

I am just looking for all host/service which we are monitoring in Nagios.
csv list should be having 2 columns ( 1st hostname, 2nd service name)

[kyang]

We don't have any report to show all host/services that are being monitored.

You could try to grep the status.dat or objects.cache file and send it to a csv?

Here's a small solution, it's not displayed in two columns, but it's just to give you an idea.

Code: Select all

grep -A 1 'host_name=\|service_description=' /usr/local/nagios/var/status.dat

The output.

Code: Select all

        host_name=localhost
        service_description=Swap Usage
        modified_attributes=0
--
        host_name=localhost
        service_description=Total Processes
        modified_attributes=0

Save it to a csv file and transfer it to your desktop.

Code: Select all

grep -A 1 'host_name=\|service_description=' /usr/local/nagios/var/status.dat > /tmp/test.csv

I'm sure there's a better way, that you could try.

[Ayush Jain]

I guess from this data i can write script to get the desired output

Thanks,
Ayush Jain

[kyang]

No problem!

Did you have any more questions? Or are we okay to lock up this thread?

[Ayush Jain]

yeah please lock it up .
Thanks:-)

[kyang]

Sounds good! I'll be closing this thread!

If you have any more questions, feel free to create another thread.

Thanks for using the Nagios Support Forum!