SELECT TOP 100

 [PrincipalObjectAccessId]

 ,[PrincipalId]

 ,[PrincipalTypeCode]

 ,[ObjectId]

 ,[ObjectTypeCode]

 ,[AccessRightsMask]

 ,[InheritedAccessRightsMask]

FROM

 [PrincipalObjectAccess] WITH (NOLOCK)

[Account].[AccountId] in

(

select  POA.ObjectId from PrincipalObjectAccess POA

join SystemUserPrincipals sup (NOLOCK) on POA.PrincipalId = sup.PrincipalId

where sup.SystemUserId = u.SystemUserId and

POA.ObjectTypeCode = 1 and

((POA.AccessRightsMask | POA.InheritedAccessRightsMask) & 1)=1

)

---Get the total number of shared records

SELECT COUNT(0) FROM PrincipalObjectAccess

--Get the total number of shared records grouped by Entity

SELECT  EV.NAME AS [ENTITY NAME],COUNT(POA.OBJECTTYPECODE) AS [RECORDS COUNT]

FROM PRINCIPALOBJECTACCESS POA

INNER JOIN ENTITYLOGICALVIEW EV ON EV.OBJECTTYPECODE = POA.OBJECTTYPECODE

GROUP BY EV.NAME

ORDER BY 2 DESC

--Get the total number of shared records grouped by User

SELECT  SU.FULLNAME AS [USER NAME],COUNT(POA.OBJECTTYPECODE) AS [RECORDS COUNT]

FROM PRINCIPALOBJECTACCESS POA

INNER JOIN SYSTEMUSER SU ON POA.PRINCIPALID= SU.SYSTEMUSERID

GROUP BY SU.FULLNAME

ORDER BY 2 DESC

--Get the total number of shared records grouped by Entity and User

SELECT  SU.FULLNAME AS [USER NAME],EV.NAME AS [ENTITY NAME],COUNT(POA.OBJECTTYPECODE) AS [RECORDS COUNT]

FROM PRINCIPALOBJECTACCESS POA

INNER JOIN SYSTEMUSER SU ON POA.PRINCIPALID= SU.SYSTEMUSERID

INNER JOIN ENTITYLOGICALVIEW EV ON EV.OBJECTTYPECODE = POA.OBJECTTYPECODE

GROUP BY SU.FULLNAME,EV.NAME

ORDER BY 1

SELECT DISTINCT name, objecttypecode

FROM [CRMORGDB_MSCRM].[MetadataSchema].[Entity]

ORDER BY name ASC 

select distinct

       case

           when POA.[PrincipalTypeCode] = 8 then

               'User'

           when POA.[PrincipalTypeCode] = 9

                and TEAM.[TeamType] = 0 then

               'Owner Team'

           when POA.[PrincipalTypeCode] = 9

                and TEAM.[TeamType] = 1 then

               'Access Team'

           else

               'Other'

       end                                       as 'PrincipalType'

     , coalesce(USERID.[FirstName], TEAM.[Name]) as PrincipalName

     , POA.[ObjectTypeCode]

     , ENTITY.[OriginalLocalizedName]

     , POA.[ObjectId]

     , POA.[AccessRightsMask]

     , POA.[InheritedAccessRightsMask]

     , POA.[ChangedOn]

     , POA.[PrincipalTypeCode]

     , POA.[PrincipalId]

from KYGF_MSCRM.[dbo].[PrincipalObjectAccess]            as POA

    left outer join KYGF_MSCRM.[dbo].[SystemUserBase]    as USERID

        on POA.[PrincipalId] = USERID.[SystemUserId]

    left outer join KYGF_MSCRM.[dbo].[TeamBase]          as TEAM

        on POA.[PrincipalId] = TEAM.[TeamId]

    left outer join KYGF_MSCRM.[MetadataSchema].[Entity] as ENTITY

        on POA.[ObjectTypeCode] = ENTITY.[ObjectTypeCode]

where POA.[PrincipalTypeCode] in ( 8, 9 )

      and POA.[ObjectTypeCode] = 2

      and POA.ObjectId = 'C84FBA58-8CCB-DF11-9176-02BF0AC9DF07';