Update Rollup 6

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 release, see Microsoft Knowledge Base article 970148: Update Rollup 6 is available for Microsoft Dynamics CRM 4.0.

Important: This update is not necessary for Microsoft Dynamics CRM Online. All updates are installed automatically.

We recommend customers install the update rollup to keep your software performing at its best. Installing previous update rollups is not a requirement to installing the current rollup.

Read Full Post »

Access History of a CRM 4.0 Report

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 

ReportServer.dbo.Catalog C with(nolock) 

LEFT OUTER JOIN ReportServer.dbo.ExecutionLog  E with(nolock) ON C.ItemID = E.ReportID 

WHERE

 C.type=2

 

For those who want to deep dive on this Execution Log Reporting domain, please refer:

Using the Reporting Services Execution Log with CRM 4.0

Reporting Services Log Files

Auditing Report Execution using the ReportServer Database

Reading the Report Execution Log for CRM 4.0

 

Read Full Post »

11 ways to be a Happy Employee

Eleven little tips for you to be happy at the workplace:

1. Plan your week on Sunday night
2. Undertake activities that you are passionate about
3. Do not indulge in the blame game
4. Communicate more often in person
5. Know what is happening at Ur workplace
6. Participate in Organization-level activities
7. Have a hobby that keeps you busy and happy
8. Take up a sport
9. Keep yourself away from office politics
10. Wish and smile
11. Volunteer for some activity

Interested? Read More!

Food for thought: “The value of a man resides in what he gives and not in what he is capable of receiving.” – Albert Einstein

Read Full Post »