I have moved this thread to the Server Administration area of the forums. There are resources under the content management section of the Tableau Server area that may help you out.
Using the TS Data Connections data source to get the information from the Tableau Server repository database will provide information on both the local and published data sources used in a workbook. But the information on what specific schema, tables, views, and fields are being used can only be retrieved by downloading the workbook .twb and the published data source .tds that the workbook references, and parsing the XML.
Thanks Matt. That was helpful.
But neither the twb nor the tds has any information about the actual local Data sources. They only refer to the tableau server data source. I need the schema information particularly