rrd file name and interface description mapping

[niranga1127]

Hi,

I have a requirement to get rrdfile name to router interface description mapping to table in database. Is there any way to get this mapping using mysql database or any other way ?

Regards
Niranga

[Osiris]

Well there are a few joins

- poller_item - has the path
- data_local - maps to it on local_data_id

The snmp_index column there is the primary key that then maps to

- host_snmp_cache - where you can query by any column and find a rrdfile.