Convert Office Outlook VBA Macro To PowerShell

In my profession I have always been presented with problems or requests that provide a bit of a challenge. One such challenge was automating local PST archiving (not to be confused with online archiving). There is a MAPI property on each folder in the mailbox that will identify whether the …

Connect To All Office 365 Services With PowerShell

Since I had to accumulate the following through trial and error of outdated links and outdated technet articles, I have created the up to date defacto version of how to connect to all Office 365 sessions through PowerShell. I divided each service up into its own section along with a …

Create Shortcuts .lnk or .url Files With PowerShell

Have you ever needed to create shortcuts while scripting. Shortcuts are simply .lnk files with a few details highlighting a few details of the file that you would like to launch. Many people simply copy an already created shortcut. With PowerShell you can actually create a shortcut from scratch by …

Delivering Version Controlled Tools With PowerShell

The most popular PowerShell user interface IDE is Sapien’s PowerShell Studio which allows for an easy way to create WinForms applications. When packaging PowerShell code into an .exe file you can specify the version number, increasing it with each new release. If you create PowerShell based executable files with this …

Join Computer to Domain with Desired Computer Name and OU

Someone submitted a PowerShell request for scripting the adding of a workstation to the domain. The solution was to be used in an imaging process with the ability to change the workstation name and import the workstation into a user specified Organizational Unit with no reboot between steps. I will …

Find any E-Mail Address or Proxy Address In Active Directory

Here is another common request for any Exchange or Unified Communications administrator. Someone will usually pop by and ask, “Who has this e-mail address?” The address could be one of many different types of objects. A user mailbox, shared mailbox, distribution list, public folder, contact or resource could all contain …

Automate Sip Address and UPN name changes in Lync / Skype for Business

When a person’s name changes a lot of organizations implement different strategies of keeping relative addresses in sync. For Lync / Skype for Business and Exchange purposes the four attributes that are important are mail, proxyAddresses, msRTCSIP-PrimaryUserAddress and userPrincipalName. For the best Lync / Skype for Business login experience it …

Export Subnets from Active Directory Sites and Services

I was asked if I could produce all the subnets from our environment. I was quick to turn to PowerShell for this request. As long as you have all of your subnets properly associated to sites in Active Directory, PowerShell can be utilized to get you the subnets. The commands …