Hello,
I would like to send a sql query to a database and get the value (using a select count etc...) I can do it from the 'command line' but from the web interface I am completely lost
Thanks for your help
Solved
Request SQL
+1Best answer by coco163
--sql-statement should be between double quotes
--sql-statement=”select count(*)...;”
+11if you are familiar with the command line, then just create a new check command.
After that simply create a service with the command you created.
Share of to us and we will guide you to define the macros
+1here is the command that I execute but when I create a new command in the web interface with the same command it marks me (Execute Command failed)
+11--sql-statement should be between double quotes
--sql-statement=”select count(*)...;”
+14
https://docs.centreon.com/pp/integrations/plugin-packs/procedures/applications-databases-oracle/
/usr/lib/centreon/plugins/centreon_oracle.pl \
--plugin=database::oracle::plugin \
--hostname='10.0.0.1' \
--help
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.