Show SNMP OID registred in tamplate

To list all OIDs used in template "Template Module Generic SNMPv2":

select snmp_oid from items where flags=0 and hostid=10204;

List all parameters:

select * from items where flags=0 and hostid=10204\G;