How do I create a chart of Windows host status

[stevenbutterwor]

I would like to create a visualisation of my Windows hosts and their status over time.

e.g. something like this:

sourcetype=WinHostMon | timechart values(Status) by Host

Ideally I would like to see a table or graph that shows the up/down status of each host over a week

[P_vandereerden]

Better late than never:

Assuming your windows host monitoring polls the hosts at regular intervals and logs a success or failure, and if you want a simple line chart with values 1 for up and 0 for down in some interval (say 10 minutes), you could do this:

sourcetype=WinHostMon
|  eval status_num=if(Status="up",1,0)
|  timechart span=10m min(status_num) by Host