Table Explaination for dbo.catalog table in ReportServer database
Hello, I am trying to look for the explaination for the columns in dbo.catalog table. Is there any place i haveexplainations for these tables? For instance there is a column 'Type' in dbo.catalog table. But not sure what information it has - it has values like 1,2,3,4 .. Wanted to know what these values are.. Any idea on this? Thanks, Uma
October 29th, 2008 2:23pm

Hi Uma, We do not document or support querying any Report Catalog tables. If you need to find out what items are in the report catalog, use the ListChildren SOAP API to list them. We do support the ExecutionLog (Table/View; version dependent) or the ExecutionLog2 View. Otherwise, writing queries against the SSRS DB is not supported and the schema, content, interpretation of the content is subject to change without notice. Probably not the answer you wanted to hear... -Lukasz
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 4:12pm

Hi Lukasz, Do you know if it is possible to copy a modelID to another model in the catalog table? Or is the ModelID stored in another table(s) within the ReportServer database? I had to generate a new report model and cannot overwrite the existing due to it having a different ModelID. I need to overwrite, as there are numerous reports that have been created against the original model? Thanks! -Carla
October 29th, 2008 8:00pm

Hi Carla - You can export the previous model and then upload it again to the server. Unfortunately, model item ids are not guaranteed to be identical across multiple Generate Model calls. Hope that helps, -Lukasz
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2008 11:59am

Thank you so much b_ruslyUma
May 3rd, 2010 4:37pm

Hi All, I saw value 6 in type column of Catalog table, am wondering what does '6' represent? thanks, Ling
Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2011 1:03am

6 = report model
March 11th, 2011 1:40pm

In case someone end up here using SQL Server 2008 R2, newly-added values since R2 are: 8 = Shared Dataset 9 = Report PartMCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2012 3:21am

Hi Valentino, can we get the detail of tables and views in ReportServer database?Sushant
July 10th, 2012 2:08am

Hi Sushant, As Lukasz said, Microsoft does not document the internal report server tables/views. However, that of course doesn't mean that you can't query them. As long as you don't rely on the structure of the tables for any production systems, I don't see any harm in running select statements on those tables. Have a look at the script here for some interesting usage of the reportserver tables: http://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5cMCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2012 9:28am

in catalog table i can find out those names but those contain the deleted report names also. how can i separate reports from deleted reports to existing reports? The Catalog table does not contain deleted reports. Once they're deleted, they're gone from the table as well. Are you sure you're not confusing "deleted" with "hidden"? To filter out hidden reports, have a look at the Hidden column in the Catalog table: WHERE Hidden = 0 MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
October 23rd, 2012 8:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics