Tech Support > Microsoft Windows > Windows CRM > Where can I grab user longin activity history
Where can I grab user longin activity history
Posted by ConSol IT Team on January 16th, 2008


CRM3 Admin question:
How can I find the times a user has either logged in with their outlook
client or using the web client.
I can run a simple activity report on this user, but that does not show me
login times for either client.
I need client to server linkage times and which client this person was
working from.
A simple activity report will not do!

Will I have to create a custom SQL query or can I simply do this from adv
reporting?
What SQL Table in the CRM database would hold this data login data?

Thank for your time.

Posted by uMar Khan on January 17th, 2008


Hi,
I am afraid MS CRM dont provide any functionality for such Audit and dont
even provide any programming interface to develop such solution. You will
need to think out of the box to develop some kind of soution which can achive
your desired results or atleast some of them.
The best source of information is the IIS Logs, which can record each
request sent to CRM. MS have a tool that allows parsing of these logs with
SQL queries

http://www.microsoft.com/technet/scr...r/default.mspx


Something interesting;

https://www.microsoft.com/downloads/...displaylang=en

--
uMar Khan :: MS CRM MVP
CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/de...file/umar.khan


"ConSol IT Team" wrote:


Similar Posts