MSCRM Log Files

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.
TwinkeToesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

preitmeyerCommented:
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,
Paul
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.