How to find task where certain table is included

[DanielaLiszio]

Hi.

We created a bundle of tasks splitting the list of tables. If I am searching for a certain table, how can I see to which task this table belongs? Is there a way to see in which task the table in included?

Thanks in advanced.

- Daniela

[john_wang]

Hello @DanielaLiszio ,

There are several options to get the tables list. the easy one is check the "Full Table List":

You may also export the tables list to a TSV file, see above step (2).

Hope this helps.

John.

[DanielaLiszio]

Hi, thanks for your answer. But what to in case I don't want to scroll through every task ( some have a long list of tables) of a project so find my table. And I would like to avoid to export 5 or more task to use in export file. Isn't there any reverse engineering to fine the task of a table? I mean without to check all single tasks ?

[john_wang]

Hello Daniela, @DanielaLiszio 

Yes. You may use APIs to get table list in QEM, eg GetTableList via QEM REST API. In .NET and Python API you may call the same method as well.

Regards,

John.

[PGN]

You can run the following command as well:

x:\Attunity\Replicate\bin\repctl -d y:\Data exportrepository include_server_settings=true" 

This will create a .JSON file with all tasks on that server and they you can use a Powershell or other parsing script to create a list of tables and other elements from the tasks.

[DanielaLiszio]

Thanks a lot. That helps.  🙂

[john_wang]

Thank you for your support! @DanielaLiszio