45
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.
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.
You could raise a ticket to contact Microsoft Support.
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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (