Exchange 2010 Unused Mailboxes

Hi I have an Exchange 2010 Env't with 2000 users.  We are going through a transition of bringing down the users to 1500.
Management wants a report of all "active users" in Exchange.  When running through EMS script, I am getting false positives where for ex.
I have Shared Mailboxes accessed by a team of 15 users (ie. our  This email address/user account shows up as a stale/unused mailbox that has NOT been logged into/accessed in ie. 30 days, 90 days, 365 days - on any EMS script I run into .CSV.
Now to test this issue, I logged into the email address via Outlook, opened up a few emails, then ran the EMS commands again and voila - did NOT appear in the csv.
So question is how can I get a EMS  script to work which filters out the Shared Mailboxes as most certainly none of the users actually probably log into these shared mailboxes, just have access to them send/receive/full access - we probably have over 100 shared mailboxes

Who is Participating?

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

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.

Will SzymkowskiSenior Solution ArchitectCommented:
The only way you can accomplish this is by filtering based on recipient type details i.e. RoomMailbox, Equipment Mailbox etc. If you create a Shared Mailbox that is a regular mailbox then you cannot disipher weather or not it is a shared mailbox unless you have specifically identified this in the Name or in another attribute of the mailbox.

Another thing you can consider is using the following script that goes out and looks for inactive mailboxes. This is directly from the scripting gallery.

Vincent BurtonCommented:
Please have a look on below given links might be helps you to get this job done.

Create a list of inactive Exchange mailboxes: 

List Inactive Mailboxes on Exchange

Determine the Number of Active Users on Exchange 2010 with PowerShell

Check this earlier discussed thread on Exchange active users report: 

Meanwhile check this:

First of all you have to fetch list of mailboxes which are not opened since last 90 days. You can get them using with the following command;

get-mailboxstatistics -database yourdbname | Sort-Object LastLogonTime -Descending  export-csv "csvfilepath"

Then you can open csv file in excel and prepare a list of user account and delete mailboxes from Exchange server.

Hope it helps you!

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

From novice to tech pro — start learning today.