Can you list all LDAP users in Web Reports?

Reporting
1

(imported topic written by Luke.Foelske)

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?

2

(imported comment written by cstoneba)

same question here.

3

(imported comment written by bxk)

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