Can nagios write its data to MS SQL Server

[FTL]

Hi Guys,

Currently using Nagios 3.4.1 on Ubuntu 12.04

Ive been using Nagios for last 5 years or so and have a custom written bash script that basically scrapes the availabilty report data off the page and emails it each week and month in HTML format for all my hosts and hostgroups. (Its a very dirty script and the output is not too pleasing on the eye, it would never see the real world but it works for what is intended)

I now have a requirment to provide monthly data for a set of sepcific hosts and have been asked if i can change the way Nagios writes its data from dat files to database format to accomodate this.

They would in an ideal workd like to have the data is MS SQL format so they can use MS Reporting Services to produce this data to the clients big bods each month.

A) Is is possible to have Nagios write its data "NDOUtils style" but instead to a remote MS SQL Server?

B) If not, would it be a feasable and managealbe solution to convert my Nagios install to use NDOUtils and then in the background copy and convert the MYSQL database off into a remote MS SQL?

C) Any other better plugins or suggestions from you more experienced guys for emailing reports in Nagios Core?

Cheers lads

[tmcdonald]

A.) I do not believe so. NDO and Nagios were designed with MySQL in mind, so there might be compatibility issue. Hasn't been tested, though we always welcome people to test it and let us know!
B.) Converting to use NDO is pretty painless, and personally this option sounds a lot more desirable.
C.) If I may put on my Sales hat for a minute, Nagios XI does this natively and there are features in-place to do so on a scheduled basis.

[FTL]

Thanks tmcdonald for the reply.

With regards to

B) Are there any guides anywhere on how to convert to NDO please? I remember trying to get it working when i first started out with Nagios and was unsucessful, although i know a little more now about unix (not alot more mind, still Windows brainwashed )

C) My pleas fall on deaf ears! Seems that the no comes quicker each time i ask!!!

[tmcdonald]

B.) Instructions for setting up NDO, as well as the NDO code, are all on our Github page: https://github.com/NagiosEnterprises/ndoutils

C.) It's definitely an answer we have given in the past: https://support.nagios.com/forum/viewto ... 41#p141417

Part of the reason we recommend XI is because it was designed specifically with these needs in mind. That being said, the advice given in the linked thread is to check our Exchange site for reporting addons, such as this one:

https://exchange.nagios.org/directory/A ... df/details

We can't really provide support for third-party code, so it's provided "as-is" in that regard.

[FTL]

C) My pleas fall on deaf ears! Seems that the no comes quicker each time i ask!!!

C.) It's definitely an answer we have given in the past: https://support.nagios.com/forum/viewto ... 41#p141417

Part of the reason we recommend XI is because it was designed specifically with these needs in mind. That being said, the advice given in the linked thread is to check our Exchange site for reporting addons, such as this one:

tmcdonald - i believe you have mis-interpreted my original quote.

The plea's falling on deaf ears was in reference to me asking my boss to purchase me XI, his no's come quicker to me each time i ask him!

[tmcdonald]

Ahh, yes I definitely misunderstood!

Has your boss seen XI? Had a webinar, quickstart, anything like that? Have you spun up a trial? I've gotten pretty good at turning a No into a Yes :)

Regardless of that though, did you find any addons that might work for you?