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.

Összehasonlító nézet linkje

Előző változat mindkét oldalon Előző változat
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>​ </​WRAP>​
  
-=== Node-ok megőrzési idejei ===+=== Node-ok ​ütemezései és megőrzési idejei ===
  
 <​WRAP>​ <​WRAP>​
 <​file>​ <​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, \ 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((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 \ 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>​ </​file>​
 </​WRAP>​ </​WRAP>​
sql.txt · Utolsó módosítás: 2019/09/16 16:37 szerkesztette: admin
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0