How to get Workbook Technical name and descriptio from query technical name

[Former Member]

Hello All,

Could you please provide any input for my question:

I have list of queries and wanted to know in which workbooks these queries are saved.

Thanks & Regards,

Bandana

[Former Member · Accepted solution]

Hi,

Use the following tables.

RSRREPDIR: COMPID - Query Technical name, COMPUID, GENUNIID - Query ID

RSZELTTXT: ELTUID - COMPUID, TXTLG - Description

RSRWORKBOOK: WORKBOOKID - Workbook ID, GENUNIID - Query ID

RSRWBINDEXT: WOKBOOK ID , Description

Regards,

Suzitha