Splunk Query

[i_am_manish]

If i have n numbers of router in my index  and i want to know the current status of router if its connected or failed , if its is failed i need to show the router number of the failed router how to display the router number instead of router count , what query i should write  

[ITWhisperer]

| stats latest(status) as status by router
| where status="failed"

[isoutamo]

Can you give some sample data (please use </> when you post it)?