Video Screencast Help
Search Video Help Close Back
to help

Archiving and eDiscovery Community Blog

Showing posts in English
Work out the hourly archiving rate, for the past 24 hours
Wayne Humphrey | 15 Dec 2009 | 1 comment

So here is a SQL script to work out the hourly archiving rate, for the past 24 hours .

You will need to define all the Vault Stores in this query.

USE VaultStore01
SELECT Min(archiveddate) AS ArchivedDate,
 "Hourly Rate for Americas Vault Store 04" = count (*),
 "Av Size" = sum (itemsize)/count (*)
FROM Saveset s
 
WHERE archiveddate > dateadd(hh, -24, getUTCdate ())
GROUP BY LEFT (convert (varchar, s.archiveddate,20),14)
ORDER BY LEFT (convert (varchar, s.archiveddate,20),14) DESC
 
USE VaultStore02
SELECT Min(archiveddate) AS ArchivedDate,
"Hourly Rate for  APJ Vault Store 02" = count (*),
"Av Size" = sum (itemsize)/count (*)
FROM Saveset s

 

Read more
Extract Item - ECM
Wayne Humphrey | 14 Dec 2009 | 0 comments

To combibe all the SISParts and stuff you can use the following hta script to use the ECM APT to do :

Save it as get_item.hta 

<html>
<title>Extract Item</title>
<head>
 <HTA:APPLICATION 
    ID="objMyApp" 
    APPLICATIONNAME="Extract Item" 
    BORDER="thin"
    BORDERSTYLE="normal"
    CAPTION="yes"
    CONTEXTMENU="no"
    INNERBORDER="no"
    MAXAMIZEBUTTON="yes"
    MINIMIZEBUTTON="yes"
    NAVIGABLE="yes"
    SCROLL="no" 
    SELECTION="yes"
    SHOWINTASKBAR="yes"
    SINGLEINSTANCE="no"
    SYSMENU="yes"
    VERSION="1.0"
    WINDOWSTATE="normal">
</head>
 
<script language="VBScript">
On Error Resume Next
Dim ContentManagementAPI
Set ContentManagementAPI = CreateObject("EnterpriseVault.ContentManagementAPI")
 
'...
Read more
Get all List of all Archives
Wayne Humphrey | 13 Dec 2009 | 0 comments
This SQL Script will get all List of all Archives and dispaly the following:
  • Mailbox Name
  • Exchange Server
  • Number of Items (Mailbox) 
  • Number of (Archive)
  • Mailbox Size (MB) 
  • Archive Size (MB)
  • Total Size (MB) 
  • Archive Created
  • Archive Updated
SELECT 
LEFT(MbxDisplayName,20) AS 'Mailbox', 
ExchangeComputer AS 'Exchange Server',
MbxItemCount AS '#Items (Mailbox)', 
VS1.ArchivedItems AS '#Items (Archive)',
MbxSize/1024 AS 'Mbx Size (MB)', 
VS1.ArchivedItemsSize/1024 AS  'Archive Size(MB)',
(mbxsize+VS1.ArchivedItemsSize)/1024 AS 'Total Size(MB)', 
VS1.CreatedDate AS 'Archive Created',
VS1.ModifiedDate AS 'Archive Updated', 
MbxExchangeState AS 'Exchange State'
 
FROM
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS...
Read more
Mbx Archiving State / Mbx Exchange State
Wayne Humphrey | 08 Dec 2009 | 0 comments
Often the question of what is the different states of MbxArchivingState and MbxExchangeState in the ExchangeMailboxEntry table.

The Archiving State translates as follows:

0 = Not Enabled
1 = Enabled
2 = Disabled
3 = Re-Link

To view the Archiving State you can use the following:

SELECT count(MbxArchivingState) as '# Mailboxes',
MbxArchivingState as 'Archiving State'
FROM ExchangeMailboxEntry
GROUP BY MbxArchivingState

The Exchange State translates as follows: 
 

