Forum Discussion

gesgin's avatar
gesgin
Icon for Helper I rankHelper 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 

6 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi gesgin,

     

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

     

    Best Regards,
    Qiuyun Yu 

    • gesgin's avatar
      gesgin
      Icon for Helper I rankHelper 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
        Icon for Community Support rankCommunity 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