Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


sql to find out which interface local_data_id belongs to

 
Post new topic   Reply to topic    Cacti Forum Index -> Help: General
Author Message
pgb205



Joined: 10 Nov 2008
Posts: 17
PostPosted: Thu Nov 13, 2008 1:12 pm    Post subject: sql to find out which interface local_data_id belongs to Reply with quote
lets say i know that interface with local_data_id=20 has the highest number of traffic_out packet. Now I want to find out which port on a device it is. It is easy to find out which device it is from host_id and then get host.description value and host.hostname. So now i have description as well as ip for the device with the highest usage port but i still don't know how to get information about which port on the device corresponds to local_data_id=20.

thanks
Back to top
pgb205



Joined: 10 Nov 2008
Posts: 17
PostPosted: Thu Nov 13, 2008 1:34 pm    Post subject: Reply with quote
looks like data_local.snmp_index provides what I'm looking for?
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Help: General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group