This the answer, because the Em dash will cause this error. You can test it with the two following searches:
working:
| metadata type=hosts
| eval seconds_lag=(recentTime -lastTime)
| convert ctime(lastTime) as LastTime
| convert ctime(firstTime) as FirstTime
| convert ctime(recentTime) as IndexTime
| rangemap field=seconds_lag low=0-1800 elevated=1801-3600
| fields host,FirstTime,LastTime,IndexTime,seconds_lag,range
not working:
| metadata type=hosts
| eval seconds_lag=(recentTime -lastTime)
| convert ctime(lastTime) as LastTime
| convert ctime(firstTime) as FirstTime
| convert ctime(recentTime) as IndexTime
| rangemap field=seconds_lag low=0—1800 elevated=1801—3600
| fields host,FirstTime,LastTime,IndexTime,seconds_lag,range
Returns the error Error in 'rangemap' command: Invalid range: '0—1800'. '-' expected. because of the Em dash http://www.thepunctuationguide.com/em-dash.html
cheers, MuS
... View more