Hi all, in trying to figure-out which modules and which alerts were configured in all the machines, is there way to a general view of it or dump such information in a file in CSV format? For example, to check that all the machines have the module Free C disk space enabled and with which alert limits. If not is there a way to do that via SQL? Pandora version is 4.0.2. Thanks in advance, Alex
Dump of all the modules enabled and alerts set
alex · 20 mar 2014, 16:26 · 11 mensajes · 53 visitas
- Inicio del debate
Hello Can you tell me the type of system where Pandora is installed? Regards Ivo
Hi Ivo, Pandora 4.0.2 Distributor ID: Debian Description: Debian GNU/Linux 6.0.7 (squeeze) Release: 6.0.7 Codename: squeeze mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1 I hope this was information you sought for, otherwise let me know. Alex
I hope you can help Ivo, this will simplify the task to have an overview on how the system is configured. Maybe there is a way to dump such information to a CSV file? That will help as well a lot. Many thanks in advance, Alex
Hello Thank you for the information I will try and replicate the server's infrastructure and I'll inform you as soon as I have it done (it could take some time). Regards Ivo
Hi Ivo, that's great. Please let me know if I can be of any help by starting with simple queries. If you want I can post here the description of the tables, would that be OK? Looking forward to hearing from you. Alex
Hello I've been looking into this issue and I can't help you untill you update to a newest version. Version 4.0.0 is very old. You'd need to update at least to version 4.1.1. Regards Ivo
Thanks Ivo, will I use a feature of Pandora (what would that be?) or a SQL query? Thanks, Alex
Hello You will be able to see the alerts configured in a general view in the pandora console. Regards Ivo
Thanks Ivo, I guess you refer to :: Operation :: -> Monitoring -> Alert Detail. There I can see all the alerts and their status but not the thresholds defined for warning and the critical conditions. I came to the conclusion that the following mysql query should give me an overview of what defined in each agent (by hand server by server) mysql> pager less -SFX mysql> select b.nombre,a.nombre,a.id_agente,a.id_modulo,a.min_warning,a.max_warning,a.str_warning,a.min_critical,a.max_critical,a.str_critical from tagente_modulo a join tagente b on b.id_agente = a.id_agente; mysql> pager cat This query returns the thresholds for each modulo and I now after running it I'm aware that there are some inconsistencies due to many people who configured on their own the thresholds. I'm thinking to move to the commercial version, to whom can I address such request of mine? Thanks, Alex
Hello You can contact the following email address for questions on the commercial version: [email protected] Regards Ivo
Entra en tu cuenta para publicar.