0 = Normal
1 = Hidden
2 = Deleted

To view the Exchange State you can use the following:

SELECT count(MbxExchangeState) as '# Mailboxes',
MbxExchangeState as 'Exchange State'
FROM ExchangeMailboxEntry
GROUP BY MbxExchangeState

Read more
EV Manuals
Wayne Humphrey | 06 Dec 2009 | 1 comment

Lots of times I refer back to the EV manuals to see whether something that I “discover” is actually documented.  I have a copy locally on my machine in the office of many of the manuals, from many of the different versions.  I had often wondered about an externalised version of them, and whether they were easy to find.

With the power of Google, I found :

http://seer.support.veritas.com/docs/277782.htm

That goes back as far as V6, which is the beginning of time (almost) as far as I am concerned

Read more
EV Connection Status
Wayne Humphrey | 06 Dec 2009 | 0 comments

In the EV Outlook Client trace you very often see the Connection Status listed as a number.. well, what does the number mean ?

0 = Unknown connection.  You sometimes see that near the start of a client trace.
1 = Online
2 = Offline
3 = No Exchange
4 = Disconnected
5 = Cached Mode, Offline
6 = Cached Mode, Disconnected
7 = Cached Connected, headers only
8 = Cached Connected, Full items
9 = Cached Connected, “Drizzle Mode”
 
These are of course the Outlook to Exchange connection states, and the EV Outlook Add-in often needs to know what state things are in so that various operations can be performed (or not as the case may be).
Read more
Storage Magazine - Email Archiving Survey October 2009
BravoZulu | 05 Dec 2009 | 0 comments

I wanted to post this article from storagemagazine because I was suprised that 63 of the respondents to this survey are not using an age or quota based policy.....

Growing need for email archiving
by Rich Castagna
Issue: Oct 2009
...
Read more
Virtual Vault (Can't move the items. You don't have appropriate permission to perform this operation.)
GregRountree | 05 Dec 2009 | 1 comment

Virtual Vault (Can't move the items. You don't have appropriate permission to perform this operation.)

 

Untitled.png

Hi Group,

I wanted to post this error because it is a little vague. When moving items from Outlook or PST's you might get this error for a couple of reasons:

Make sure you have a calendar in Virtual Vault (create a blank Calendar) Calendar items will not be ingested if you do not have some place to put them
Make sure all IPM. files are added to the Admin Console under the Directory Exchange Message Classes tab. Here is a link to the Microsoft Message Classes. http://msdn.microsoft.com/en-us/library/bb176446.aspx
Make...

Read more
Fingerprint DB's
Rob.Wilcox | 13 Nov 2009 | 1 comment

A question arose the other day about why EV 8 creates a fingerprint database, even if the vault store group you are going to create is only ever going to be used with partitions relating to Centera.

This was, I think, initially raised during the EV 8 Beta program, and it is for two reasons :-
a) Consistency
b) At _some point_ in the future it might be that OSIS including Centera data is added to the product
Note: No fingerprints are written to the fingerprint database if the partitions in the vault stores in the vault store group are Centera only.
Hopefully that makes sense.
Read more
Sharepoint PSTs
Rob.Wilcox | 12 Nov 2009 | 5 comments

 Many EV customers are doing PST migrations, and this is something that you should be aware of, I think.

EV will scan machines for anything with a PST extension.   It doesn't really know at this point whether a file that it finds is truly a PST or not.  There are two issues here :-

* EV finds a file that has a PST extension, and it's not a PST..  opening it with MAPI will then cause all sorts of issues!

* EV finds a file that is in fact a PST.... but it's a Sharepoint PST.

With Sharepoint 2007 you can synch document libraries to a "client", ie Outlook.  When you do that a PST is created on the client machine which contains hooks back up to the Sharepoint document library and things are kept in synch by Outlook.  It's really good, and it's really bad.. for PST migrations.

The first issue above has been fixed in Enterprise Vault already (8 SP 2)

The second issue is to be fixed shortly....

Read more