Update Rollup 6 for Microsoft Dynamics CRM 4.0 (KB 970148) Microsoft has released Update Rollup 6 for Microsoft Dynamics CRM 4.0. The update includes bug fixes and performance enhancements packaged together for easy deployment. Update Rollup 6 is available for all languages that are supported by Microsoft Dynamics CRM 4.0. For more information about this [...]
Archive for the ‘CRM 4.0’ Category
Update Rollup 6
Posted in CRM 4.0, Microsoft Dynamics, tagged KB 970148, Update Rollup 6 on August 28, 2009 | Leave a Comment »
Access History of a CRM 4.0 Report
Posted in Business Intelligence, CRM 4.0, SSRS, SSRS 2005, SSRS 2008, tagged Access History, Auditing Report Execution, Execution Log Reporting on August 25, 2009 | Leave a Comment »
The following code snippet can be used to get the access history of a MS Dynamics CRM 4.0 Report. SELECT C.Name ‘Report_GUID’ ,CASE WHEN ((PATINDEX(‘%CRM_FormatDate=%’, E.Parameters)- (PATINDEX(‘%CRM_FullName=%’, E.Parameters) + 14 )) > 0) THEN SUBSTRING(E.Parameters,(PATINDEX(‘%CRM_FullName=%’, E.Parameters)+13), (PATINDEX(‘%CRM_FormatDate=%’, E.Parameters)- (PATINDEX(‘%CRM_FullName=%’, E.Parameters) + 14 ))) END ‘UserName’ ,E.TimeStart ,E.TimeEnd ,E.Status FROM [...]
