How to identify a User's Mailbox ID and find related ESM log? (4253156)

User's ESM log maybe needed for troubleshooting purposes. One of the methods to obtain user's ESM log is via identifying Mailbox ID of a user.

Method 1:
Warning: Please make sure you have full backup of AM SQL database before running below script.

To obtain user's MailboxID please run below script in SQL query:

USE AM_DB
SELECT  * FROM MailBox where NAME LIKE '%Test1%'

Where AM_DB is name of your Archive Manager database and Test1 is desired user's username

This search may return multiple matches as it is a wildcard search.

Note  the correct  MailboxID, go to Archive Manager's Data directory, open ESM | YYYYMMDD | 0 folder and pick up the file with MailboxID-XX-YYYMMDD.wlog
where XX above identified MailboxID.

Method 2:

Note: This method will only work in Archive manager 5.4 or below. If running 5.4 then switch to the old website. In 5.5 the old website is not available so method 1 should be used.

This method does not involve SQL query and purely based on AM Web GUI. As an AM administrator gain the access to user's mailbox in AM administration.
Go back to AM main window where on the left hand side you should be able to see user's mailbox next to your own mailbox. Make sure you have Status bar checked in IE's View menu. Click on user's mailbox and notice the MailboxID in IE's status bar as seen on below sample screenshot.

Note that MailboxID, go to Archive Manager's Data directory, open ESM | YYYYMMDD | 0 folder and pick up the file with MailboxID-XX-YYYMMDD.wlog
where XX above identified MailboxID.