Hi Team,
I am trying to get output of Action Status with Start and End Date, time in YYYY-MM-DD , HH:MM:SS format. Currently i am using below query, so how i can define the start date and end date in "((end date of it >= (“2018-10-01 00:00:00) as date) and (end date of it <= (“2018-10-30 23:59:59”) as date))” this format:-
(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 “2018”))) of bes actions whose ((start date of it = (“03 oct 2018”) as date) and (end date of it = (“05 oct 2018”) as date)and (hour_of_day of end time_of_day of it <=20) and (hour_of_day of start time_of_day of it >=0))