[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2013-01-31
16
Medium Priority
?
4,679 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

1
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 

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 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

656 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