Dynamics 365 CRM相关SQL查询

获取实体选项集数据

//查询选项集值
select Value as name , AttributeValue as id  from
 CPEDev_MSCRM..StringMap where AttributeName='选项集字段' and ObjectTypeCode=
 (select ObjectTypeCode from CPEDev_MSCRM..EntityLogicalView where LogicalName='实体名称')

//模拟用户查询
DECLARE @binUserGuid VARBINARY(128)
DECLARE @userGuid UNIQUEIDENTIFIER
SET   @userGuid = 'C8AC73D8-35B4-E911-B803-005056B6907F'
SET @binUserGuid = CAST(@userGuid AS VARBINARY(128)) 
SET context_info @binUserGuid 

select * from Filteredtec_deal

//获取已安装CRM产品密钥
SELECT [NvarCharColumn] AS CRMLicenseKey,ColumnName FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S