Search This Blog

2011-10-26

how-to start putty from the command line with pre-saved session

:: Start - Run - type cmd /c START /max putty -load userName@ServerHostName.Domain.com Now if you would like to export your putty settings from PC to PC you could use the following cmd for that : (Hint: I use to Have the following folder structure C:\Temp\<>\conf\<>\conf\putty ) Now <> is var and <> is var ... thus you could keep all the PC's settings always with you ; )
@ECHO OFF
ECHO any comments suggestions are welcome at : 
ECHO http://ysgitdiary.blogspot.com/search/label/Putty
ECHO This batch file copies some the needed settings of Putty
ECHO it depends on a simple GetNiceTime_on_%computername%.cmd 
ECHO batch file producing the %_NICETIME% variable in YYYYMMDD_hhmmss 
ECHO format
ECHO Tested on Win7 64 -bit Putty 
ECHO you should call this batch file from its current directorry
 
:: GET A YYYYMMDD_hhmmss TIMESTAMP
call GetNiceTime_on_%computername%.cmd
 
SET _RegFileWithSettings=PuttySettings_Helios_on_%COMPUTERNAME%_%NiceTime%.reg
SET _RunLog=%0.run.log
SET _ErrorLog=%0.error.log
::SET _PuttySynFilesDirOnWin64=%ProgramFiles(x86)%\Putty 5\system
::SET _PortableSynFilesDir=%CD%\system
SET _RegistryKey=HKEY_CURRENT_USER\Software\SimonTatham
SET _RegistryFilesDir=%CD%\reg
SET _RegistryFileWithSettings=%_RegistryFilesDir%\PuttySettings_on_%computername%_%NiceTime%.reg
SET _LogDir="%CD%\log"
 
 
ECHO START REGISTRY SETTINGS EXPORT AT %_NiceTime%
ECHO RUN LOG : START REGISTRY SETTINGS EXPORT AT %_NiceTime%  >%_RunLog%
ECHO ERROR LOG START REGISTRY SETTINGS EXPORT AT %_NiceTime%  >%_ErrorLog%
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
ECHO create a directory called sysm in the current directory 
ECHO create a directory called sysm in the current directory 1>>%_RunLog% 2>> %_ErrorLog% 
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
ECHO now copy alls the files from the %Program Files(x86)%\Putty 5\system\ 
ECHO now copy alls the files from the %Program Files(x86)%\Putty 5\system\ 1>>%_RunLog% 2>> %_ErrorLog%
 
ECHO IF NOT EXIST %_PortableSynFilesDir% MKDIR %_PortableSynFilesDir% 1>>%_RunLog% 2>> %_ErrorLog%
:: IF NOT EXIST %_PortableSynFilesDir% MKDIR %_PortableSynFilesDir% 1>>%_RunLog% 2>> %_ErrorLog%
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
ECHO COPY EACH syn files 
:: for /f "tokens=*" %%i in (' dir "%_PuttySynFilesDirOnWin64%\*.syn" /s /b') do copy /y "%%i" "%_PortableSynFilesDir%" 1>>%_RunLog% 2>> %_ErrorLog%
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
:: CREATE THE _RegistryFilesDir if it does not exist 
ECHO IF NOT EXIST %_RegistryFilesDir% MKDIR %_RegistryFilesDir% 1>>%_RunLog% 2>> %_ErrorLog%
IF NOT EXIST %_RegistryFilesDir% MKDIR %_RegistryFilesDir% 1>>%_RunLog% 2>> %_ErrorLog%
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
:: NOW PERFORM THE ACTUAL EXPORT OF THE CURRENT SETTINGS
ECHO REG EXPORT "%_RegistryKey%" "%_RegistryFileWithSettings%" 1>>%_RunLog% 2>> %_ErrorLog%
REG EXPORT "%_RegistryKey%" "%_RegistryFileWithSettings%"
 
ECHO IF NOT EXIST %_LogDir% MKDIR %_LogDir% 1>>%_RunLog% 2>> %_ErrorLog%
IF NOT EXIST %_LogDir% MKDIR %_LogDir% 1>>%_RunLog% 2>> %_ErrorLog%
ECHO.1>>%_RunLog% 2>> %_ErrorLog%
 
ECHO COPY THE LOG FILES TO THE LOG DIRECTOREY FIRST 
FOR /F %%i in ('dir "%CD%\*.log" /b') do copy /y "%%i" "%_LogDir%\"
 
:: DEBUG PAUSE
:: wait for 3 seconds 
ping localhost -n 3
 
ECHO DONE NOW OPEN THE LOG FILES TO SEE THE RESULTS  :
:: if you donät have textpad FOR /F %%i in ('dir "%CD%\log\*.log" /s /b') do cmd /c start /max notepad "%%i"
FOR /F %%i in ('dir "%_LogDir%\*.log" /s /b') do cmd /c start /max textpad "%%i"
 
 
ECHO NOW DELETE THE ALREADY COPIED LOG FILES FROM THE CURRENT DIR
FOR /F %%i in ('dir "%CD%\*.log" /b') do del  /q "%%i" 
 
 
:: NOW OPEN TO VIEW THE REGISTRY FILE AS WELL
:: CMD /C START /MAX notepad %_RegistryFileWithSettings%
CMD /C START /MAX textpad %_RegistryFileWithSettings%
:: HINT: you could execute any dos file including this one by creating a new external tool
:: Command: cmd.exe , Parameters: CMD /C $FileName , Check Prompt for parameters 
:: Check Save all documents first , Check Capture output , Check Suppress output untill completed

2011-10-12

2011-10-11

