Teljes szöveg:
- TSM napi riport shell szkript
- lt SQL selectek TSM-hez SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as ... ancy date" from status' #SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as ... cy date" from status' SQL_UTOLSO24H_ADATMOZGASAI="select nn.domain_name,summary.activity, sum(cast(summary... ivity,domain_name asc" SQL_UTOLSO24H_AKTIVITASAI="SELECT activity, cast(float(sum(bytes))/1024/1024/1024 a
- TSM és OS adatgyűjtő TSM szerver felméréshez
- # Az elmult 7 nap aktivitasa tipusonken:t SQL1="SELECT substr(end_time,1,10), substr(activity,1,20), cas... time,1,10)" # Az elmuĂlt 7 nap adatmozgasai SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_n... activity,domain_name asc" # Node-ok méretei SQL3="select substr(ao.node_name,1,30) as node_name, ao.total_... zis mentesek futasi ideje elmult 30 napban: SQL4="SELECT DATE(start_time) as DATE, TRANSLATE('a bc:de:fg',
- TSM drive usage riport
- pa=$TSMPASS -se=$TSMSERVER -dataonly=y -commadel "select distinct library_name from drives where online='Y... pa=$TSMPASS -se=$TSMSERVER -dataonly=y -commadel "select count(*) from drives where online='YES' and libra... RY}'") # Minden library-re kulon lefuttatjuk SQL="select ORA, cast(round(sum(USAGE) / (select count(*) from drives where online='YES' and library_name='${LIBRARY}
- TSM kliens riport shell szkript
- asznalt SQL selectek TSM-hez SQL_Q_FAILED_EVENTS="select substr(e.node_name,1,20) as \"NODE NAME\", e.sche... ]]; then continue; fi SQL_3X_MISSED="select substr(e.node_name,1,20) as \"NODE NAME\", substr
- Egy node adott objektumának kikeresése, van-e, melyik szalagon van
- d=$ID -pa=$PSW -dataonly=y -displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME, BACK... d=$ID -pa=$PSW -dataonly=y -displ=list -commadel "select object_id, FILESPACE_NAME, HL_NAME, LL_NAME from
- VMware image mentések riportja
- $TSMUSER -pa=$TSMPASS -se=$TSMSERVER -dataonly=y "select BACKUP_DATE from backups where node_name='$TSMNOD
- Szebb 'q process' kimenet
- m' LIGHT_CYAN='\033[1;36m' DEFAULT='\033[0m' SQL='SELECT process_num, substr(process,1,20) as PROCESS, sub
- Szebb 'q session' kimenet
- m' LIGHT_CYAN='\033[1;36m' DEFAULT='\033[0m' SQL="SELECT SESSION_ID, CLIENT_NAME, substr(char(start_time),