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
--
Roger Aas
Stord/Haugesund College