web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Report on List of Active CRM Users and their Last Activity Date.

(0) ShareShare
ReportReport
Posted on by 2,171

Hi 

I'm trying to run a report to see a list of all active Microsoft Dynamics CRM user in our system. I want to see who has been assigned a CRM license and what date was their last activity (either creating a new record or modifying something in the CRM). This way I can evaluate which users aren't using the licenses fully so that I can redistribute their license to someone else in the organisation.

Could someone help in terms of what filter criterias, I'll need to run to get that report?

Kind Regards

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Biplab Singha Profile Picture
    on at
    RE: Report on List of Active CRM Users and their Last Activity Date.

    Unfortunately There is nothing available Out of Box that can fulfill all the requirement. But Custom you can create. Your can follow  community.dynamics.com/.../118506

    Mark this answer as Verified if it helps

  • MikeC282 Profile Picture
    2,171 on at
    RE: Report on List of Active CRM Users and their Last Activity Date.

    Thanks Biplab

    Really appreciate the article link and it's very helpful. One quick question. I had a look at the Organization insights Dashboard and it is indeed helpful in seeing CRM Activity.

    I am also looking for a more drilled down report, specially a list of users so I can filter a view on who haven't used the CRM in the last <time frame> so I can reallocate the unused user licenses to another person in the organisation.

    Any advice would be greatly appreciated.

    Kind Regards

  • Suggested answer
    Biplab Singha Profile Picture
    on at
    RE: Report on List of Active CRM Users and their Last Activity Date.

    Hi Mike,

    If you are in Latest Version of CRM online(8.1.0359) A good fit for you is Organization Insight Dashboard. Its shows the users Activity and adoptions in graphs.   The good article for this is https://community.dynamics.com/crm/b/innovatingoncrm/archive/2016/06/02/organization-insights-dashboard-metrics.

    For the licensing information you can Check Enabled user, disabled User and Disabled users Consuming CRM license View for the user

    Mark this answer as verified if this helps

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans