tsm: xxxxxxxx> select nodes.domain_name,summary.activity, -
cont> sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB -
cont> from nodes, summary -
cont> where (end_time between current_timestamp - 24 hours and current_timestamp) -
cont> and (activity='BACKUP' or activity='RESTORE' -
cont> or activity='ARCHIVE' or activity='RETRIEVE') -
cont> and ((nodes.node_name=summary.entity)) -
cont> group by domain_name,summary.activity -
cont> order by activity,domain_name asc
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
DOMAIN_NAME ACTIVITY GB
------------------ ------------------ ------------------
xxxxxxxxxxxx ARCHIVE 31.44
xxxxxxxxxx BACKUP 181.28
xxxxxxxxxxxx BACKUP 1323.92
xxxxxxxxxxxx RETRIEVE 0.65
tsm: xxxxxxxx>
ez az egyik serverünk a 100ból, természetesen nincs mindegyiken ennyi, de van vagy 10 hasonló
[ Szerkesztve ]
"Ipari szörnyeteghangdaganatok lepték el a lüktető, eleven, nedvzöld csodahippirétet."