Cool programs , utilities and programming environments for Windows, most of which free ( revised )

Opera - simply the best browser on the planet
Google Chrome
Firefox
strawberry perl for Windows (with dmake for modules )
Cygwin
SysInternals Suite
izarc - the best zipper
Process Explorer - shows resources usage per running process on Windows
Google Earth
Picasa - the best free picture viewer , organizer
Mozilla Thunderbird
Textpad - the best text editor for Windows
smstoolpack - create CRUD for sql server
GreenShot
Open diff - tool for comparing sql server 2005 databases
Skype - the best client for Internet and Video Telephony
NSIS - the best open source Windows installer maker
And the time plugin
Gears -- edit online documents offline
Free youtube to ipod converter -- get mp4 files easily to your phone
Defragler - Disk Defragment utility
DvdDecrypter - the best DVD free ripper
ImgBurner - burn ISO images - freeware
ArsClip remembers your clibboard stuff - Hint , Ctrl + Shift + Z , 2
colorpic - Color to hex utility
Expresso - a GUI tool for building and verifying Regular Expressions
a flv file player
Python - for cool scripts and programming
STARUML - the best open source UML editor
Infrarecorder - free CD / DVD burner
Paint.Net - freeware image editor
putty
winscp
Multiline Search and Replace utility program
Google Gears - use Gmail offline
HijackThis
tortoise svn - a stable gui and command line to subversion for Windows
slik svn - the command line tools for svn for windows
Data Recovery - recover Shift + del removed programs
Windows Sysinternal utilities
Cmdow is a Win32 commandline utility for NT4/2000/XP/2003 that allows windows to be listed, moved, resized, renamed, hidden/unhidden, disabled/enabled, minimized, maximized, restored, activated/inactivated, closed, killed and more.
Grep , FGrep and Egrep for windows (remember the dll's also )
Less for Windows ( remember the dll's also )
7-zip
Rise Editor - Entity Relationship Diagram tool
Adobe Acrobat
Virtual Clone Drive - Map ISO files
svn client and server
Doxygen - code documentation utility
Qt - Nokia's Development Platform
Dia - control flow chars freeware software
AudioGrabber - the best mp3 ripper
AutoHotKey - GUI automating
Fiddler - http sniffer
Windows GNU utils
Active Perl
Safari -

2011-10-01

Some audience stats ... A like the Google's BI diagrams design ...

Sh Cheat Sheet

#File:ShCheatSheet.sh v.1.1.0 docs at the end 
#source:http://www.dartmouth.edu/~rc/classes/ksh/index.html#for loop example
for file in * ; do echo Processing $file ; done ; 
 
for file in  `ls -1` ; do echo Processing $file ; done ; 
 
#if example 
 
if [ -r $myfile ]
then
   cat $myfile
else
   echo $myfile not readable
fi
 
#case example 
 
case $filename in
*.dat)
echo Processing a .dat file
;;
*.sas)
echo Processing a .sas file
;;
*)
# catch anything else that doesn't match patterns
echo "Don't know how to deal with $filename"
;;
esac
 
 
*
Matches any zero or more characters. 
?
Matches any one character. 
[string]
Matches exactly one character that is a member of the string string. This is called a character class. As a shorthand, string may contain ranges, which consist of two characters with a dash between them. For example, the class ‘[a-z0-9_]’ matches a lowercase letter, a number, or an underscore. You can negate a class by placing a ‘!’ or ‘^’ immediately after the opening bracket. Thus, ‘[^A-Z@]’ matches any character except an uppercase letter or an at sign. 
\
Removes the special meaning of the character that follows it. This works even in character classes.
 
# while example 
count=0
max=10
while [[ $count -lt $max ]] ; do 
  echo $count ; 
  count=$((count + 1)) ; 
done ; 
echo "Value of count after loop is: $count"
 
 
 
wlog(){
        echo "`date +%Y.%m.%d-%H:%M:%S` [$$] $*" >> $LOGFILE
        test -t 1 && echo "$*"
}
 
send_mail(){
        # $1 = subject
        # $* = recipients
        # - = text
        test -z "$2" && {
                wlog "NOTICE: no mail recipients"
                return 0
        }
        _sm_s="$1"
        shift 1
        mailx -s "$_sm_s" $* || {
                wlog "ERROR: Failed to send mail to $*"
                return 1
        }
        return 0
}
 
#get a nice date
`date +%Y%m%d%H%M%S`
 
outgoing_dirs=`find $ROOTDIR -type d -name 'outgoing'`
 
for odir in $outgoing_dirs
do
        test -d "$odir" || continue
        find $odir -type f -mtime $MAXAGE -print0 | xargs --null -r $debug rm
done
 
#The ultimate find in files 
DirToSearch=/var/log/
FilesToSearch=`ls -rt $DirToSearch`
for file in $FilesToSearch
do
        file=$DirToSearch/$file
        test -f "$file" || continue 
        grep -nH 'sekauppi' $file  
done
 
 
find $DirToSearch -type f -exec grep -nH 'yogeorgi' {} \; | less 
 
today=`date +%Y%m%d`
yesterday=`date --date yesterday +%Y%m%d`
 
