web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 1 -
1 file changed, 1 deletion(-)
New commits:
commit 7056409916495c6ca917b8a326e4025f9dad6b36
Author: Partha Aji <paji(a)redhat.com>
Date: Wed Sep 22 15:57:33 2010 -0400
636653 - Made the Channel Family Subscribed Systems page show guest systems also
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 a86912d..1347fb5 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -880,7 +880,6 @@ SELECT distinct S.id, S.name
AND SC.channel_id = CFM.channel_id
AND CFM.channel_family_id = :cfam_id
AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND
USP.server_id = S.id)
- AND NOT EXISTS (SELECT 1 FROM rhnVirtualInstance vi WHERE vi.VIRTUAL_SYSTEM_ID = S.id
AND EXISTS ( SELECT 1 FROM rhnServerEntitlementView sev WHERE vi.HOST_SYSTEM_ID =
sev.server_id AND sev.label IN ('virtualization_host',
'virtualization_host_platform')))
ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID
</query>
<elaborator name="system_overview" />
Show replies by date