Last user login through SQL

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Last user login through SQL

Hi Ben,

Thank you for your time.

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

Regards
Verified answer

Ben Thompson 6,350 on at

Like (0)

Report

RE: Last user login through SQL

The browser information isn't passed from the server to the database - so the information you want sadly isn't available.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Last user login through SQL

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
gdas 50,085 on at

Like (0)

Report

RE: Last user login through SQL

Hi,

Check this article -

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