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 

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 

      • gesgin's avatar
        gesgin
        Helper I
        7 years ago

        I guessed so :)

         

        Thank you again for your support v-qiuyu-msft