Office 365 New Message Encryption and Discovery/Journal

This blog post is about New Message encryption capabilities of office 365 that are based on Azure Information Rights Management. Most of us are already aware of how to set it up and various articles exists on Internet for assistance. You can refer below Microsoft link if you are not aware about its setup/configuration. https://support.office.com/en-us/article/set-up-new-office-365-message-encryption-capabilities-7ff0c040-b25c-4378-9904-b1b50210d00e…

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/…

Microsoft PowerAPPS and Flow restrict third party Apps

Flow and Powerapps are two most powerful tools in office 365 arsenal and can automate IT, business processes and can create applications in no time. With that being said Power Users that become fluent in using these can easily move data around and can connect to hundred of third-party application which your security department may…