Topic
2 replies Latest Post - ‏2013-05-28T20:54:18Z by bxk
Luke.Foelske
Luke.Foelske
5 Posts
ACCEPTED ANSWER

Pinned topic Can you list all LDAP users in Web Reports?

‏2013-05-01T15:33:44Z |

We would like to start using using LDAP for Web Reports accounts.  The problem we have though is that we need to be able to track all users that will be using Web Reports.

Currently, only local accounts are listed under User Management. Is there a way to view all LDAP users as well?

  • cstoneba
    cstoneba
    182 Posts
    ACCEPTED ANSWER

    Re: Can you list all LDAP users in Web Reports?

    ‏2013-05-15T19:38:04Z  in response to Luke.Foelske

    same question here.

  • bxk
    bxk
    1 Post
    ACCEPTED ANSWER

    Re: Can you list all LDAP users in Web Reports?

    ‏2013-05-28T20:54:18Z  in response to Luke.Foelske

    I'm rather sure there isn't a way inside Web Reports. It's a well needed feature.

    However, if you have access to the Web Reports database (BESReporting), you can use this query.

    SELECT     dbo.USER_NAMES.LoginName, dbo.ROLES.Name
    FROM         dbo.USER_NAMES INNER JOIN
                          dbo.ROLE_USER_ASSIGNMENTS ON dbo.USER_NAMES.UserID = dbo.ROLE_USER_ASSIGNMENTS.UserID INNER JOIN
                          dbo.ROLES ON dbo.ROLE_USER_ASSIGNMENTS.RoleID = dbo.ROLES.ID
    WHERE     (dbo.USER_NAMES.IsADUser = 1)
    ORDER BY dbo.USER_NAMES.LoginName, dbo.ROLES.Name 

    If you've granted permission using LDAP security groups, then the most you can get from the database is the Group's SID.

    SELECT     dbo.ROLE_GROUP_ASSIGNMENTS.GroupSID, dbo.ROLES.Name
    FROM         dbo.ROLES INNER JOIN
                          dbo.ROLE_GROUP_ASSIGNMENTS ON dbo.ROLES.ID = dbo.ROLE_GROUP_ASSIGNMENTS.RoleID