Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Oct 18, 2017 6:03 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: New Field at IP addresses view
PostPosted: Tue Aug 22, 2017 6:54 am 
Offline

Joined: Tue Aug 22, 2017 6:45 am
Posts: 2
Hi,

Could be possible the addition of the field "Name" at this view as is showed at the "Interfaces" one?

Thanks


Top
 Profile  
 
 Post subject: Re: New Field at IP addresses view
PostPosted: Wed Aug 23, 2017 2:02 am 
Offline

Joined: Tue Aug 22, 2017 6:45 am
Posts: 2
Hi people,

This is my workaround

551 -- > $query_string = "SELECT mac_track_ips.*, mac_track_sites.site_name, mac_track_oui_database.*, mac_track_interfaces.ifName
FROM mac_track_ips
LEFT JOIN mac_track_sites
ON (mac_track_ips.site_id = mac_track_sites.site_id)
LEFT JOIN mac_track_oui_database
ON (mac_track_oui_database.vendor_mac=SUBSTRING(mac_track_ips.mac_address, 1, 8))
LEFT JOIN mac_track_interfaces ON (mac_track_interfaces.device_id=mac_track_ips.device_id AND mac_track_interfaces.ifIndex=mac_track_ips.port_number)
$sql_where
$sql_order
$sql_limit";



mac_track_view_ips{ ...
echo '<td>' . $port_result['port_number'] .'::'. $port_result['ifName'] . '</td>';
...}


Top
 Profile  
 
 Post subject: Re: New Field at IP addresses view
PostPosted: Wed Aug 23, 2017 8:08 pm 
Offline
Cacti Pro User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 542
Github pulling request is a better place for this.

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group