How to get Failed steps from DB for one release

[Yang.Chen]

Hi,

 

Our customer wants to run some SQLs to list all actions whose status is "Failed" for one release, like the event list we can see from the studio. Which tables I should combine to get these data?

 

I can get the release list from RC_RELEASE table but don't know how to relate it with its failed actions.

 

Thanks

Yang

[Jacky_Mahadab]

Try use this query (I use MySQL DB)

It will list the failed actions for specific release id

 

select rcbm.name as Releaase_step_name,c.PROCESS_NAME as ProcessName,ose.step_title as AcitonName,ose.result_desc as ActionResultDesc ,rcs.stage_mode as Deployment_result,

rcm.module_mode as step_result from rc_stages rcs

  inner join rc_releases rcr on rcr.id=rcs.release_id

  inner join rc_modules rcm on rcm.stage_id=rcs.id

  inner join rc_basic_modules rcbm on rcbm.id=rcm.id

  inner join offline_execution_jobs oej on oej.id=rcm.job_id

  inner join offline_step_events ose on ose.job_id=oej.id

  inner join published_process s on s.ID=rcbm.published_process

  inner join process_container c on c.ID=s.ID

where rcr.id = 2380 and ose.step_state like 'finished' and ose.result_type like '1'

 

 

[Yang.Chen]

Hi Jacky,

 

Thanks for the quick reply. That works very well. My environment is Oracle,  I changed ose.step_state like 'finished' to ose.step_state like 'FINISHED'.

 

Yang

[Jacky_Mahadab]

great

Jacky