Help(){
        cat<<EOF
 
`basename $0` [-t filetype] [-f srcfile] [-o outfile] [-D outdir]
        [-u owner] [-g group] [-U srcurl] [-d day -d day2 ...]
        [-F] [-b daysback]
 
        filetype:       {userlist | auditlog}
        user:           $channel_user
        srcurl:         $BASE_URL
        daysback:       $DAYS_BACK
 
        -F to force download even if file was downloaded already
EOF
 
#Purpose: 
# Provide an easy copy paste resource for sh programming
# VersionHistory: 
# 1.1.0 --- ysg --- Updated docs , published 
# 1.0.0 --- ysg --- Initial version , see main source 

mysql cheat sheet

-- File:MySqlCheatSheet.sql v.1.1.0 docs at the end 
 
/* [mysql dir] */
/bin/mysql -h hostname -u root -p 
 
mysql -u userName -p  -D DbName -B -e "select * from users;"   > /home/yogeorgi/tmp/list.csv ;
mysql -u userName -p  -D information_schema -B -e "select columns from columns;"   > /home/yogeorgi/tmp/list.csv ;
 
-- Batch mode (feeding in a script): 
mysql -u user -p < batch_file
/* (Use -t for nice table layout and -vvv for command echoing.) */
-- Alternatively: 
source batch_file;
 
 
-- List all databases on the mysql server. 
show databases;
 
/* Switch to a database. */
use [db name];
 
-- get all the tables in the currently selected database 
show tables;
 
-- get the table's fields format 
describe [TableName];
 
-- to remove a db
drop database [database name];
 
-- to drop a table 
drop table [TableName];
 
/* Show all data in a table. */
SELECT * FROM [TableName];
 
/* Returns the columns and column information pertaining to the designated table.  */
show columns from [TableName];
 
/* Show certain selected rows with the value "whatever". */
SELECT * FROM [TableName] WHERE [field name] = "whatever";
 
/* Show all records containing the name "Bob" AND the phone number '3444444'.  */
SELECT * FROM [TableName] WHERE name = "Bob" AND phone_number = '3444444';
 
/* Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field.  */
SELECT * FROM [TableName] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;
 
/* Show all records starting with the letters 'bob' AND the phone number '3444444'.  */
SELECT * FROM [TableName] WHERE name like "Bob%" AND phone_number = '3444444';
 
-- Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. 
-- This finds any record beginning with a. 
SELECT * FROM [TableName] WHERE rec RLIKE "^a$";
 
-- how-to show only unique records. 
SELECT DISTINCT [column name] FROM [TableName];
 
/* Show selected records sorted in an ascending (asc) or descending (desc).  */
SELECT [col1],[col2] FROM [TableName] ORDER BY [col2] DESC;
 
/* Return number of rows. */
SELECT COUNT(*) FROM [TableName];
 
/* Sum column. */
SELECT SUM(*) FROM [TableName];
 
/* Join tables on common columns.  */
 
select lookup.illustrationid, lookup.personid,person.birthday from lookup
left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;
 
/* Switch to the mysql db. Create a new user.  */
 
INSERT INTO [TableName] (Host,User,Password) VALUES('%','user',PASSWORD('password'));
 
-- Change a users password.(from unix shell). 
[mysql dir]/bin/mysqladmin -u root -h  hostname.blah.org -p password 'new-password'
 
-- Change a users password.(from MySQL prompt).
SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
 
/* Allow the user "bob" to connect to the server from localhost using the password "passwd"  */
grant usage on *.* to bob@localhost identified by 'passwd';
 
/* Switch to mysql db.Give user privilages for a db. */
INSERT INTO [TableName] (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N'); 
 
/* OR  */
grant all privileges on databasename.* to username@localhost;
 
/* To update info already in a table. */
UPDATE [TableName] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user'; 
 
/* ADelete a row(s) from a table. */
DELETE from [TableName] where [field name] = 'whatever';
 
-- how-to Update database permissions/privilages. 
FLUSH PRIVILEGES;
 
-- how-to delete a column
alter table [TableName] drop column [column name]; 
 
-- how-to add a new column to table 
alter table [TableName] add column [new column name] varchar (20);
 
-- how-to change a column name in a table 
alter table [TableName] change [old column name] [new column name] varchar (50);
 
-- Make a unique column so you get no dupes.  
alter table [TableName] add unique ([column name]); 
 
-- Make a column bigger
alter table [TableName] modify [column name] VARCHAR(3);
 
-- Delete unique from table. 
alter table [TableName] drop index [colmn name]; 
 
--how-to load a CSV file into a table.
LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [TableName] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);
 
/* Dump all databases for backup. Backup file is sql commands to recreate all db's.  */
[mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql
 
-- Dump one database for backup. 
[mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql 
 
-- Dump a table from a database
[mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql
 
-- Restore database (or database table) from backup. 
[mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql 
 
/* Create Table Example 1. */
CREATE TABLE [TableName] (
  FirstName                 VARCHAR(20)
, MiddleName             VARCHAR(3)
, LastName                 VARCHAR(35)
, Suffix                     VARCHAR(3)
, OffficeId                     VARCHAR(10)
, UserId                     VARCHAR(15)
, UserName             VARCHAR(8)
, Email                     VARCHAR(35)
, Phone                     VARCHAR(25)
, Groups                     VARCHAR(15)
, DateStamp             DATE
, TimeStamp             time
, PgpEmail                 VARCHAR(255)
); 
 
-- Create Table Example 2. 
create table [TableName] (
   personid int(50) not null auto_increment primary key
 , firstname varchar(35)
 , middlename varchar(50)
 , lastnamevarchar(50) default 'bato'
);
 
 
-- Inserting one row at a time: 
INSERT INTO table_name VALUES ('MyName', 'MyOwner', '2002-08-31');
(Use NULL for NULL)
 
-- Retrieving information (general):
SELECT from_columns FROM table WHERE conditions;
 
-- All values:  
SELECT * FROM table;
 
-- Some values:  
SELECT * FROM table WHERE rec_name = "value";
 
-- Multiple critera: 
SELECT * FROM TABLE WHERE rec1 = "value1" AND rec2 = "value2";
 
-- Reloading a new data set into existing table:
SET AUTOCOMMIT=1; # used for quick recreation of table
 
DELETE FROM pet;
 
LOAD DATA LOCAL INFILE "infile.txt" INTO TABLE table;
 
-- Fixing all records with a certain value:
UPDATE table SET column_name = "new_value" WHERE record_name = "value";
 
-- Selecting specific columns:
SELECT column_name FROM table;
 
-- Retrieving unique output records:
SELECT DISTINCT column_name FROM table;
 
-- Sorting:
SELECT col1, col2 FROM table ORDER BY col2;
Backwards: SELECT col1, col2 FROM table ORDER BY col2 DESC;
 
--Date calculations:
SELECT CURRENT_DATE, (YEAR(CURRENT_DATE)-YEAR(date_col)) AS time_diff [FROM table];
MONTH(some_date) extracts the month value and DAYOFMONTH() extracts day.
 
-- Pattern Matching:
SELECT * FROM table WHERE rec LIKE "blah%";
(% is wildcard - arbitrary # of chars)
Find 5-char values: SELECT * FROM table WHERE rec like "_____";
(_ is any single character)
 
-- Extended Regular Expression Matching:
SELECT * FROM table WHERE rec RLIKE "^b$";
(. for char, [...] for char class, * for 0 or more instances
^ for beginning, {n} for repeat n times, and $ for end)
(RLIKE or REGEXP)
To force case-sensitivity, use "REGEXP BINARY"
 
 
-- Grouping with Counting:
SELECT owner, COUNT(*) FROM table GROUP BY owner;
(GROUP BY groups together all records for each 'owner')
 
-- Selecting from multiple tables:
SELECT pet.name, comment FROM pet, event WHERE pet.name = event.name;
(You can join a table to itself to compare by using 'AS')
 
-- Currently selected database:
SELECT DATABASE();
 
-- Maximum value:
SELECT MAX(col_name) AS label FROM table;
 
-- Auto-incrementing rows:
CREATE TABLE table (number INT NOT NULL AUTO_INCREMENT, name CHAR(10) NOT NULL);
INSERT INTO tabe (name) VALUES ("tom"),("dick"),("harry");
 
-- Adding a column to an already-created table:
ALTER TABLE tbl ADD COLUMN [column_create syntax] AFTER col_name;
 
-- Removing a column:
ALTER TABLE tbl DROP COLUMN col;
(Full ALTER TABLE syntax available at mysql.com.)
 
-- Create a database on the sql server. */
create database [databasename];
 
-- Backing up a database with mysqldump:
# mysqldump --opt -u username -p database > database_backup.sql
(Use 'mysqldump --opt --all-databases > all_backup.sql' to backup everything.)
 
-- how-to export to csv the db's metadata 
use information_schema ; 
 
SELECT     TABLE_CATALOG  , TABLE_SCHEMA  , TABLE_NAME  , COLUMN_NAME  , ORDINAL_POSITION  , COLUMN_DEFAULT  , IS_NULLABLE  , DATA_TYPE  , CHARACTER_MAXIMUM_LENGTH  , CHARACTER_OCTET_LENGTH  , NUMERIC_PRECISION  , NUMERIC_SCALE  , CHARACTER_SET_NAME  , COLLATION_NAME  , COLUMN_TYPE  , COLUMN_KEY  , EXTRA  , PRIVILEGES  , COLUMN_COMMENT
INTO OUTFILE '/var/lib/mysql/information_schema.csv'
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY ' ' 
LINES TERMINATED BY '\n' 
from COLUMNS; 
 
 
-- Purpose: 
-- This is a list of handy MySQL commands that I use time and time again. 
-- At the bottom are statements, clauses, and functions you can use in 
-- To login (from unix shell) use -h only if needed. 
-- Shamelessly stolen from Internet and forgot to mention the sources ... 
 
-- VersionHistory
-- 1.1.0 --- ysg --- docs, formatting 
-- 1.0.0 --- ysg --- Hard copy paste from Internet ... 

win registry cheat sheet


Windows Registry Editor Version 5.00
;File:WinRegistryCheatSheet.reg : v1.1.0 docs at the end
;HOW TO IMPORT SILENTLY A REGISTRY FROM A FILE

;REMEMBER TO SAVE ALLWAYS YOUR REG FILES IN ANSI
;reg import /s C:\temp\the_name_of_the_file.reg
;HOW TO GO TO SPECIFIC KEY
;DOWNLOAD REGJUMP regjump "[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs]"


;PUT THE NAME OF THE COMMANDS YOU WOULD LIKE NOT TO TYPE
;FROM THE START - RUN
[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs]
"url1"="firefox http://www.youtube.com/my_playlists"
"url2"="firefox http://gmail.google.com"
"url3"="C:\\Program Files\\Opera\\opera.exe g toSearch"
"url4"="firefox http://www.google.com/search?hl=en&q= typeHereTheWordToSearch"
;Note the space before typeHereTheWordToSearch if yount to have several words
;ANOTHER CACHE FOR THE RUN MENU
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU]
"a"="shutdown -f -s -t 00"
"b"="shutdown -f -r -t 00"
"c"="shutdown -f -h -t 00"
"d"="opera g toSearch"


;THE FOLLOWING ARE HISTORY KEYS, FOR TYPED URLS ,LAST DOCUMENTS ETC
[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs]
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU]
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RecentDocs]
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\ComDlg32\LastVisitedMRU]
[HKEY_CURRENT_USER\Software\Microsoft\Search Assistant\ACMru]

[HKEY_CLASSES_ROOT\*\shell\cmdhere]
@="Cmd&Here"

[HKEY_CLASSES_ROOT\*\shell\cmdhere\command]
@="cmd.exe /c start cmd.exe /k pushd \"%L\\..\""

[HKEY_CLASSES_ROOT\Folder\shell\cmdhere]
@="Cmd&Here"

[HKEY_CLASSES_ROOT\Folder\shell\cmdhere\command]
@="cmd.exe /c start cmd.exe /k pushd \"%L\""

;add a command line functionality from Start - Run with Opera on Windows
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\opera.exe]
@="C:\\Program Files\\Opera\\opera.exe"
"Path"="C:\\Program Files\\Opera"

;Purpose: provide a single reg import <<FilePath>> to commonly used registry settings
;VersionHistory
;1.1.0 --- ysg --- refactor added in morphus
;1.0.0 --- ysg --- initial creation

cmd cheat sheet ( revised )


::File:Cmd_Cheat_Sheet.cmd v.1.2.0

:: GET A NICE PROMPT
set prompt=$P$S$S$t$_$_$S$S

:: forcely restart now
shutdown -r -f -t 00
:: forcely shutdown now
shutdown -s -f -t 00
:: forcely hibernate now
shutdown -h -f -t 00


RUNAS /profile /user:userName " shutdown.exe -r -f -m \\remoteHost"

:: execute command remotely not working
LSrunas /user:userName /password:company01 /domain:%computername% /command:"reboot -r -f -m \\remoteHost" /runpath:"C:\Temp\QARunpack\bin"


psexec -u user001 -p pass "shutdown.exe -r -f -m \\RemoteHostName "
psexec -u user001 -p pass "shutdown.exe -r -f -m \\RemoteHostName"

LSrunas /user:userName /password:company01 /domain:%computername% /command:" updateTRN.bat \\1USD01011" /runpath:"C:\Temp\QARunpack\bin"

:: ADDING USER WITH PASS
net user userName company01 /ADD
:: ADDING USER TO THE LOCALGROUP ADMINISTRATORS
net localgroup "Administrators" userName /add
:: ADDING VANTAGE USER IDENTIFIED BY company01 TO THE LOCALGROUP ADMINISTRATORS
net user vantage company01 /add
:: ADDING USER TO THE LOCALGROUP ADMINISTRATORS
net localgroup "Administrators" vantage /add
:: OPENS THE EXPLORER IN THE C:\TEMP FOLDER MAXIMIZED - USE THE /MIN OPTION TO GET

:: THE WINDOWS STARTED MINIMIZED
cmd /c start /max Explorer /e , "C:\Temp"
:: RUN THE REGEDIT AS A SPECIFIC USER
RUNAS /profile /user:userName regedit | sanur /i C:\utils\psts.txt
:: REboot agent remotely using the runas command - WORKS !!!!
:: START A CMD PROMPT UNDER THE userName user
RUNAS /profile /user:userName cmd.exe | sanur /i C:\utils\psts.txt
RUNAS /profile /user:userName " shutdown.exe -f -r -t 00 -m \\RemoteHostName"
::WORKS ALSO NEEDS SANUR http://www.commandline.co.uk/sanur_unsupported/index.html
RUNAS /profile /user:userName " shutdown.exe /f /r /t 00 /m \\2SGD00070" | sanur /i C:\utils\psts.txt

runas /u:domain\username program.exe | sanur /i C:\utils\psts.txt
:: GET ALL THE INFORMATION RELATED TO NETWORKING ON A WINDDOWS STATION
ipconfig /all
:: USE OF FOR /F
FOR /F "usebackq delims=\" %i IN (`DIR /AD /B`) DO FIND /I "TEMP"
:: LIST THE RUNNING APPLICATIONS
tasklist /v
:: FIND SOMETHING IN A COMMAND
ipconfig /all | find /i "Address"
:: EXPORT AND PARSE VALUE FROM THE REGISTRY
setlocal
if exist tmp.reg del /q tmp.reg
reg export "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon" tmp.reg
for /f "tokens=2 delims==" %%a in ('find /i "username" tmp.reg') do set line=%%a&call :strip
endlocal
goto :EOF
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:strip
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
set usr=%line:"=%
echo/the user is %usr%>>%computername%.txt
del /q tmp.reg
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: ANOTHER WAY OF EXPORTING KEYS FROM THE REGISTRY
regedit /e c:\zzz\reg.reg "HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer"

:: COUNT THE NUMBER OF SPECIFIC TYPE OF FILES ARE THEY IN A SPECIFIED DIRECTORY
for /f "tokens=* delims=" %%i in ('dir C:\Temp\scripts\*.* /b /a-d ^| find /i /c "mdb"') do @echo num of scripts is %%i>>"%cd%\%computername%.txt"

:: LABEL EACH FILE IN A DIRECTORY
for /f "tokens=* delims=" %%i in ('dir /b C:\Temp\scripts\*.mdb') do @echo installed script %%i >>"%cd%\%computername%.txt"

:: START EXPLORER
for /f "tokens=* delims=" %%i in ('type DrillDownAllNames.txt') do (
)
:: CHANGE DRIVE AND DIRECTORY AT THE SAME TIME.
cd /d %ProgramFiles%
:: COMMAND SEPERATOR. EXECUTES TWO (OR MORE) COMMANDS ON ONE LINE.
dir & path
SAME, BUT THE ECHO COMMAND WILL ONLY BE EXECUTED WHEN THE COPY WAS SUCCESFUL.
copy a b && echo
SAME, ONLY IF UNSUCCESFUL.
copy a b || goto error

GOTO THE ERRORLABEL, IF THE PREVIOUS COMMAND EXITTED WITH AN ERRORLEVEL BIGGER THAN ZERO.
)


