Example t-sql style... There is an example in the SDK how to do this in C# code (Server\HowTo\CS\Entities\RetrieveSupportedMessages.cs)

In some scenarios you might not find your supported message but a workaround could be to set the Triggering Pipeline to Child Pipeline on the primary entity.

Use mydemo_MSCRM
Go

Select C.Name, A.SdkMessageFilterId, B.Name, A.PrimaryObjectTypeCode, A.IsCustomProcessingStepAllowed
From SdkMessageFilter as A
Inner join SdkMessage as B on A.SdkMessageId = B.SdkMessageId
Inner join MetadataSchema.Entity as C on A.PrimaryObjectTypeCode = C.ObjectTypeCode
And A.IsCustomProcessingStepAllowed = 1 Order by C.Name

Entity

Message

EntityCode

IsSupported

Account

Assign

1

1

Account

Delete

1

1

Account

GrantAccess

1

1

Account

Create

1

1

Account

ModifyAccess

1

1

Account

Retrieve

1

1

Account

RetrieveMultiple

1

1

Account

RetrievePrincipalAccess

1

1

Account

RetrieveSharedPrincipalsAndAccess

1

1

Account

RevokeAccess

1

1

Account

Merge

1

1

Account

SetState

1

1

Account

SetStateDynamicEntity

1

1

Account

Update

1

1

This posting is provided "AS IS" with no warranties, and confers no rights.