Folder-Based Security Information

[gesgin]

Hi,

Is there a table/view in report server database where we can list the authenticated users per each folder and report in report server url? (except ExecutionLog3 view)

Thank you

[v-qiuyu-msft]

Hi @gesgin,

You can check [dbo].[ExecutionLogStorage] table in report server database. 

Best Regards,
Qiuyun Yu 

[gesgin]

Thank you for your answer @v-qiuyu-msft

I know this table that shows the report click information. But I need a data like "A has access to X folder / Y report"

[v-qiuyu-msft · Accepted solution]

Hi @gesgin,

Please run below query against report server database: 

select C.Path, C.Name,ELS.UserName from [dbo].[Catalog] C join [dbo].[ExecutionLogStorage] ELS on C.ItemID=ELS.ReportID

Best Regards,
Qiuyun Yu 

[gesgin]

Thank you for the query @v-qiuyu-msft

If the user has access to a specific report but never executes it before, does this script returns data about this report?

[v-qiuyu-msft]

Hi @gesgin,

Based on my research, there is no record if the report is not executed. You can do a small test on your side as well. 

Best Regards,
Qiuyun Yu 

[gesgin]

I guessed so 🙂

Thank you again for your support @v-qiuyu-msft