Teljes szöveg:
- TSM napi riport shell szkript
- as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 24 hours an... 024/1024/1024 as dec(8,2)) as \"GB\" FROM summary WHERE end_time>current_timestamp-24 hours and activity<... cc_time)) as \"LAST SEEN\" from EVENTS a, nodes b where (a.scheduled_start >=current_timestamp - 3 days) ... 4/1024 AS DEC(10,2)) AS \"Rec. MB\" FROM sessions WHERE SESSION_TYPE='Node' and (current_timestamp - star
- TSM és OS adatgyűjtő TSM szerver felméréshez
- ))/1024/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hours and activity... as decimal(6,2))) as GB from nodes as nn, summary where (end_time between current_timestamp - 168 hours a... es/1024/1024/1024 as DEC(8,2)) as GB FROM summary WHERE activity='FULL_DBBACKUP' AND current_timestamp - ... MSS)\", affected, number, successful FROM summary WHERE activity='EXPIRATION' AND entity IS NULL AND curr
- TSM drive usage riport
- ommadel "select distinct library_name from drives where online='YES'") bold=$(tput bold) ... dataonly=y -commadel "select count(*) from drives where online='YES' and library_name='${LIBRARY}'") # Mi... t(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}')) as d... ) END as dec(5,2))) /60*100 as USAGE from summary where ACTIVITY='TAPE MOUNT' and library_name='${LIBRARY
- TSM kliens riport shell szkript
- okból veszi, aminek a formátuma: email cím; (sql WHERE feltétel az events, mint "e" táblából) order by <... tatus,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.scheduled_start ... cc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=current_timestamp - 3 days)
- Egy node adott objektumának kikeresése, van-e, melyik szalagon van
- _NAME, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" ech... d, FILESPACE_NAME, HL_NAME, LL_NAME from archives where node_name=upper('$NODE') $HL_NAME $LL_NAME"`" </f
- VMware image mentések riportja
- RVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNODE' and hl_name like '\\$VM_NAME
- Szebb 'q session' kimenet
- only=y -commadel -displ=list -se=$TSMSERVER "$SQL WHERE SESSION_TYPE='Node'" | awk -F',' '{printf "%10s