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: […]