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(a)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(a)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
---
Show replies by thread