Thursday, May 24, 2012

Enterprise Wide PST Import - Morning Status Report

This is Part 9 in a series of posts about my experience tackling the migration of PST files.
The first post in the series is here.

The next post in the series is here.


This is the report I get each morning. The information is derived from several sources.

First, we took a snapshot of our starting point in this project. That was done on Oct 9th, 2011. That's why all the calculation is done from that date.

We run a report every Sunday. It looks for all users, if they have a HomeDirectory defined, and do they have any PST files there? We log each PST file, so we know when there are new ones, if one is removed.
It's just a simple CSV file.

And every day, we get a list of all the people that have an Archive Mailbox and check each one again. Has that file been removed?, is the PST file in use?, etc. The user also gets a reminder message of PST files still attached to Outlook and instructions on how they should be detaching those PST files.  The user gets a message every 14 days from the day they were migrated.

We run another process manually on Wednesdays that looks to see how long it's been since a PST file was last accessed.  If it is older than 30 days, it tries to move the PST file to the user's local hard drive. Assuming there is space to hold it, of course.

New Hires are put in a GPO that "Disallows PST Growth."  Archive Mailbox users are put in that same GPO. We are calling these people "Controlled Users" because we can controll their PST file habit.

In the gap between New Hires and Archive Mailbox users, are the "Uncontrolled Users." Users not in the GPO and free to add messages and create new PST files.

The ultimate goal of this project is the removal of the PST files from the HomeDiectory.


What this report means:

· We have removed 4.3TB of PST data off Home shares
· Uncontrolled users (Not Online PST Users and Not New Hires) added 1TB of data to new PST files since Oct 2011
· Uncontrolled users have added, to their existing PST files, 2TB of data
· Leaving us a net removal of 1.3TB
· Uncontrolled Users added 55 PST files just last week.
· The 42% is: NumberOfPSTFilesRemoved / NumberOfPSTFilesOnOct92011


Percent Complete
42 %
People with Archive MBX
1,585
All Users with PST files on HomeShares
9-Oct-11
24-May-2012
Diff
Number of PSTs
23,516
18,739
4,777
Size on Shares
12,396,679
11,068,508
1,328,171
Users with PSTs on H:
3,004
2,506
498
Since Begining
Last Week
New PSTs on Shares
2,293
55
Size New PSTs
1,063,297
29,538
Users w/Archive Mailbox: PST files on HomeShares
Discovered
Processed
Removed
Number of PST Files
14,248
8,810
9,916
Size on Shares
6,992,846
3,495,739
4,346,864




Introduction: The Beginings
Part 1: Script Requirements
Part 2: Add-PSTImportQueue
Part 3: Process-PSTImportQueue
Part 4: Some Tools we added
Part 5: Set-PSTImportQueue
Part 6: About PST Capture
Part 7: More PST Import Tools
Part 8: Using RoboCopy
Part 9: Morning Status Report
Part 10: Using BITS Transfer
Part 11: Get the script / Set up
Part 12: The Functions


No comments:

Post a Comment