Using a Customized Dataset

[MikeyMike]

Hi there, I have successfully created a customized dataset that works perfectly when I click the ' test' button. Problem is, I' m not sure how to get this dataset to run in a report. I have placed it into a chart and referenced the dataset. I then put the chart into a report but when the report runs, no data is returned. Help. Thanks,

[L_FTNT]

As far as I can see, you' ve followed the right steps. It should work for you. It may be helpful to post your dataset query here and also your chart configuration. BTW, which version of FAZ you are on?

[MikeyMike]

Dataset Log Type: Traffic. No variables select `hostname`, sum(coalesce(`rcvdbyte`,0)+coalesce(`sentbyte`,0)) as total_bytes from $log where $filter and (coalesce(nullifna(`user`), `srcip`)=' USER1' ) group by `hostname` order by total_bytes desc Chart Category: Traffic Dataset: the one referenced above Resolve hostname: enabled Show First 100 Data type: raw Column1: Column2 Header: hostname total_bytes Data Binding: hostname total_bytes *user1 is the name of the user I want to report on FAZ300D

[hzhao_FTNT]

Your dataset and chart config are OK for me. What' s your FAZ version? If you are using FAZ 5.0.7 or above, you need use ipstr(`srcip`) instead of `srcip`. BTW, suggest to remove user filter from dataset and apply it in report or chart filter.

[AtiT]

Hi MikeyMike What is the FAZ version and which type of graph you are using?: table,bar,pie,line. Try the table it should always work.

[MikeyMike]

Firmware Version: v5.0-build0232 (GA Patch 4) and i' m using table

[hzhao_FTNT]

Hi MikeyMike, I tried your dataset and chart config on FAZ-VM64 B232, they worked OK, please see my attached screenshot. Since you can see results on data test console, but no report output, this could be hcache problem. Please clean your hcache in CLI and try again: dia sql remove hcache Regards, hzhao_FTNT

[MikeyMike]

Hi hzhao_FTNT, I have no idea what hcache is. Before I run this command, are there any side effects that I should be made aware of?

[hzhao_FTNT]

hcache tables in DB are automatically created in back end in order to increase the sql query speed. If you remove hcache, the report generation time will be longer than usual for the first time, but the perfomance will be back to normal after that.

[MikeyMike]

Cleared htables successfully. When I run the report now, I see " Processing item" for a quick second then that' s it. I don' t see the Report listed or being generated in the " Latest Reports" list. It' s as if the report isn' t running at all.