How to use tstats to show unique list of hosts for a specified index?

[russell120]

Hi, I'm using this search: | tstats count by host where index="wineventlog" to attempt to show a unique list of hosts in the wineventlog index.

But I get this error: Error in 'tstats' command: Invalid argument: 'index=wineventlog'

How do I form my search to use tstats (not stats) to return a unique list of hosts within a specific index? (in this case, wineventlog)?

[ddrillic]

What about - | tstats count where index="wineventlog" by host? works for me ...

[adamblock2 · Accepted solution]

Try the following: | tstats count where index="wineventlog" by host.

[russell120]

Perfect, thanks bro.