Hi, i am using the below relevance query to fetch the action results , having issue to on the specific time as data is almost 2GB in size , so looking out an option to get the data with some hour and minutes combination.
(IDs of Actions of it, Names of Issuers of Actions of it, Names of Actions of it, States of Actions of it, Times Issued of Actions of it, Names of Computers of it, Operating Systems of Computers of it, IP Addresses of Computers of it, Last Report Times of Computers of it, Detailed Status of it,Status of it,Names of member actions of actions of it ) of results whose (((Name of Action of it as lowercase starts with “2016p1”))) of bes actions whose ((start date of it = (“24 sep 2016”) as date) and (end date of it = (“24 sep 2016”) as date) and (hour_of_day of end time_of_day of it <= 21) and (hour_of_day of start time_of_day of it >= 20))