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
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
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.
you enabled auditing you can access audit summary report
Refer the following thread:
community.dynamics.com/.../156708
Tanks a lot Rajkumar : that solve my problem.
Good suggestion - I never would have guessed that was the goal.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
UllrSki 2
SC-08081331-0 1