Query on fix [TPS#13871] applied in 5.8.8

[lmiltchev]

I sent you a PM.

[bomahony]

Thanks mate, and responded

[lmiltchev]

I responded too.

[bomahony]

Tried it in two other environments. still the same damn issue. I was ghoing WTF, when I realised something.

HG in Nagios: HAProxy
HG in config file: HAPROXY



So I just did an import and it worked fine. You can close this off!

B

[bomahony]

As a matter of interest is there a way to report how many checks are applied to each host from the cli, akin to the
hostgroup overview? [either including o/w/c/u or not, either is fine].
Basically i want to be able to correlate across DCs that cannot talk to each other, but should be mirrors. with about 1000 hosts it is not feasible manually. EG

dc1-srv-01: 60 checks
dc1-srv-02: 25 checks
dc1-srv-20: 45 checks

And so forth?

[lmiltchev]

As I mentioned in the PM, Linux is case sensitive, so different case means different config name, so duplication makes sense now.

As a matter of interest is there a way to report how many checks are applied to each host from the cli...

I believe you could use a command as the one below. It will give you the number of services that are added to each host (and are active):

Code: Select all

echo "select count(*),name1 from nagios_objects where name2 !='' and is_active=1 group by name1;" | mysql -t -uroot -pnagiosxi nagios

The format would be a little bit different, but this should not matter much.

Let us know if it is OK to close this topic and mark it as resolved. Thank you!

[bomahony]

RE: The camel case. Yeah I knew it was case sensitive but just couldnt actually see it. Sorry for all the hassle

Thanks for the support - you can close the case.

RE: Checks per host: That works perfectly.

[lmiltchev]

Great! I am glad we could help!