Skip to main content
ksm
ksm
New Member
April 4, 2016
Question

days for generating a report on FAZ 400C

  • April 4, 2016
  • 2 replies
  • 21383 views

Hi,

 

we have this kind of issues on our FORTIANALYZER since we have it, but actually it is extremly slow for generating reports, even very small ones. So It is difficult to understand. Generate a report can take until 14 days for 10 pages...

 

Could you telle me if there is any way to troubleshoot for one report how it has be made ?

 

Thanks in advance for the advices.

 

FAZ 400C

Logs /sec : often below the sustained Log rate of 200Actual Log insert time 14000 seconds. ( Working on a report for quite 3 days... )

Number of devices : 75 / 300 allowed

Gb / day : 2.41 / 15 Licensed

Firmware : v5.2.5-build3175 160119 (GA)

 

JS

    2 replies

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    April 4, 2016

    Please run below CLI during report running.

    dia log device

    dia test application fortilogd 2

    dia test application sqllogd 2

    get system report auto-cache

    exe sql-report list-schedule <adom-name>

    dia de en

    dia sql status sqlreportd

    dia sql status run-sql-rpt  (several times during report running)

    get sys performance

    exe top (several times during report running)

     

    Regards,

    hz

    ksm
    ksmAuthor
    New Member
    April 5, 2016

    Hi,

     

    thanks a lot for your answer, I will do all of that and will post a reply ASAP.

     

    JS

    ksm
    ksmAuthor
    New Member
    May 9, 2016

    hi hz,

     

    For me it is solved. I have had all my reports. And my 5 devices in a report group got me quick reports and not empty this time. I have to generalize the configuration.

     

    Thanks again !

     

    Cheers :)

     

    JS

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    May 9, 2016

    No problem. Good to know your issue has been resolved.

     

    Regards,

    hz

    Terms & ConditionsAccessibility statement