With the information from both and research, I found the answer that I was looking for:
| stats values(host) as host
| eval host="(".mvjoin(host,",").")"
| nomv host
|eval description=host." host have failed"
the results gave me what I was looking for: (host1,host2,host3....) host have failed
the stats command made the host a multivalue field, the mvjoin allowed the commas between, and the nomv took away the multivalue and made it a normal field.
Thanks for ideas. Appreciate the time from your busy schedules.
... View more