PST Holding folder: 'Owner' of COPY*.PST

[NJC]

Hi All, 

EV8 here. Using the Locate & Collect PSTs Task. I'm not going to be importing them into archives however. Once I've collected them the only way to see the 'owner' of is to view the Properties of each file in Personal Store Management, which is lengthy...

As you know they are named COPY*.PST etc and I'd like to know if there was a way to see which mailboxes/users own which COPY*.PST in one go such as report.

I don't think this is possible ..or is it..

Thanks

Nickcx

[TonySterling]

Something like this SQL query would help you with that.

SELECT p.FileSpecification, e.MbxDisplayName
FROM PstFile p
JOIN ExchangeMailboxEntry e on e.ExchangeMailboxEntryId = p.ExchangeMailboxEntryId
WHERE p.HoldingLocation LIKE '%Copy4.pst%'

[TonySterling · Accepted solution]

Here is another version of that will give you a list of all of them.

It will run against the EnterpriseVaultDirectory table, btw..

SELECT p.HoldingLocation, p.FileSpecification, e.MbxDisplayName
FROM PstFile p
JOIN ExchangeMailboxEntry e on e.ExchangeMailboxEntryId = p.ExchangeMailboxEntryId
WHERE p.HoldingLocation IS NOT NULL

[NJC]

Ah, yes. Of course. Thanks, Tony - will get on with that.

[EDIT UPDATE]

So I added the other column (HoldingLocation) I needed to see and widened the LIKE to give:

SELECT p.FileSpecification, e.MbxDisplayName, p.HoldingLocation

FROM PstFile p

JOIN ExchangeMailboxEntry e on e.ExchangeMailboxEntryId = p.ExchangeMailboxEntryId

WHERE p.HoldingLocation LIKE '%Copy%'

=

Thanks again

[NJC]

great minds and all that.. just updated my reply then saw this :)