web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
New commits:
commit ba7aa6d770bb76a1368bfcd1bdea4619bce2fad8
Author: Ville Salmela <Ville.Salmela(a)csc.fi>
Date: Fri Apr 29 14:52:34 2011 +0200
Patch to run remote commands on multiple machines on Spacewalk 1.4 PostgreSQL.
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index 72463fc..36e32ba 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -2,6 +2,7 @@
<mode name="ssm_remote_commandable">
<query params="user_id">
+select * from (
SELECT DISTINCT S.id,
S.name AS SERVER_NAME
FROM rhnServer S,
@@ -18,7 +19,9 @@ SELECT DISTINCT S.id,
AND CC.capability_name_id = CCN.id
AND CCN.name = 'script.run'
AND USP.server_id = S.id
-ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID
+) X
+ORDER BY UPPER(COALESCE(X.name, '(none)')), X.id
+
</query>
<elaborator name="system_overview" />
<elaborator name="entitlements"/>
Show replies by date