Useful Cool Tools... and they're free

• ASAP Utilities add-on for Excel... Awesome tool for making your life with Excel easier
• http://www.asap-utilities.com/ 
• Example of uses: http://www.asap-utilities.com/asap-excel-tutorial-how-to.php
  
  
•  Expresso. An aweome RegEx Dev tool
• http://www.ultrapico.com/Expresso.htm



• PicPick: Free Screen Capture, image editor, color picker, color palette, pixel ruler, protractor, cross-hair and whiteboard all-in-one tool
• http://www.picpick.org/
• 



• TrueCrypt: on the fly volume encryption tool for Windows platforms
  http://www.truecrypt.org

Span BackupExec jobs to use mutiple drives

BackupExec Enterprise does not have the capability/feature to allow spanning any backup jobs to use multiple backup drives as in auto libaries.

To work around that, split your backup jobs into multiple smaller jobs (can be scheduled to run at the same time) and assign each of them to a different tape drive out of your autoloader.

Remove Packages With this RPM ""Error: ... Specifies Multiple Packages "

How To Remove RPM Packages if you receive this error message "Error: ... Specifies Multiple Packages"

Run RPM with the --allmatches option as follows:

rpm -ev --allmatches

nohup & disown

Both nohup and disown commands allow you to leave a job or script running even after you logout of your Linux shell

GREP Tips

Search for black OR white:
grep 'black\|white' files


 Search for searchtext at the beginning of a line in files:
grep '^searchtext' files


Search for searchtext at the end of a line in files:

grep 'searchtext$' files


Search files for blank lines:
grep '^$' files


Search files for US formatted phone numbers (###-###-####):
grep '[0-9]\{3\}-[0-9]\{3\}-[0-9]\{4\}' files


Search for e-mail or email in files:
grep e-*mail files


Search for searchtext case-insenstively in files:
grep -i searchtext files


 Search for searchtext at the beginning of a line in files:
grep '^searchtext' files


Search for lines infiles that contain both partial_name and function:
  grep partial_name files | grep function

Deleting *nix files by their inode number

For deleting those stubborn files or files with odd characters in their file names:

First find out file inode number with any one of the following command:

stat file-name OR ls -il file-name

If you cannot type the file name, just use * instead of file-name for show file info (including inode numbers) for all files in that directory:

Then,

Use the find command to find and remove a specified file:

find . -inum [inode-number] -exec rm -i {} \;

Hit the Y key  to confirm deletion of the file.

BackupExec Selection List via SQL

Execute the following SQL query to return all items in all selection list.

SELECT [ScriptName],[ScriptDescription],[DeviceSelectionName],[PathName],[FileName] FROM [BEDB].[dbo].[vwScriptPropertiesBackup]


This query can be trimmed down using the where clause.