Show/Hide Toolbars

SSRS Security Manager

Navigation: Security Manger > Audit Report

Overview of Excel File

Scroll Prev Top Next More

The Excel audit file has various worksheets depending on which security options were selected.

 

The main sheet in the excel file is the Summary worksheet.

 

There are hyperlinks in the worksheets that allow you to move between sheets and see further information about security. There is a back button in cell a1 in all sheets except the summary sheet. This will go back to either the Summary sheet or the Item security sheet.

 

 

 

below are a list of the worksheet explanation:

 

 

 

Worksheet Name

Description

Summary

Main worksheet- everything links from this worksheet.

Item Security

Summary of folder and items in folder secruity. Summary security information is stored in the sheet.

Task Role Mapping

Worksheet showing the relationship between roles and task

Sys User Role

shows relationship between system roles and system users and groups.

#....    (begins with #)

used to give detail security information. the number after the # links back to the Item security worksheet.

grp-... (begins with grp-)

list of users in a group the group name is the part after 'grp-'. This works with nested groups.

Sys Task Role Mapping

Worksheet showing the relationship between system roles and system tasks

 

 

group information and screenshot