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 [...]
Archive for the ‘SSRS 2008’ Category
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 »
