Microsoft Exchange 2007 How to find what is inside Mailbox Database from Shell

In this Article, We are checking various options from the Exchange Management Shell

To avoid any Permission issue, Run Exchange Management Shell "Run As" Administrator or Account with Full Admin rights

How to find Mailbox Database
[PS] C:\>Get-mailboxDatabase

How to find Mailbox Database
[PS] C:\>Get-mailboxDatabase | FL Name, StorageGroup, Mounted, BackupInProgress, OnlineMaintenanceInProgress

How to find Mailbox Database
[PS] C:\>Get-mailboxDatabase -id "Name of the DB" | Get-Mailbox

How to find which Mailbox belongs to which Database
[PS] C:\Documents and Settings\Administrator>Get-mailbox | FL Name, Database

How to find list of the Mailboxes in Database
[PS] C:\>Get-mailbox -database "Database name" 

How to find Total number of Storage group 
[PS] C:\>Get-StorageGroup 

How to find list of the Mailboxes in Database
[PS] C:\>Get-mailbox -database "Database name" 


How to find list of the Mailboxes in Database
[PS] C:\>Mount-Database -Id "E2k7\RSG\"Mailbox Database" 

Understanding CCR log files
http://blogs.technet.com/b/timmcmic/archive/2009/09/21/log-files-required-to-be-copied-after-an-update-storagegroupcopy-re-seed-has-been-successfully-completed.aspx

Creating bulk users from Exchange management shell

Original script From : Script to download


When you have downloaded and extracted the scripts to your server – open a Powershell Console and navigate to the location where they are located – when there type in:

.\CreateUsersFromCSV.ps1

LabUsers01

When the script executes you will be presented with a Windows “Open” dialog box – navigate to the location where you extracted the files and then choose the sample CSV – see below;

LabUsers02

The script will then execute creating each user in your Active Directory Lab environment – the Default password is “Password1” – see below;

LabUsers03

When the script has completed – open Active Directory Users and Computers – you will see a new OU called “ExchangeUsers” – within this OU are the new accounts that you can play with – see below;

LabUsers04

Enable the users using Power Shell

Get-User -Filter {Department -Like 8* -And RecipientType -eq User} | % { Enable-MailUser $_ -externalEmailAddress $($_.name)@angrytech.com}

Another Script
-------------------------------
Get-User | Where-Object{$_.RecipientType –eq “User”}
Get-User –OrganizationalUnit People | Where-Object{$_.RecipientType –eq “User”}
get-user –organizationalUnit people | where-object{$_.RecipientType –eq “User” -and $_.department –eq “Sales”}
get-user –organizationalUnit people | where-object {$_.RecipientType –eq “User” -and $_.department –eq “Sales”} | Enable-Mailbox –Database “EXCHANGE1\Mailbox Database” | get-mailbox | select name,windowsemailaddress,database


Steps
From the powershell, run the .\CreateUsersFromCSV.ps1
and the confirm the user from Get-User in Active directory at OU=ExchangeUsers and in the below Exchange shell command rename -OrganizationalUnit People
Get-user –organizationalUnit people | where-object {$_.RecipientType –eq “User” -and $_.department –eq “Sales”} | Enable-Mailbox –Database “EXCHANGE1\Mailbox Database” | get-mailbox | select name,windowsemailaddress,database

Run the command from Shell
get-mailbox | fl name, database and from the resultant replace the Database after Enable-Mailbox -Database ""

So the new command would be
get-user –organizationalUnit ExchangeUsers | where-object {$_.RecipientType –eq “User” -and $_.department –eq “Sales”} | Enable-Mailbox –Database “E2K7\First Storage Group\Mailbox Database” | get-mailbox | select name,windowsemailaddress,database


Here OrganizationUnit is the location from ADUC where Exchange users created
and E2K7\First Storage Group\Mailbox Database is an example from my E2k7 DB

Post Installing KB 2837618 2768005 Unable to set out of office settings, free busy contains no information

Issue : 
--------------------
After installing KB on Outlook 2013, users are complaining that they are unable to set "Out of Settings" and can't schedule Free busy information after Installing November Security Patches

but Owa users can set OOF and schedule meetings

