Thursday, October 2, 2014

Get MS CRM users login Audit MS CRM 2011

for this you must enable this in System Setting -> Auditing -> Enable Audit User Access.

you can see the details in Settings -> System -> Auditing ->Audit Summary View.
you can do filtering as per requirements.
but you can export the reports...

but to get the details, go SQL (do carefully)
run the query in Orgname_MSCRM DB and you can change as per requirement and filter...

select MAX(a.CreatedOn) as lastlogon, UserIDName
from Audit a
group by UserIdName
order by lastlogon desc