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 Uma, It is referring to the typeof Path column. if the value was 1 then the path is a folder. Value 2 refers to Report Value 3 refers to Resource Value 4 refers to Linked Report Value 5 refers to Data Source i hope it makes you clear your doubt
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2008 1:29am

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
November 24th, 2008 11:59am

Thank you so much b_ruslyUma
Free Windows Admin Tool Kit Click here and download it now
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
March 2nd, 2011 1:03am

6 = report model
Free Windows Admin Tool Kit Click here and download it now
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)
March 2nd, 2012 3:21am

Hi Valentino, can we get the detail of tables and views in ReportServer database?Sushant
Free Windows Admin Tool Kit Click here and download it now
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)
July 14th, 2012 9:42am

Hi valentine, Thanks for your answer. But can you help in getting the list of reports deployed in project web access site? 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? Thanks Sushant
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 8:39am

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

Other recent topics Other recent topics