Mysql: Get Template Name and item Name

[karl.otte]

Hi, I need your help.

What is the SQL command that I caught the name of the item and the name of that template?

Regards, Karl.

[ableev]

mysql> SELECT h.host AS Template, i.description AS Item FROM items i JOIN hosts h ON i.hostid = h.hostid WHERE i.templateid = 0 AND i.description like 'Free memory';
+----------------+-------------+
| Template       | Item        |
+----------------+-------------+
| Template_Linux | Free memory |
+----------------+-------------+
1 row in set (0.00 sec)

[karl.otte]

Tks

Thank you ableev.

I could do what I wanted.