INNER JOIN dbo.Webs ON Roles.SiteId = Webs.SiteId AND Roles.WebId = Webs. I am trying to build an application to add users to our LDAP and need to populate all our specific values however I don't have the specific property names to populate. INNER JOIN dbo.Webs ON Roles.SiteId = Webs.SiteId AND Roles.WebId = Webs.Id If there is a code snippet that displays just the available properties of a user object, this would be sufficient. INNER JOIN dbo.Roles ON RoleAssignment.SiteId = Roles.SiteId AND RoleAssignment.RoleId = Roles.RoleId INNER JOIN dbo.Perms ON Perms.SiteId = RoleAssignment.SiteId AND Perms.ScopeId = RoleAssignment.ScopeId INNER JOIN dbo.UserInfo ON RoleAssignment.SiteId = UserInfo.tp_SiteID AND UserInfo.tp_ID = RoleAssignment.PrincipalId , CASE WHEN UserInfo.tp_DomainGroup>0 THEN UserInfo.tp_Login ELSE NULL END AS, NULL AS, Roles.Title AS RoleTitle, Roles.Description, Roles.PermMask, UserInfo.tp_title SELECT Perms.ScopeUrl,UserInfo.tp_Login As Account, CASE WHEN UserInfo.tp_DomainGroup>0 THEN NULL ELSE UserInfo.tp_Title END AS Username I found this SQL from the below link and edited it a little. Will tell you who has access to the library documents and what level permissions they have. The below SQL is what I used to get a list of the Library documents, the permissions assigned, and the user they are assigned to whether they are in active directory user or not. I found the answer on my own looking at the SharePoint database tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |