User Access Audit Report Broken

(0) Share

Report

Posted on by Alex Spodkiewicz

We have a report we created a few years back based on a similar article to this one using FetchXML: https://www.concurrency.com/blog/march-2016/creating-an-audit-report-for-user-logins-in-dynami

It appears something has changed and the report no longer works. Has anyone experienced a similar issue and found a way to update the report so it will work again? I know there have been changes recently with auditing and wondered if an update has caused the problem.

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Hi Alex Spodkiewicz,

I have tested the Fetch XML query in the link you provided on my side and it could work fine. Have you tested it?

And could you share the Fetch XML query you used?

Was this reply helpful? Yes No
Alex Spodkiewicz 45 on at

Like (0)

Report

The fetchxml looks like this:

<fetch mapping="logical" aggregate="true" version="1.0′ >
<entity name="audit" >
<attribute name="createdon" alias="LastLoginDate" aggregate="max" />
<filter>
<condition attribute="operation" operator="eq" value="4′ />
</filter>
<link-entity name="systemuser" from="systemuserid" to="objectid" alias="su" link-type="inner" >
<attribute name="fullname" alias="fn" groupby="true" />
<attribute name="domainname" alias="dn" groupby="true" />
<attribute name="userlicensetype" alias="ult" groupby="true" />
<attribute name="accessmode" alias="am" groupby="true" />
<attribute name="isdisabled" alias="id" groupby="true" />
</link-entity>
</entity>
</fetch>

It was working up to about a month ago its to get the last login for each user.

Thanks

Alex

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi Alex Spodkiewicz,

I tested this fetchxml and get the error:

And I found a thread refer to this, this is because Audit has got migrated from SQL to Cosmos DB and haven't found any alternative.

Pull last login date/time from audit entity (old fetchxml query no longer working) - Dynamics 365 General Forum Community Forum

You could raise a ticket to contact Microsoft Support.

Was this reply helpful? Yes No