LLD Discovery of LLD Discovered item

[du5tylane]

I am running zabbix 3.4.2. Hosts are Linux and Windows. Zabbix is installed on centos 7.

Running Zabbix Agent's on 99% of hosts.

I am using host side scripting to discover the database. Now, I want to discover the tables inside of each discovered database. I have the logic in the script to accomplish this, but I do not know how to send the data back to zabbix in the correct json format.

Question 1 - can I do this in one low level discovery? If so, how do I format this in json correctly? Would someone mind providing an example of what the json should look like.

Question 2 - if this is not the correct method, what is the correct method? Host prototypes?

Examples\Direction on how to get this into zabbix would be very appreciated.

[kaspars.mednis]

Hello,

One way to discover tables in databases is with built in ODBC discovery,
take a closer look at https://www.zabbix.com/documentation...ry/sql_queries

If you want to use your custom host-side script instead off built-in functionality, then the script must return a JSON object, which is described in the same manual. There is a good example.

Regards,
Kaspars

[du5tylane]

Thank you for the reply, but maybe I was not clear on what I am trying to accomplish.

I have a discovery item. It discovers all of my databases. Now, I want to discover each table inside of the table with a second discovery item.

I am unsure how to run a discovery on a discovered set of items.

Thank you for the link. That is what I used originally to ensure my host side scripts where formatting json correctly for zabbix.