The report tool presents a number of reports with information from your network. The report tool also links to the IP device center, to the “IP address scope - graphical view” and the services - graphical view.

Each NAV report is in essence an SQL query to the database. It shown its data in a number of columns. The data is in many cases also hyperlinks to other reports or other tools in NAV. The whole report system is highly configurable, the basis for the system is the configuration file report.conf. Details on the configuration is provides below.

An example report showing all your network equipment sorted by type:

From this report you can drill down on a particularly type and see the number of devices you have of this type. That will display another report (the netbox report) with more information on each device. From here you can go to other reports, i.e. a switch port report for a given switch, or a room showing equipment in a given room.

Tips:

• To navigate back to the report home page, use the “current path” provided below the NAV bar.
• The search bars on top are shortcuts to interesting reports. The room searc lets you go directly to a room of interest. You may also search for a particular port name, or you may dive directly into the IP device center of a device in interest.

The IP device center is a dashboard for a given device showing relevant information. It presents recent events for the device, if any. If the device is a switch or router a switch port and/or router interface view is given.

For large networks the task of maintaining the total IP address scope may be a challenge in itself. It is useful to have an overview of all the subnets in operation, and whats more, how full they are, i.e. how many machines do they contain. NAV introduces a tabular view that gives an excellent overview on a single page:

This tool is quite simple and only useful if you use the NAV service monitor to an extent. It displays all servers and services in a matrix showing operational status.

As mentioned the report system is higly configurable, you can alter the configuration file report.conf. In NAV 3.4 we will strengthen the means of editing reports by adding support for local reports, see Task SMJ3.

The NAV reports are made based on the report.conf configuration file. You can expand this file with new reports as you like. Each report is in essence an SQL-query to the database (with some limitations). It is easy to make hyper links from data in the report to other reports or elsewhere.

An example report is given, this is the router port report:

gwport {
$sql= "
 SELECT netbox.sysname, gwport.ifindex, gwport.interface, module.module,
        gwport.link, gwport.speed, prefixcount, metric, netbox.netboxid,
        gwportid, gwport.portname, n2.sysname AS otherbox, swport.interface AS remoteif
 FROM netbox
 JOIN module ON (netbox.netboxid=module.netboxid) 
 JOIN gwport ON (module.moduleid=gwport.moduleid) 
 LEFT JOIN (SELECT gwportid, COUNT(gwportid) AS prefixcount
                 FROM gwportprefix
                 GROUP BY gwportid) tempaggr1 USING (gwportid)
 LEFT JOIN netbox AS n2 ON (gwport.to_netboxid=n2.netboxid)
 LEFT JOIN swport ON (gwport.to_swportid=swport.swportid)
";
$title = "Router ports";
$hide = "netboxid,gwportid";
$name_sysname="Router";
$name_interface="Interface";
$name_gwip="IP address";
$name_speed="Mbps";
$name_portname="Description";
$name_prefixcount="#prefix";
$name_otherbox="Connected to";
$name_remoteif="Remote if";
$order_by="sysname,ifindex";
$url_sysname="netbox?sysname=$sysname";
$url_module="modules?sysname=$sysname&module=$module";
$url_prefixcount="gwip?sysname=$sysname&ifindex=$ifindex";
$url_otherbox="netbox?sysname=$otherbox";
$url_remoteif="swport?b1.sysname=$otherbox&s1.interface=$remoteif";
}

The syntax of report.conf is:

Each report is enclosed within brackets:

      	r1{
              ...
              }

This report is seen as https://your_nav/report/r1

Further explanation of the report.conf syntax: