Skip to main content
HeMan
New Member
January 31, 2020
Question

FortiAnalyzer Dataset - Traffic-History-By-Active-User

  • January 31, 2020
  • 0 replies
  • 2057 views

[size="4"]Hi All,[/size]

 

[size="4"]So I'm trying to use a dataset from the official Dataset Reference guide by Fortinet for FortiAnalyzer 6.0.6, but keep getting an error:[/size]

 

[size="4"]Dataset:[/size]

[size="4"]select $flex_timescale(timestamp) as hodex, count( distinct(user_src) ) as total_user from ###({{FGT_DATASET_BASE_TRAFFIC_BANDWIDTH_SESSION}})### t group by hodex order by hodex[/size]

 

[size="4"]ERROR: syntax error at or near "{"[/size]

[size="2"]LINE 7: ({{FGT_DATASET_BASE_TRAFFIC_BANDWIDTH_SESSION}}) t group b...[/size] [size="4"]Could somebody please shed some light on why this is happening even though the dataset is from their official document?[/size] [size="4"]I'd really appreciate it.[/size] [size="4"]Thanks.[/size]