Hello,I need to design a report on VPN Remote IP countries. There is no
srccountry or similar field in the VPN event logs, so I wonder if the
Geo IP Location info is available in SQL as a table that can be queried
in a dataset.Alternatively, I wonder...
Hello,I had the one more unpleasant surprise after upgrading the
FortiAnalyzer to 7.4.5: several datasets that worked perfectly in 7.0.x
stopped working with strange syntax errors, not being valid anymore.
Also other datasets which were ok before, no...
Hello,After making a research regarding of the (im)possibility to make
it work, and some tests on FAZ 7.4.x, I wonder if this is feasible or
even in the roadmap. Apparently the log parsers can be assigned to a
device only if it is recognized as Forti...
Hello, thank you very much for your effort!I know that starting 7.4.x
the FortiGate adds the country information in the Event logs related to
VPN. My problem is that the FG has 7.2.x, and I was hoping that the FAZ
could have included into SQL the Geo...
In the meantime something deteriorated inside the box, because I now
receive validation errorMERGE: ERROR: relation "queries" does not exist
LINE 2: ...,q.dt as dt,q.dt-ins.tis as dif,q.dom as dom from queries
q,... ^but the dataset still runs fine:t...
In the meantime, something deteriorated, because even if the code is
unchanged, I get validation errorMERGE: ERROR: relation "queries" does
not exist LINE 2: ...,q.dt as dt,q.dt-ins.tis as dif,q.dom as dom from
queries q,... ^.Still, the sql-query-da...
With the following SQL code I have VALIDATION OK, the dataset runs fine
both in the GUI test run and from CLI exec sql-query-dataset, but I
still have 2 problems: 1) impossible to build a DrillDown-type Chart
because the Aggregation Column offers an ...
Hello Rosa Technocrat, and thank you for your interest in this
problem.The first error when I validate the exact same SQL code is
"ERROR: 'group by' or 'order by' clause is expected in hcache."Then I
tried the following codeDROP table if exists time_...
