Identifying tables for queries

Question

Hi I have a newbie question.
Let me give some background and then ask the question. I pull information from jobs in Azure for leadership. I would go to a batch account, go to jobs and find the job(s) I need.
Each job has 2 tasks:

1. One with the start and end time of each job(usually need the job duration as well)
2. second task to notify on job completion (success or failure)
   I want to create a KQL query that gets the jobID, job start time, job end time and calculate the duration. I will probably have to do a join statement since i believe the data does not reside in one table. The problem I have is identifying the tables that have the data I need.

Answer 1

@Gbolahan Akeem Rajifuja
I wanted to apologize that this question was not answered earlier.

I believe you can get all this information from the service log event Task complete event. You should be able to query the event in Log Analytics.

Hope this helps. If you still have questions let me know and I will work to resolve them.

-------------------------------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.