Thank you. Exactly what i was looking for.

Hi Darrell,

To add on to this, you'll also be interested in dbo.search_activity. search_activity_log only has information for completed instances, whereas search_activity has information on running instances. When instances complete, their data moves from search_activity to search_activity_log.

Similarly, the search_activity_messages and search_activity_messages_log tables follow the same rules, but contain information on messages logged by activities during their run.