Launch H2 database console
http://<SNMPcollector Robot's IP>:9715/database
SQL to visualize your active monitors and which template is affecting.
SELECT d.HOSTNAME, d.IPADDRESS, ca.VALUE, mf.DISPLAYNAME, m.METRICNAME, a.TEMPLATENAME from METRICSTATE m
INNER JOIN ATTRIBUTION a on m.ATTRIBUTION_ID_OID = a.ID
INNER JOIN SNMPDEVICE d on d.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENTGROUP mf on m.METRICFAMILYID = mf.METRICFAMILYID and mf.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENT c on m.METRICFAMILYID = c.METRICFAMILYID and m.COMPONENTSEQUENCEID = c.SEQUENCEID and c.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENT_ATTRIBUTES ca on ca.ID_OID = c.ID and ca.KEY = 'Names'
SQL to visualize your active monitors in which no template affecting.
SELECT d.HOSTNAME, d.IPADDRESS, ca.VALUE, mf.DISPLAYNAME, m.METRICNAME from METRICSTATE m
INNER JOIN SNMPDEVICE d on d.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENTGROUP mf on m.METRICFAMILYID = mf.METRICFAMILYID and mf.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENT c on m.METRICFAMILYID = c.METRICFAMILYID and m.COMPONENTSEQUENCEID = c.SEQUENCEID and c.DEVICEID = m.PARENTDEVICEID
INNER JOIN COMPONENT_ATTRIBUTES ca on ca.ID_OID = c.ID and ca.KEY = 'Names'
WHERE m.ATTRIBUTION_ID_OID IS NULL