Month: March 2017

How to Enable/ Disable languages in Dynamic 365 Online?

Arun Potti CRM, Microsoft Dynamics 365, Microsoft Dynamics CRM 2016 , , , ,

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

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

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

Arun Potti CRM, crm 2011, CRM 2015, CRM 2016, Microsoft Dynamics 365, Microsoft Dynamics CRM 2016, MS CRM 2013, ms crm 2015 , ,

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

Arun Potti CRM, crm 2011, CRM 2015, CRM 2016, Microsoft Dynamics 365, Microsoft Dynamics CRM 2016, MS CRM 2013, ms crm 2015 , ,

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?

Arun Potti CRM, crm 2011, CRM 2015, MS CRM 2013, ms crm 2015, SQL

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

With CRMSystemUser
As
(
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]
,DATEPART(YYYY,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))AS [Year]
,MAX(DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn)) [LastAccessAt]
FROM AUDIT A
INNER JOIN SystemUser U ON A.objectid = U.Systemuserid
WHERE Action= 64
GROUP BY
U.fullname, U.DomainName, U.BusinessUnitIdName, U.Systemuserid
,DATEPART(YYYY,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
,DATEPART(MM,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
,DATEPART(DD,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
)

Select 
CRMSystemUser.FullName,
CRMSystemUser.UserName,
CRMSystemUser.LastAccessAt
From CRMSystemUser
Where ROW_NUM = 1 
order by 
LastAccessAt desc

Output:

System User Last Accessed Information

Credits to My Friend Krishna Gowtham