Unix, Router, NT, System and Database Tips/Tricks

Extranet Username and Password lookup
DB Admin Page
username - xnet
password - xnet
Database - int1
select * from EXTRANET_PRINCIPALS

Router Tips

CDP (Cisco Discovery Protocol)
show cdp neighbor fastethernet detail

DataBase Tips

Total Money - select sum(max(bidamt)) from bidhist where itemid in (select itemid from auction where auctioncode = 'ccaf0002') group by itemid
Total Bids - select count(*) from bidhist where itemid in (select itemid from auction where auctioncode = 'ccaf0002')

UNIX Tips

/usr/lib/sendmail -bt -d0.4 - Info on the host about sendmail
NMAP to a host
sudo nmap -sF -v -O hostname

Mounting a CD on www2 sudo mount -rF hsfs /dev/dsk/c0t6d0s2 /mnt

Samba
/etc/init.d/samba stop
/etc/init.d/samba start
/usr/local/bin/samba/conf/smb.conf

\~nieusma/scripts/check_home_dirs will verify that all home dirs in /etc/passwd exist

sudo su - oracle -c '/some/command' # will execute a single command as user oracle sudo su - oracle # will give you interactive access as user oracle and initialize the environment

VI Tips

When you have a text file full of ^M chars in vi and you want to kill them, type this (while in command mode):
:%s/^V^M//g
(Where ^V = ctrl - v and ^M = ctrl - m) This will replace all of the ^M's with nothing, globally.

AS-400 Tips

E-mail Commands
dsppfm emailasn = already assigned
dsppfm emailpros = loaded by java not taken yet