Solved

Request SQL


Badge +1

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

icon

Best answer by coco163 31 May 2022, 11:12

View original

3 replies

Userlevel 1
Badge +11

if 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

Badge +1

here 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)

 

Userlevel 1
Badge +11

--sql-statement should be between double quotes

 

--sql-statement=”select count(*)...;”

Reply