Break the Shackles of your CRM Environment!

SQL Queries Version 1 Get Privilege by Role name select priv.*  from Privilege priv join RolePrivileges rolePrivileges on (rolePrivileges.PrivilegeId = priv.PrivilegeId ) join Role role on (rolePrivileges.RoleId = role.RoleId) where role.Name = 'system administrator'  Get the Users By RoleName select sysuser.FirstName,sysuser.DomainName,sysuser.AccessMode, sysuser.ActiveDirectoryGuid,sysuser.CALType, sysuser.* from SystemUser sysuser join SystemUserRoles userRoles on (userRoles.SystemUserId = sysuser.SystemUserId ) join Role role on (userRoles.RoleId = role.RoleId ) where role.Name ='system administrator'  and sysuser.AccessMode=0 and sysuser.CALType=0 and sysuser.IsDisabled=0 Get All Privilege By Role with formatting SELECT DISTINCT FilteredRole.name, EntityView.PhysicalName AS [Entity Name], EntityView.IsCustomEntity AS [IsCustom], displayname.Label as[Entity Display Name] , CASE Privilege.AccessRight WHEN 1 T...

Which method will you apply to get related records of an entity record?  Could we get it using service.retrieve? Probably you cannot... It will return single record but you may not get related records. So how do you get it  You can utilize Retrieverequest for this purpose. You can pass Relatedentity query as part of retrieve request which will return related entities as part of the response.  Let us see some sample if you want one specific incident record with its notes you can get it in a single server call. Retrieve Method Retrieve method used to get specific record by Id C# public override Entity Retrieve (             string entityName,             Guid id,             ColumnSet columnSet ) Parameters entityName Type:  Str...

Hi Looking for a data management solution in CRM? Every body knows, if active data load is less, the transactions will process faster. But probably the purging policy of customer for data may not allow you to remove or delete history data. :-( May be you will reach some situation where we cannot achieve better performance after doing all technical/hardware changes in CRM and infrastructure level. In  such situation, this approach may help you. Here is the basic idea.  Below items has to take care: 1.        Keep the same GUID & Created on dates for integrity 2.         Sync Customization Changes in Original entity to duplicate Entity I    We are in the process of making this tool. I will post as per its progress.... Welcome your input             Thanks. Great Day Ahead!