Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1097
  • Last Modified:

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!
0
Grffster
Asked:
Grffster
  • 3
  • 3
2 Solutions
 
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
 
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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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
 
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now