Solved

How to export Public Folders into a CSV file by using Powershell

Posted on 2008-06-16
8
6,284 Views
Last Modified: 2008-08-26
Hello Guys,

I am totally new with PowerShell and I will need to understand which commands I can use to import and export to a CSV file into Exchange 2007 environment.
I used to do the same with Exchange 2003 only by clicking with the right-button on the Public Folders and then "Export List". Does any one have an idea how I would be able to proceed? Maybe if you guys could give me just an idea I will be able to do it.
Thanks, LaranjaCarioca
0
Comment
Question by:LaranjaCarioca
[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
  • 5
  • 3
8 Comments
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795823
Get-PublicFoler | export-csv <your file> -NoType
0
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795827
sorry

get-publicfolder not Get-publicfoler
0
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795929
btw... if you want all you need to add the -recurse

Get-PublicFolder -Recurse | Export-Csv <CSV File> -noType
0
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:LaranjaCarioca
ID: 21796026
Sorry BSonPosh....what is -Recurse ?   if I want ALL, I did not get what you mean.
0
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21796135
-recurse means to process the entire tree (almost like a directory tree.)

If you do not use -recurse then it will only get one level of public folders
0
 

Author Comment

by:LaranjaCarioca
ID: 21796240
BSonPosh,

Really thanks for your help...do you think the following command would work?

Get-PublicFolder -Database server\storage group\public folder database -recurse | Export-Csv c:\PFcsvFile.csv
0
 
LVL 18

Accepted Solution

by:
BSonPosh earned 250 total points
ID: 21796314
If your wanting a specific Public folder you need to use the -id parameter.

How many public folders do you have?

I would step through the command (it doesnt change anything.)

PS> Get-PublicFolders
What did you get?

PS> Get-PublicFolders -recurse
Did you get more folders? Did you get the ones you wanted? To many?

Use "Get-Help Get-PublicFolders -full" for detailed help

0
 

Author Comment

by:LaranjaCarioca
ID: 21796540
Hello BSonPosh,

As a matter of fact it is just an example. Soon I will need to work with this and I just wanted to make sure how to get the public folders on a specific public folder and then save it into a CSV file.
Probably it will be lots of folders and subfolders.
I read the -full help for this command and I think it would work. As soon I get back something from the production mode, I will let you know...THANKS!

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

Find out what you should include to make the best professional email signature for your organization.
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
To show how to create a transport rule 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 Mail Flow >> Rules tab.:  To cr…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

732 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