I have a requirement to get the details of last login date and time of a user but I do not want the list of users which are created by system. Please Help me with the fetch XML query for System User entity .
Not Fullname as SYSTEM , I want 'records which are created by SYSTEM' ...This I need to exclude .
Hi,
Your condition should be as below
Fullname does not eq SYSTEM And
Fullname does not eq Integration User
Hi Anonymousssss,
Use Fetch XML Builder in XRM Tool Box to play with this query.
If I answer your question then please mark it as verified.
Let me know if I can provide you with more details.
Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../
@abdul Thanks for your quick response . It is related to audit history . So we are trying to do this way below :
<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="systemuserid" alias="sysid" groupby="true" />
<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>
The response of this fetch XML is that we are able to track the login of normal users along with the SYSTEM users .
But we do not want SYSTEM Users , what could be the condition in link entity , in this case??
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156