Convert any CSV to Formatted Excel file

Many of my scripts I created in the past required to have a Excel report instead of plain CSV, as these reports are for different Technical/Management/Leadership teams. Today We got one such requirement where excel report is required therefore to make it easy for future I wrote a powershell code that takes CSV as input…

Exchange Online Rooms Report

One of our customer is in hybrid environment and have migrated lot of rooms to Exchange Online. There was a issue reported by L1 team as they were not able to see all the parameters in Exchange online ECP where as they were able to see those when these rooms were on onpremise exchange 2010…

Extract office 365 Role Admins

Sharing a quickly written small script which will be useful if you want to extract all the admins from office 365. Download and Extract the script from below: https://gallery.technet.microsoft.com/scriptcenter/Extract-office-365-Role-b4007ddf Run the batch file, It will prompt you for your credentials. Note:¬†MSOL should be installed and I have tested the script with Global Admin credentials. follow:¬†https://syscloudpro.com/2015/04/30/connecting-office-365-via-powershell/…

Office 365 License Reconciliation

This script that I am sharing has been written to assist with our provisioning process: As you are aware when you provisioin new exchnage onine mailbox, if license is not applied, you have 30 days to assign the license. To detect these mailboxes and applying the Exchange license –> this solution has been written (I…

HIDE Office 365 Groups from GAL

We have seen lot of users are creating Microsoft Teams, Planner etc and these in-turn create Office 365 groups. Some are even test and it creates lot of unwanted data in the GAL which many users and our organization management is not encouraging. So we have created this script that runs regularly and hide Newly…