Error:
---------------------
 "Your server location could not be determined."


WorkAround
---------------------
Creation of new profile while update 2768005 and 2837618 installed on the system, didn't working either, you need to remove both of the update and then create a new Outlook Profile.

Lots of users are complaining about this issue on Outlook 2013 with Exchange 2007.

Alternately Quit Outlook and try setting OOF from OWA and log back into Outlook and check if this settings can resolve the issue


There is no update released as far of now, wait for Microsoft to update about this issue in newer patch or update

Current issue on Technethttp://social.technet.microsoft.com/Forums/en-US/827a12f0-c785-43df-a71f-0b21aeffa176/outlook-2013-freebusy-fails-after-updates?forum=officeitpro

Download Log parser

Download log parser from below link

Log Parser Studio

Microsoft Log Parser

Inspirational Quotes

“Experience life in all possible ways –good-bad, bitter-sweet, dark-light, summer-winter. Experience all the dualities. Don’t be afraid of experience, because the more experience you have, the more mature you become.”
- Osho

Continuous effort—not strength or intelligence—is the key to unlocking our potential.
- Winston Churchill

In order to grow, you must give up the struggle to remain the same, and learn to embrace change at all times.
–Michael A.  Singer


“if we do what we resolve to do then we can enjoy unlimited success” –Amit Malviya

"Focus on where you want to go, not on what you fear." - Anthony Robbins



Some of my suggestions are easier said than done. Just try. The intention is more important than immediate success. - Dr. Brian Weiss


"It's determination and commitment to an unrelenting pursuit of your goal that will enable you to attain the success you seek."


"Sooner or later, those who win are those who think they can." - Richard Bach

People only treat you one way …… the way you allow them

एक छुपी हुई पहचान रखता हूँ, बाहर शांत हूँ, अंदर तूफान रखता हूँ, 

रख के तराजू में अपने दोस्त की खुशियाँ, दूसरे पलड़े में मैं अपनी 

जान रखता हूँ।

One night a father overheard his son pray: Dear God, Make me the kind of man my Daddy is. Later that night, the Father prayed: Dear God, Make me the kind of man my son wants me to be.

- Anonymous


The 3 C’s of life: You must make a choice to take a chance or your life will never change

Shell Script Microsoft Exchange server 2010

ForEach ($mailbox in $mailbox) {Enable-Mailbox -Identity $Mailbox.Identity -Database $Mailbox.Database}

SAVE THIS AS C:\ENABLEBOX.PS1
NEXT: Run the Script
Go to Exchange Management Shell
You can change the directory to the root by typing cd\ then hit Enter (NOTE: If you just typed the words "then hit Enter" you do not belong working on servers)

Then type: ./enablebox.ps1

Just in case you want to enable archive for all users in the csv add this to the above script. 
Add <| Enable-Mailbox –Archive -ArchiveDatabase "<enter archive db name here>"}> Shown below in its entirety. 

$mailbox=import-csv C:\<filename>.CSV
ForEach ($mailbox in $mailbox) {Enable-Mailbox -Identity $Mailbox.Identity -Database $Mailbox.Database | Enable-Mailbox –Archive -ArchiveDatabase "<enter archive db name here>"}



Reference : Mailbox Script

Please check this command >Get-Mailbox | Where {$_.ProhibitSendReceiveQuota -gt 100}

Value 100 is in bytes to convert MB into Bytes for example, you need to convert 500 MB into bytes for Shell, then multiply MB by 1048576

5000 MB x 1048576 = 5242880000  bytes

So the command would be Get-Mailbox | Where {$_.ProhibitSendReceiveQuota -gt 5242880000}

Similarly you can change object from Mailbox to Mailboxdatabase



--------------------------------------------------------------------------------

Get-MailboxDatabase | Select-Object Name,IssueWarningQuota,ProhibitSendQuota,ProhibitSendReceiveQuota | Sort-Object Name | Export-Csv –Path .\DatabaseLimits.csv –NoTypeInformation

Get-Mailbox | Select-Object DisplayName,Database,IssueWarningQuota,ProhibitSendQuota,ProhibitSendReceiveQuota | Sort-Object DisplayName | Export-Csv –Path .\MailboxLimits.csv –NoTypeInformation

