Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gesgin
Helper I
Helper I

Folder-Based Security Information

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

1 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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-qiuyu-msft
Community Support
Community Support

Hi @gesgin,

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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"

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I guessed so 🙂

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.