Databases Reference
In-Depth Information
ReportServer Database
The ReportServer database is the main store for data in Reporting Services. It contains all report defini-
tions, report models, data sources, schedules, security information, and snapshots. There are a series of
tables for each functional area. The database schema is open and generally easy to follow.
Updating or querying these database tables is not recommended, but an understanding of how they are
arranged should give you a better understanding of how Reporting Services works.
The following table lists some of the tables in the ReportServer database and their related functions.
Table Name
Function
Resources
Catalog
Contains report definitions, folder locations, and data source
information.
DataSource
Contains individual data source information. Data source informa-
tion is maintained separate from report definitions to ensure it is not
overwritten when reports are republished.
Security
Users
User name and security ID (SID) information for authorized users.
Policies
Listing of references to different security policies.
PolicyUserRole
Association of users/groups, roles, and policies.
Roles
List of defined roles and the tasks that the role can perform.
Snapshots and Snapshot History
SnapshotData
Information used to run an individual snapshot, including query
parameters and snapshot description.
ChunkData
Stores the report snapshots. Snapshots contain both report definition
and data. There are also certain records containing rendered snapshot
output for quicker rendering.
History
Stores a reference between stored snapshots and the date they were
captured.
Scheduling and Report History
Schedule
Contains information for different report execution and subscription
delivery schedules.
ReportSchedule
Association between a given report, its execution schedule, and the
action to take.
Subscriptions
Listing of individual subscriptions, including owner, parameters, and
delivery extension.
Notification
Subscription notification information such as date processed, last
runtime, and delivery extension.
Search WWH ::
Custom Search