• Thanks Jeff. The only thing which still i am thinking is how frequently I need to run this query as a job.

    With that query it provides me max start time info. But, if i schedule the job for every 15 mins, I may get logs of last minute and I will miss the logs of 14 minutes...

    I am not sure if there is a way in auditing where it directly updates one of the SQL Table with new changes?