ICON : how to link VQ to agent target

[Gui75]

Hi guys.

It should be a very easy question and it seems to be a mess.
I use ICON 7.6.

I want to get the agent target of a VQ.
A joint between G_VIRTUAL_QUEUE table and G_CALL table does not provide the result as I can have the same callid associated to many targets (when routing on no answer for example).
I tried a joint between G_VIRTUAL_QUEUE and G_PARTY (using callid and targetdn). But it does not work, when using multisite routing, targetdn is filled with the number of the ERP...) instead of the endpoint of the target.

I am afraid I will have to do some PLSQL and compare the timestamps.
Or I will use statserver tables.

I wondered how Genesys did handle this in Infomart.

Any idea is welcome!