Dashboards & Visualizations

Tracking state changes for a day

jeromehenry906
New Member

Here is some background on what I am trying to accomplish, I have 3 separate devices that will be in any of 6 stages of activities throughout a day. I have a base search that will tell when a device changes states, what state it changes to, and what time this occurs. I would like to have a chart or graph that will tell me how long each device was in each state for a given day.  I can't put my search or data on the forum. 

Labels (3)
0 Karma

diogofgm
SplunkTrust
SplunkTrust

If your looking at 1 device at a time, given that you have a table like  "_time_of_change | previous_state | new_state " you can use the "| delta _time_of_change" command to calculate the duration of the previous_state. Make sure you use the time as epoch.

 

------------
Hope I was able to help you. If so, some karma would be appreciated.
0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>