Subversion Repositories DevTools

Rev

Rev 4293 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4293 Rev 4867
Line -... Line 1...
- 
 
 1 
 SELECT rt.rtag_id,
- 
 
 2 
        bm.display_name,
- 
 
 3 
        rl.rcon_id,
- 
 
 4 
        rl.pause,
- 
 
 5 
        rl.current_run_level,
1 
 SELECT rt.rtag_id,bm.display_name,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
 6 
        rl.current_pkg_id_being_built,
- 
 
 7 
        rt.build_age,
- 
 
 8 
        rc.daemon_mode,
- 
 
 9 
        TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days,
- 
 
 10 
        TO_CHAR(rl.LAST_BUILD, 'DD-MON-YYYY') as last_build,
2 
    CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
 11 
    CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
3 
         WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
 12 
         WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
4 
         WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
 13 
         WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
5 
         WHEN (rl.pause = 1)       THEN 1 -- paused
 14 
         WHEN (rl.pause = 1)       THEN 1 -- paused
6 
         WHEN (rl.pause = 2)       THEN 2 -- disabled
 15 
         WHEN (rl.pause = 2)       THEN 2 -- disabled