Hi,
after a firmware upgrade, a custom dataset stop working:
select coalesce(nullifna(`user`),nullifna(`srcname`), ipstr(`srcip`)) as user_src,coalesce (nullifna(root_domain(hostname)),'other')as domain, sum($browse_time) as browsetime, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log where $filter and coalesce (nullifna(root_domain(hostname)),'other') is not null group by domain, user_src having sum($browse_time)>9 order by user_src asc, browsetime desc
The error is this:
ERROR: function sum(int4range[]) does not exist
LINE 1: ...ullifna(root_domain(hostname)),'other')as domain, sum(ebtime...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Can Anyone help me?
Thank's
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1732 | |
1105 | |
752 | |
447 | |
240 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.