Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to know in which queues a recording was sent ?

(0) ShareShare
ReportReport
Posted on by 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 ! =) 

  • LuHao Profile Picture
    LuHao 40,872 on at
    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 Profile Picture
    FrancoisT 188 on at
    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 Profile Picture
    LuHao 40,872 on at
    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".

    pastedimage1601631646243v1.png

    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.

    pastedimage1601631690170v2.png

    2. which kind of entity it was for

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

    pastedimage1601631767808v3.png

    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.

    pastedimage1601631859678v4.png

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

    pastedimage1601632026704v5.png

    Then set the workflow as follow.

    pastedimage1601632790381v6.png

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans