Tag Archives: Tips & tricks

Printing lines side by side in shell

Everybody knows, there is paste command in every *NIX to print two files side by side or join which is obviously used to join text-files by their key-fields. And there are a lot of examples and tutorials over Internet, so the subject is as … Continue reading

Posted in Tips & tricks | Tagged , , , , | 10 Comments

A nice way to return string values from functions in Bash

What can be as trivial as returning a value from a function in a scripting language? For those who has ever dealt with Bash, the answer turns out to be not so obvious. First, there are multiple options to do … Continue reading

Posted in Misc, My projects, Tips & tricks | Tagged , , , , , , , , | Leave a comment

Sorting Tumblrs you are following by their last activity

It seems, migration to GitLab stimulated me to code more in unusual for me languages and environments. First, it pushed me to do something in PowerShell: A short script to change audit rules on a file or a directory in … Continue reading

Posted in My projects, Tips & tricks | Tagged , , , , , , , | Leave a comment

Executing a batch of commands on multiple IBM SVC/Storwize storage systems

Sometimes you have to change several configuration parameters or run multiple commands over a list of IBM SVC storage systems. Here is my small Python 3 script to do the stuff quickly. It requires Paramiko module to handle SSH interactions. Edit … Continue reading

Posted in Storage Automation, Tips & tricks | Tagged , , , , , , , , , | Leave a comment

Scan IBM SVC/Storwize system for “SCSI ID Mismatches”

A small addition to the SAN/Storage CLI Toolbox which shows so called SCSI ID (LUN) mismatches on IBM SVC/Storwize systems. This Bourne shell/awk script shows the list of the same vdisks that are mapped with different SCSI IDs. Should be useful … Continue reading

Posted in Storage Automation, Tips & tricks | Tagged , , , , , , , , , , , , | Leave a comment

Short memo on COUNTIFS(), SUMIFS() and VLOOKUP() functions in MS Excel

Not using Excel very often, I sometimes have to waste my time searching Office support site for these functions in order to refresh in memory their tricky syntax and usage limitations. Today I decided to gather everything I know about … Continue reading

Posted in Tips & tricks | Tagged , , , , , | Leave a comment

Quick MS Excel IsTime() and TypeIs() functions solution

I never thought I would write hints for MS Excel VBA, nevertheless here is the first one. It turns out, there is a scripting problem with identifying value as a time in a cell on a worksheet. I was curious … Continue reading

Posted in Tips & tricks | Tagged , , , , , , | Leave a comment