:: HOW TO IMPORT SILENTLY A REGISTRY FROM A FILE
reg import /s C:\temp\the_name_of_the_file.reg
reg import /s C:\temp\qarunpack\bin\PcAnyStealth.reg
:: ANOTHERWAYS TROUGH the regedit.exe
cmd /c %SystemRoot%\Regedit.exe /s thePaht\TheFile.reg

:: HOW TO EXPORT VALUES FROM THE REGISTRY INTO A FILE

:: DELETING KEYS OR VALUES USING A REG FILE
:: IT IS ALSO POSSIBLE TO DELETE KEYS AND VALUES USING REG FILES. TO DELETE A KEY START BY :: USING THE SAME FORMAT AS THE THE REG FILE ABOVE, BUT PLACE A "-" SYMBOL IN FRONT OF THE :: :: KEY NAME YOU WANT TO DELETE. FOR EXAMPLE TO DELETE THE :: :: [HKEY_LOCAL_MACHINE\SYSTEM\SETUP] KEY THE REG FILE WOULD LOOK LIKE THIS:

:: TO EXPORT A KNOW REGISTRY KEY FROM THE REGISTRY
reg export "HKEY_LOCAL_MACHINE\SYSTEM\SETUP" filename.reg


:: IF A FILE OR FOLDER EXISTS (SPELLED WITHOUT THE LETTER S ON THE END). THE PARENTHESES
:: GROUP THE COMMANDS OVER THE LINEBREAK (¶ DENOTES A LINEBREAK).

