Data Services System tables

[former_member263733]

What Data Services system tables would show the details for the Datastores in a repository?

[DayaJha]

Please refer below query to get BODS metadata details

Following are the List of Query to Fetch the Jobs CountS.NoDetailsQuery1All Project InformationSelect * From ALVW_PROJECTINFO2All Jobs InformationSelect * From ALVW_JOBINFO3All WorkFlow InformtionSelect * From ALVW_WORKFLOWINFO4All DataFlow InformationSelect * From ALVW_DATAFLOWINFO5All DataStore InformationSelect * From ALVW_DATASTOREINFO6All Function InformationSelect * From ALVW_FUNCINFO7All File Format InformationSelect * From ALVW_FILEFORMINFO8All Source Target InformationSelect * From ALVW_MAPPING9All Jobs Execution HistorySelect * From ALVW_HISTORY

Also refer below SCN link

https://archive.sap.com/discussions/thread/3618865

Regards,

Daya Jha

[former_member562213]

You Can use the following query to get the list of datastores in your local repository.

select L.NAME as "DATASTORE" from AL_LANG L where OBJECT_TYPE='5';