none
Is it possible to find out which mailboxes are in which Database without using Get-Mailbox?

    Question

  • Hi!

    I have the following problem:

    - For unknown reasons two users have lost their ArchiveDatabase attribute value

    To solve this I would usually just add the value using Set-Mailbox, but we have several Archive-DBs and I have no idea what the original value was...

    Is there any way to see which mailboxes are in which DB without the use of Get-Mailbox?

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Thursday, June 7, 2018 11:04 AM

Answers

  • Hi!

    I have the following problem:

    - For unknown reasons two users have lost their ArchiveDatabase attribute value

    To solve this I would usually just add the value using Set-Mailbox, but we have several Archive-DBs and I have no idea what the original value was...

    Is there any way to see which mailboxes are in which DB without the use of Get-Mailbox?

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

     Get-MailboxStatistics-database <DB1> |FL > Db1.txt

    Do this for each DB you have and output to a text file.

    Then search in those text files for the name of the user and Online Archive and it will show the GUID and DB etc of the online archive

    • Marked as answer by Gerrit Deike Friday, June 22, 2018 6:56 AM
    Thursday, June 21, 2018 6:18 PM
    Moderator

All replies

    1. That's an odd thing to occur, sounds like this isn't the first time this occurred
    2. Since the information lives in AD I don't think there is a way via PowerShell to do what you want
    3. You could download our DigiScope product, get a DEMO license and then open offline copies of the archive DB's to get a visual of what's actually within the DB

    Search, Recover, Export Mailboxes, Folders, Email, Contacts, Calendars, Tasks, etc. from Offline Exchange Databases (EDBs), On-Premise Exchange Servers and Office 365. Migrate/Recover direct from any offline EDB into any On-Premises Exchange Server, even cross version i.e. 2003 → 2007 → 2010 →2013 → 2016 → Office 365 with Lucid8's DigiScope

    Thursday, June 7, 2018 3:06 PM
  • Hi,

    Don't use any third party tools, because we cannot evaluate the risk. 

    If you cannot remember the original archive DB, it should be hard to reset it via command. At present, we have a option to export the current archive content to pst file, then set a random one as the new archive DB.

    Below is the command to export to pst file:

    New-MailboxExportRequest -Mailbox username -FilePath "\\SERVER\PSTFileShare\user.pst" -IsArchive

    Hope it helps.

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, June 8, 2018 8:59 AM
    Moderator
  • Hi,

    Don't use any third party tools, because we cannot evaluate the risk. 

    If you cannot remember the original archive DB, it should be hard to reset it via command. At present, we have a option to export the current archive content to pst file, then set a random one as the new archive DB.

    Below is the command to export to pst file:

    New-MailboxExportRequest -Mailbox username -FilePath "\\SERVER\PSTFileShare\user.pst" -IsArchive

    Hope it helps.

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Hi Manu,

    I understand the risk of using a third-party tool, but as you yourself say, there is no way to locate the original location with PowerShell. As I want to reconnect this mailbox with its archive (and that way not loose any data) I don't see me having much of a choice.

    Anyway the risk will be fairly small as I'll be looking into offline copies of the DBs and not into the productive DBs. 

    BTW: Why should I export the Mailbox, when all I want is to reconnect it to its archive?


    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Friday, June 8, 2018 11:21 AM
  • Hi,

    Don't use any third party tools, because we cannot evaluate the risk. 

    If you cannot remember the original archive DB, it should be hard to reset it via command. At present, we have a option to export the current archive content to pst file, then set a random one as the new archive DB.

    Below is the command to export to pst file:

    New-MailboxExportRequest -Mailbox username -FilePath "\\SERVER\PSTFileShare\user.pst" -IsArchive

    Hope it helps.

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Hi Manu,

    I understand the risk of using a third-party tool, but as you yourself say, there is no way to locate the original location with PowerShell. As I want to reconnect this mailbox with its archive (and that way not loose any data) I don't see me having much of a choice.

    Anyway the risk will be fairly small as I'll be looking into offline copies of the DBs and not into the productive DBs. 

    BTW: Why should I export the Mailbox, when all I want is to reconnect it to its archive?


    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Since there are only two users having the issue, exporting to pst should be a relatively easy method. We could export the archive to a pst file, then import it back to the mailbox after setting the new archive database, theoretically, it won't lose any data.  

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, June 11, 2018 2:09 AM
    Moderator
  • Hi Manu,

    please explain to me how I am supposed to export the archives when I don't even know in which DB they are...? There's nothing linking the data to the user account...

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Monday, June 11, 2018 6:15 AM
  • Hi Manu,

    please explain to me how I am supposed to export the archives when I don't even know in which DB they are...? There's nothing linking the data to the user account...

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    If we have enabled online archive to a user, then we could use the following command to export to archive, we don't need to specify the database when running the commmand:

    New-MailboxExportRequest -Mailbox username -FilePath "\\SERVER\PSTFileShare\user.pst" -IsArchive

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Thursday, June 14, 2018 2:45 AM
    Moderator
  • Hi Manu,

    I thing you're missing the point. The Attribute ArchiveDatabase is empty, eventhough the Mailbox is activated for archiving...

    I don't have a problem with the data in the DB. My problem is that I don't know in which DB the data is.


    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Thursday, June 14, 2018 8:40 AM
  • Hi Manu,

    I thing you're missing the point. The Attribute ArchiveDatabase is empty, eventhough the Mailbox is activated for archiving...

    I don't have a problem with the data in the DB. My problem is that I don't know in which DB the data is.


    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    I know your concern, exporting to pst is for backup purpose, then we could set the archive database with set-mailbox command. Even if it is not a the original one (it is possible because we couldn't remember it), we will not lose any data.

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Tuesday, June 19, 2018 8:13 AM
    Moderator
  • Ok, maybe I'm missing something here. How do I export data that not even the system knows where to find?

    BTW: The problem has solved itself. The colleague in question is leaving the company, so I'm no longer in any hurry, but I still want to understand how you propose to save data that I can't finde, because the system has lost it's connection to it?

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Tuesday, June 19, 2018 11:43 AM
  • Ok, maybe I'm missing something here. How do I export data that not even the system knows where to find?

    BTW: The problem has solved itself. The colleague in question is leaving the company, so I'm no longer in any hurry, but I still want to understand how you propose to save data that I can't finde, because the system has lost it's connection to it?

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    When we export the mailbox data using the new-mailboxexportrequest command, we don't need to specify the database. As long as we know the mailbox name, we could export the data to a certain path. 

    Regards,

    Manu Meng


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Thursday, June 21, 2018 2:26 AM
    Moderator
  • Yes, but only the mailbox data, not the archive. I don't have a problem with the mailbox, it's fine. I need to recover the archive and the connection to that has been lost. Trying to export the mailbox with the -IsArchive flag doesn't work. I get the following error message:

    The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input.
        + CategoryInfo          : InvalidArgument: (<Mailbox Name>:PSObject) [New-MailboxExportRequest], ParameterBinding
       Exception
        + FullyQualifiedErrorId : InputObjectNotBound,New-MailboxExportRequest
        + PSComputerName        : <Server FQDN>

    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Thursday, June 21, 2018 6:18 AM
  • I understand Manu's concern about using a 3rd party tool to check this however a few things to consider

    1. You could restore the latest backup of the archive DB to the RDB, or take the existing archive DB offline and make a copy and then open that copy

    2. Use DigiScope to open the offline copy which will expose all mailboxes within

    NOTE: DigiScope doesn't modify the EDB during normal mount and also has a forensic mount option

    Then you can update the archive value for the users in question.


    Search, Recover, Export Mailboxes, Folders, Email, Contacts, Calendars, Tasks, etc. from Offline Exchange Databases (EDBs), On-Premise Exchange Servers and Office 365. Migrate/Recover direct from any offline EDB into any On-Premises Exchange Server, even cross version i.e. 2003 → 2007 → 2010 →2013 → 2016 → Office 365 with Lucid8's DigiScope

    Thursday, June 21, 2018 5:17 PM
  • Hi!

    I have the following problem:

    - For unknown reasons two users have lost their ArchiveDatabase attribute value

    To solve this I would usually just add the value using Set-Mailbox, but we have several Archive-DBs and I have no idea what the original value was...

    Is there any way to see which mailboxes are in which DB without the use of Get-Mailbox?

    Regards,

    Gerrit


    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

     Get-MailboxStatistics-database <DB1> |FL > Db1.txt

    Do this for each DB you have and output to a text file.

    Then search in those text files for the name of the user and Online Archive and it will show the GUID and DB etc of the online archive

    • Marked as answer by Gerrit Deike Friday, June 22, 2018 6:56 AM
    Thursday, June 21, 2018 6:18 PM
    Moderator
  • Thanks! That is exactly the solution I was looking for! :)

    If you think your to small to make a differnce, try going to bed with a mosquito in the room...

    Friday, June 22, 2018 6:56 AM