server

Veeam 9.x PSSnapIn failure
ISSUE Installed Veeam 9 Backup and Recovery. Installed the Veeam Powershell after a couple days of demoing. When launching the Veeam powershell module via Veeam menu it opens[1]http://forums.veeam.com/powershell-f26/how-do-you-even-get-powershell-to-work-with-veeam-t26429.html?hilit=icon#p137617p and works just fine. However when attempting to launch the Veeamssnapin using the command ‘Add-PsSnapIn VeeamPSSnapIn’ I received an error (below). As […]

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