Mike Campbell exactmike

Requirements

Have the following powershell modules installed, functions loaded, and permissions granted to the connection you are going to make to Microsoft Graph and ActiveDirectory

Modules

Install these modules in the environment where you will run your powershell session

Microsoft.Graph
OGraph

Initial Tenant Setup

Register an Enterprise App

Attribute	Value
Name	Stale Account Management
Supported Account Types	Accounts in this organizational directory only

Note the application (client) ID and the Directory (tenant) ID

Distribution Group Management for End Users

Overview

When end users mailboxes are migrated to Exchange Online from Exchange on premises the users' ability to manage email enabled on premises directory distribution groups in Microsoft Outlook is impacted. The users' Outlook is no longer connecting to the on premises directory service. While Outlook will have visibility to the synchronized representation of the on premises email enabled distribution groups those synchronized groups are not directly editable in the online directory.

As an alternative to using Outlook to manage Distribution Groups users have access to the Exchange Control Panel (ECP), a web interface that is a native part of Microsoft Exchange for end user and administrative access to Exchange features. However, access to the ECP for end users is typically tied to having a Mailbox in the same Exchange environment. Because of this dependency for typical ECP access by end users, when a user mailbox is migrated to Exchange Online, the user's

	function Convert-DukeEnergyXmlToHaStatisticsFile
	{
	<#
	.SYNOPSIS
	Converts Duke Energy (ESPI / Green Button) interval XML into an hourly, cumulative
	counter time series suitable for the homeassistant-statistics importer.

	.DESCRIPTION
	Duke Energy provides 30-minute interval deltas (kWh per interval). Home Assistant long-term
	statistics for the Energy dashboard use hourly timestamps (minutes must be 00).

	[cmdletbinding()]
	param(
	[parameter(Mandatory)]
	[ValidateScript( { Test-Path -type Container -path $_ })]
	[string]$OutputFolderPath
	,
	[switch]$ExchangeOnline
	)

	$ErrorActionPreference = 'Continue'

	#From https://www.joseespitia.com/2020/02/07/automatically-create-microsoft-edge-profile-shortcuts/
	$EdgeProfiles = Get-ChildItem "$env:LOCALAPPDATA\Microsoft\Edge\User Data" \| Where-Object { $_.Name -like "Profile *" }

	ForEach ($EdgeProfile in $EdgeProfiles.Name)
	{

	# Get Profile Name
	$Preferences = "$env:LOCALAPPDATA\Microsoft\Edge\User Data\$EdgeProfile\Preferences"
	$Data = (ConvertFrom-Json (Get-Content $Preferences -Raw))
	$ProfileName = $Data.Profile.Name

	Function Send-OutlookMail
	{
	[cmdletbinding()]
	param(
	[parameter()]
	[string]$Subject
	,
	[parameter()]
	$Body
	,

	function Get-AzureADUserByAttribute
	{
	<#
	.SYNOPSIS
	Get Azure AD users by an arbitrary filterable attribute, such as MailNickName.
	.DESCRIPTION
	Get Azure AD users by an arbitrary filterable attribute, such as MailNickName.
	.EXAMPLE

	$list = Import-CSV .\TempTestUsers.csv