Can a report be obtained on what mailboxes are assigned to a login using a SQL script? (99026)

Can a report be obtained on what mailboxes are assigned to a login using a SQL script?

Run the following SQL query against the Archive Manager database:

USE ArchiveManager
GO
SELECT LoginMailBox.LoginID, Login.DisplayName AS 'Login Name', LoginMailBox.MailBoxID, MailBox.Name AS 'Mailbox Name'
FROM LoginMailBox INNER JOIN
Login ON Login.LoginID = LoginMailBox.LoginID INNER JOIN
MailBox ON MailBox.MailBoxID = LoginMailBox.MailBoxID