Skip to main content
Solved

Query on local TX repository (V20.10.45)


avanrijn
Contributor
Forum|alt.badge.img+2

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 @avanrijn 

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.

View original
Did this topic help you find an answer to your question?

3 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • July 5, 2024

Hi @avanrijn 

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.


avanrijn
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 36 replies
  • July 5, 2024

Hi Thomas,

Thanks Thomas, this is what I am looking for.

Regards,

Arthur


  • Contributor
  • 75 replies
  • July 8, 2024

If global databases are used then don't forget the globaldatabaes table. And note the validTo field: 99999999 means it's a current record.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings