find Missed events on SQL query

[Harold]

Hi, I am trying to make a query that shows all events (whether those are failed, missed or successful). I tried to use a query joining summary (for bytes backed up) and events tables but I realized that the missed ones are not being recorded on the events table.

Any ideas on how to have the complete view on that info?

 

[gruening]

Hello,
i hope to find you well.
Would you be please so kind to give us an example of your query and a missing event ?
It might so happen that the Event is just to old and no longer resides in the event table.

regards

 

[Harold]

Thank you, it was a misundestanding from my side. I was using the actual_start in the where clause but obviously this event did not happen so it did not have any actual_start, changing to scheduled_start made the trick.