if errorlevel 1 goto error
if exist "file.log"
echo Log exists
goto end
:: ESCAPE CHARACTER TO USE REDIRECT/PIPE CHARACTERS IS THE CARET (^)
echo a -^> b
:: REDIRECTS OUTPUT (INCLUDING ERROR MESSAGES) TO FILE.LOG
command > file.log 2>&1
:: COMMAND SAME THING (BUT IT APPENDS). IN THIS WAY, YOUR BATCH FILES LOOK CLEANER.
>> file.log 2>&1
PUT MESSAGES IN STDIN.LOG AND ERROR MESSAGES IN STDERR.LOG.
command 1> stdin.log 2> stderr.log

start /wait regedit /s file.reg
:: Will ensure when the batch-file continues, the merge operation has completed.
:: regsvr32 /s file.dll Registers a COM DLL without dialog boxes (no report via %errorlevel% of
:: success/failure). Use /s /u for unregistering. :: QUIT'S THE CURRENT BATCH-FILE
:: (ONLY WORKS UNDER NT4 WHEN COMMAND EXTENTIONS ARE ENABLED, WHICH IS NOT THE DEFAULT).
goto :EOF
::THE BATCH FILE'S VERSION OF GOSUB. END THE "SUBROUTINE" WITH GOTO :EOF INSTEAD OF RETURN.
ECHO LOG >> %~N0.LOG IN A BATCH FILE: TRICK TO APPEND A MESSAGE TO A LOG WITH THE SAME NAME AS THE BATCH-FILE, BUT WITH AN OTHER EXTENSION.
call :subroutine
notepad %* In a batch file: replaced by all the arguments in a batch file.

C:\winnt\system32\drivers\etc\
147.243.4.137 servername


:: SEE THE CURRENT STATUS OF THE ACCOUNTS
net accounts


:: SET THE PASSWORDS TO NEVER EXPIRE ON THE LOCAL COMPUTER
net accounts /maxpwage:unlimited /%computername%

:: ADDS LOCAL USER NO PASSWORD NOTHING DO NOT USE
net user userName secretPass /ADD /%computername%

NET USER userName company01 /ADD /expires: never /times: all /%computername%


:: ADDS THE USERS TO THE ADMINISTRATOR GROUP
net localgroup "Administrators" userName /add
net localgroup "Administrators" user001 /add


RUNAS /profile /user:user001 REGEDIT
RUNAS /profile /user:userName REGEDIT



:: RUN CONSOLE ROOT
RUNAS /profile /user:userName mmc
psexec -u userName -p company01 cmd /c regedit.exe
psexec -u user001 -p secretPass cmd /c regedit.exe

:: FIND AND REPLACE STRING IN TEXT FILE USING GSAR
gsar "-sIMMIDIATERUN:0611" "-rIMMIDIATERUN:0610" -o "C:\Temp\settings.txt"

:: ACCESS EACH ROW FROM THE FILE
for /f "tokens=* delims=" %%a in ('more/e +0 ^<"%cd%\%computername%.txt"') do

:: COMPARING STRINGS
@echo off
set VAR=before
if "%VAR%" == "before" (
echo %var%
set VAR=after
echo %var%
pause
if "!VAR!" == "after" @echo If you see this, it worked
)
echo %var%
pause
:: OPEN THE SERVICES FROM THE COMMAND PROMPT
%SystemRoot%\system32\services.msc /s


:: THE USE OF THE SET COMMAND
set agent=something
:: WRONG !!!! AVOID SPACES BEFORE = AFTER IT AND AFTER THE RVALUE IT TAKES THOSE ALSO !!!!!!

::ALWAYS USE THE NET USE COMMAND IF YOU WANT TO USE NETWORK RESOURCES FROM CMD
net use "\\server\share\"

