Powershell Scripts Ready-to-use

# Import the Exchange Online Management module
Import-Module ExchangeOnlineManagement

# Define the Office 365 admin credentials
$UserCredential = Get-Credential

# Connect to Exchange Online
Connect-ExchangeOnline -UserPrincipalName $UserCredential.UserName -Credential $UserCredential

# Example command to get a list of all mailboxes
Get-Mailbox

# Disconnect from the session
Disconnect-ExchangeOnline -Confirm:$false

# Define paths to common temporary folders
$tempPaths = @(

# Define Temp folders
"$env:Temp",
"$env:LocalAppData\Temp",
"$env:SystemRoot\Temp",
"$env:SystemDrive\Windows\Temp"
)

# Loop through each path and remove files and directories
foreach ($path in $tempPaths) {
if (Test-Path $path,) {
try {
# Remove all files in the directory
Get-ChildItem -Path $path -Recurse -Force | Remove-Item -Force -Recurse -ErrorAction SilentlyContinue

Write-Host "Temporary files in '$path' have been removed." -ForegroundColor Green
} catch {
Write-Host "Failed to remove files in '$path': $_" -ForegroundColor Red
}
} else {
Write-Host "The path '$path' does not exist." -ForegroundColor Yellow
}
}

# Ensure you have the necessary module installed
# You can install the required module via PowerShell Gallery, for example:
# Install-Module -Name ImportExcel

# Start Excel application
$excel = New-Object -ComObject Excel.Application

# Make Excel visible (optional)
$excel.Visible = $true

# Add a new workbook
$workbook = $excel.Workbooks.Add()

# Get the first worksheet
$worksheet = $workbook.Worksheets.Item(1)

# Add some data to cells
$worksheet.Cells.Item(1,1) = "Name"
$worksheet.Cells.Item(1,2) = "Age"
$worksheet.Cells.Item(2,1) = "John Doe"
$worksheet.Cells.Item(2,2) = 30
$worksheet.Cells.Item(3,1) = "Jane Smith"
$worksheet.Cells.Item(3,2) = 25

# Save the workbook
$workbook.SaveAs("C:\Path\To\Your\Directory\Sample.xlsx")

# Close the workbook
$workbook.Close()

# Quit Excel
$excel.Quit()