Boomerang is a neat and handy FREE tool that allows you to connect to virtual machines across mutliple ESXi hosts or vCenter servers in a single portal. http://labs.vmware.com/flings/boomerang
Force Mounting VMFS Datastore in ESXi 5.0
We had an issue last week that in our vSphere cluster (6 ESXi 5.0 hosts, 3 datastores), two hosts can not see one of the datastores. The issue was caused by that a guy in my team did not follow the proper LUN operation procedure. I tried to add the storage back in the vSphere … Continue reading Force Mounting VMFS Datastore in ESXi 5.0
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