::USE REDIRECTING OF ERRORS THIS WAYS
copy file1 file2 2> errors.txt
errors.txt

:: CHANGE THE SETTINGS IMMIDIATERUN FROM THE COMMAND LINE
gsar "-sIMMIDIATERUN:0611" "-rIMMIDIATERUN:0610" -o "C:\Temp\settings.txt"
:: CHANGE THE REBOOOTEVERYCYCLE FROM 1 TO 0
gsar "-sREBOOTEVERYCYCLE:0611" "-rREBOOTEVERYCYCLE:0610" -o "C:\Temp\settings.txt"
:: CHANGE THE TIMEOUT FROM 30 TO 20
gsar "-sQARUN_TIMEOUT:06130" "-rQARUN_TIMEOUT06120" -o "C:\Temp\settings.txt"

:: WE DO NOT WANT TO MESS WITH SCRIPTS
IF NOT DEFINED CMDWindow Set CMDWindow=1&Start "GetAndSendInfo" /MIN %0&Goto :EOF
:: PUT THE CODE HERE
exit
:: append a new folder to the path of a
AddPath -s -n -v Path "C:\Program Files\BEA Systems\TUXEDO"

:: DLL LINKING using the regsvr32 command SILENTLY
regsvr32 /s DIV_ExtMESClient.dll

:: runthe registry as a different user


:: using runas command
LSrunas /user:userName /password:company01 /domain:%computername% /command:"REGEDIT" /runpath:"%cd%"
:: normal
RUNAS /profile /user:userName REGEDIT

:: PSEXEC
:: In order to get the psexec working the following commands should succeed
net use \\target\Admin$ /user:Administrator
dir \\target\Admin$
net use \\target\Admin$ /delete
:: (only disconnects, does not delete anything.)

:: reboot fast station with the shutdown utility
C:\Temp\QArunpack\bin\shutdown.exe -s reboot -f -m "The station will reboot in 3 seconds" -l 3 -c
shutdown -f -r -t 00

::=========================================================
:: using bmail
::=========================================================
:: SETTING TO THE E-MAIL TO WHOM WE ARE GOING TO SEND THE E-MAIL
::=========================================================
set mailadd= yordan.georgiev^@company.com

::CONTCATENATE ANY ERRORS TO THE END OF THE LOG
echo errors in the logging process are listed bellow: >>"%cd%\%computername%.txt"
for /f "delims=" %%a in ('more/e +0 ^<"%cd%\error_log_%computername%.txt"') do echo/%%a>>"%cd%\%computername%.txt"


:: WE USE THE BMAIL.EXE UTILITY TO SEND OURSELF AN E-MAIL CONTAINING THE TEXT FILE
:: ALTERNATIVE SMTP MIGHT BE esebe107.NOE.company.com, UNCOMMENT THE NEXT LINE FOR ALTERN
:: cmd /c bmail -s esebe107.NOE.company.com -m %computername%.txt -t %mailadd% -a %computername% -h
bmail -s smtp.company.com -m %computername%.txt -t yordan.georgiev^@company.com -a %computername% -h

:: eof using bmail
::=========================================================


::=========================================================
:: edit the hosts file
::=========================================================
echo 147.243.4.137 serverName >> C:\winnt\system32\drivers\etc\hosts
::=========================================================

::=======================================================
:: START A MINIMIZED BATCH WINDOW
::=======================================================
@echo off
IF NOT DEFINED CVRestart Set CVRestart=1&Start "Minimized" /MIN %0&Goto :EOF

exit
::=======================================================


::=======================================================
:: USAGE OF THE WHERE COMMAND ::WHERE [/R dir] [/Q] [/F] [/T] pattern...
::=======================================================
WHERE /R "\\server\share\" *spare*
::=======================================================
::get the mac address of an workstatioin
getMac


:: Start - Run utils
:: Add or Remove Programs
APPWIZ.CPL
:: COMPUTER MANAGEMENT
COMPMGMT.MSC
:: DEVICE MANAGER
DEVMGMT.MSC
:: DISK DEFRAGMENTER
DFRG.MSC -
:: Disk Management
DISKMGMT.MSC
:: Event Viewer
EVENTVWR.MSC
:: Sound Volume
SNDVOL.EXE

