This entry was posted on Friday, April 24th, 2009 at 1:58 pm and is filed under Customizations, Dynamics CRM 4.0. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
CRM Acceptance Reporting – IIS, SQL, and SSRS
I got this idea from the Microsoft CRM team blog and their guest blogger David Jennaway. The idea of acceptance and user reporting for CRM is really basic, but it provides a trackable way to determine if users are accessing the system. Here is the article.
http://blogs.msdn.com/crm/archive/2009/04/08/crm-usage-reporting-unleashed.aspx
A couple things that i found in the article to ‘tweak’ was defiantely adding a couple check constraints onto the SQL log table that you will be using this for. In my case there are quite a few users generating activity and that would be a very large file. Thank goodness for sql table compression in 2008 right… we will see.
If you haven’t created a check constraint before it is really easy, and you will save your tables from a bunch of useless rows of data. Here is a quick example below.
USE [CRMACCEPTANCE]
ALTER TABLE [dbo].[inetlog] WITH NOCHECK ADD CONSTRAINT [CK_inetlog_username] CHECK (([username]<>‘MEDTECH\scribe’))
This is basically because i use scribe integration that is always writing rows into the database and these could cause significant storage use during the period of a month.
Leave a Reply
You must be logged in to post a comment.
