Különbségek

A kiválasztott változat és az aktuális verzió közötti különbségek a következők.

--- sql [2019/09/16 15:32]
admin [Egyéb]
+++ sql [2019/09/16 16:37] (aktuális)
admin [Egyéb]
@@ Sor 192: / Sor 192: @@
 </WRAP>
-=== Node-ok megőrzési idejei ===
+=== Node-ok ütemezései és megőrzési idejei ===
 <WRAP>
 <file>
 select substr(n.node_name,1,20) as Node, substr(n.domain_name,1,15) as "Domain", cast((m.set_name) as char (7)) as Set, \
-m.class_name as MgmtClass, assoc.schedule_name as "Schedule", cast((m.defaultmc) as char(6)) as Deflt, \
+csch.schedule_name as "Schedule", csch.action, csch.options, csch.objects, csch.startdate || ' ' || csch.starttime as START_TIME, csch.period || ' ' || csch.perunits as PERIOD, case when csch.sched_style='ENHANCED' then csch.dayofweek || ',' || csch.enh_month || ',' || csch.dayofmonth || ',' || csch.weekofmonth else csch.dayofweek end as melyik_nap, substr(csch.expiration,1,19) as EXPIRATION, \
+m.class_name as MgmtClass, cast((m.defaultmc) as char(6)) as Deflt, \
 cast((verexists) as char(8)) as "VerEx", cast((verdeleted) as char(8)) as "VerDel", \
-cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly" from nodes as n, \
+cast((retextra) as char(8)) as "RetEx", cast((retonly) as char(8)) as "Retonly" FROM nodes as n, \
-mgmtclasses as m, bu_copygroups as c, associations as assoc where n.domain_name=m.domain_name and \
+mgmtclasses as m, bu_copygroups as c, associations as a, client_schedules csch WHERE a.domain_name = csch.domain_name AND a.schedule_name = csch.schedule_name and n.domain_name=m.domain_name and \
 m.domain_name=c.domain_name and m.set_name=c.set_name and m.class_name=c.class_name \
-and m.set_name='ACTIVE' and assoc.node_name=n.node_name order by n.node_name,n.domain_name,Set,MgmtClass
+and m.set_name='ACTIVE' and a.node_name=n.node_name order by n.node_name,n.domain_name,Set,MgmtClass
 </file>
 </WRAP>