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!
GrffsterAsked:
Who is Participating?
 
GrffsterAuthor Commented:
I muddled through this in the end guessing at certain fields. Too many to list here. If you want further info then reply to this and I'll see if I can answer the meaning of that field.
0
 
Bob LearnedCommented:
Hmmm...that is a great question.

Have you seen the database diagram?



ReportServer-Database-Layout.pdf
0
 
GrffsterAuthor Commented:
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?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Bob LearnedCommented:
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.
0
 
GrffsterAuthor Commented:
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.
0
 
Bob LearnedCommented:
Yes, what you are asking for is not something that too many people are familiar with (including myself).  I couldn't find a relation for you, either.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.