Akif's profileAkif - akif.tech.aePhotosBlogListsMore ![]() | Help |
|
September 09 How to find all shares in MS CRM 4While implementing CRM at one of our clients, I was asked to provide them a report of all shares by one user. I was sure it must have to do something while displaying all items views in CRM. So I used SQL Profiler to find exact query used by CRM to fetch all items on which a user has access and from them extract the part which returns all shares for a user. This is what I got and it is really simple to find shares :)
select POA.* from PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId
where sup.SystemUserId = '6130B308-2692-DE11-A9EF-000C29F4EE9D' and POA.ObjectTypeCode = 4200 and
(( POA.AccessRightsMask|POA.InheritedAccessRightsMask) & 1) = 1TrackbacksThe trackback URL for this entry is: http://aakif.spaces.live.com/blog/cns!C8D5222E0E2125AE!575.trak Weblogs that reference this entry
|
|
|