SQL query to retrieve all objects added to the archive

Please define what you mean by all objects and what parameters you are trying to retrieve in that dump.

We've added people to the archive, as well as other shared mailboxes.  I'm trying to get a handle on the complete list of people and mailbox objects that are currently being stored in the S1 archive.

Hi Alcolon,

You can query the ES1Activity Database with the following:

SELECT *

FROM DataSources

This will give you a resultset with all the mailboxes/SharePoint Sites/File Shares/.. that have been touched by EMC SourceOne. You should filter out the Service Account/Groups/Admin Group and you have a clear view.

You may also want to look at EmailAddress table too the reason is like this:

For example when an email is sent by CEO of company to 5000 employees and may be 100 outsiders in BCC, SourceOne maintains all routes in its table. That way you have 5101 routes stored and 1 copy of email stored where all these routes will point to.

If SourceOne has been added to your responsibility then first thing you want to read is the EMC SourceOne Email Management Administration guide for the version of SourceOne you have. Its never versions and older versions can be downloaded from support.emc.com website.

Most of the admins do not need to understand how the database tables/schema is interrelated. Most of the time address rules are the default address rules unless they were altered to achieve corporate/compliance goals. There are some videos on YouTube that may interest you, they are very basic but for someone new to system they could be start point. EMC also runs administration course for this product.

Best regards,

Rajan