http://help.outlook.com/en-us/140/Gg576861(d=lightweight).aspx

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
To get a list of all users on an Exchange 2010 server who are Unified messaging-enabled

 $Mailboxes = Get-Mailbox
 $Mailboxes = | ForEach { If($_.UmEnabled -Eq $True){$_.Name}}
--------------------------------------------------------------------------------


--------------------------------------------------------------------------------
 script that will monitor the index state.

Get-mailboxdatabase | Get-MailboxDatabaseCopyStatus | where {$_.contentindexstate -ne "Healthy" -and $_.contentindexstate -ne "Crawling"} | select Name,DatabaseName,Status,ContentIndexState,MailboxServer,ActiveDatabaseCopy,ActivationSuspended
--------------------------------------------------------------------------------


ShowInlineAttachments
===============================================
We run the set-OrganizationConfig -ShowInlineAttachments:$true

ThrottlingPolicy
===============================================
Get-ThrottlingPolicy | Where-Object ($_.IsDefault -eq “True”) | FL Identity



ExTrace.exe (This is Microsoft proprietary tool and need to contact Microsoft)
===============================================
ExTrace.exe -v -c xx.etl >output.txt

NLTEST
===============================================
nltest /dsgetdc "owen.edu"
nltest /dsgetsite
nltest /securesite
netdom query dc
netdom query fsmo
nltest /sc_change_pwd:<DC FQDN>
//On W2k8 DC, nltest /sc_change_pwd:federation.local, will reset the password 

set u


Produce a list of Full Access Permissions
===============================================
For full access, from EMS run this command
get-mailbox | %{$foo = $_; Get-MailboxPermission $foo | ?{$_.AccessRights -eq "FullAccess" -and $_.IsInherited -eq $false}} | ft {$foo},User,AccessRights

get-mailbox | %{$mailbox = $_; Get-ADPermission $mailbox.DistinguishedName | ?{$_.ExtendedRights -like "Send-As" -and $_.User -notlike "NT AUTHORITY\SELF"}} | ft {$mailbox},user,{"Send-As"}

ADPLUS
=================================================
adplus.exe -crash -pn msexchangetransport.exe -NoDumpOnFirst -o e:\dumps 

Default Scipts found in Exchange 2010 scripts folder

ActiveSyncReport.ps1                                                     

AddReplicaToPFRecursive.ps1                                              

AddUsersToPFRecursive.ps1                                                

AggregatePFData.ps1                                                      

CheckDatabaseRedundancy.ps1                                               

CheckInvalidRecipients.ps1                                               

CITSConstants.ps1                                                         

CITSLibrary.ps1                                                          

CITSTypes.ps1                                                            

CollectOverMetrics.ps1                                                   

CollectReplicationMetrics.ps1                                            

Configure-SMBIPsec.ps1                                                   

ConfigureAdam.ps1                                                        

ConfigureNetworkProtocolParameters.ps1                                   

ConvertOABVDir.ps1                                                       

ConvertTo-MessageLatency.ps1                                             

DagCommonLibrary.ps1                                                     

DatabaseMaintSchedule.ps1                                                

DiagnosticScriptCommonLibrary.ps1                                         

Disable-InMemoryTracing.ps1                                              

enable-CrossForestConnector.ps1                                           

Enable-InMemoryTracing.ps1                                               

enable-OutlookCertificateAuthentication.ps1                               

ExchUCUtil.ps1                                                           

Export-OutlookClassification.ps1                                         

Export-RetentionTags.ps1                                                 

get-setuplog.ps1                                                         

Get-UCPool.ps1                                                           

GetDatabaseForSearchIndex.ps1                                            

GetSearchIndexForDatabase.ps1                                            

Import-RetentionTags.ps1                                                 

LargeToken-IIS_EWS.ps1                                                   

LargeToken-Kerberos.ps1                                                  

MailboxDatabaseReseedUsingSpares.ps1                                     

ManageScheduledTask.ps1                                                  

MigrateUMCustomPrompts.ps1                                                

Move-TransportDatabase.ps1                                               

MoveAllReplicas.ps1                                                      

