Archive for Month: December 2014

Finding active ports using netstat
very simple. make a note of the sqlsrvr.exe PID from taskmanager then run this command:
netstat -ano | findstr *PID*
it will show TCP and UDP connections of your SQL server (including ports) standard is 1433 for TCP and 1434 for UDP

Useful Exchange Powershell Commands
Exchange 2007 Exchange 2007 view database sizes
1 |
Get-MailboxDatabase | foreach-object {add-member -inputobject $_ -membertype noteproperty -name mailboxdbsizeinGB -value ([math]::Round(([int64](get-wmiobject cim_datafile -computername $_.server -filter ('name=''' + $_.edbfilepath.pathname.replace("\","\\") + '''')).filesize / 1GB),2)) -passthru} | Sort-Object mailboxdbsizeinGB -Descending | format-table identity,mailboxdbsizeinGB |
List all AD users in the domain and export to CSV:
1 |
Get-ADUser -filter * -properties emailAddress | Select SamAccountName | Export-CSV c:\temp.csv -notype |
Exchange 2010 Check if database is mounted:
1 |
get-mailboxdatabase -status | format-table Name,Mounted |
Check database name/server/size.
1 |
Get-MailboxDatabase -Status | select ServerName,Name,DatabaseSize |
Display the existing state of the queue (exports)
1 |
get-mailboxexportrequest | get-mailboxexportrequeststatistics |
Display database that the user is a member of: […]

AIX 5.3 Kill Proc
I began receiving alerts that my CPU utilization was peaking 1.25. Obviously this was not common for my build and I began inspecting. I ran the first command
1 |
Ps -ef |
Output:
1 2 3 4 5 6 7 8 9 10 11 |
# ps -ef UID PID PPID C STIME TTY TIME CMD root 1 0 0 Mar 03 - 2:52 /etc/init root 86212 1 0 Mar 03 - 2:57 /APP/ud/bin/smm -t 60 root 94284 1 0 Mar 03 - 0:00 /usr/ccs/bin/shlap64 root 118898 1 0 Mar 03 - 16:59 /storis/ud/bin/sbcs -r root 122964 1 0 Mar 03 - 0:00 /usr/lib/errdemon root 135406 176260 0 Mar 03 - 0:00 /usr/sbin/rpc.lockd -d 0 root 139502 1 0 Mar 03 - 555:55 /usr/sbin/syncd 60 root 163958 1 0 Mar 03 - 4:50 /APP/ud/bin/cleanupd -m 10 -t 20 root 172122 1 0 Mar 03 - 0:08 /APP/ud/unishared/unirpc/unirpcd |
If you wanted to sort it by the top 10 processes you can use the following:
1 |
# ps -e -o pcpu -o ruser -o args|sort -nr|grep -v %CPU|head -10 |
Output:
1 2 3 4 5 6 7 8 9 10 |
# ps -e -o pcpu -o ruser -o args|sort -nr|grep -v %CPU|head -10 24.5 billybob03 udserver 4 3600 0 0.2 billybob02 udt 0.1 int udt 0.1 int udt 0.1 int udt 0.1 int udt 0.1 int udt 0.1 int udt 0.1 billybob01 udt |
[…]