Tuesday, November 11, 2014
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]
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.
Friday, March 7, 2014
Thursday, February 6, 2014
http://blogs.msdn.com/b/mcsuksoldev/archive/2012/11/02/azure-access-control-services-creating-a-custom-identity-provider.aspx
http://blogs.technet.com/b/meamcs/archive/2011/12/19/securing-wcf-services-with-custom-wif-sts-a-step-by-step-guide.aspx
http://bitblits.wordpress.com/2011/08/01/implementing-windows-identity-foundation-wif-into-azure-using-appfabric-acs/
http://msdn.microsoft.com/en-us/library/gg328483.aspx
http://blogs.perficient.com/microsoft/2010/12/sign-into-sharepoint-2010-with-facebook-using-a-custom-sts/
https://github.com/manoj-kumar1/auth-against-crm-using-STS
--
Monday, January 6, 2014
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
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, February 11, 2013
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.
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, December 19, 2012
Monday, December 10, 2012
Wednesday, November 7, 2012
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
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/
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
Inversion of Control and Dependency Injection
http://www.c-sharpcorner.com/UploadFile/db2972/inversion-of-control-and-dependency-injection/
Wednesday, March 28, 2012
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
Subscribe to:
Posts (Atom)