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 |
Main worksheet- everything links from this worksheet. |
|
Summary of folder and items in folder secruity. Summary security information is stored in the sheet. |
|
Worksheet showing the relationship between roles and task |
|
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. |
list of users in a group the group name is the part after 'grp-'. This works with nested groups. |
|
Worksheet showing the relationship between system roles and system tasks |
group information and screenshot