Dear Sir,
I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.
I am using v20.10.45.
Thanks in advance.
Regards,
Arthur
Dear Sir,
I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.
I am using v20.10.45.
Thanks in advance.
Regards,
Arthur
Best answer by Thomas Lind
Hi
The data sources are stored in its namesake in the repository.
Of course only Business Unit data sources.
To find the project a data source is stored in, you can locate the BusinessUnits table.
To find the projects there is a table called projects where you can find this info.
So all you need are some joins to relate DataSources to BusinessUnits that relates to Projects and you will have all the info you need.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.