BusinessObjects Board

querying DS Repository

dataservices metadata reports
#1

Hello Forum, I wish to identify the various Projects and components (Jobs, Workflows, Dataflows, etc) in my DS 4.0 repository. So far I have been able to join Projects and Jobs but do not see how to “extend” this to the other components. The below code retrieves Projects and Jobs, but neither of these Views can be Joined to ALVW_DATAFLOWINFO, for example.

Can anyone help dig into this further? Thank you!

select ap.PROJECT_NAME, aj.JOB_NAME
from 
  DDSCEN_REPO.dbo.ALVW_PROJECTINFO  ap,		
  DDSCEN_REPO.dbo.ALVW_JOBINFO      aj,
  DDSCEN_REPO.dbo.ALVW_PROJECT_JOB apj
where apj.PROJECT_ID = ap.PROJECT_ID
  and aj.JOB_ID      = apj.JOB_ID
order by 1, 2

CNV_Ben (BOB member since 2002-08-15)

#2

Okay the Table is AL_PARENT_CHILD which contains all the relationship and anything. But that cannot get the info of scripts!! For script names if you look/While Loops/Conditional Flows, they can only be found in the AL_LANGTEXT maze

ganeshxp :us: (BOB member since 2008-07-17)