Martin Griffiths
asked on
Definition of report server database tables in ssrs 2005
I'm trying to write a report showing all report subscriptions etc being run by SQL agent jobs. Looks like I can get the information I require from the ReportSchedule table in the report$server database. However, I seem to be getting multiple entries and I seem to be getting snapshots mixed in with subscriptions. An identifier seems to be the ReportAction field or Type in the Catalog table. I'm unsure though of the definition of these two fields. Where can I get a field layout and description of report server database tables please? Would have thought this would have been easy to find on the web somewhere or on the microsoft site but I've failed dismally!
ASKER
Thanks! lol. That's really useful that. although I'm still struggling with the meaning of some of the fields. Looks like Microsoft are keeping this close to their chests here. Any ideas?
Did you look at the primary keys between the tables? There isn't any reference that I know for these tables, but we might be able to infer one.
ASKER
Pretty tricky them as I can't see a link to some of the tables either. Lot of fields that aren't referenced too so not that intuitive.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you seen the database diagram?
ReportServer-Database-Layout.pdf