FLEISCHMANN György, _flex, Gyurci, FleXoft FleXoft

## HPE SM delete all tables before system-load (MS SQL)
SELECT 'drop table', name, ';' FROM sysobjects WHERE xtype='U' order by name

## HPE SM Oracle user settings
sqlplus / as sysdba

create user smadmin identified by smadmin default tablespace users quota unlimited on users;

alter user smadmin default tablespace users;
alter user smadmin temporary tablespace temp;
alter user sys identified by password;

grant create materialized view TO smadmin;
grant create session ,alter session ,create synonym ,create view ,create table ,create sequence TO smadmin;

## hr
hr(){ yes -- ${@:-=} | tr -d $'\n' | head -c $COLUMNS ; }

## codesign
codesign -f -s - --deep

## kef search
while :; do clear; read -p 'Mit keresünk? '; echo;grep --color=always -i "$REPLY" 20200310_KM01SRVT17_Árlista.csv | cat -n ; echo ; read -p 'Nyomj!'; done;

## Recursively counting files in a Linux directory
find . -maxdepth 1 -type d -print0 | xargs -0 -I {} sh -c 'echo $(find "{}" | wc -l) "{}"'

## Listing physical and virtual FC adapters and their WWNs on the server as root (lists only the adapters for that server):
lsdev -S a -Cc adapter | grep '^fcs' | awk '{print $1}' | while read name; do lscfg -vl ${name} | grep -E "${name}|Network Address"; done

## List of physical FC adapters and their WWNs on the VIO server by padmin users (lists only the adapters of the given VIO server):
lsdev -type adapter -state available | grep '^fcs' | while read name rest; do lsdev -dev ${name} -vpd | grep -E "${name} |Network Address"; done

## List of virtual FC adapters and their WWNs on the HMC using hscroot (find all servers in Operational state and all LPARs on them):
lssysconn -r all -F resource_type,state,type_model_serial_num | grep '^sys,Connected' | cut -d',' -f3 | while read name; do echo ${name}; lshwres -r virtualio --rsubtype fc -m ${name} --level lpar -F lpar_name,slot_num,wwpns --header | grep -v null; done

## BATCH loop counter with leading zero
@echo off
setlocal enabledelayedexpansion
SET d=10

for /L %%t IN ( ) DO (

    SET /A d = !d! + 10
    rem echo alma !d!

    set "formattedValue=0000000000!d!"
	sqlplus / as sysdba

	create user smadmin identified by smadmin default tablespace users quota unlimited on users;

	alter user smadmin default tablespace users;
	alter user smadmin temporary tablespace temp;
	alter user sys identified by password;

	grant create materialized view TO smadmin;
	grant create session ,alter session ,create synonym ,create view ,create table ,create sequence TO smadmin;
	@echo off
	setlocal enabledelayedexpansion
	SET d=10

	for /L %%t IN ( ) DO (

	SET /A d = !d! + 10
	rem echo alma !d!

	set "formattedValue=0000000000!d!"