Nav version 3.0.0
"Toolbox -> Report -> Servers -> (Sort on) IP" gives me this error:
Servers Configuration error! The report generator is not able to do such things. ERROR: column "netbox.ip" must appear in the GROUP BY clause or be used in an aggregate function SELECT roomid,sysname,host(ip),catid,orgid,count(distinct category) as subcats,count(serviceid) as services,val as function,netbox.netboxid,prefixid FROM netbox LEFT JOIN service USING (netboxid) LEFT JOIN netboxcategory USING (netboxid) LEFT JOIN netboxinfo ON (netboxinfo.netboxid=netbox.netboxid AND netboxinfo.var='function') WHERE catid='SRV' GROUP BY roomid,sysname,host(ip),catid,orgid,val,netbox.netboxid,prefixid ORDER BY ip,roomid LIMIT 100 OFFSET 0
This does not happen with the other categories like routers, core switches and wireless that I have in NAV now.
- Roger