Link to home
Start Free TrialLog in
Avatar of Yashy
YashyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How to create reports for inactive users, devices and mailboxes?

Hi guys

I'm currently working on all of the licenses across our estate. I ran the Microsoft SAM tool and of course in the report we have so many users/mailboxes/devices which are over the licenses we actually have.

I'm trying to work out a way which I can get a report into an Excel sheet with the following to help me with all of the licensing:

a.  All of the people who have not accessed their mailboxes for over 2 months (the plan is to backup and then remove those mailboxes)
b. All of the mobile devices that have got Exchange emails added to them.
c. All of the computer devices that have not accessed or been active or no longer on the network.

Is this feasible? As it will hopefully help with getting rid of stale and unused records to aid me with organising our licenses.

Thanks a lot for helping
Yashy
ASKER CERTIFIED SOLUTION
Avatar of Ivan
Ivan
Flag of Serbia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Yashy

ASKER

Thank you for responding Ivan. I appreciate it.
Avatar of Naveen Sharma
Naveen Sharma

You can also automate this process using this Active Directory Cleanup solution to identify, move or clean up inactive AD user accounts: https://www.lepide.com/lepideauditor/active-directory-cleanup.html 

Here is an article which lets you how to manage inactive user and computer accounts in Active Directory:
https://www.lepide.com/how-to/manage-inactive-accounts-in-active-directory.html

Hope you find this useful!