How can I link Jobs table to QueueItems table in Orchestrator DB?

Hi all,

We have some on-prem clients who are looking to get some analytics by cloning their Orc DB and connecting to BI Solutions. I have been exploring the architecture of the DB.

Is there any way to link queues and jobs table? I want to understand which processes from the jobs table are going into which queue? Not sure if anyone has tried doing this before.

Thanks!