Report: How to get the Affected Objects view of a JobQueue in a sql query?

Okay, found it, I don’t know how to do it through a SQL query, but to do it through the report interface you just have to click on "Resolve foreign Key" after selecting the BasisObjectKey in the Columns Section.

Do you know how to use group by with that interface? or count or substring or any other function? Or just understand how does parent query works...?

New Update, I didn’t manage to do a group by or a count or use any function, BUT (!), you can create a set of data in sql with everything you want, group by, count and so on and create another set of data with the interface that resolves the foreign key.

When you get your two sets of data, you save and you can then create a relation between your two sets though the dictionary tab by linked two UID (a join of a sort).

Not straight forward at all and I have no idea if I did the easiest possible I could do or if I somehow stumbled onto the most convoluted answer through sheer luck... 

You may want to check our video series about reporting in One Identity Manager on our official YouTube channel to catch some basics.

https://www.youtube.com/playlist?list=PL242czeZwlAkUZlAIuXZG2a3zdMBub9uz