Recalculate Rollup Fields - Dynamics CRM 2015 Programatically (Plugin)

using Microsoft.Crm.Sdk.Messages;

      

CalculateRollupFieldRequest CRF = new CalculateRollupFieldRequest

                    {

                       Target = new EntityReference("ParentEntityName", ParentEntityNameID),

                        FieldName = "FieldName"

                    };

                  

 CalculateRollupFieldResponse response = (CalculateRollupFieldResponse)service.Execute(CRF);

Microsoft Dynamics CRM 2016 Release Overview - Video

CRM 2013/15 On-Prem - Last access date & time for CRM users

For getting a list of all last login date and time for all CRM users on Dynamics CRM (On-Premises), run below SQL script using SQL Server Management Studio :

SELECT SU.FullName
 ,SU.DomainName
 ,SUO.LastAccessTime
FROM SystemUser SU
INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] SUO ON SUO.CrmUserId = SU.SystemUserId
INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserAuthentication] SUA ON SUA.UserId = SUO.UserId
ORDER BY SUO.LastAccessTime DESC

Applying same Business Rule to several forms, not all forms

We can configure Business Rules to be used on all forms for an entity, or only on one form. If you want to apply a Business Rule to several forms, and not all forms, you must create a copy of the rule for each form,you can do this by opening the Business Rule and clicking Deactivate then Save As and entering a new name for the copy of the Business Rule and select the scope and active it.

And if you select all forms as the scope of a Business Rule, the rule will be applied to all forms (Main or Quick Create forms), and you can not select the scope for a rule to apply to the Quick Create form only!

Import Data Wizard for CRM 2015 Online Update 1 now supporting XLSX file format!

The Microsoft Dynamics CRM 2015 Online Update 1 encapsulates many new great features and improvements. One of such features is improved Import Data Wizard to support XLSX file format.

List of all custom fields names & types for any Custom Entity - Dynamics CRM On-Premises

For getting a list of all custom fields names and types for any Dynamics CRM (On-Premises) custom entity, run below SQL script using SQL Server Management Studio :

USE [CRMDatabaseName]

SELECT c.NAME
 ,t.NAME
FROM syscolumns c
INNER JOIN sys.types t ON t.system_type_id = c.xtype
WHERE id = object_id('CustomEntityTableName')
 AND c.NAME LIKE 'new_%'

Note : Replace new with your solution prefix  :)

          Remove (and c.name LIKE 'new_%') for getting all of custom and system fields.

List of supported languages by Microsoft Dynamics CRM 2015

#	Language Name	LCID
1	Arabic	1025
2	Basque (Basque)	1069
3	Bulgarian (Bulgaria)	1026
4	Catalan (Catalan)	1027
5	Chinese (Hong Kong S.A.R.)	3076
6	Chinese (PRC)	2052
7	Chinese (Taiwan)	1028
8	Croatian (Croatia)	1050
9	Czech	1029
10	Danish	1030
11	Dutch	1043
12	English	1033
13	Estonian (Estonia)	1061
14	Finnish	1035
15	French	1036
16	Galician (Galician)	1110
17	German	1031
18	Greek	1032
19	Hebrew	1037
20	Hindi (India)	1081
21	Hungarian	1038
22	Indonesian	1057
23	Italian	1040
24	Japanese	1041
25	Kazakh (Kazakhstan)	1087
26	Korean	1042
27	Latvian (Latvia)	1062
28	Lithuanian (Lithuania)	1063
29	Malay	1086
30	Norwegian (Bokmål)	1044
31	Polish	1045
32	Portuguese (Brazil)	1046
33	Portuguese (Portugal)	2070
34	Romanian (Romania)	1048
35	Russian	1049
36	Serbian (Cyrillic)	3098
37	Serbian (Latin, Serbia)	2074
38	Slovak (Slovakia)	1051
39	Slovenian (Slovenia)	1060
40	Spanish	3082
41	Swedish	1053
42	Thai	1054
43	Turkish	1055
44	Ukrainian (Ukraine)	1058
45	Vietnamese	1066