orourke.tv - tech-notes:scripts

add-default-route-of-a-dns-hostname

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:04:53 +0000

Add Default Route of a DNS hostname @echo off for /f "tokens=1,2 delims=[]" %%A in ('ping purplepi.mooo.com -n 1^| find "Pinging"') do set ipaddress=%%B route add %ipaddress% mask 255.255.255.255 192.168.255.1 ping 127.0.0.1 -n 5 >NUL

bulk-audio-channel2

anonymous@undisclosed.example.com (Anonymous) — Fri, 13 Oct 2023 08:53:33 +0000

Bulk Remove Left Channel WAV files retain channel 2 from Audio files The SOX command to remove channel 1 and retain channel 2 is the remix option: sox

remix 2 This example would trim from 0 seconds to 60 seconds.

bulk-audio-trim

anonymous@undisclosed.example.com (Anonymous) — Thu, 12 Oct 2023 18:17:04 +0000

Bulk Trim wav files Trim Audio files - 60 seconds The SOX command to trim an audio file is: sox

trim 0 60 This example would trim from 0 seconds to 60 seconds. @echo off path=%path%;C:\Program Files (x86)\sox-14-4-2 cls set confirm=N echo *************************** echo Audio ALAW Converting tool echo *************************** echo The sox.exe must be located in the current folder or on the OS PATH. echo Download sox from http://sox.sour…

bulk-ivr-normize

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:04:57 +0000

Bulk IVR Normalize wav files IVR audio files should on average have a max volume of 50% which is -6dB This batch file uses the command line utility sox to normlizes wav files within a folder and sub folder to this level. Prior to using this batch file include sox. Note: You may need to adjust Sox folder in the PATH in the batch depending on Sox version.

convert-raw-alaw

anonymous@undisclosed.example.com (Anonymous) — Mon, 15 Sep 2025 10:08:33 +0000

Convert raw to A-Law Note * f → each file that matches *.pcm - "f“ → the full filename (e.g. input.pcm) * ~nf → just the name without extension (e.g. input) - "~nf.wav” → builds the output filename with .wav : Gerard O'Rourke : Michael Brophy : Version 1.1 @echo off cls set confirm=N echo *************************** echo Audio ALAW Converting tool echo *************************** echo The sox.exe must be located in the current folder or on the OS PATH. echo Download sox from http:/…

convert-to-8k

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:02 +0000

Bulk Convert Batch file for converting to 8K @echo off : Gerard O'Rourke : Michael Brophy : Version 1.1 :::::: UPDATE BELOW to the CORRECT FOLDER NAME ::::::: set SOX-FOLDER=C:\Program Files (x86)\sox-14-4-1\ set PATH=%PATH%;%SOX-FOLDER% cls set confirm=N echo ************************************* echo Converting tool - to 8K Sampling Rate echo ************************************* echo echo Download sox from http://sox.sourceforge.net/ echo ********************************************…

convert-to-ulaw

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:07 +0000

Bulk Convert Batch file for converting to Ulaw : Gerard O'Rourke : Michael Brophy : Version 1.1 @echo off cls set confirm=N echo *************************** echo Audio Mu-LAW (Ulaw) Converting tool echo *************************** echo The sox.exe must be located in the current folder or on the OS PATH. echo Download sox from http://sox.sourceforge.net/ echo ****************************************************************** echo. set /P confirm=Do you want to proceed and overwrite and co…

convert-ulaw-to-alaw

anonymous@undisclosed.example.com (Anonymous) — Sun, 27 May 2018 09:01:33 +0000

Bulk Convert Batch file for converting Ulaw to Alaw : Gerard O'Rourke : Michael Brophy : Version 1.1 @echo off cls set confirm=N echo *************************** echo Audio ALAW Converting tool echo *************************** echo The sox.exe must be located in the current folder or on the OS PATH. echo Download sox from http://sox.sourceforge.net/ echo ****************************************************************** echo. set /P confirm=Do you want to proceed and overwrite and conver…

copy-cvp-media

anonymous@undisclosed.example.com (Anonymous) — Wed, 22 May 2019 13:19:56 +0000

Copy Media Files for CVP This script will copy files from the A side Server to teh B side server. It will only copy files that do not exist or are newer on the A side : Gerard O'Rourke : 20/08/2016 : Copy Audio Files from A to B side @echo off cls echo =========== MEDIA FILES ============= echo. echo ************************************* echo * Warning this file will copy files * echo * from the A side to B side server * echo * Only Later Modified files will be * echo * copied * echo …

copycallbackstologger

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:15 +0000

