CrmBuzz work in progress!

Update Rollup 3 for Microsoft Dynamics CRM 2011 is available

2011-07-28T13:34:00.001-07:00

Update Rollup 3 for Microsoft Dynamics CRM 2011 is available. you can find the download on the following location:

http://www.microsoft.com/download/en/details.aspx?id=26912

Rollup Summary information

http://support.microsoft.com/kb/2547347

The build number of the update packages for the following components is 5.0.9688.1244.

The file names for the 32-bit versions of the update rollup packages are as follows:

CRM2011-Client-KB2547347-LangID-i386.exe
CRM2011-Router-KB2547347-LangID-i386.exe
CRM2011-Bids-KB2547347-LangID-i386.exe
CRM2011-Mui-KB2547347-LangID-i386.exe

The file names for the 64-bit versions of the update packages are as follows:

CRM2011-Server-KB2547347-LangID-amd64.exe
CRM2011-Client-KB2547347-LangID-amd64.exe
CRM2011-Mui-KB2547347-LangID-amd64.exe
CRM2011-Router-KB2547347-LangID-amd64.exe
CRM2011-Srs-KB2547347-LangID-amd64.3exe

Highlights of Update Rollup 3

· 69 total fixes

· 24 customer-escalated issues (see KB for details)

Abe.

Performance Toolkit for Microsoft Dynamics CRM 2011

2011-07-19T10:21:00.001-07:00

My customer was reminding me about server performance, looking for answers I got internally (Microsoft) the Performance Toolkit for Microsoft Dynamics CRM 2011, the following is the external (partner) link for the Performance Toolkit

http://dynamics.pinpoint.microsoft.com/en-us/applications/performance-toolkit-for-microsoft-dynamics-crm-2011-12884915630

Press the “Try It” button on the left column, to login and download.

Application Description

“The Performance Toolkit is designed to formalize performance testing for Microsoft Dynamics CRM 2011. This Toolkit is highly customizable and can be used by Microsoft Dynamics CRM partners and customers to collect performance data to support decisions related to their CRM 2011 on-premise deployments”

Abe.

Building a CRM 2011 Virtual Machine–Video Walkthrough

2011-07-19T10:09:00.001-07:00

Working on a customer site, I was in the need to create a Virtual Machine to test a CRM 2011 deployment, I was looking on my notes and found the following link on how to create a CRM 2011 Virtual Machine step by step, I was able to get my VM up and ready faster than me looking to my old notes.

Hope you enjoy the following post from Girish Raja and video form David Yack.

http://blogs.msdn.com/b/girishr/archive/2011/01/26/building-a-crm-2011-virtual-machine-video-walkthrough.aspx

Abe.

SCOM Management Pack for Microsoft Dynamics CRM 2011 is now Available…

2011-07-14T06:27:00.001-07:00

The System Center Monitoring Pack for Microsoft Dynamics CRM 2011 enables you to administer the Microsoft Dynamics CRM 2011 application in Microsoft System Center Operations Manager (SCOM) 2007 SP1 and System Center Operations Manager 2007 R2

By managing these Microsoft Dynamics CRM components in Operations Manager, the administrator can respond quickly to critical events and key performance indicators, and take action to prevent service outages, reduce the resolution time for alert conditions, and increase the overall availability and performance of the Microsoft Dynamics CRM system.

Monitoring Pack and Documentation is available on the following location

http://www.microsoft.com/download/en/details.aspx?id=26795

To import the Monitoring Pack:

On a System Center Operations Manager server, open the Administration console.
Right click on the Management Packs node, and then click Import Management Packs.
Follow the instructions to import the Management Pack.

Abe.

Returning My Blog to Bloggers and retake blogging..

2011-07-12T12:56:00.001-07:00

The time has come to return and continue blogging about Microsoft Dynamics CRM 4.0 and now 2011.

I had been busy working on many projects, some of these are really interesting others are not so much but learning some good tricks and code among other things.

New information and categories will be added to my blog for MS CRM 2011 and PowerShell scripting is now the new way to get thinks done, I will be posting small scripts I been using to deploy CRM 4.0 and 2011 on Windows Server 2008 R2 (64bit) servers.

Keep connected I will be providing more information soon.

Abe.

Purging rows on Princiapl Object Access

2007-02-09T14:34:00.000-08:00

[Disclaimer:All postings are provided "AS IS" with no warranties, and confer no rights.]

Purging some tables on Crm is simple as calling the delete service and make sure that everything continues running properly, but when you have more than 10 million rows on one table (PrincipalObjectAccess) how do you will be able to take the delete process on stages?

[MS Crm support response: There is an un-supported option that you could try if you want to get rid of all sharing that is currently setup in CRM. You could directly update the PrincipalObjectAccess table and set the AccessRightsMask and InheritedAccessRightsMask columns to 0. Then we have a deletion service that will go through and automatically clean up that table. This is not technically supported, but if you want to remove all sharing this could be an option that you could do.

Ok that is awesome, but how to identify the rows that are not in use or ready to be deleted.

This is one of the Sql scripts to get the total of rows ready to be deleted and terminated

declare @totalRows int
declare @ToDelete int
declare @ToDeleteMarked int

SELECT @totalRows = count( * )
FROM PrincipalObjectAccess (nolock)

SELECT @ToDelete= count( *)
FROM PrincipalObjectAccess (nolock)
where AccessRightsMask = 0
and InheritedAccessRightsMask > 0

SELECT @ToDeleteMarked= count( *)
FROM PrincipalObjectAccess (nolock)
where AccessRightsMask = 0
and InheritedAccessRightsMask = 0

Select @totalRows as TotalRows,
@ToDelete as ToDelete,
(@totalRows - @ToDelete) as RemainingRows,
@ToDeleteMarked as ToDeleteMarked

Using the previous script will give you the totals only the following script is the one that will update your columns and marked the rows for deletion..

[IMPORTANT: Make sure that you have SQL database backups before trying this and know that you may have to restore your databases if you run into issues. Also this can ONLY be done if you want to remove ALL sharing. There is not a way to leave some sharing intact. ]

SELECT top 500000 *
into #TempPOAFROM
PrincipalObjectAccess (nolock)
where AccessRightsMask = 0
and InheritedAccessRightsMask > 0

update PrincipalObjectAccess
set InheritedAccessRightsMask = 0
where rowguid in (Select rowguid from #tempPOA)

drop table #TempPOA

After finishing marking all the rows for deletion, now you can run the delete service, stop the service (not required) then run the following dos command

C:\Program Files\Microsoft CRM\Server\bin\CrmDeletionService.exe -runonce

[NOTE: -runonce = Clean up database right now.]

we schedule the deletion service to run only once a day, on a business downtime, this process will keep your tables purged and on optimal conditions

regards,
Abe Saldaña