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
go

Regards,
yes.sudhanshu

3 comments:

  1. Perfect !! Thank you very much! ! visit more info Windows live mail support also Call +1-800-231-4635 (Toll Free).

    ReplyDelete
  2. welcome Mr Alex. glad that it helped you,.

    Yes.Sudhanshu

    ReplyDelete
  3. Thanks for sharing helpful information . i think it's very useful for us. good job keep it up visit:- Windows live mail help also Call +1-800-231-4635 (Toll Free).

    ReplyDelete