Copy Callbacks to Logger @echo off : Gerard O'Rourke : version 1.0 : Date 13/10/2017 SET IMPORTFILE=SystemTest.csv SET CALLBACKFILTERFILES=SystemTest SET LOGGERA=UCCE-RGR-A SET IMPORTSHARE=\\%LOGGERA%\DialerImport\ SET CALLBACKFOLDER=C:\X-Callbacks\ SET CALLBACKFILTER=Callback SET TEMPFILE=%CALLBACKFOLDER%\%CALLBACKFILTERFILES%-Temp.csv : *********************************************************************** :Check if Logger is up before Proceeding REM One Ping First to get it in ARP Ta…

cvp

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:15 +0000

Copy files from One Media Server to the other(s) This script will copy only later modifed files from A sever to B server. : Gerard O'Rourke : 20/08/2016 : Copy Audio Files from A to B side @echo off cls echo ************************************* echo * Warning this file will copy files * echo * from the A side to B side server * echo * Only Later Modified files will be * echo * copied * echo ************************************* echo. set confirm=N set /P confirm=Do you want to proce…

date-time

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:15 +0000

Timestamp Batch file FOR /F "TOKENS=1 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET dd=%%A FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B FOR /F "TOKENS=1,2,3 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET yyyy=%%C SET mydate=%yyyy%%mm%%dd%

delete-files-older-than

anonymous@undisclosed.example.com (Anonymous) — Wed, 12 Jun 2019 09:16:45 +0000

Delete Files older than X days Example Delete all files with starting with blah in Folder “FolderName” older than 30 days. forfiles -p C:\FolderName -m blah*.* /d -30 -c "cmd /c del @path" Newer Windows use slightly different parameters - e.g. Windows 2012

dial-peer-config

anonymous@undisclosed.example.com (Anonymous) — Tue, 05 Mar 2019 16:51:01 +0000

Convert voice Dial-peer config into a CSV Table Initial * install sed for windows * get the running config of router(s) Batch file : Author Gerard O'Rourke : Date 05/03/2019 : To export Dial-peer config into table format : Note cannot handle dial-peer config which contain : a single quote (two quotes are ok) or "&" cls @echo off REM Setting a Timestamp variable which can be used in a batch file FOR /f "tokens=1-4 delims=/ " %%A IN ('date /t') DO ( set nday=%%A set nmonth=%%B set nyea…

home

anonymous@undisclosed.example.com (Anonymous) — Wed, 15 May 2024 12:16:52 +0000

Scripts Regex * Convert from G723 to G711 using FFMPEG ffmpeg -i 888001000029999.wav -c:a pcm_alaw output1.wav * top-tips * mask-password-in-a-batch-file * ping * cvp * simple-ping-timestamp * putty-login * Bulk Convert Audio to Alaw * Bulk Convert Audio to ulaw * Bulk Convert Audio to 8K Sampling Rate * Bulk Normalise wav files to -6dB for an IVR * Bulk Trim Wav Files for just the first 60 seconds * Bulk Remove Left Channel from Audi…

mask-password-in-a-batch-file

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:16 +0000

