On Wed, 3 Mar 2021 14:48:42 +0100 Biselx Nicolas nicolas.biselx@epfl.ch wrote:
I would like to make a report with the following information:
Switch, Interface, Configured Vlan, Mac address start and end time, patch and cabling informations.
Is there a way to make this kind of report ?
You can make any kind of SQL-based report using /etc/nav/report/report.local.conf - however:
1. It helps to be an SQL guru.
2. The report filtering forms are not well suited to filter by dates, so the report you're describing would basically dump the *entire* NAV CAM log since the beginning of time once you open the report. That is going to be a pretty heavy operation (depending on the size/age of your database).
Also, the CAM log doesn't have an explicit relation to the interface table, because old log records can refer to interfaces that no longer exist in your network.
I believe this is the main reason the Machine Tracker interface currently doesn't put more interface details in search results. It creates a hyperlink to the interface details page in ipdevinfo, but this link will only work if the combination of the device and interface name still exists in your database.
I think there may still be an old feature request issue in the tracker to add patch/cabling information to the Machine Tracker. Basically, all the stuff you're asking for would be best suited in that tool.