| 4867 |
dpurdie |
1 |
SELECT rt.rtag_id,
|
|
|
2 |
bm.display_name,
|
|
|
3 |
rl.rcon_id,
|
|
|
4 |
rl.pause,
|
|
|
5 |
rl.current_run_level,
|
|
|
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,
|
| 5177 |
dpurdie |
10 |
TO_CHAR(rl.LAST_BUILD, 'DD-Mon-YYYY') as last_build,
|
| 183 |
brianf |
11 |
CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
|
| 4293 |
dpurdie |
12 |
WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
|
| 5384 |
dpurdie |
13 |
WHEN (rt.official in ('A','Y','P') ) THEN -1 -- unavailable
|
| 183 |
brianf |
14 |
WHEN (rl.pause = 1) THEN 1 -- paused
|
|
|
15 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
|
|
16 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
|
|
17 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
|
|
18 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
|
|
19 |
ELSE -1 -- unavailable
|
| 6269 |
dpurdie |
20 |
END AS status,
|
|
|
21 |
NVL(bm.ACTIVE,'U') as active
|
| 4293 |
dpurdie |
22 |
FROM release_tags rt, release_config rc, run_level rl, build_machine_config bm
|
| 183 |
brianf |
23 |
WHERE rt.proj_id = :PROJ_ID
|
|
|
24 |
AND rt.rtag_id = rc.rtag_id
|
|
|
25 |
AND rc.rcon_id = rl.rcon_id (+)
|
| 4293 |
dpurdie |
26 |
AND rc.bmcon_id = bm.bmcon_id(+)
|
|
|
27 |
ORDER BY bm.display_name, rc.rcon_id
|
| 6269 |
dpurdie |
28 |
|