schema/spacewalk/oracle/views/rhnServerOverview.sql | 60 ------------------ schema/spacewalk/postgres/views/rhnServerOverview.sql | 24 ++++++- 2 files changed, 20 insertions(+), 64 deletions(-)
New commits: commit 6c1acd8f84558af0f4121f95308366755d715c1e Author: Lukas Zapletal lzap+git@redhat.com Date: Fri Oct 1 14:07:59 2010 +0200
updated rhnServerOverview.sql for Postgres
diff --git a/schema/spacewalk/postgres/views/rhnServerOverview.sql b/schema/spacewalk/postgres/views/rhnServerOverview.sql index 3eb2d0f..0afdd54 100644 --- a/schema/spacewalk/postgres/views/rhnServerOverview.sql +++ b/schema/spacewalk/postgres/views/rhnServerOverview.sql @@ -1,5 +1,4 @@ --- -- oracle equivalent source sha1 6582bbf3a236c11485b0d54b642b2793f49c1457 --- retrieved from ./1235117057/2510d6bed246794de798c9c9b00e8cd21d99a4dc/schema/spacewalk/rhnsat/views/rhnServerOverview.sql +-- oracle equivalent source sha1 906e02f9fee6baee19a765099b3969238347cf8e -- -- Copyright (c) 2008--2010 Red Hat, Inc. -- @@ -33,6 +32,7 @@ rhnServerOverview bug_errata, enhancement_errata, outdated_packages, + config_files_with_differences, last_checkin_days_ago, last_checkin, pending_updates, @@ -79,7 +79,24 @@ select where snpc.server_id = S.id and p.id = snpc.package_id - ), + ), + ( select count(*) + from rhnActionConfigRevision ACR + INNER JOIN rhnActionConfigRevisionResult ACRR on ACR.id = ACRR.action_config_revision_id + where ACR.server_id = S.id + and ACR.action_id = ( + select MAX(rA.id) + from rhnAction rA + INNER JOIN rhnServerAction rSA on rSA.action_id = rA.id + INNER JOIN rhnActionStatus rAS on rAS.id = rSA.status + INNER JOIN rhnActionType rAT on rAT.id = rA.action_type + where rSA.server_id = S.id + and rAS.name in ('Completed', 'Failed') + and rAT.label = 'configfiles.diff' + ) + and ACR.failure_id is null + and ACRR.result is not null + ), ( select current_timestamp - checkin from rhnServerInfo where server_id = S.id ), ( select TO_CHAR(checkin, 'YYYY-MM-DD HH24:MI:SS') from rhnServerInfo where server_id = S.id ), ( select count(1) @@ -93,4 +110,3 @@ select from rhnServer S ; -
commit 8bb5081c092e4fa6c963f10a17f7adbf2969a028 Author: Lukas Zapletal lzap+git@redhat.com Date: Fri Oct 1 14:07:05 2010 +0200
oracle rhnServerOverview old revision log deletion
diff --git a/schema/spacewalk/oracle/views/rhnServerOverview.sql b/schema/spacewalk/oracle/views/rhnServerOverview.sql index cd9d51f..f27d205 100644 --- a/schema/spacewalk/oracle/views/rhnServerOverview.sql +++ b/schema/spacewalk/oracle/views/rhnServerOverview.sql @@ -109,63 +109,3 @@ select from rhnServer S / - - --- --- Revision 1.21 2003/10/23 17:12:36 cturner --- get locked state into rhnServerOverview --- --- Revision 1.20 2002/11/14 20:26:31 cturner --- I am a dumbass; it was not an id --- --- Revision 1.19 2002/11/14 20:15:39 cturner --- be consistent; server_arch_id not server_arch --- --- Revision 1.18 2002/11/14 17:20:34 pjones --- arch -> *_arch_id and archCompat changes --- --- Revision 1.17 2002/06/03 18:35:07 cturner --- fix for bug 58264 --- --- Revision 1.16 2001/12/03 18:35:56 cturner --- fix view for odd case of same nvre in multiple channels for differing errata --- --- Revision 1.15 2001/11/28 20:23:30 cturner --- show last checkin on entitlement page, too --- --- Revision 1.14 2001/10/28 04:28:13 cturner --- moving towards hiding servergroups with a specific type, in favor of task-oriented lists. --- --- Revision 1.13 2001/10/25 09:48:26 cturner --- mods to server overview view --- --- Revision 1.12 2001/08/09 23:47:54 cturner --- push script changes --- --- Revision 1.11 2001/07/31 00:17:40 cturner --- fix for history table change --- --- Revision 1.10 2001/07/28 23:30:55 cturner --- outdated package column in server list... whew --- --- Revision 1.9 2001/07/25 23:04:20 cturner --- new column on rhnServerOverview -- whether the server is entitled --- --- Revision 1.8 2001/07/07 13:03:39 cturner --- better overview --- --- Revision 1.7 2001/07/04 06:55:33 cturner --- fixing broken server overview view. syntax errors. --- --- Revision 1.6 2001/07/02 21:12:18 gafton --- more formatting --- --- Revision 1.5 2001/07/02 21:10:50 gafton --- format so it fits on a damn page printout --- --- Revision 1.4 2001/06/29 08:30:53 cturner --- more underscore changes, plus switching from rhnUser to web_contact. may switch back later, but avoiding synonyms and such seems to make things cleaner --- --- Revision 1.3 2001/06/27 02:05:25 gafton --- add Log too ---
spacewalk-commits@lists.fedorahosted.org