Need to make an Excel spreadsheet report of all current Exchange Server users

I need to make an Excel spreadsheet report of all current Exchange Server users.

This report needs to list the individual user names, email addresses, Exchange Server names, mailbox size, and (if possible) if the user has a Smart phone set up with that user's emails address. Is it also possible to list what kind of Smart phone that user is using?

The most important information that I need involves all of the information listed above. While it would be nice to know exactly which users are using Smart phones for their email, this requirement isn't quite as important as getting all of the other information.

Please describe how I can create such a report from the Exchange Management Console (either Exchange 2007 or Exchange 2010) or from the Exchange Power Shell (either Exchange 2007 or Exchange 2010.

This report needs to be exported into a CSV or similar format that I can then easily import into an Excel document.

If there is some kind of global report that can be run or displayed that includes extra information besides what I have listed above, this will be OK. I can always delete any information that I don't need to have out of this report once it has been imported into the Excel 2010 spreadsheet.
IT GuyNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IT GuyNetwork EngineerAuthor Commented:
How can I export such a report from Exchange 2010?
0
TomasPCommented:
0
IT GuyNetwork EngineerAuthor Commented:
I also need to know the exact size of each user's mailbox.

How can I add this feature to the Add/Remove columns? I don't see any option to add this.

I'm sure that this could be added by creating a Custom Attribute that will display the mailbox size.

How can I create such a Custom Attribute that will display the mailbox size?
Add-Remove-columns.png
0
TomasPCommented:
Just follow the wizards and select the properties/conditions you want.
I don't have access to my exchange server right now but this will help you

http://technet.microsoft.com/en-us/library/bb124255.aspx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.