Microsoft Dynamics 365 | Integration, Dataverse...

How to know in which queues a recording was sent ?

(0) Share

Report

Posted on by FrancoisT

188

Hello !

I'm trying to have a log of the entries & departures from the queues, in PowerBI. I have tried with the "audit" table, but it's not giving me enough info.
I can see when something was created in a queue, I think I can see when it was deleted, but I don't know which kind of entity it was for, and which queue it was for. So it's impossible to work with that. There must be more info in another entity, but which one ?

I see the number of the fields modified, in "attributemask", but I don't see the values anywhere.

Am I missing something ? Thanks in advance ! =)

All responses (3)

Answers (0)

LuHao 40,876 on at

Like (0)

Report

RE: How to know in which queues a recording was sent ?

Hi Francois,

Do you mean export Audit history of the Queue Item in the XRMToolbox?

If so, unfortunately there is currently no supported way to obtain audit data in Power Bi.

The only solution I can think of is to export the audit records to Excel in XRMToolBox, and then use this Excel as the data source of Power Bi.

If you don't do this, then as mentioned in my last answer, you have to create a custom entity to store the Queue Item data.

Or, as mentioned in my last answer, you have to create a custom entity to store Queue Item data.
FrancoisT 188 on at

Like (0)

Report

RE: How to know in which queues a recording was sent ?

Thanks for your answer. Indeed, that would work. It requires to create a new entity and workflows though. The audit of the QueueMember entity should have all the info recorded somewhere. If I use XRMToolBox, I can restore a queue member. So everything is available somewhere already (with XRMToolbox, I can see all the necessary info), without the need to recreate a similar info in a custom entity (which I would prefer of course).

Does anybody know where this info is available, and if PowerBI can access it?
Suggested answer

LuHao 40,876 on at

Like (0)

Report

RE: How to know in which queues a recording was sent ?

Hi Francois,

We can create a custom entity to store the deleted queue item information.

I create a new entity called "Queue item audit".

Here you need the values of two fields, one is which queue it was for, another is which kind of entity it was for. So I will create two fields to correspond to the two fields you need.

1. which queue it was for

New a lookup field of lookup type, select entity to Queue.

2. which kind of entity it was for

New a field of Option Set type, add some options. Here I just add 3 options.

The name of the original field of Queue Item entity is objecttypecode, you could refer to this field to make the options of the custom entity's field.

3. Then go to Settings > Processes to new a worklfow, select Queue Item entity, uncheck Run this workflow in the background.

Then set the workflow as follow.

Each type option is a conditional branch that creates one conditional branch each for all types, and the action of each branch is to create a custom entity record with the same type as the conditional branch.

Activate the workflow.

In this way, when the queue item is deleted, a corresponding custom entity record will be created and its information will be stored.