Find GigabitEthernet with rrd_maximum=100000000

Hi,
in our cacti installation i am seeing a bunch of data sources for
GigabitEthernet interfaces with an rrd_maximum set to 10000000 e.g.
100MBit/s - This results in broken graphs so i'd like to fix them.

Is there an easy way to find all instances with an rrd_maximum
of 100000000 and their respective hostname/ipaddress and interface name?

I found the maximum in the data_template_rrd table but i fail to
find a way to match it to a host and interface ...

Flo
-- 
Florian Lohoff                                                 [email protected]
      We need to self-defend - GnuPG/PGP enable your email today!

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140

_______________________________________________
cacti-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cacti-user

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQIVAwUBVriLkZDdQSDLCfIvAQq8vg//fTpVfUFeCQ21fn2nY46vyabnAJ0IQRdn
y2HKbxZYBuhQ6ROt+LT4IjD4y2ITS1pSoAoE1sfpI+S9OiQkHOBXE5NeSNTAt4Su
UEq2pq0JYw/KEhCBF44Lh3xkCYhf+1LIJkTMivKA3Ea75OoSnTxBycB6+i7r51wR
r+7lQQKzgpdSyMVPsKCTdleINywYR4sLQ9h0BjT5bhBbwV0/nvwSUNdna2jjidGA
37ggijRNXkFd/fJrhEAQ95LbuENBLWygtMXvkdBsqUHUcBqMnPWDSxbGf1Tw+Oh9
GlrLoNGzXqmSZ7g9q5xQtu4M3b1D4ImCdmMHFcRoJJvLPeulBmBMQta62t0QqHfp
Rjy+5iW/2S7VTcBGY/DHDDBrPHt2fmtZcVVqSbVZOgc2BC+IjrPAMcVGQRznaSDy
Apy7GQFv3aQPKfS+8iIqDwSKFdalEO0Jr0SRSJVo0Vyh4Lr21FDHzMO0SBAzpg1R
ab8VvNL+e8eUze+Iud4kjvpXGQauzyX0aiHfV4Qjo6QO7/siX/XKDNAc0uZmk2nJ
jKJvGbmBSumTQE/H94pDcfpKi/EkeXrChkLbl3fI0wZzEfBiPNYWUzHu9dKZ2RTO
C1rc65UoHZhq/TNYzg8xi2eL/g/h8wdU1HejE4T2yVdWLGYuj3srzvNO4rYRse9y
lG+mObm8wpI=
=vF7u
-----END PGP SIGNATURE-----