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

Next gen EV ...

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

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 -

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