meta data for this page
  •  

Keresés

A keresés eredményét lentebb láthatod.

Teljes szöveg:

TSM napi riport shell szkript
52 Találatok, Utolsó módosítás:
,substr(SUROCC_DATE,1,19) as "SUR occupancy date" from status' #SQL_LICENSZ_HASZNALATOK='select cast(FRO... UR retain TB",SUROCC_DATE as "SUR occupancy date" from status' SQL_UTOLSO24H_ADATMOZGASAI="select nn.dom... mary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between curr... sum(bytes))/1024/1024/1024 as dec(8,2)) as \"GB\" FROM summary WHERE end_time>current_timestamp-24 hours
TSM és OS adatgyűjtő TSM szerver felméréshez
17 Találatok, Utolsó módosítás:
oat(sum(bytes))/1024/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hour... mary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes as nn, summary where (end_time between curr... NUM_FILES,count(distinct vu.volume_name) as tapes from auditocc ao JOIN occupancy oc ON ao.node_name=oc.... )\", cast(bytes/1024/1024/1024 as DEC(8,2)) as GB FROM summary WHERE activity='FULL_DBBACKUP' AND curren
TSM drive usage riport
13 Találatok, Utolsó módosítás:
ataonly=y -commadel "select distinct library_name from drives where online='YES'") bold=$(tput bold) ... $TSMSERVER -dataonly=y -commadel "select count(*) from drives where online='YES' and library_name='${LIB... ect ORA, cast(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}')) as dec(4,0)) from ( \ select concat(date(start_time) || ' ',substr(
VMware image mentések riportja
3 Találatok, Utolsó módosítás:
TSMUSER=user TSMPASS=password TSMSERVER=tsm EMAIL_FROM="TSM riporter" TSMNODE=VCENTER01 IN_RISK_DAYS=31 ... SS -se=$TSMSERVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNODE' and hl_name li... T_FILE.html)" > $OUTPUT_FILE.html cat $OUTPUT_FILE.html | sendmail -B 8BITMIME -t -F $EMAIL_FROM </file>
TSM kliens riport shell szkript
2 Találatok, Utolsó módosítás:
|| substr(e.status,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.s... timestamp)-days(n.lastacc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=curr
Egy node adott objektumának kikeresése, van-e, melyik szalagon van
2 Találatok, Utolsó módosítás:
id, FILESPACE_NAME, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name=upper('$NODE') $HL_NAME $... elect object_id, FILESPACE_NAME, HL_NAME, LL_NAME from archives where node_name=upper('$NODE') $HL_NAME
Szebb 'q process' kimenet
1 Találatok, Utolsó módosítás:
al(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "MB/s" FROM processes' echo -e "$GREEN$TMSERVER:$DEFAULT" ec
Szebb 'q session' kimenet
1 Találatok, Utolsó módosítás:
)) / 1024 / 1024 AS DEC (10,2)) AS \"Rec. MB/s\" FROM sessions" # AND (BYTES_RECEIVED>1024*1024 OR BYTE