How to Enable/ Disable languages in Dynamic 365 Online?

Follow the below steps to Enable/ Disable languages in CRM Online,

Step 1: Goto Dynamics 365 -> Settings -> Administration. Click on Languages.


Step 2: Select the required Language to Enable/ Disable and Apply.

In this Example, I am going to Enable Language Hindi (India).

Select Enable or Disable Languages

Step 3: Click on Ok to Confirm Language Change.

Enable Language_Click Ok

Step 4: It will take some time to Enable/ Disable Languages.

Language Settings_Work in Progress

Step 5: Click on Personal Settings to see the Enable/ Disable Language changes.

Personal Settings

Step 6: Go to Languages Tab and see the newly added language. Select Hindi (India) to see the changes in CRM and click on OK.

Language Options in Personal Settingsjpg

Step 7: You can see the new language in CRM.

CRM in Hindi

Hope you learned a new thing today :):):)


QuickFindQueryRecordLimit exceeded. Cannot perform this operation in CRM

I am facing the below issue, when the user is searching for a Text in Contact’s Home Page grid view.

QuickFindQueryRecordLimit exceeded. Cannot perform this operation

Root cause: User is searching for a Text in Contact’s Home Page grid view and there are having more than 10,000 records.

Due to this limitation in CRM for Quick Find Search, CRM Platform is throwing this issue.

Solution: Goto Settings -> Administration -> System Settings

Change the Enable Quick Find record limits under Set up Quick Find to No and click on OK.

Quick Find Settings in System Settings

Now you can search the required Text without any issues.

Hope this resolves your issue.

FetchXML Formatter Online

With regards to my Post FetchXML Formatter Tool, Ashish created an online version of this Tool.

Click here and have a look at the FetchXML Formatter Online Version and it really helps as it can be accessed online by everyone from anywhere.

FetchXML Formatter Online Version

Really appreciate Ashish Vishwakarma’s effort in creating this Tool in Online Version.


How to get the System User last accessed CRM Application info using SQL?

Run the below query in SQL against the required CRM Organization to get the System User last accessed CRM Application details,

With CRMSystemUser
select Row_Number() Over(Partition by U.fullname Order By MAX(DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn)) desc, U.fullname desc) As Row_Num,
 U.fullname AS [FullName], U.DomainName AS [UserName], U.BusinessUnitIdName AS [BusinessUnitIdName]
,MAX(DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn)) [LastAccessAt]
INNER JOIN SystemUser U ON A.objectid = U.Systemuserid
WHERE Action= 64
U.fullname, U.DomainName, U.BusinessUnitIdName, U.Systemuserid

From CRMSystemUser
Where ROW_NUM = 1 
order by 
LastAccessAt desc


System User Last Accessed Information

Credits to My Friend Krishna Gowtham