Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Backup & Archiving Community Blog

Showing posts tagged with Database remove filter
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
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
Certified Altiris
KimITRecrt | 24 Apr 2009 | 0 comments

Certified Altiris Technician
Downtown Chicago

The Altiris information services specialist reports to a specific client site or on a daily basis to provide solutions and support services on a variety of complicated tasks that requires in depth knowledge of Altiris Deployment Solution, Wise Package Studio, and Asset Management to research, develop, and provide creative solutions. This position works with end user groups and onsite management to evaluate and solve technical problems and requires not only strong technical knowledge but also an outgoing and pleasant personality. Specialists evaluate existing systems, processes, procedures, and user needs to analyze, design, recommend, and implement system changes as directed by the specific client or management for services requested by the client such as system solutions or asset management. It is critical that the specialist maintain accurate records of all activities using the client’s format. The specialist...

Read more

Technical Support

Symantec.com

Store

Community Stats

Total Content Items
Members
258,918