Showing results for 
Search instead for 
Did you mean: 

List of info providers whose templates are published in portal!!

Former Member
0 Kudos


How can I get the list of only those info providers whose queries/templates/workbooks are published in the portal?

Is there any table which has this info??

Thanks in advance,


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Shylaja,

You can check this table: RSZWTEMPLATE



Former Member
0 Kudos

RSZCOMPDIR stores the relation btw query and infoprovider.

RSZWORKBOOK stores relation btw Query and Workbook.

Until Bw 3.x, relation between webtemplate and query are not stored in Tables.

It can be tracked only in the html code of the template.

Thus even if you find webtemplates/WORKBOOK/QUERY used in portal, you will not get the complete list. Query used in webtemplates will always be missing. thus the whole relation will fail.