I am trying to create a custom report that gives me the details on
changes made to our FortiGate firewalls. I have created the following
dataset: Detailed-Firewall-Changes -select * from $log-event where
$filter and type='event' and subtype='system' ...
OK, I copied the sql statement as written, still no results listed. I
then did what you recommended and cleared the hcache and still no
results get pulled into the report. Rather frustrating that I can see
the items in the dataset test, but not in th...
Here is the information you requested. Query:select devid, user, ui,
action, cfgpath, cfgobj, cfgattr, msg from $log-event where $filter and
type='event' and subtype='system' and cfgattr!='' order by itime desc
FAZ version: v5.2.2-build0706 150415FGT...
I made the changes to use the field names rather than the "*" in the
select statement. I also went into the chart and re-selected the
dataset, re-did the fields I want in the chart, and even re-added the
chart to the report and I still get "No matchi...
