| Line 714... |
Line 714... |
| 714 |
<input name="NOPRJ" id="NOPRJ" type="Button" value="None" onclick="toggle_all_projects(0)">
|
714 |
<input name="NOPRJ" id="NOPRJ" type="Button" value="None" onclick="toggle_all_projects(0)">
|
| 715 |
</td>
|
715 |
</td>
|
| 716 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Release</td>
|
716 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Release</td>
|
| 717 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Release<br>Mode</td>
|
717 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Release<br>Mode</td>
|
| 718 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>Mode</td>
|
718 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>Mode</td>
|
| 719 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>Hostname</td>
|
719 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>Host</td>
|
| 720 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>State</td>
|
720 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Daemon<br>State</td>
|
| 721 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Building<br>Package</td>
|
721 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Building<br>Package</td>
|
| 722 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<br>Delta (secs)</td>
|
722 |
<td valign="middle" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<br>Delta (secs)</td>
|
| 723 |
</tr>
|
723 |
</tr>
|
| 724 |
<%
|
724 |
<%
|
| 725 |
|
725 |
|
| 726 |
query_string = "SELECT rc.RCON_ID, " &_
|
726 |
query_string = "SELECT rc.RCON_ID, " &_
|
| 727 |
" rc.RTAG_ID, " &_
|
727 |
" rc.RTAG_ID, " &_
|
| 728 |
" rc.DAEMON_HOSTNAME, " &_
|
728 |
" bm.DISPLAY_NAME, " &_
|
| 729 |
" rc.DAEMON_MODE, "&_
|
729 |
" rc.DAEMON_MODE, "&_
|
| 730 |
" rt.RTAG_NAME, " &_
|
730 |
" rt.RTAG_NAME, " &_
|
| 731 |
" rt.OFFICIAL, " &_
|
731 |
" rt.OFFICIAL, " &_
|
| 732 |
" p.PROJ_ID, " &_
|
732 |
" p.PROJ_ID, " &_
|
| 733 |
" p.PROJ_NAME, " &_
|
733 |
" p.PROJ_NAME, " &_
|
| 734 |
" rl.CURRENT_PKG_ID_BEING_BUILT, "&_
|
734 |
" rl.CURRENT_PKG_ID_BEING_BUILT, "&_
|
| 735 |
" rl.CURRENT_RUN_LEVEL, "&_
|
735 |
" rl.CURRENT_RUN_LEVEL, "&_
|
| 736 |
" rl.PAUSE, " &_
|
736 |
" rl.PAUSE, " &_
|
| 737 |
" TRUNC (86400*(SYSDATE - rl.KEEP_ALIVE)) as delta" &_
|
737 |
" TRUNC (86400*(SYSDATE - rl.KEEP_ALIVE)) as delta" &_
|
| 738 |
" FROM release_config rc, release_tags rt, projects p, run_level rl " &_
|
738 |
" FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, PROJECTS p, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
| 739 |
" WHERE rt.RTAG_ID = rc.RTAG_ID " &_
|
739 |
" WHERE rt.RTAG_ID = rc.RTAG_ID " &_
|
| 740 |
" AND rc.DAEMON_HOSTNAME is not null" &_
|
740 |
" AND rc.DAEMON_HOSTNAME is not null" &_
|
| 741 |
" AND rt.PROJ_ID = p.PROJ_ID " &_
|
741 |
" AND rt.PROJ_ID = p.PROJ_ID " &_
|
| 742 |
" AND rt.OFFICIAL != 'A' " &_
|
742 |
" AND rt.OFFICIAL != 'A' " &_
|
| 743 |
" AND rt.OFFICIAL != 'Y' " &_
|
743 |
" AND rt.OFFICIAL != 'Y' " &_
|
| 744 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
744 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
| - |
|
745 |
" AND rc.DAEMON_HOSTNAME = bm.MACHINE_HOSTNAME(+)" &_
|
| 745 |
" ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, rc.DAEMON_HOSTNAME"
|
746 |
" ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, bm.DISPLAY_NAME"
|
| 746 |
|
747 |
|
| 747 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
748 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
| 748 |
|
749 |
|
| 749 |
' String variables
|
750 |
' String variables
|
| 750 |
Dim strProject_checked ' Can be "" or "checked". Determines appearance of project enable checkbox
|
751 |
Dim strProject_checked ' Can be "" or "checked". Determines appearance of project enable checkbox
|
| Line 899... |
Line 900... |
| 899 |
<%End If%>
|
900 |
<%End If%>
|
| 900 |
|
901 |
|
| 901 |
|
902 |
|
| 902 |
<td nowrap <%=styleNow%>><%=Get_Official(rsQry("official"))%></td>
|
903 |
<td nowrap <%=styleNow%>><%=Get_Official(rsQry("official"))%></td>
|
| 903 |
<td nowrap <%=styleNow%>><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>
|
904 |
<td nowrap <%=styleNow%>><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>
|
| 904 |
<td nowrap <%=styleNow%>><%=rsQry("daemon_hostname")%></td>
|
905 |
<td nowrap <%=styleNow%>><%=rsQry("display_name")%></td>
|
| 905 |
<td nowrap <%=styleNow%>><%=Get_Run_Level(rsQry("current_run_level"), bIndefinitelyPaused)%></td>
|
906 |
<td nowrap <%=styleNow%>><%=Get_Run_Level(rsQry("current_run_level"), bIndefinitelyPaused)%></td>
|
| 906 |
<td nowrap <%=styleNow%>><%=Get_Pkg_Name(pkgId)%></td>
|
907 |
<td nowrap <%=styleNow%>><%=Get_Pkg_Name(pkgId)%></td>
|
| 907 |
|
908 |
|
| 908 |
<%If (rsQry("delta") > 600) AND (IsNull(pkgId) OR pkgId = "") Then%>
|
909 |
<%If (rsQry("delta") > 600) AND (IsNull(pkgId) OR pkgId = "") Then%>
|
| 909 |
<td nowrap <%=styleNow%> style=color:Red><%=rsQry("delta")%></td>
|
910 |
<td nowrap <%=styleNow%> style=color:Red><%=rsQry("delta")%></td>
|