In this blog you can find: Useful and simple code snippets in the area of Dynamics CRM (T-SQL, PowerShell). Interesting topics about (TIBCO) Scribe Insight.

Saturday, July 11, 2020

Get Option Set values directly from the CRM database

USE CRM_MSCRM
GO
SELECT
    sm.AttributeValue
    ,sm.Value
FROM StringMap sm with(nolock)
    inner join EntityLogicalView el with(nolock) on
        sm.ObjectTypeCode = el.ObjectTypeCode
WHERE
    AttributeName = 'statuscode'
    AND LangId = 1033
    AND el.Name = 'Opportunity'
GO

No comments:

Post a Comment

MSMQ - Add user privileges to queues via PowerShell

In PowerShell, the Set-MsmqQueueACL cmdlet can be used to modify the access rights of queues. Sample - Add "FullControl" permissi...