PowerShell TIP – CSV to EXCEL

Sharing a tip that will guide many of you in converting CSV to EXCEL in a fast manner. We have some scripts where the creator has got the large data in a variable or exported to CSV and than called excel to write data one row at a time which was taking around 10 to…

ADD additional SMTP Email Address Exchange Hybrid

When you run Hybrid Wizard for setting up Exchange onpremise to Exchange online integration, one of the step –> updates the email address policy to include alias@domain.mail.microsoft.com.  This adds additional email address to all the users that have Automatically update Email adddresses based on e-mail address policy is checked. There are always mailboxes in the…

NetApp Space Reclaimer

This has been requested by our Storage Team as they were doing lot of manual stuff , uploading it in the community may be it fulfills needs for others as well. It can act as reference script only as every environment has different needs. Below were the requirement: Monday, Wednesday, Friday Run reclaim commands on…

Change ActiveSync Policy Based on AD group

There has been a requirement that we need to change the policy of certain users & need to automate the process based on AD group. We have written below script to do this job, this script uses QAD AD Shell & Exchange management shell. It fetches group members from the AD group export them in…