This repo is where I maintain most of my PowerShell scripting work. So far it always seems to come back to Exchange for me and PowerShell, so most of my work here caters to that. My only real boundary for what will live here though is that it’s PowerShell (scripts, functions, modules, etc.), so over time the content will surely bounce around between more topics.
ℹ Most of my scripts / functions have detailed comment based help to make using them easier. This can be read here on GitHub by viewing the code (which is syntax-highlighted for easy viewing), or directly in PowerShell which can also be handy.
PS C:\> conex -? PS C:\> Get-Help Get-MailboxTrusteeps1 -Examples PS C:\> Get-Help Get-MailboxTrusteeWebSQLEdition.ps1 -Full
Conex is aimed at Exchange admins (or users) who need to connect to Exchange remote Powershell regularly. It offers easy menu/choice prompts for those who like to smaaasshh
[Enter], and parameters to cover those who need unattended/automation options. This one is something I use all the time, so naturally is a very active project for me.
The name ‘conex’ is both the name of the module, and the desired (by me) alias of the original function Connect-Exchange. For now I’m continuing to maintain both the module (which has several, and growing, functions included), and the function (which is an exact copy of the same function in the module).
This script’s target audience is anyone who needs to find mailbox permission relationships, for example when planning a migration to Office 365. The script outputs one object for every mailbox-trustee relationship, a format that works well for direct usability in a database or Excel table, from which pivot tables can very easily be crafted in seconds.
If you give it a try, try using it with -Verbose. This, combined with its detailed progress, allows me to forego tracking with a processesd.csv etc. or needing to pair it with something like Microsoft’s kindly-offered Start-RobustCloudCommand.ps1. This one is screaming to be used in parallel jobs or runspaces for ultra performance.
New-MailboxTrusteeReverseLookup.ps1 is the sister script to Get-MailboxTrustee.ps1. What to do after you’ve extracted your entire Exchange organization’s list of mailbox & mailbox folder permissions (maybe even on a scheduled basis)? Well, one thing you can do is respond to requests for mailbox permsission reverse lookups (e.g. User: ‘What mailboxes do I have access to and what is my access level to each of them?’ Answer: ‘Coming right up!’)
The SQL Edition is now at parity with the original version, and beyond (the database storage/engine really help tremendously). If you have a large data set from Get-MailboxTrustee.ps1, this script has you covered with zippy speeds as it identifies webs. The parameters allow for repeated trial and error / trial and cancel runs, as you fine tune the parameters to persuade the resulting web as desired..
While the original version (combined with the input-optimizing brother) works fine for small data sets, the SQL Edition is better suited to larger sets. Requirements? SQL Express (only 2017 tested), and a database (default is TempDB) where current user has permissions to create/delete tables.
This script pulls some key details together to help determine how a mailbox is used. Details include AD user account’s last logon date, the mailbox’s last logged on date / last logged on user, the newest item in the Inbox and Sent Items folders, and a few other items. This one is arguably overlapping of Office/Microsoft 365’s usage reports. Its intended use is strictly with mailboxes, for tasks like determining if a UserMailbox is a good candidate for conversion to SharedMailbox, or Room/EquipmentMailbox. Being that it can also be used with Exchange On-Premises or EXO, it rather compliments the O/M365 usage reports.