Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Report don't work with custom chart
I great dataset to search phrase with the source ip and time but when i try to generate report it appear no matching data also i test the dataset and it work.
select from_dtime(dtime) as timestamp, ipstr(`srcip`),Hostname, keyword, count(*) as requests from $log where $filter and keyword is not null group by ipstr(`srcip`),dtime,hostname,keyword order by requests desc
kindly help
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please as alias for ipstr(`srcip`), otherwise chart can not determine correct data column.
select from_dtime(dtime) as timestamp, ipstr(`srcip`) as SourceIP,hostname, keyword, count(*) as requests from $log where $filter group by SourceIP,dtime,hostname,keyword order by requests desc