[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]
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1749 | |
1114 | |
765 | |
447 | |
241 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2025 Fortinet, Inc. All Rights Reserved.