Microsoft – Page 2 – McAvatar.com

Tools for LabTech/ConnectWise Automate

This site has several interesting tools designed to improve working with ConnectWise Automate.

PowerShell Module
Script to deploy ScreenConnect/ConnectWise Control on Macs. (Great for when the native installer fails!)

If their main site is down, they host their projects on GitHub.

Resolving Windows Update issues with DISM or System Update Readiness

To fix Windows Update issues, Windows 8 and newer have the built-in DISM command. Windows 7 has a System Update Readiness tool that can be downloaded.

This page has information on both tools.

PowerShell Commands for connecting to Office 365

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook
.com/powershell/ -Credential $Cred -Authentication Basic –AllowRedirection

PowerShell Commands to remove Office 365 users

Remove-MsolUser -UserPrincipalName user@example.com
Remove-MsolUser -UserPrincipalName user@example.com -RemoveFromRecycleBin

Connect to Office 365 via PowerShell

https://technet.microsoft.com/en-us/library/dn975125.aspx

Removing orphaned local AD accounts from Azure AD

Removing orphaned local AD accounts from Azure AD

You can’t manage or remove objects that were synchronized through the Azure Active Directory Sync tool

Source

Azure AD Connect sync: Configure Filtering

Source

Object deletions aren’t synchronized to Azure AD when using the Azure Active Directory Sync tool

Source

How to delete an ‘orphaned’ synced account from Office 365 when using Managed Workplace

Change font case in Excel

I needed to change the format of some text in Excel 2016 today. Excel doesn’t have the same font controls as Word, so it’s not as intuitive as one would expect.

The process in Excel is to use formulas (in my case, it was UPPER) to create the text you wish to see in the world, then paste those values into their final destination.

Thanks to Andre at GroovyPost for the tutorial!