V11 SP8
Loading...

Limiting User Access to Report Data

You can limit the report information that users see by including some additional lines in both built-in queries and custom queries. When you include these lines, users who view the report will see data only from the CommCell clients that they have access to.

Before You Begin

  • To create data sets, build reports, manage reports, and deploy reports to the dashboard, your CommCell user account requires a role with the following permissions: Add Report, Delete Report, Edit Report, Execute Report, Add Datasource, Delete Datasource, Edit Datasource, Query Datasource.
  • Your CommCell user account must have an association with the CommCell entity.

For more information on users, permissions, and associations, see User Administration and Security - Overview.

Procedure

  1. On the Web Console for the Private Metrics Reporting Server, click Reports.

    The Worldwide Dashboard appears.

  2. From the navigation pane, click Configuration > Reports, and next to the Report Name under Actions, click Edit.
  3. On the Dataset tab, select the main data set for the report and click Edit .
  4. In the Query For Table Data box, add lines that query from the UMUsers table, as shown in the following example:

    select C.name, C.net_hostname from APP_Client C, UMUsers U 
    where  dbo.isClientVisible(U.id,c.id, 0,0,0,0) = 1 
    and U.login = @sys_username

  5. Click Verify Query to test that the query works with user security.