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)

Find the date of latest connection

(0) ShareShare
ReportReport
Posted on by

Hi,

Is it possible to find in CRM database the date of latest connexion of user and if not, is it a smart way to find it ?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Aiden Kaskela Profile Picture
    19,696 on at
    RE: Find the date of latest connection

    Hi,

    It sounds like you're looking for the created on date of the most recent Connection record for some user. If that's the case, you can get it in Advanced Find by querying for Connection records where the to or from user is { the user }, and include Created On as a column.

    When you get your results, sort by Created On and the most recent one will be at the top of the list.

    Here's a screenshot of the query I just wrote to do that. If I misunderstood, let me know and I'll take another shot at it. If this helps, I'd appreciate if you would mark this as the verified answer.

    Thanks,

      Aiden

    connection-query.png

  • VITALTH Profile Picture
    on at
    RE: Find the date of latest connection

    I tired what you suggest but I think there is a misunderstood.
    I tired with myself ("Connected from" is me et "Connected to" is me) and I get no record.

    Actually I thoughht that connections (as Entity) is when you put the Action of connect to a record to another to find it easier.

    It is not what I want : I want the last connection to the website (the CRM website) of each user.

  • Verified answer
    Rajkumar Rajaraman Profile Picture
    on at
    RE: Find the date of latest connection

    you enabled auditing you can access audit summary report

    Refer the following thread:

    community.dynamics.com/.../156708

  • Suggested answer
    VITALTH Profile Picture
    on at
    RE: Find the date of latest connection

    Tanks a lot Rajkumar : that solve my problem.

  • Aiden Kaskela Profile Picture
    19,696 on at
    RE: Find the date of latest connection

    Good suggestion - I never would have guessed that was the goal.

  • Rajkumar Rajaraman Profile Picture
    on at
    RE: Find the date of latest connection

    Thanks Aiden....

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans