The above search will work for small instances or low volume scenarios. If you need a quick way to get the hosts and sources information separately:
| metadata type=hosts
OR
| metadata type=sources
For information over the last 24 hours:
| metadata type=hosts | eval diff=now()-recentTime | where diff < 86400 | convert ctime(*Time)
OR
| metadata type=sources | eval diff=now()-recentTime | where diff < 86400 | convert ctime(*Time)
If you need to find information for a different time range, modify the 86400 value to your desired time (in seconds).
Also, the first two above searches will give you a very fast and complete summary of all hosts and sources.
... View more