Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Wed Jan 09, 2019 12:00 pm
I sent you a PM.
Nagios Support Forum
Support for Nagios products and services
https://support.nagios.com/forum/
Query on fix [TPS#13871] applied in 5.8.8
Page 3 of 3
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Wed Jan 09, 2019 1:14 pm
Thanks mate, and responded
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Wed Jan 09, 2019 3:16 pm
I responded too.
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Thu Jan 10, 2019 7:14 am
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
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
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Thu Jan 10, 2019 7:49 am
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?
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?
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Thu Jan 10, 2019 10:03 am
As I mentioned in the PM, Linux is case sensitive, so different case means different config name, so duplication makes sense now.
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!
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):As a matter of interest is there a way to report how many checks are applied to each host from the cli...
Code: Select all
echo "select count(*),name1 from nagios_objects where name2 !='' and is_active=1 group by name1;" | mysql -t -uroot -pnagiosxi nagiosLet us know if it is OK to close this topic and mark it as resolved. Thank you!
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Thu Jan 10, 2019 10:10 am
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.
Thanks for the support - you can close the case.
RE: Checks per host: That works perfectly.
Re: Query on fix [TPS#13871] applied in 5.8.8
Posted: Thu Jan 10, 2019 10:41 am
Great! I am glad we could help!