Hi everyone, Just want to get some opinions on Splunk cloud vs on prem. Originally when we first started using splunk we were on prem. This was all going fine and then the director decided to move to cloud due to being sold the whole deal about speed and not having to look after Splunk so much.  As time has gone by i have found cloud to be quite restrictive (especially when it comes to scripted inputs and app creation) and its getting annoying have to raise a case constantly for splunk to do something. Would be good to hear some opinions from yourselves about both sides?  ... View more

I am trying to calculate the difference between 2 times which have been converted to strftime but the duration is not working and i think its to do with min and max stats. I have the below:   mysearch | stats count by Location Action Type a_rid _time | stats list(Action) as action, list(Type) as type, list(_time) as time by Location a_rid Action | eval times=strftime(time,"%H:%M:%S") | eval total=mvzip(times, type) | mvexpand total | makemv total delim="," | eval value1=mvindex(total, 0) | eval value2=mvindex(total, 1) | stats min(value1) as begins, max(value1) as ends by Location a_rid | eval duration=ends-begins   I get the below results   n Location a_rid begins ends 1 AssetRepository 63d71f3f-4a6c-4447-9c37-828062493f68 09:23:53 09:23:53 2 ContributionRepository 63d71f3f-4a6c-4447-9c37-828062493f68 09:23:54 09:23:54 3 FinancialSummaryController 63d71f3f-4a6c-4447-9c37-828062493f68 09:23:53 09:23:54   This all works apart from the duration where it doesnt appear. Can you advise if there is another way round this to get the duration to work? ... View more