Forum Discussion

d_gosbell's avatar
d_gosbell
Super User
2 years ago
omnia_saleh wrote:

I can access alot of tables like catalog,Policies,Roles,Users but table event,history,subscription  has on data in ReportServer database in SSMS

Yes, they cannot block access to people that have high enough rights on the database server. But they do not support making changes to the tables or even querying them directly. It can cause blocking and interfere with the normal operation of Report Server.

omnia_saleh's avatar
omnia_saleh
Helper II
2 years ago

I want to see data in table  [Event] and [history] in ReportServer database  in sql server managemet studio when i do select on it dont retrive any data why althoughi can select from tables like catalog,Policies,Roles,Users

  • josef78's avatar
    josef78
    Memorable Member
    2 years ago

    Is not recommended use these undocumented tables directly. Use API access.

    But unformately, Event table is not log, these are records only for short time during PBI report refresh queuing. History table is only for history snapshots of paginated reports.