Teljes szöveg:
- TSM napi riport shell szkript
- RONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB",substr(FRONTEND_CAP_DATE,1,19) as "Front-End Date",FRONTEND_CLIENT_COUNT as "Front-End client count",cast(TOTALSUROCC_TB as decimal (8,2)) as "SUR ... RONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB",substr(FRONTEND_CAP_DATE,1,19) as "Front-End
- TSM drive usage riport
- rt_time),1,2)) as ORA, sum( cast(CASE WHEN substr(end_time,1,13)=substr(start_time,1,13) THEN timestampdiff(4,end_time-start_time) WHEN substr(end_time,1,13)>substr(start_time,1,13) THEN timestampdiff(4,timestamp(con... start_time),1,2) || ':59:59.000000'))-start_time) END as dec(5,2))) /60*100 as USAGE from summary where
- TSM és OS adatgyűjtő TSM szerver felméréshez
- 7 nap aktivitasa tipusonken:t SQL1="SELECT substr(end_time,1,10), substr(activity,1,20), cast(float(sum... 4/1024/1024 as dec(8,0)) as GB FROM summary WHERE end_time>current_timestamp-168 hours and activity<>'EXPIRATION' and bytes>0 GROUP BY activity, substr(end_time,1,10)" # Az elmuĂlt 7 nap adatmozgasai SQL2="select substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) a
- TSM kliens riport shell szkript
- ed - e.actual_start), '_______abcdefgh_____',' ') end as \"RUNTIME \", case when e.result=0 then ' 0-... e.result as char) || '-' || substr(e.status,1,11) end ) end as \"RESULT\" from events e where (current_timestamp - 24 hours)<e.scheduled_start and e.schedul
- AIX tape device-ok lekérdezése sorozatszámmal, PRI/ALT párral (ha van)
- mp/get_serial.out done function seq { beg=$1 end=$2 seq='' while [[ $beg -le $end ]]; do seq="$seq $beg" ((beg=$beg+1)) done echo $seq
- TSM kliens log gyűjtő
- =`ls -la $LOGFAJLOK 2>/dev/null | awk '{ sum+=$5} END {print sum}'` if [[ `uname` = 'Linux' ]]; then e=