| Line 1... |
Line 1... |
| 1 |
SELECT rt.rtag_id,rc.daemon_hostname,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
|
1 |
SELECT rt.rtag_id,bm.display_name,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
|
| 2 |
CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
|
2 |
CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
|
| - |
|
3 |
WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
|
| 3 |
WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
|
4 |
WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
|
| 4 |
WHEN (rl.pause = 1) THEN 1 -- paused
|
5 |
WHEN (rl.pause = 1) THEN 1 -- paused
|
| 5 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
6 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
| 6 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
7 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
| 7 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
8 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
| 8 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
9 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
| 9 |
ELSE -1 -- unavailable
|
10 |
ELSE -1 -- unavailable
|
| 10 |
END AS status
|
11 |
END AS status
|
| 11 |
FROM release_tags rt, release_config rc, run_level rl
|
12 |
FROM release_tags rt, release_config rc, run_level rl, build_machine_config bm
|
| 12 |
WHERE rt.rtag_id = :RTAG_ID
|
13 |
WHERE rt.rtag_id = :RTAG_ID
|
| 13 |
AND rt.rtag_id = rc.rtag_id
|
14 |
AND rt.rtag_id = rc.rtag_id
|
| 14 |
AND rc.rcon_id = rl.rcon_id (+)
|
15 |
AND rc.rcon_id = rl.rcon_id (+)
|
| - |
|
16 |
AND rc.bmcon_id=bm.bmcon_id(+)
|
| 15 |
ORDER BY rc.daemon_hostname,rc.rcon_id
|
17 |
ORDER BY bm.display_name,rc.rcon_id
|