Solved

How to see How many public Folders I have and last access time

Posted on 2013-01-31
16
4,206 Views
Last Modified: 2013-03-04
We have Exchange 2010 in a  DAG configuration with out 8 databases.  I need to an Exchange Powershell command to run in order to export to a CSV the following:



Name of Public Folder
Last access time
Last Modification
Total Size


Here is the command I was given before however it errors that "Get-PublicFolderStatistics : A parameter cannot be found that matches parameter name 'Recurse'."




Get-PublicFolderStatistics –Identity '\' –Recurse –ResultSize Unlimited | FL AdminDisplayName, LastAccessTime, LastModificationTime, LastUserAccessTime, TotalItemSize > C:\PublicFolders.txt
0
Comment
Question by:Twhite0909
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
  • 3
16 Comments
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38840796
Get-PublicFolder –Identity '\' –Recurse –ResultSize Unlimited | Get-PublicFolderStatistics | FL AdminDisplayName, LastAccessTime, LastModificationTime, LastUserAccessTime, TotalItemSize > C:\PublicFolders.txt

Try the above command

- Rancy
0
 

Author Comment

by:Twhite0909
ID: 38841276
Now i get this error:


Couldnt find public folder "\" on server "exmbx2.ad.local




This is the server that currently houses the databses and I also tried this command of EXMBX1 just to be sure and got same error
0
 
LVL 40

Expert Comment

by:Subsun
ID: 38855166
Try..
Get-PublicFolderStatistics –ResultSize Unlimited | FL AdminDisplayName, LastAccessTime, LastModificationTime, LastUserAccessTime, TotalItemSize > C:\PublicFolders.txt 

Open in new window


You can also export it to CSV file..

Get-PublicFolderStatistics –ResultSize Unlimited | Select AdminDisplayName, LastAccessTime, LastModificationTime, LastUserAccessTime, TotalItemSize | Export-Csv c:\pfreport.csv -NoTypeInformation

Open in new window

0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:Twhite0909
ID: 38864557
Get-PublicFolderStatistics –ResultSize Unlimited | Select AdminDisplayName, LastAccessTime, LastModificationTime, LastUserAccessTime, TotalItemSize | Export-Csv c:\pfreport.csv -NoTypeInformation

I like this command but I have a few requests:

The original command using IDENTITY (I think) showed me the location of the Public FOlder Example:

\Agilysys\CorporatePublicFolders\Timw\MyTestFiles

Where is this command will simple show:

MyTestFiles

Also I noticed my access times are all the same date.  Example below shows name of folder and last access date/time:

EMC      1/31/2013 14:23
EMC      1/31/2013 14:23
EMC Commissions      1/31/2013 14:20
EMC Completed 2006      1/31/2013 14:20
EMC Completed 2007      1/31/2013 14:20
EMC Completed 2008      1/31/2013 14:20
EMC Completed 2009      1/31/2013 14:20
EMC Completed 2010      1/31/2013 14:20
EMC Completed 2011      1/31/2013 14:20
EMC Completed 2012      1/31/2013 14:20
EMC Group      1/31/2013 14:27

Anyone know why it shows same date where I am positive these have been access and modified since that date.
0
 
LVL 40

Expert Comment

by:Subsun
ID: 38865147
To get path, include FolderPath attribute while exporting the list..

Get-PublicFolderStatistics –ResultSize Unlimited | Select AdminDisplayName,FolderPath,LastAccessTime,LastModificationTime, LastUserAccessTime,TotalItemSize | Export-Csv c:\pfreport.csv -NoTypeInformation

Open in new window


Also I noticed my access times are all the same date..
Does it change if you try to access the folder?
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38865182
Look run this normal command

Get-PublicFolderStatistics -Identity "\Agilysys\CorporatePublicFolders\Timw\MyTestFiles" |FL

The above command will give you a list of attributes select what you want and use them after the FL :)

- Rancy
0
 

Author Comment

by:Twhite0909
ID: 38865210
Cool that worked as far as listing the path which is excellent

For access time it did not change even after Ia ccessed a specific folder:

Agilysys\ESGPublicFolders\EMC.Config\EMC Completed 2006           
Last Access time shows  2/7/2013 11:38      

Last Modification times shows 6/28/2012 16:07

I wnet into that folder right before I ran this command so last access time should show today at about 1:35pm EST
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38865225
Look the changes arent lighting fast so need to wait .... why not try to modify or place a post and check

- Rancy
0
 
LVL 40

Expert Comment

by:Subsun
ID: 38865234
Check LastUserAccessTime and LastUserModificationTime .. does it change? Please keep in mind that this attribute is for folders.. For folder items there is a different command  Get-PublicFolderItemStatistics
0
 

Author Comment

by:Twhite0909
ID: 38865789
My problem is this.  The LastAccessTime shows all 6,000 of my public folders as being accessed Today all within 10 minutes of each other between 10:35 am and 11:48 am.   User AccessTime shows a few today about a dozen others within the last year and about 5500 as blank.  Does blank mean it has not been accessed in over a year possibly?
0
 
LVL 40

Expert Comment

by:Subsun
ID: 38866539
Does your AV scan public folders?
0
 

Author Comment

by:Twhite0909
ID: 38880092
No AV is not installed on this machine.  I am trying to think of anything else that would scan all the folders but nothing comes to mind.
0
 
LVL 40

Expert Comment

by:Subsun
ID: 38880140
Get-PublicFolderStatistics simply dump the attributes of public folder.. I guess some application might be scanning the public folders folders, I cannot think of anything else which might cause this..
0
 

Author Comment

by:Twhite0909
ID: 38880149
If AV on a Users laptop scan is set to scan email would it scan the public folders from there you think?
0
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 38880203
From client side it's more of on-demand scan, If configured, probably it will scan when user opens the specific public folder in outlook.. but I don't think it will scan all public folders..
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
how to add IIS SMTP to handle application/Scanner relays into office 365.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question