::Calculator
CALC.EXE
::Character Map
CHARMAP.EXE
::Disk Space Cleanup Manager
CLEANMGR.EXE
::SQL Client Configuration Utility
CLICONFG.EXE
::Clipboard Viewer
CLIPBRD.EXE
::Class Package Export Tool
CLSPACK.EXE
::Command Line
CMD.EXE
::Connection Manager Profile Installer
CMSTP.EXE
::Control Panel
CONTROL.EXE
::Component Services
DCOMCNFG.EXE
::DDE
DDESHARE.EXEShare
:: Doctor Watson v1.00b
DRWATSON.EXE
:: Doctor Watson Settings
DRWTSN32.EXE
:: DVD Player
DVDPLAY.EXE
:: DirectX Diagnostics
DXDIAG.EXE
:: Private Character
EUDCEDIT.EXEEditor
:: Event Viewer
EVENTVWR.EXE
:: Windows Explorer
EXPLORER.EXE
:: System Logoff
LOGOFF.EXE
:: Microsoft Management Console
MMC.EXE
:: Remote Desktop Connection
MSTSC.EXE /v 127.0.0.1:3388
:: Notepad
NOTEPAD.EXE
:: NSLookup Application
NSLOOKUP.EXE
::Symbolic Debugger for Windows 2000
NTSD.EXE
:: ODBC Data Source Administrator
ODBCAD32.EXE
:: On Screen Keyboard
OSK.EXE
:: Windows Uninstall Utility
OSUNINST.EXE
:: Performance Monitor
PERFMON.EXE /RES
:: Program Manager
PROGMAN.EXE
:: Remote Access Phonebook
RASPHONE.EXE
:: Registry Editor
REGEDIT.EXE
:: Resets Session
RESET.EXE
:: System Restore
RSTRUI.EXE
:: RTC Application Sharing
RTCSHARE.EXE
:: System File Checker
SFC.EXE
:: Create Shared Folder
SHRPUBW.EXE
:: System Shutdown
SHUTDOWN.EXE
:: File Signature Verification
SIGVERIF.EXE
:: Sound
SNDREC32.EXERecorder
:: Display Properties
DESK.CPL
:: Add Hardware Wizard
HDWWIZ.CPL
:: Internet Explorer Properties
INETCPL.CPL
:: Regional and Language Options
INTL.CPL
:: Mouse Properties
MAIN.CPL
:: Sounds and Audio Device Properties
MMSYS.CPL
:: Network Connections
NCPA.CPL
:: User Accounts
NUSRMGR.CPL
:: ODBC Data Source Administrator
ODBCAD.CPL
:: Power Options Properties
POWERCFG.CPL
:: System Properties
SYSDM.CPL
:: Phone and Modem Options
TELEPHON.CPL
:: Date and Time Properties
TIMEDATE.CPL
:: Microsoft Management Console (MMC Snap-ins) - Certificates
CERTMGR.MSC
:: Indexing Service
CIADV.MSC
:: Shared Folders
FSMGMT.MSC
:: Local Users and Groups
LUSRMGR.MSC
:: REMOVABLE STORAGE
NTMSMGR.MSC
:: REMOVABLE STORAGE OPERATOR REQUESTS
NTMSOPRQ.MSC
:: PERFORMANCE MONITOR
PERFMON.MSC
:: SERVICES
SERVICES.MSC
:: WINDOWS MANAGEMENT INFRASTRUCTURE
WMIMGMT.MSC
:: CONVENTIONAL USER ACCOUNT INTERFACE
CONTROL USERPASSWORDS2
::START OFFICE APPLICATIONS FROM COMMAND LINE
EXCEL.EXE
MSACCESS.EXE

MSPUB.EXE
:: Microsoft Office Picture Manager
OIS.EXE
OUTLOOK.EXE
POWERPNT.EXE
WINWORD.EXE

control keyboard

RUNAS /profile /user:user001 "COMPMGMT.MSC " | sanur /i C:\utils\psts.txt
RUNAS /profile /user:userName "regedit " | sanur company01
:: STOP A SERVICE
net stop "PCAnywhere Host Service"

:: STOP AN WINDOWS SERVICE IN MICROSOFTS WAY
sc \\servername stop schedule
:: WITH PSINTERNALS
psservice \\computername -u UserName-p Password stop "PCAnywhere Host Service"
psservice \\RemoteHostName -u userName -p Password company01 stop "PCAnywhere Host Service"



:: How do I concatenate files into one file overwriting previous existing one?
copy /b /y *.txt APMDeployment.html

:: If you want separations between the files,
:: try something like this...

@echo off
if .%1==.Loop goto process
> output.fil rem
for %%a in (*.txt) do call %0 Loop %%a
goto end
:process
>>output.fil echo.
>>output.fil echo ----------- File %2 -----------
>>output.fil type %2
:end

net use \\hostName\Temp\tmp "secretPass" /USER: " yogeorgi@NOE.company.com"
NET USE W: \\hostName\Temp /Persistent:No


:: COPY FILES RECURSIVELY TO THE CURRENT DIRECTORY
:: USES exec.bat by Fred Stluka
exec /s *pdrs*jpg do xcopy /s /m /f

:: SETTING TITLE AND COLOR AND FOR CMD
cmd.exe /k cd c:\Temp && color fc && title ***** Admin console *****

:: DELETE FILES CONTAINING STRING ON REMOTE COMPUTER
:: uses srp.exe see start remote process
cmd /c srp workstation cmd /c del /q C:\Temp\\*20060*

:: Fast search the directory for filename

::Windows fast directory search from WinLogo + R
cmd /c "dir C:\temp\path\*toFind* /s /b>list.txt&list.txt "

:: open all textpad files in a directory
for /f "tokens=* delims=" %%i in ('dir /b /s c:\TEMP\OXIT\BATTERY\*.txt') do cmd /c start /max textpad %%i


:: the syntax of the if command
echo set the variable to 0
set variable=0
pause
IF %variable% == 0 (
::   commands to be executed if the condition is true
echo the variable is %%variable%% = 0
) ELSE (
echo the variable is %%variable%% = 1
::   commands to be executed if the condition is false
)
pause


:: PURPOSE
:: TO PROVIDE THE USERS WITH COPY PASTE OF THE MOSTLY USED COMMANDS IN THE PECC TEAM
:: FOLLOW THE SYNTAX TO MAKE COPY PASTE EASIER , USE CAPITAL LETTERS FOR COMMENTS

::VersionHistory
:: 1.2.0 --- ysg --- formatting cleaning
:: 1.1.0 --- ysg --- removed NDA stuff

Labels

perl (41) Cheat Sheet (25) how-to (24) sql server 2008 (13) windows (13) oracle (12) sql (12) Unix (11) linux (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) bash (4) excel (4) future (4) generic (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) git cheat sheet (2) informatica sql repository (2) logging (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat sheet (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scp (1) scripts (1) scsi (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.