As Per below screenshot, i getting results the difference between last week host and this week host count. But i want list of the difference servers in splunk search. How can i retreive the list of all 23 servers which arr having diffrence from last week count to this week count.
Try using
| stats dc(host) as Total_host, values(host) as Hosts by Week_Status
You'll also need to modify the stats commands that follow so they don't discard the Hosts field.
The last two lines of the query should be deleted because they add no value.
Try using
| stats dc(host) as Total_host, values(host) as Hosts by Week_Status
You'll also need to modify the stats commands that follow so they don't discard the Hosts field.
The last two lines of the query should be deleted because they add no value.
Yes, i get the solution. Thanks for the help