Get a query that would display all the data sources from my server

Python Help
1

imagine we have 100 workbooks and 100 datasources on the server. Each of these 200 assets has a minimum of 1 table/database it is connected to. How do we find all the connections in these assets eg Microsoft SQL server, oracle, python

is there a query that can perform this?

2

Apparently, I guess it’s something you have to manually code, or perhaps a library exists which can help you do the trick.