Dynamics Community Forum Thread Details

How to get users list who doesn't logged in from past 3months in d365 CRM

Hello CU26030451-0,

To get a list of users who haven't logged into Dynamics 365 Customer Service (or any Dynamics 365 environment) in the past three months, you'll need to use a combination of tools and techniques. Here's a breakdown of the process:

1. Using the SystemUser Entity and Audit Logs (Recommended):

Understanding the Approach:
- The SystemUser entity stores user information.
- The audit logs track user login activity.
- You'll need to query these logs to find users with recent login timestamps.

Steps:
1. Access the Audit Logs:
  - Go to Settings > Auditing > Audit Summary View.
  - You can filter the audit logs by "User Access Audit" events.
2. Use Advanced Find or FetchXML:
  - For more complex queries, use Advanced Find or FetchXML.
  - FetchXML Example (to get login activity):
  - <fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">
    <entity name="audit">
    <attribute name="userid" />
    <attribute name="createdon" />
    <order attribute="createdon" descending="true" />
    <filter type="and">
    <condition attribute="action" operator="eq" value="65" /> <condition attribute="createdon" operator="on-or-after" value="[Date 3 months ago]" />
    </filter>
    <link-entity name="systemuser" from="systemuserid" to="userid" alias="user">
    <attribute name="fullname" />
    <attribute name="internalemailaddress"/>
    </link-entity>
    </entity>
    </fetch>
  - Replace [Date 3 months ago] with the actual date.
  - This query will give you all the users that have logged in within the last 3 months.
3. Find Users Not in the Login List:
  - Export the list of users from the SystemUser entity.
  - Either export the results of the fetch xml query, or use the web api to get the results.
  - Compare the two lists to identify users who are in the SystemUser list but not in the login activity list.
  - You can do this in Excel or using a scripting language.
4. Web API (Programmatic Approach):
  - If you need to automate this process, use the Dynamics 365 Web API.
  - You can use the web api to query both the audit and systemuser entities, and then use code to compare the results.

2. Power Automate (For Automation):

You can create a Power Automate flow to automate the process:
1. Get Recent Logins: Use the "List rows" action with the Audit entity, filtering for "User Access Audit" events within the last 3 months.
2. Get All Users: Use the "List rows" action with the SystemUser entity.
3. Compare Lists: Use "Compose" actions and expressions to compare the lists of users.
4. Send Notification: Use the "Send an email (V2)" action to notify administrators of the users who haven't logged in.

Important Considerations:

Auditing Enabled: Ensure that auditing is enabled for user access events.
Audit Log Retention: Be aware of your audit log retention policies. Older logs might be purged.
Permissions: You'll need appropriate permissions to access audit logs and user data.
Time Zones: Consider time zone differences when filtering by date.
Deactivated Users: Ensure you filter out deactivated users from the SystemUser list.
Performance: Large audit logs can impact query performance.

Key Recommendation:

Using FetchXML or the Web API to query the Audit and SystemUser entities is the most robust and accurate approach.
Power automate is great for automation of the process.

By following these steps, you should be able to get a list of users who haven't logged into Dynamics 365 Customer Service in the past three months.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak

Quick Links