Category: Scripting

Batch Script: Send Email


sendmail is a handy tool that can be used in batch script to send email. 1) Configure your SMTP settings in the sendmail.ini file. Following is a sample to use Gmail: [sendmail]; you must change mail.mydomain.com to your smtp server,smtp_server=smtp.gmail.com ; smtp port (normally 25)smtp_port=465 ; error logerror_logfile=mail_error_log.txt ; Gmail username and passwordauth_username=xxxxxx@gmail.comauth_password=*********** ; the … Continue reading Batch Script: Send Email →

Perl: Send Email


A Perl sample code to send a file’s content by either Gmail or local SMTP. #!/user/bin/perl -w use strict;use Net::SMTP; # used by local SMTPuse Net::SMTP::TLS; # used by Gmail # Read the file content from error_logopen( my $error, "<error_log");my @log = <$error>;# If error_log is empty, then do nothingif (scalar(@log) == 0) {    close … Continue reading Perl: Send Email →

Perl: Read Excel Cell Value


A sample code to read excel cell value by using Spreadsheet::ParseExcel module. #!/user/bin/perl -w use strict;use Spreadsheet::ParseExcel;#Parse excel filemy $parser = Spreadsheet::ParseExcel->new();my $workbook = $parser->parse("test.xls"); #Get cell value from excel sheet1 row 1 column 2my $worksheet = $workbook->worksheet('sheet1');my $cell = $worksheet->get_cell(1,2); # Print the cell value when not blankif ( defined $cell and $cell->value() ne … Continue reading Perl: Read Excel Cell Value →

Bash: Log File Archive Script


There are some logs files are in such format: 20120130-174201-130947.log. I created two bash scripts to archive them by year/month/day: The first one is based on the log file creation date, the other one is based on the time stamp within the file name. #Backup Script1: Use modification date of the file#!/bin/bash #Define the Log … Continue reading Bash: Log File Archive Script →

List Running Processes Test Failed in Cluster Validation


If the Windows 2008 cluster validation failed to list the running process on some nodes, you can try to restart the process that has high handle counts. Use the PowerShell command to list the handlecounts in order - gwmi win32_process –computer localhost | sort handlecount | select name, handlecount In my example, the the CcmExec.exe … Continue reading List Running Processes Test Failed in Cluster Validation →