Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- ement class-ok listázása === <file>select domain_name,class_name as "MGMT CLASS without OBJECTS" from mgmtclasses where class_name not in (select distinct class_name from backups) and class_name not in (select distinct class_name from
- Hálózati okosságok @linux
- ss, and port is an integer port number or service name, bash attempts to open a TCP connection to the co... ss, and port is an integer port number or service name, bash attempts to open a UDP connection to the co... D=$(cat $PORT/speed) WWN=$(cat $PORT/port_name | sed 's/^0x//') echo "$PORT#$WWN#$SPEED#
- TSM napi riport shell szkript @shell:riportok
- tus' SQL_UTOLSO24H_ADATMOZGASAI="select nn.domain_name,summary.activity, sum(cast(summary.bytes/1024/102... y='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc" SQL_UTOLSO24H_AKTIVITASAI="SELECT activity, cast(fl
- Linux okosságok
- == dm-* device-ok felderítése ==== find /dev/ -name "dm-*" -exec readlink -n {} \; -exec echo " -->" ... = LVM snapshot készítés ==== lvdisplay -C -olv_name,lv_path --noheadings lvcreate -s -L 1G -n blabl... foglal egy bizonyos fájl csoport? ==== find / -name "*\.trc" -print0 | du --files0-from=- -hc | tail
- Szkriptelés @linux
- attern.| |${!varprefix*},${!varprefix@} | Matches names of all previously declared variables beginning w
- TSM és OS adatgyűjtő TSM szerver felméréshez @shell:riportok
- t substr(end_time,1,10) as DATE, substr(nn.domain_name,1,15) as DOMAIN,substr(summary.activity,1,15) as ... y='ARCHIVE' or activity='RETRIEVE') and ((nn.node_name=summary.entity)) group by substr(end_time,1,10),domain_name,summary.activity order by date,activity,domain_name asc" # Node-ok méretei SQL3="select substr(ao.node_
- TSM drive usage riport @shell:riportok
- ER -dataonly=y -commadel "select distinct library_name from drives where online='YES'") bold=$(tput bol... unt(*) from drives where online='YES' and library_name='${LIBRARY}'") # Minden library-re kulon lefuttat... unt(*) from drives where online='YES' and library_name='${LIBRARY}')) as dec(4,0)) from ( \ select conca... m summary where ACTIVITY='TAPE MOUNT' and library_name='${LIBRARY}' and start_time<timestamp('${DATE_TO}
- TSM kliens riport shell szkript @shell:riportok
- by <rendező mező> Pl: fonok@cegem.hu; (e.node_name='FONOK_SZERVERE' or e.schedule_name like 'NAPI_INCR_%') ORDER BY e.schedule_name Ha egy email címhez több sor is van, azokat külön szekció... TSM-hez SQL_Q_FAILED_EVENTS="select substr(e.node_name,1,20) as \"NODE NAME\", e.schedule_name, cast ( S
- Linux interfészek listázása @shell:device_management
- D=$(cat $PORT/speed) WWN=$(cat $PORT/port_name | sed 's/^0x//') echo "$PORT#$WWN#$SPEED#
- VMware image mentések riportja @shell:riportok
- E printf "%-30s %-60s %-40s %-5s %-15s\n" "VM_NAME","RESOURCE_POOL","UUID","PW_ST","LAST_BACKUP" >>$... -type m | sed 's/^.*\///g' | sort | while read VM_NAME; do POWER_STATE=$(./govc vm.info "$VM_NAME" | awk -F':' '/Power state/{print $2}' | sed 's/ *powered//') UUID=$(./govc vm.info "$VM_NAME" | awk -F':' '/UUID/{print $2}' | sed 's/ *//')
- Technikai poolokat, vezérlő szkripteket kialakító szkript @shell
- MPASS -se=$TSMSERVER -dataonly=y "select DEVCLASS_NAME from devclasses where library_name='$DR_LIBRARY'" printf ": "; read DR_DEVCLASS echo "Milyen suffix-u s... -dataonly=y "select 'def stg ' || replace(stgpool_name,'$SUFFIX','') || '$DR_SUFFIX $DR_DEVCLASS col=no ... axscr=' || maxscratch from stgpools where stgpool_name like '%$SUFFIX'" echo # Éles poolról technikai p
- Oracle VM CPU pin map @shell:oravm
- SERVERS:=$SERVERS}; do [[ $($SSHC show server name="$OVS" | grep -c 'Status: Success') -eq 0 ]] && c... _PIN_SUM echo CPU_NUM=$($SSHC show server name="$OVS" | grep -c '^.*Cpu.*Processor ') fejlec... $MAX_CPU_NUM*3-3)) VM_NUM=$($SSHC show server name="${OVS}" | grep -c '^.*Vm .*\[.*\]') if [[ $V... v printf '\u256b')" while read VM; do VM_NAME=$(echo $VM | grep -oP '(?<=\[).*(?=\])')
- VM-ek listázása @shell:oravm
- m_list_vm_phys_disks.lst TMP_FILE=${0}.tmp echo 'NAME;OS;IP;VCPU;MEMORY;DISK_SIZE_SUM;NETWORKS' for VM_... vm_cli "show vm id=$VM_ID" 2>&1 > ${TMP_FILE} NAME=$(cat ${TMP_FILE} | awk -F'=' '/Name/{print $2}') MEMORY=$(cat ${TMP_FILE} | grep -v Max | awk -F'=... =' '/Operating System/{print $2}') IP=$(host $NAME | awk '{print $NF}') VNIC_NUM=$(cat ${TMP_FIL
- VM-ek diszkjeinek listázása @shell:oravm
- .sh kulcs_ellenorzes printf $yel echo "VM" "Disk_name" "Repository/WWN" "Disk_Size" "Virt/Phys"| awk '{... DISK_FILENAME=$DISK_ID DISK_NAME=$(ovm_exec "show virtualdisk name=$DISK_ID" "[[:space:]][[:space:]]Name") DISK_REPO=$(ovm_cli "show virtualdisk name=$DIS
- TSM node replikacios iranyt forgato szkript @shell:replikacio
- -dataonly=y -tabdelim" SQL_REPLNODES="select node_name from nodes where REPL_STATE='ENABLED' order by node_name" white=$(tput bold;tput setaf 7) # brigh... $DSMADMC1 "select REPL_MODE from nodes where node_name=upper('$NODE')"` # Ha nem olyan modban van, mint... MC1 "select session_id from sessions where CLIENT_NAME='$NODE' and SESSION_TYPE='Node'" | egrep -v 'AN[S