meta data for this page
  •  

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 oldalonElőző változat
Következő változatKövetkező változat mindkét oldalon
shell:riportok:gather_data [2017/05/18 15:34] – ↷ Page moved from shell:gather_data to shell:riportok:gather_data adminshell:riportok:gather_data [2021/10/07 18:11] – admin
Sor 20: Sor 20:
 # Az elmuĂlt 7 nap adatmozgasai # Az elmuĂlt 7 nap adatmozgasai
 SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) as DOMAIN,substr(summary.activity,1,15) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by substr(end_time,1,10),domain_name,summary.activity order by date,activity,domain_name asc" SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) as DOMAIN,substr(summary.activity,1,15) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours and current_timestamp) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by substr(end_time,1,10),domain_name,summary.activity order by date,activity,domain_name asc"
 +# Node-ok méretei
 SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_mb, sum(distinct oc.num_files) as NUM_FILES,count(distinct vu.volume_name) as tapes from auditocc ao JOIN occupancy oc ON ao.node_name=oc.node_name left JOIN volumeusage vu ON vu.node_name=ao.node_name group by ao.node_name,ao.total_mb order by 2 desc" SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_mb, sum(distinct oc.num_files) as NUM_FILES,count(distinct vu.volume_name) as tapes from auditocc ao JOIN occupancy oc ON ao.node_name=oc.node_name left JOIN volumeusage vu ON vu.node_name=ao.node_name group by ao.node_name,ao.total_mb order by 2 desc"
 # Adatbazis mentesek futasi ideje elmult 30 napban: # Adatbazis mentesek futasi ideje elmult 30 napban: