Sunday, October 26, 2014

SQL query provides CRM 2011/2013 Security Role privilege options in Excel

more...

SELECT DISTINCT
FilteredRole.Name as 'Security Role Name',
EntityView.PhysicalName AS [Entity Name],
CASE Privilege.AccessRight
WHEN 1 THEN 'READ'
WHEN 2 THEN 'WRITE'
WHEN 4 THEN 'APPEND'
WHEN 16 THEN 'APPENDTO'
WHEN 32 THEN 'CREATE'
WHEN 65536 THEN 'DELETE'
WHEN 262144 THEN 'SHARE'
WHEN 524288 THEN 'ASSIGN' END AS [Access Level],
CASE PrivilegeDepthMask
WHEN 1 THEN 'User'
WHEN 2 THEN 'Business Unit'
WHEN 4 THEN 'Parent: Child Business Unit'
WHEN 8 THEN 'Organisation' END AS [Security Level]
FROM RolePrivileges
INNER JOIN FilteredRole ON RolePrivileges.RoleId = FilteredRole.roleid
INNER JOIN PrivilegeObjectTypeCodes
ON RolePrivileges.PrivilegeId = PrivilegeObjectTypeCodes.PrivilegeId
INNER JOIN Privilege ON RolePrivileges.PrivilegeId = Privilege.PrivilegeId
INNER JOIN EntityView ON EntityView.ObjectTypeCode = PrivilegeObjectTypeCodes.ObjectTypeCode
ORDER BY FilteredRole.name, [Entity Name]

Monday, August 18, 2014

Fetch-based report, Sandbox and TCP 808(rsProcessingAborted error when running custom reports)

Just a reminder, if you deploy a Dynamics CRM 2011/2013 on different servers, you need to allow the inbound TCP port 808 on the Windows Firewall Inbound Rules on the CRM application server, or change it to something meaningful to you.

Monday, December 30, 2013

Authenticate Office 365 Users with Microsoft Dynamics CRM Online

Just for the quick note Microsoft CRM Online has been changes this day to authenticate. Below I am posting code sample that will help many of us. the code only works for CRM 2011 online and Office 365 users/. Define Username and Password: private const String UserName = "xxx@jaxaracrm.onmicrosoft.com"; private const String Password = "xxxxx$";

Necessary Dynamics CRM Link

http://dynamicscrm2011.wordpress.com/tag/crm-2011-add-button-ribbon/
http://dynamicscrm2011.wordpress.com/tag/adding-a-tab-to-the-existing-ribbon/
http://msdn.microsoft.com/en-us/library/gg334341.aspx
http://gotcrm.blogspot.com/2012/12/business-intelligence-for-crm-2011-data.html

Monday, December 31, 2012

MVC Database Migration.

Add: Connection String:
In the Package Manager Console window at the PM> prompt enter "Enable-Migrations -ContextTypeName MvcMovie.Models.MovieDBContext".
In the Package Manager Console window, enter the command "add-migration Initial" to create the initial migration.
In the Package Manager Console, enter the command "update-database" to create the database and run the Seed method.

Wednesday, October 10, 2012

Backup and Restore SharePoint Sites using Power Shell:

Backup/Restore from one server to another or from one Site Collection to another (with PowerShell command)
In SharePoint 2010, PowerShell command Backup-SPSite is used for taking backup. you can get details of the command from the msdn link. The following command will backup the site collection ‘http://myserver’.
Backup Command: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak"
Restore Command for new site: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak"
Restore Command for existing site: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak" -force

Wednesday, September 26, 2012

Multi Tenant SaaS Application

http://msdn.microsoft.com/en-us/library/aa479086.aspx
http://www.devx.com/webdev/Article/44977
http://dba.stackexchange.com/questions/16745/handling-growing-number-of-tenants-in-multi-tenant-database-architecture
http://www.ibm.com/developerworks/webservices/library/ws-middleware/

Tuesday, September 4, 2012

Factory Design Pattern

http://www.c-sharpcorner.com/UploadFile/db2972/factory-design-pattern/

Inversion of Control and Dependency Injection

http://www.c-sharpcorner.com/UploadFile/db2972/inversion-of-control-and-dependency-injection/

Wednesday, March 21, 2012

Inventory Costing

http://publib.boulder.ibm.com/infocenter/sfsf/v9r1/index.jsp?topic=%2Fcom.ibm.help.prod.concepts.doc%2Fc_AverageCostingMethodInventoryCostingForDrop-ShipProducts.html