介绍Dynamics 365的OrgDBOrgSettings工具

xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="OrgDBOrgSettingsTool.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </sectionGroup> </configSections> <applicationSettings> <OrgDBOrgSettingsTool.Properties.Settings> <setting name="OrgDBOrgSettingsTool_CrmService_CrmService" serializeAs="String"> <!--- Please change CrmServer to your Crm Server Name --> <value>http://CrmServer/MSCrmServices/2007/CrmService.asmx</value> </setting> <setting name="OrgDBOrgSettingsTool_CrmDiscoveryService_CrmDiscoveryService" serializeAs="String"> <value>https://disco.crm.dynamics.com/XrmServices/2011/Discovery.svc</value> </setting> <setting name="OrgDBOrgSettingsTool_SKU" serializeAs="String"> <!--- Possible values here are Online/Office365/SPLA/OnPrem --> <value>Office365</value> </setting> <setting name="OrgDBOrgSettingsTool_UserName" serializeAs="String"> <!--- Please change the value below to your email Id/User Name for Online / SPLA --> <value>admin@crm773088.onmicrosoft.com</value> </setting> <setting name="OrgDBOrgSettingsTool_Domain" serializeAs="String"> <value>crmdom</value> </setting> <setting name="OrgDBOrgSettingsTool_OrgServiceUri" serializeAs="String"> <value>https://crm773088.api.crm.dynamics.com/XrmServices/2011/Organization.svc</value> </setting> <setting name="OrgDBOrgSettingsTool_RegistrationEndPointUri" serializeAs="String"> <value>https://login.live.com/ppsecure/DeviceAddCredential.srf</value> </setting> <setting name="OrgDBOrgSettingsTool_Partner" serializeAs="String"> <!--- This is applicable only for Online --> <value>Crm.Dynamics.com</value> </setting> <setting name="OrgDBOrgSettingsTool_Environment" serializeAs="String"> <!--- This is applicable only for Online --> <value></value> </setting> </OrgDBOrgSettingsTool.Properties.Settings> </applicationSettings> </configuration>

然后使用PowerShell切换到解压目录后运行类似如下命令：

.\Microsoft.Crm.SE.OrgDBOrgSettingsTool.exe Retrieve /u org9936ebf2

输入密码，但是我这里报错如下，我才应该是SSL握手有问题，可能是一个BUG。

 

那我就不能更改了吗？这里介绍另外一个工具 seanmcne/OrgDbOrgSettings ，不想学习源码的话直接下载安装包，是一个托管解决方案，下载网址是：https://github.com/seanmcne/OrgDbOrgSettings/releases 。

下载完毕后导入到Dynamics 365 Customer Engagement实例中，打开可以看到类似下面的界面：

 

 我这里更改下 SkipGettingRecordCountForPaging 参数值(官方对这个参数的解释为Disables the record count query. This query is responsible for retreiving the total number of records returned for each view. This query can cause longer search times and may cause SQL timeouts or exceptions. False - Enables record depend on views. True - Disables record depend on views.)为True，如下：

 

 然后我去看下效果，发现视图显示数据的时候不会告诉我有多少条符合条件的记录了，当然这个如果返回的记录数大于5000条的话，也不会告诉用户具体多少条，若小于5000条则是准确的。

 

 下面是我不更改这个参数值得截图，可以看到会告诉用户有多少条记录符合筛选条件，当然超过5000条不会告诉具体数据，知会告诉你是 5000+。

 

可能我们有时候为了信息安全常改得另外一个参数是MaxRecordsForExportToExcel ，默认值是10万，可能会改成1万或者更少。

还有哪些参数可以改，请参考官方文档 OrgDBOrgSettings tool for Microsoft Dynamics CRM 我这里不再赘述。

 

介绍Dynamics 365的OrgDBOrgSettings工具

标签：ISE   excel   pps   src   输入密码   div   return   pow   lease