how to monitor selected database table

[Eric25]

Hi.
I would like to monitor if a row has been added to a given table during the last hour and I would like to download this row in part. I currently have an MSSQL by ODBC template that contains discovery roles from database discovery. Currently the template collects a large amount of data but needs to check if a row is added to a given table and then a trigger is fired. The question is how can I do it quickly? I will add that I would like to monitor several tables with different names

[Hamardaban]

The simplest thing is to create a item with the "select count(*) from youtable" in SQL query (if the table has a key field, then it is better to select count(keyfield) from youtable).
Then you make a trigger with the diff or change function.

https://www.zabbix.com/documentation/5.0/manual/config/items/itemtypes/odbc_checks

https://www.zabbix.com/documentation/5.0/manual/appendix/triggers/functions

[Eric25]

@edition
I was able to add a trigger. A very important question, how can I add monitoring of several tables from different databases to one template? should I create a separate item for monitoring each time? And how can I display the content of a given entry in the trigger?

[tonyxavierj]

Eric25 how did you achieve this?
I am trying to monitor a table and get the count.