Blog Posts

PFSense – won’t boot after power failure
Problem: I left on vacation and I left all my devices plugged in and online. During my absence the wonderful Florida power grid did it’s thing and intermittently decided to work. This brought my firewall down dirty and offline never to be seen again. Model: NetGate APU4 I had to […]

GUIDE and UniData structured files
GUIDE which can be run on the server that analyzes files, generates statistics and provides suggestions for optimizing file sizes and ensuring data integrity. While GUIDE is running, it will sit at the prompt, there’s no output while it’s working on true U2 files.

PFSense 503 – Service Not Available
Recently I attempted to log into a nanobsd pfsense 2.2.3 firewall webGUI. Was not having any issues with the firewall other than not being able to access the webGUI.
Error:
503 – Service Not Available

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