Re: Interface History Custom Report

hzhao_FTNT · 11-12-2019

Report "last 7 days" doesn't include today's logs. Because $filter will automatically add device and time filter to your query, please make sure you have correctly set time period in report settings. You can use Today/This Week/This Month/This Year o...

hzhao_FTNT · 11-08-2019

Hi shaneboy, Because of the hcache, do not join $log with other tables.Try below query:select app, sum(case when dom=to_char(now(), 'YYYY-MM-DD') then bandwidth else 0 end) as today_bandwidth, cast(sum(bandwidth)/count(distinct dom) as decimal(18,0))...

hzhao_FTNT · 11-08-2019

Hi there, You can use filter family(srcip)=6 for ipv6 traffic.For example:select devid, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter and (logflag&1>0) and family(srcip)=6 group by devid order by bandwidth desc...

hzhao_FTNT · 12-05-2018

The JSON API reference is available in FNDN. Please visit https://fndn.fortinet.net for more info.

hzhao_FTNT · 11-30-2018

Currently we have 20 XML APIs on FAZ, and no plan to develop new XML APIs for now. Instead, we have many new JSON APIs, I would suggest you check JSON documents if need more functions.

User Statistics

User Activity

Re: Not Equal Results between Dataset and Report Chart

Re: Not Equal Results between Dataset and Report Chart

Re: Find all IPv6 address in logs

Re: What should be the FortiAnalayzer API WSDL URL?

Re: What should be the FortiAnalayzer API WSDL URL?

Re: Interface History Custom Report

Re: Interface History Custom Report

Re: Interface History Custom Report

Re: users visiting a particular website

Re: Not Equal Results between Dataset and Report C...

Re: Only "Super_User" profile has access to report...

Re: RE: LDAP Query

Re: DataSet Query for Weekday

Re: XML API SearchCriteria Syntax

Fortinet Training Institute

KCS