Skip to main content
Zilitonas
Zilitonas
Explorer
May 19, 2016
Question

Need sub-chart dataset name

  • May 19, 2016
  • 1 reply
  • 7679 views

Hi guys,

 

I need help with chart "Top 5 Users by Bandwidth". As we all know, this chart has dataset "utm-drilldown-Top-Users-By-Bandwidth" and a sub charts, which is called: Application Summary, Threat Summary, Traffic Summary, Web Summary. If I applies a filter on the report "Top 5 Users by Bandwidth" (example filter: dstintf=wan1), this filter does not work on a sub charters datasets. Filter only works on  dataset ""utm-drilldown-Top-Users-By-Bandwidth".

 

My question is: maybe someone you know the subcharts datasets names? 

 

If I knew the datasets name, then I'll try to find it in FortiAnalyzer configuration file and then I try to change dataset.

    1 reply

    awasfi_FTNT
    Staff
    awasfi_FTNT
    Staff
    May 19, 2016

    Hello,

     

    You may use the following command to figure out the sub-charts/datasets used by this chart:

    # execute sql-report run root 10005

    Where "root" is the default ADOM, 10005 is "User Report" ID.

    You can use "?" to list available reports:

    # execute sql-report run root ?

     

    Regards,

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    May 19, 2016

    Hi there, the filter issue you mentioned has been fixed in 5.2.7. For this special designed drilldown chart, even you know the dataset name, you still can not modify the sub chart setting. Please upgrade your FAZ. 

     

    Regards,

    hz

    Zilitonas
    ZilitonasAuthor
    Explorer
    May 20, 2016

    Hi,

    Awasfi_FTNT, thank you very much for the command. I have found the desired DataSet.

     

    Best Regards

    Terms & ConditionsAccessibility statement