Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2013-01-31
16
Medium Priority
?
5,265 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
  • 6
  • 6
  • 3
15 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
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

 

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

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft has decided to launch the Exchange Server 2019 this year for its on-premise users. What’s new now Microsoft is going to serve its users? How good is it going to be on the current Exchange Server 2016? This blog is going to answer all queri…
This article is divided into two sections. 1) First describes how you can connect to server / service / device with Username and secure password in powershell. 2) Second part is to use secure credentials and connect to vCenters which are in Link…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.

588 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