Forum Discussion

gesgin's avatar
gesgin
Helper I
7 years ago
Solved

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
folder
Roles
Security
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    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 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
7 years ago

Hi gesgin,

 

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

 

Best Regards,
Qiuyun Yu 

gesgin's avatar
gesgin
Helper I
7 years ago

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's avatar
    v-qiuyu-msft
    Community Support
    7 years ago

    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's avatar
      gesgin
      Helper I
      7 years ago

      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's avatar
        v-qiuyu-msft
        Community Support
        7 years ago

        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