I am trying to figure out how to remove duplicates in a custom perfmon counters data that is exported to Splunk.
We have a custom perfmon counter implemented for a service, which reports response time of a service when ever it is called. Otherwise, it will be returning the same old data from the last service response until the new request is served. The same service is hosted on multiple hosts and all the host report perfmon data.
I am trying to find the average by removing all the consecutive duplicates by host and get an average.
Since we are sending data to Splunk every 1s from all the hosts, this is how the data in the Splunk is represented (as per my knowledge). See below. In this case, the above search is not removing the duplicates.