cancel
Showing results for 
Search instead for 
Did you mean: 

which table under sql server repository keeps track of Data store names

Former Member
0 Kudos

which table under sql server repository keeps track of Data store names our repo is based on sql server.

Thanks for the helpful info.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check for tables AL_USAGE and ALVW_PARENT_CHILD.

They keep the datastored info

Former Member
0 Kudos

Hello Suraj, thankyou here is teh query i am using to get All datastore details associated with a job.

   

 

select

* from [AL_PARENT_CHILD] where DESCEN_OBJ_TYPE ='Datastore' and PARENT_OBJ_TYPE='Job'

;

Answers (0)