Linux : Unpack an rpm

rpm2cpio chef-full-0.10.8-3.x86_64.rpm | cpio -idv

Linux : Force Ntp update

/etc/init.d/ntpd stop ntpdate -u pool.ntp.org /etc/init.d/ntpd start

Excel - Replace all commas with a newline character

Replace all commas with a newline character - what to put in the replace field? Hold down , and type 0010 using the numbers on the Num keypad, *not* the numbers under the function keys.

Search ldap server under linux

This uses the default ldap repo set up in /etc/ldap.conf ldapsearch -v -x -s sub uid=USERNAME

Remove single revision of a file from CVS

To remove a version of a file from CVS (careful!), e.g., remove vsn 1.3, but keep 1.2 cvs admin -o1.3 myfile [where 'o' stands for 'outdates'] To TOTALLY remove a file from the current directory and CVS repository : rm myfileisjunk cvs remove myfileisjunk cvs commit -m"no longer needed (IS)" myfileisjunk

Mercurial : Use Hooks to maintain list of binary files required but excluded

Use a precommit declared in the .hg/hgrc file of the local repository Note - this is not retained in the repo and is individual to each mirror [hooks] precommit.001 = find `hg root`/bonecrushertest/src | egrep '\.tar\.gz$|\.rpm$|\.tgz' | tee `hg root`/bonecrushertest/src/manifest.txt

Oracle : Identifying last SCN available that has been backed up

select next_change#-1 last_change, br.* from V$BACKUP_REDOLOG br order by first_change# desc