MSCRM Log Files

Posted on 2004-11-16
Last Modified: 2013-11-24
Is there anyway is MSCRM you can see what has been done throughout the day (what meeting etc have taken place) in the log files (or would you need to create a Crystal Report in order to see this information?) Thanks.
Question by:TwinkeToes
    1 Comment
    LVL 6

    Accepted Solution

    There is a log file of who has logged into the system, and also the event log will show errors and W3C (world wide web services) errors and logs... however, the information in the log for the W3C is not very detailed, just more of a "user DOMAIN\Username logged in at 11\18\2004 12:04:01" kinda stuff....  in order to see what has actually taken place during the day, Id reccomend using the Activity Report in Crystal Reports. See what Activities have been completed for the day etc. I have never personally used Crystal for that, but I am sure it is possible and also the best way to do so. As far as using SQL is concerned, the StateCode = 1 value in the dbo.Account view should show you what was completed or just use the "ModifiedOn" column also in the dbo.Account view to see who has worked on stuff for that day, and run the report daily against the:
    AccountBase, ContactBase, InvoiceBase, ActivityBase tables.
    That should give you a more general look at what has gone on.
    If you want a sample SQL Script give this a try on your Account view:
    SELECT name, PrimaryContactIdName, Address1_Line1, Address1_Line2, Address1_City, Address1_StateOrProvince, Address1_PostalCode, OwnerIdName, ModifiedOn from dbo.Account WHERE ModifiedOn ='todaysdate'

    Run that against the Organization_Name_MSCRM database in Query Analyzer.
    Good Luck,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now