MoveMailbox.ps1                                                          

new-TestCasConnectivityUser.ps1                                          

Prepare-MoveRequest.ps1                                                  

 RedistributeActiveDatabases.ps1                                          

Reenable-AuditLoggingAgent.ps1                                           

RemoveReplicaFromPFRecursive.ps1                                         

RemoveUserFromPFRecursive.ps1                                            

ReplaceReplicaOnPFRecursive.ps1                                          

ReplaceUserPermissionOnPFRecursive.ps1                                   

ReplaceUserWithUserOnPFRecursive.ps1                                     

ResetAttachmentFilterEntry.ps1                                           

ResetCasService.ps1                                                       

ResetSearchIndex.ps1                                                     

ResumeMailboxDatabaseCopy.ps1                                             

RollAlternateServiceAccountPassword.ps1                                  

StartDagServerMaintenance.ps1                                            

StopDagServerMaintenance.ps1                                             

StoreTSConstants.ps1                                                     

StoreTSLibrary.ps1                                                       

Troubleshoot-CI.ps1                                                      

Troubleshoot-DatabaseLatency.ps1                                         

Troubleshoot-DatabaseSpace.ps1     

Check Public Folder Permission

Get-PublicFolder "\" -Recurse | Get-PublicFolderClientPermission | Out-File -FilePath "c:\Temp\PFPerms.txt"

Event logging level BETWEEN SITES
===========================================
set-transportserver -identity <servername> - IntraOrgConnectorProtocolLoggingLevel verbose

set-transportserver -identity <servername> - IntraOrgConnectorProtocolLoggingLevel None

The logs are stored under the Logs folder of TransportRoles

How to find Mailbox is Shared Mailbox

C:\Get-mailbox -Resultsize unlimited | Where-object {$_.Isshared -eq $True}

An alternative way to identify possible problematic receive connectors by using Exchange Management Shell, is if the queue delivery type is SmtpRelayToRemoteAdSite. To do this, run the following shell commands:

$remotesite = (get-queue | where {$_.LastError -like "451 4.4.0*"}).NextHopDomain

