Hi everyone, Good day! I would like to ask about my search query below. index="myIndex" source IN(*MyLogs*) host=server* | append [search "Missing process" | eval myTime = _time | eval myHour=strftime(_time, "%H") | eval myMinute=strftime(_time, "%M") ] | search ((myHour>=7 AND myMinute>=31) AND (myHour<=14 AND myMinute<=59)) And this is my use case: How can I retrieve search event from 7:31AM to 4:29PM from my search query? Everytime I tried using the query above, I was able to retrieve some results if I use something like this | search ((myHour>=7 AND myMinute>=31) AND (myHour<=14 AND myMinute<=59)) But if I changed it to something like this | search ((myHour>=7 AND myMinute>=31) AND (myHour<=14 AND myMinute<=29)) I can no longer see any results. It seems that I do have some issues in assigning the minute parameters on this search query. But I'm not sure how to fix it. Will you be able to provide some insights on how can I achieve my use case above? ... View more

Hi everyone! I'm fairly new to Splunk. I just wanted to ask about the feasibility of my use case and how can I make it work. Use case: I have a PowerShell script that runs every week that checks the status of my services on my list of servers remotely. After verifying the status of each service, it'll then return the results in the form of CSV file. Assuming that CSV file is already on-boarded to Splunk, I want to search it using a search query in Splunk and then create a dashboard based on the recent pull of data. Will this be possible? If yes, do you have links that I can use so that I can just follow on how can I achieve my use case? Sample CSV file. Application,ServerName,Process,State AppA,ServerA,ServiceA,Running AppA,ServerA,ServiceB,Running AppA,ServerA,ServiceC,Running AppA,ServerA,ServiceD,Stopped AppA,ServerB,ServiceA,Running AppA,ServerB,ServiceB,Stopped AppA,ServerB,ServiceC,Stopped AppA,ServerB,ServiceD,Stopped ... View more