Forum Topic

Thanks for your participation and contribution.


Back to AWS

Athena Queries with Time Internval

Post a reply
743 views
i90runner1
i90runner1

Athena Queries with Time Internval

SELECT * 
FROM cloudtrail_logs_aws_cloudtrail_logs
where eventsource ='kinesisvideo.amazonaws.com'
and eventname='DeleteSignalingChannel'
and eventtime >  to_iso8601(current_timestamp - interval '12' hour) 
order by eventtime desc
limit 1000

1-1 of 1

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.