mask a password inputed in a batch file @echo off powershell -Command $pword = read-host "Enter password" -AsSecureString ; $BSTR=[System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($pword) ; [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($BSTR) > .tmp.txt & set /p password=<.tmp.txt & del .tmp.txt echo %password%

ping

anonymous@undisclosed.example.com (Anonymous) — Mon, 11 Mar 2024 11:34:51 +0000

PING Scripts Bulk Ping @echo off :start cls set mypath=%cd% FOR /F %%i IN (%mypath%\IPaddresses.conf) DO ( ping %%i -n 1 -w 2000 | find "TTL" || echo %%i is DOWN ) pause goto start 192.168.1.1 192.168.1.2 192.168.1.3 192.168.1.4 Ping test start "ping-test" ping 1.1.1.1 -t start "ping-test" ping 8.8.8.8 -t

putty-login

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:17 +0000

Putty command line Login Create a two files, a config file and a batch file as in below example config.cmd @echo off set PATH=%PATH%;C:\PuttyFolder\ set USERNAME=username1 set PASSWORD= set /P USERNAME=Enter Username [%USERNAME%]? REM Password below can be seen on screen so deprecate this version and use alterntive REM set /P PASSWORD=Enter Password [%PASSWORD%]? REM Powershell command below **** out the password on screen. powershell -Command $pword = read-host "Enter password" -AsSecu…

simple-ping-timestamp

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:17 +0000

simple Ping with timestamp Copy and paste below into a batch file, e.g. “test-ping.cmd” Edit the Address value to the host you want to ping @echo off : Gerard ORourke : simple PING with Timestamp set ADDRESS=127.0.0.1 Set COUNT=60 set FILENAME=Output-PING.txt echo Ping Started. Pinging Address: %ADDRESS% echo Please Check Output File %FILENAME% to confirm Ping test is OK :start echo. >> %FILENAME%% echo *********************>> %FILENAME%% echo %date% >> %FILENAME%% echo %time% >> %FILE…

simplesqlscript

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:17 +0000

Simple SQL Script Batch file @echo off : Gerard O'Rourke : Date 13/09/2016 : FOR /F "TOKENS=1 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET dd=%%A FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B FOR /F "TOKENS=1,2,3 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET yyyy=%%C SET /P dd=Please enter Day (dd) [%dd%]? SET /P mm=Please enter Month (mm) [%mm%]? SET /P yyyy=Please enter Year (yyyy) [%yyyy%]? echo RUNNING SQL QUERY echo. call sqlcmd -v mydate="%yyyy%-%mm%-%dd%" -i SamplePr…

sql-backup

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:18 +0000

Backup SQL database sqlcmd -Q "BACKUP DATABASE TO DISK='C:\Backup\mydatabase.bak'" Example of a script which backs up database with today's date and moves to a network folder. @echo off set LOGFILE=SQL-ScriptBackup.log set DBNAME=cvp_dn_config set BACKUP-FOLDER=D:\X-Backup FOR /f "tokens=1-4 delims=/ " %%A IN ('date /t') DO ( set nday=%%A set nmonth=%%B set nyear=%%C ) set SORTDATE=%nyear%%nmonth%%nday% FOR /f "tokens=1-2 delims=: " %%A IN ('time /t') DO ( set hour=%%A se…

sql-restore

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:18 +0000

SQL Restore script sqlcmd -Q "RESTORE DATABASE FROM DISK= WITH REPLACE" Simple Example sqlcmd -Q "RESTORE DATABASE mydatabase FROM DISK=C:\Backup\mydatabase.bak WITH REPLACE" Example script which restores a backup file with today date, and then deletes backup files older than 30 days

time-elapsed

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 19:05:18 +0000

Time Elapsed Aacini Code from here @echo off rem Get start time: for /F "tokens=1-4 delims=:.," %%a in ("%time%") do ( set /A "start=(((%%a*60)+1%%b %% 100)*60+1%%c %% 100)*100+1%%d %% 100" ) rem Any process here... rem Get end time: for /F "tokens=1-4 delims=:.," %%a in ("%time%") do ( set /A "end=(((%%a*60)+1%%b %% 100)*60+1%%c %% 100)*100+1%%d %% 100" ) rem Get elapsed time: set /A elapsed=end-start rem Show elapsed time: set /A hh=elapsed/(60*60*100), rest=elapsed%%(60*60*100),…

top-tips

anonymous@undisclosed.example.com (Anonymous) — Tue, 05 Mar 2019 14:12:49 +0000

Batch file Top tips echo without a new line - e.g. use "." to show progress in a loop echo | set /p=. ENABLEDELAYEDEXPANSION Use in FOR loops to get variable as it is set there (rather than a parse time) - need to use !var! rather than %var% Google it! But any scripts with a ! get messed up!

ucce

anonymous@undisclosed.example.com (Anonymous) — Tue, 25 Sep 2018 15:24:48 +0000

UCCE - dumplog scripts @echo off : Gerard O'Rourke : 24/02/2009 : Version 4.1 set icm-cust-name=icm set icmPG=2A set mylogdir=D:\Xtemp set hour=00 set min=00 :Calcutate DATE FOR /f "tokens=1-4 delims=/ " %%A IN ('date /t') DO ( set nday=%%A set nmonth=%%B set nyear=%%C ) set SORTDATE=%nyear%%nmonth%%nday% set begindate=%nmonth%/%nday%/%nyear% echo Simple ICM Utility to collect PIM, OPC, CTI Server and CTIOS Logs echo ----------------------------------------------------------------- echo…

wfm

anonymous@undisclosed.example.com (Anonymous) — Wed, 15 May 2024 12:17:31 +0000

WFM Script Doesn't include the SQL FOR /F "TOKENS=1 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET dd=%%A FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B FOR /F "TOKENS=1,2,3 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET yyyy=%%C REM Set Date to Today SET mydate-ymd=%yyyy%%mm%%dd% SET /A yy=%yyyy%-2000 SET mydate-dmy=%dd%%mm%%yy% REM ========= SET DIRECTORY HERE ============== SET mylocalpath=C:\X-Support\SheduledTask\Daily\ SET mypath=\\server\blah SET myfilename=filename_%myda…