Low Level Discovery & SQL

[leoonardoo]

I have some processes that write data in a db.
Whenever I add a new "process" I want to be able to monitor some items about it; these items are database-monitor type of items.

So I:

1. set up a LLD in SQL: "select processid from processes where enabled=TRUE", db.odbc.discovery[processes,pg_QA]
2. in the discovery created, I set up an item: "select count(*) from process_status where timestamp between now() - interval '5 minutes' and now() and processid='{#PROCESSID}'"

Nothing happens...
So some questions:

1. How can I see that the processes are "discovered"?
2. Can I have a LLD macro in SQL as parameter as shown above?
3. What am I supposed to see? The items under what?

[Clontarf[X]]

Create new Discovery with Zabbix External Check type

Write new script to do the following
Run your query listing your processes
For each process, replace processname with {#FILTERNAME}

Put script into external check item field

Discovery should then populate with discovered processes, and you can then configure item prototypes e.t.c.