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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / License usage reports
Microsoft Dynamics CRM (Archived)

License usage reports

(0) ShareShare
ReportReport
Posted on by JGoforth 80

I am trying to pull data on the number of times a user logs into the CRM during a specified time period.  Is this something I can pull on my own or does it have to be developed?

I am extremely surprised that I do not see a 'Last Logged In' date on the user's record/profile.

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Karth Profile Picture
    Karth on at

    There are no specific reports as such. If you are using on-premise version of CRM, you can develop one using the IIS log.

    Below is the link to one such post which describes how to develop a Usage Report using the IIS logs

    blogs.msdn.com/.../crm-usage-reporting-unleashed.aspx

    If you are not keen on developing one, you could look at the option of enabling the ‘User Audit’ from the Audit Settings (Settings Auditing Global Audit Settings Audit Settings).

    Once you have set this up, you can view the Audit summary by navigating to the Audit Summary View and using filters to look for the data. Unfortunately, this wouldn’t provide you any sort of export feature for you to construct reports even in Excel.

  • Suggested answer
    Hosk Profile Picture
    Hosk on at

    You could turn on the audit log for users, this will give you some of the information you need.  The other methods involve quite a lot of work I'm afraid

    The other solution would be to make a report using SSRS reports

    This person created a solution

    community.dynamics.com/.../crm-usage-report.aspx

  • Luism Profile Picture
    Luism 125 on at

    CRM doesn't expose the last access attempt of a user (actually we don't store this info in the database), so we can't build a report based on standard data.

    Unless you enable auditing, CRM will only record the modifications done to a record, not the time when the user just read that record.

    Hence, as the data is not in the database, we cannot achieve what you propose in a standard way.

    Custom coding is your only way.

    Kind regards

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans