Last user login through SQL

(0) Share

Report

Posted on by Community Member

Hi,

We have a 8.2 Dynamics CRM on premise solution. It's available by PC and Dynamics APP (iOS or Android)

Is there a way to check through SQL when it was the last time the user logon into the app?? We have a query to determinate when it was the last time they logon into the system but I'm not sure if it's a way to filter if they're accesing through PC or mobile device

Thank you as always!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Check this article -

www.mscrmsolution.com/.../User-Access-Audit-Get-Last-Login-Date-Time-for-CRM-User

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Goutam,

Thank you for your time, very useful article

I can get the latest connection date but I dont know how to filter if desktop (PC) access or Mobile app

Regards

Was this reply helpful? Yes No
Verified answer

Ben Thompson 6,350 on at

Like (0)

Report
Copy link

Link copied!

The browser information isn't passed from the server to the database - so the information you want sadly isn't available.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ben,

Thank you for your time.

Wasn't the answer I was hoping for but thank you for the information :)

Regards

Was this reply helpful? Yes No