topic Folder-Based Security Information in Report Server

Folder-Based Security Information

gesgin — Tue, 18 Dec 2018 13:41:43 GMT

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

Re: Folder-Based Security Information

v-qiuyu-msft — Tue, 25 Dec 2018 08:45:07 GMT

Hi gesgin,

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

Best Regards,
Qiuyun Yu

Re: Folder-Based Security Information

gesgin — Tue, 25 Dec 2018 08:51:16 GMT

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"

Re: Folder-Based Security Information

v-qiuyu-msft — Tue, 25 Dec 2018 09:02:11 GMT

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

Re: Folder-Based Security Information

gesgin — Tue, 25 Dec 2018 09:08:41 GMT

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?

Re: Folder-Based Security Information

v-qiuyu-msft — Tue, 25 Dec 2018 09:18:01 GMT

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

Re: Folder-Based Security Information

gesgin — Tue, 25 Dec 2018 09:22:54 GMT

I guessed so :)

Thank you again for your support v-qiuyu-msft