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

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

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

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

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

Thank you so much b_ruslyUma

Hi All, I saw value 6 in type column of Catalog table, am wondering what does '6' represent? thanks, Ling

6 = report model