Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

MSCRM_CONFIG.dbo. p_GetCrmUserId Function

  • 1.  MSCRM_CONFIG.dbo. p_GetCrmUserId Function

    Posted Apr 01, 2020 05:26 PM
    Does anyone know if this function is used to authenticate all CRM Users or is it just used for SSRS reporting authentication??

    Reviewing Google, almost all topics revolve around this being used in SSRS reporting.

    This is a CRM 2016 (v8.2.1) #CRM2016 on-premise environment...

    We are seeing this being executed a bunch in our database and causing some blocking and looking for the source of the call...

    Thanks

    ​​

    ------------------------------
    Jay Barnhart
    Centric Consulting
    Cincinnati
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: MSCRM_CONFIG.dbo. p_GetCrmUserId Function

    MICROSOFT MVP
    Posted Apr 02, 2020 04:20 AM
    Hello Jay,

    I can't answer your question as to the usage of this function but I'd recommend you raise a Microsoft Support call if you're having issues with it. This is an internal function and any modifications to it or internal tables related to it are likely to be unsupported.

    Also install any updates that might be available for 8.2 (tested in a non-production environment first) because fixes are obviously also delivered in those updates. It could be that your issue is resolved already by one of the fixes.  Microsoft Support will probably ask you to do this anyway.

    Best regards,
    Andrew.

    ------------------------------
    Andrew Bibby
    Dynamics 365 Project Adviser & Microsoft MVP
    Evesham, UK
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role