MySQL: can't "select from databasename.tablename" via custom query

[Humulus]

I'm trying to use custom queries with MySQL.
A simple working statement is:

 SELECT * FROM databasename.tablename

But when I try to make databasename a parameter:

 SELECT * FROM ?.tablename

it doesn't work, because the parameter is recognized as text and automatically padded with single...

[markfree]

I'm trying to understand what would be better for loading Zabbix dashboards in terms of performance, or loading widgets.
For example, if I query some data in a Graph widget, from a performance perspective, which would be better:

• Create 1 data-set that queries all values with a wildcard ( like

...

[Ivanova]

Hello,

I want to extract with a SQL querry the alert counter for a group host.
I've seen topics who where close to my goal (1st & 2nd). But I can not find the link between the table of the host and the alert counter after a few hours of search in the Zabbix DB and on this sit...

[brenoacp]

Hello everyone!
I am performing a query in the Items table, and the name of some items is displayed for example:

"Outgoing network traffic on $1"
or
"Free disk space on $1".

Where is the value of these variables stored?
Please, could...

[fgo.oliver]

Hello guys,

I'd like a little help please.

I have the query below and I need to get also duration off each eventid, but like I'm not DB admin, so cant finish this...

SELECT
e.eventid, e.source, e.object, e.objectid, e.clock, e.value
FROM events e...

[ankykul]

Hi,

After upgrading the server from 4.2.1 to 4.4.0 I'm getting query error on Hosts page. I'm using postgresql database and Centos.
I also check with DB server but there is nothing found suspicious. My 2 other servers are upgraded well and not getting any error.
Also getting...

[John Stoneman]

I'm currently using an HTTP agent where I want the query fields filled with values I get from other items. I think I need to use macros for this, but {ITEM.KEY} doesn't seem to work. I'm using Zabbix 4.2.4.

According to this page:
https://www.zabbix.com/documentation/4.0/manual/c...

[BlackCrystal]

i wanto create an odbc discovery for a host ( not template ). on my host i have 2 databases named sample and info. should i replace dsn with for example info?
i mean if i write my sql sever zabbix agen is going to execute that on which database?
or dsn is completly sth else?

[BlackCrystal]

hi. can i use a query to create graph in zabbix 3.4?
i have this userparameter:
UserParameter=db.bksize,echo "select bksize from BACKUP where date=current date "
it returns about 39 values.
can i use this 39 values to create graph instead of creating 39 items?
...

[fbreves]

Hi Guys,

I am a newbie in zabbix but am enjoying the tool so far. I have a question and hope you guys can point me in the right direction.

I am wondering if I could use zabbix to connect to a Database and query (maybe using stored procedures) transactional data (i.e.: CRM...

[dlethe]

I've got an app that does a lot of monitoring and tuning for disk/RAID related metrics. The app maintains a large number of database (SQLITE) tables with varying internal polling intervals, and it is important to minimize the overhead of obtaining some of the data.

Having said that, I...

[ninguno]

Hi, I'm new here. I'm testing Zabbix to see if can help me monitoring my environment and up to now it seem it's the right choice!

I have one question, one of needs is querying some database application tables to collect data, analyze results and trigger alarms/actions across time; ...

[brucegui]

Hello everybody, I'm doing a KPI with data from Zabbix and the report would basically the Availability report but in stacked bar graphs showing the rate UP and DOWN buttons for each application or server.
Already I have triggers, but I can not able to model the query.
With the following...

[fatiha]

Hi,

zabbix_server is installed on a Red Hat Enterprise Linux AS release 4 (Nahant Update 3) a,d mysql database on a Red Hat Enterprise Linux Server release 5.2 (Tikanga).

Zabbix_server stops every day and I wrote a script to restart it when it stops. The problem is that...

[Rafael.Marmo]

Hello,
I need to create a query that show all alerts generated for a given host or host group. The problem I am facing is that I dont know how the relationship between tables "Alerts, Triggers and Hosts" works.

May someone help me explaning how the DB Schema works for...