get-exchangeserver | where {$_.site -like '*'+$remotesite} | get-transportserver | Get-ReceiveConnector | where {$_.Bindings -like '*:25*'} | where {$_.AuthMechanism -notlike '*Exchange*'

From blog 

http://blogs.technet.com/b/rmilne/archive/2014/02/23/exchange-2010-tip-of-the-day-26-to-50.aspx

This command spins through all your mailbox servers and reconnects all the uniquely identified but disconnected mailboxes in any one of the mailbox stores:

$Servers = Get-ExchangeServer 

$Servers | ` Where { $_.IsMailboxServer -Eq '$True' } ` | ForEach { Get-MailboxStatistics -Server $_.Name ` 

  | Where { $_.DisconnectDate -NotLike '' } ` | ForEach { Connect-Mailbox -Identity `$_.DisplayName -Database $_.DatabaseName} }

Want to know what version of Exchange Server each of your servers is running? Type:

Get-ExchangeServer | Format-Table Name, *Version*

Want to create a group of test users in your lab? Use this command:

1..100 | ForEach { Net User "User$_" MyPassword=01 /ADD /Domain; Enable-Mailbox "User$_" }

How to switch to Scripts folder in "Exchange Management Shell"

From EMS : type this command cd $exscripts

Find specific Event id in application log via Scripts

Get-EventLog "Application" | Where-Object {$_.EventID -eq 109} | Select-Object EventID,TimeGenerated,Message | Export-CSV -NoTypeInformation -Path c:\Search_StartEvents.csv

TEST-EXCHANGESEARCH //for checking the Content Index

Get-Mailbox -Database NA1-ERICNOR-1\ NA1-ERICNOR-1-SG1\ NA1-ERICNOR-1-DB1 | Test-ExchangeSearch | ft -a

Scripts to find how many users are logon using OWA 

Method 1: 

You can find the output when you run get-logonstatistics from the article below:

View Logon Statistics

http://technet.microsoft.com/en-us/library/ff653211.aspx

Method 2:

Besides, you can use logparser to analyze it

C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT TOP 10 cs-username, Count(*) AS OWAHits INTO OWAActivity.gif FROM C:\Inetpub\logs\LogFiles\W3SVC1\u_ex*.log WHERE cs-uri-stem LIKE '/OWA/' AND cs-username IS NOT NULL GROUP BY cs-username ORDER BY OWAHits DESC" -charttype:Bar3D -o:CHART -view:ON

Or:

"C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT TO_STRING(time, 'HH') AS Hour, COUNT(*) AS Hits INTO hitPerSecond.jpg FROM C:\Inetpub\logs\LogFiles\W3SVC1\u_ex*.logGROUP BY Hour ORDER BY Hour ASC" -i:IISW3C -o:CHART -chartType:ColumnClustered -chartTitle:"Hourly Hits" -groupSize:420x280

Method 3:

We can run the command below to get the current number of outlook or OWA user who is connecting to Exchange Servers.

Get-Counter "\MSExchange RpcClientAccess\User Count" -ComputerName  name|ft

Get-Counter "\MSExchange OWA\Current Unique Users" -ComputerName  name |ft

OWA session with name of the user

========================================================

Get-Mailbox | Get-LogonStatistics | Where-Object {$_.ApplicationID -eq "Client=OWA"} | Select-Object UserName,LastAccessTime | ConvertTo-Html -Title "OWA actives sessions" -PostContent "<b>Thierry MILLE (c) 2011</b>" | Out-File C:\owa.htm; Send-MailMessage -From sender@domain.com -To recipient@domain.com -Subject "OWA sessions" -Attachments C:\owa.htm -SmtpServer 127.0.0.1; Remove-Item C:\owa.htm

How to delete and Export Mailbox without AVI MPEG files

========================================================

Get-Mailbox -ResultSize 'Unlimited' | Export-Mailbox -DeleteContent -AttachmentFilenames '*.avi', '*.mpeg' -TargetMailbox  ExportedMailbox -TargetFolder 'Export'

How to increase Logging level from Shell

========================================================

Get-EventLoglevel -server Servername

1.     Get-EventLogLevel MSExchangeTransport | set- EventLogLevel –level expert

Get-EventLogLevel MSExchangeTransport | Set-EventLogLevel -Level Expert (7) High (5) Lowest (0) Low (1)

Get-Eventloglevel msexchangetransport | set-Eventloglevel -level low

Set-Eventloglevel "MSExchangeMailSubmission\General" -level expert

Set-EventLogLevel “MSExchange POP3\General” -Level High

Set-EventLogLevel “MSExchange POP3\General” -Level lowest

set-transportserver -identity "servername" -IntraOrgConnectorProtocolLoggingLevel verbose

Set-EventLogLevel "Servername\MSExchangeSA\OAL Generator" -Level High

                                                  MSExchange IMAP4\General                                             

                                                  MSExchange POP3\General   

Set-eventloglevel -Identity ECIdParameter -Level Lowest | Low | Medium | High | Expert [CommonParameters]

Set-POPSettings -Server "HLBDEXCH" -protocolLogEnable $true

Set-EventLogLevel –identity "MSExchangeMailboxAssistants\Service" -Level Expert

Set-EventLogLevel –identity "MSExchangeMailboxAssistants\OOF Assistant" -Level Expert

Set-EventLogLevel –identity "MSExchangeMailboxAssistants\OOF Library" -Level Expert

Static domain controller

================================

Set-ExchangeServer –Identity (name of your Exchange Server goes here) –StaticDomainControllers $NULL

Pipelining Tracing

------------------------------

Run in the following order

1. Set-TransportServer <Identity> -PipelineTracingSenderAddress <SMTPAddress>     //from Sender

    Set-TransportServer <Identity> -PipelineTracingSenderAddress "<>"    // from servers

2. Set-TransportServer <Identity> -PipelineTracingPath <LocalFilePath>

    Set-TransportServer Server1 -PipelineTracingPath "C:\Pipeline Tracing Logs"

3. Set-TransportServer <Identity> -PipelineTracingEnabled <$True | $False>

    Set-TransportServer Server1 -PipelineTracingEnabled $True

Or single command sets all

Set-TransportServer –Identity “Hub Transport Server Name>” –PipelineTracingSenderAddress “Sender email address from one of the poison messages” –PipelineTracingPath “C:\Pipeline Tracing” –PipelineTracingEnabled $true –ContentConversionTracingEnabled $true

Disable Pipelining tracing

Set-TransportServer –Identity “Hub Transport Server Name” –PipelineTracingSenderAddress “Mail from Email Address in one of the message” –PipelineTracingPath “C:\Pipeline Tracing” –PipelineTracingEnabled $false –ContentConversionTracingEnabled $false

Analyzing PIPELINING

---------------------------------------

Here are the instructions:

1.            Pull up the Exchange Management Shell on one of the Hub Transport Servers first.

2.            Run the following command

Set-TransportServer –Identity “HubTransportServerName” -PipelineTracingPath  “C:\PipelineLogs”  -PipelineTracingSenderAddress  “EmailAddressOfSender” 

-PipelineTracingEnabled $true  

3.            Log on to another Hub Server and run the above cmdlet by replacing the Hub Transport name (I’m asking here to logon to another Hub server because I want to avoid the replication         

                problem)

4.            You can also specify other “Pipeline Tracing Path”. I have specified “C:\PipelineLogs” for an example here. Please go to this folder and check if Network Service permissions are 

                there.

5.            Run Get-TransportServer –Identity <HubServerName> | fl *pipe* on Exchange Management Shell and hit enter. Please check and make sure that result of this cmdlet matches with   

               what you have specified in Step # 2.

6.            Once the email has been received, you’ll see MessageSnapshot folder on one of the Hub servers which has processed the message.

7.            Zip the Message Snapshot folder and send it to me over email.

8.            Run the following cmdlet to Disable the Pipeline Tracing

Set-TransportServer –Identity <HubTransportServerName>  -PipelineTracingEnabled $false  

9.            Please run the above cmdlet 2 times by replacing the Hub server name 

PS: Enable Pipeline only on server where it requires to analyze the data

Get-TransportAgent

Get-Transportrule

Get-TransportServer

Moving the queue database

=====================================

Move-TransportDatabase.ps1 -QueueDatabasePath: D:\Exchsrvr\TransportRoles\data\Queue -QueueDatabaseLoggingPath: D:\Exchsrvr\TransportRoles\data\Queue

OR

rename the D: drive instead of C: in the EdgeTransport.exe.config

for "QueueDatabasePath"

     "QueueDatabaseLoggingPath"

     "IPFilterDatabasePath"

     "IPFilterDatabaseLoggingPath"

     "TemporaryStoragePath"

---------------------------------------------------------------------------------------------

Protocol	Default	Secure Port
HTTP	80	443	RPC over HTTP
IS	6001
Directory Referral	6002
DSProxy/NSPI	6004
IMAP4	143	993
NNTP	119	563
POP3	110	995
SMTP	25	25
LDAP	389	636
LDAP	50389	50636
RDP	3389
LINKstate	691
DC	3269/3268
FTP	21
RPC	135
DHCP Server	67
DNS	53
Hub to Edge	50389
Hub to Edge	50636

--------------------------------------------------------------------------------------

Want to find Only Exchange 2013 server in the Organization 

Get-ExchangeServer | Where-object {$_.AdmindisplayVersion -like "*15*"}

Good website for the above command in Shell

http://binarynature.blogspot.com/2013/04/get-exchange-server-version-and-update-info-with-powershell.html

Get-ExchangeServer | Where-object {$_.AdmindisplayVersion -like "*15*"} | Select-object ,,,,,, | FT -autosize 

--------------------------------------------------------------------

RBAC Role Group Membership Reporting

https://gallery.technet.microsoft.com/office/RBAC-Role-Group-Membership-ed4e12ad

Get-User -ResultSize unlimited | where {$_.linkedmasteraccount -eq "NT AUTHORITY\SELF" -and $_.recipienttypedetails -ne "RoomMailbox" -and $_.recipienttypedetails -ne "Equipmentmailbox" -and $_.recipienttypedetails -ne "DiscoveryMailbox"} | select name | ft

Start Exchange Service

Get-Service *Exchange* | Start-Service