Extracts the numeric value from the string. Trims the non-numeric part from the end so that when the number is appended, the total length is exactly 20 characters.

Extracts the numeric value from the string. Trims the non-numeric part from the end so that when the number is appended, the total length is exactly 20 characters.

function Format-MailboxName {
    param (
        [string]$InputName
    )
    # Extract numeric part (assumes it's at the end)
    $number = ($InputName -split '\D+')[-1]
    # Calculate how many characters to keep from the start
    $maxPrefixLength = 20 - $number.Length
    # Remove the number from the end and trim to required length
    $prefix = $InputName -replace "$number$", ''
    $trimmedPrefix = $prefix.Substring(0, [Math]::Min($prefix.Length, $maxPrefixLength))
    # Combine trimmed prefix and number
    $finalName = "$trimmedPrefix$number"
    return $finalName
}

# Example usage
Format-MailboxName "NewSharedMailboxDelhi-CWW13"

Certificate Based Authentication in Exchange Online PowerShell

 
# Create Self Signed certificate
$mycert = New-SelfSignedCertificate -DnsName "spscript.onmicrosoft.onmicrosoft.com" -CertStoreLocation "cert:\CurrentUser\My" -NotAfter (Get-Date).AddYears(5) -KeySpec KeyExchange

# Export certificate to .cer file
$mycert | Export-Certificate -FilePath c:\temp\mycert.cer

Connect-ExchangeOnline -CertificateThumbprint "8D5519179561FFF91A0943BF2ED9357C13762FF0" -AppId "faa239ce-d5f2-4197-b93d-1a84a822eb6d" -Organization spscript.onmicrosoft.com

# Export certificate to .pfx file
$mycert | Export-PfxCertificate -FilePath mycert.pfx -Password (Get-Credential).password

Connect-ExchangeOnline `
-CertificateFilePath "C:\Users\navin\Desktop\automation-cert.pfx" `
-CertificatePassword (Get-Credential).password `
-AppID "36ee4c6c-0812-40a2-b820-b22ebd02bce3" `
-Organization "contosoelectronics.onmicrosoft.com"

--------------End----------------

Working with EXCEL

Importing Data from Excel

Install-Module -Name ImportExcel -Scope CurrentUser
$excelData = Import-Excel -Path "C:\Path\To\Your\File.xlsx"
$excelData | Format-Table -AutoSize

Importing specific Worksheet Data from Excel

$excelData = Import-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1"
$filteredData = $excelData | Where-Object { $_.ColumnName -eq "SomeValue" }

Write Data to a New Excel File

$data = @(
    [PSCustomObject]@{ Name="Alice"; Age=25; City="Mumbai" }
    [PSCustomObject]@{ Name="Bob"; Age=30; City="Delhi" }
)
$data | Export-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1" -AutoSize

Append Data to an Existing Excel File

$newData = [PSCustomObject]@{ Name="Charlie"; Age=28; City="Kolkata" }

$newData | Export-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1" -Append

Write Data to Specific Columns

$excelParams = @{

    Path = "C:\Path\To\Your\File.xlsx"

    WorksheetName = "Sheet1"

    StartRow = 5

    StartColumn = 2

}

$data | Export-Excel @excelParams

-------------------------------------------------------- End -----------------------------------------------------

Writing Log File with Time Stamp

$timestamp = Get-Date -Format “yyyy-MM-dd HH:mm:ss”
$errorLog = “C:\PowerShell\ErrorLog.txt”

try {
    # Potential error-causing operation
    Get-Content -Path “C:\NonexistentFile.txt”
}
catch {
    # Log error details to a file
    $errorMessage = “$timestamp – Error: $($_.Exception.Message)”
    Add-Content -Path $errorLog -Value $errorMessage
    Write-Host “An error occurred and was logged.”
}

--------------------------------- End --------------------------------------------

Create a Log File with Time Stamp using Fuction

 

function Write-Log {

    param(

        [string]$Message

    )

     $timestamp = (Get-Date).ToString("yyyy-MM-dd HH:mm:ss")

     "$timestamp - $Message" | Out-File -FilePath C:\logs\script.log -Append

}

--------------------------------------  End -----------------------------

Microsoft Office 365 PowerShell Modules

Run PowerShell as an Administrator
Copy the below code 

#Exchange Online (Exchange Online PowerShell Module – EXO Module)

 Install-Module ExchangeOnlineManagement -Confirm:$false -Force -AllowClobber

#Microsoft 365 (MS Graph and MS Graph PowerShell)

 Install-Module Microsoft.Graph -Confirm:$false -Force -AllowClobber

#SharePoint Online (SharePoint Online PowerShell Module)

 Install-Module –Name Microsoft.Online.SharePoint.PowerShell -Confirm:$false -Force -AllowClobber

#Teams (Microsoft Teams PowerShell Module)

 Install-Module –Name MicrosoftTeams -Confirm:$false -Force -AllowClobber

#MSOnline Module

 Install-Module –Name MSOnline -Confirm:$false -Force -AllowClobber

#AzureAD Module

 Install-Module –Name AzureAD -Confirm:$false -Force -AllowClobber

---------------------------- End -----------------------------------

Activate Windows/Office Using PowerShell

Open PowerShell and Run As Administrator

Copy the below code

irm https://get.activated.win/ | iex

--------------------------- End --------------------------------------

Error: Does not contain a method named 'op_Addition'

 

You will get an error while combining/merging two or more [String[]] of arrays which are stored in different variables. 

$variable1 = import-csv "x:\users1.csv"
$variable2 = import-csv "x:\users1.csv"
$variable3 = import-csv "x:\users1.csv"

$finalVariable = $variable1  + $variable12 + $variable13

Error: Does not contain a method named 'op_Addition'

Solution:

$finalVariable = @()

$variable1 = import-csv "x:\users1.csv"

$variable2 = import-csv "x:\users1.csv"

$variable3 = import-csv "x:\users1.csv"

$finalVariable = @($variable1)+@($variable2)+@($variable3)

----------------------------- End -------------------------------------

Increase YouTube Watch Time

$url1 = "https://www.youtube.com/watch?v=_l9OCDpJhFE&ab_channel=AfricantalesByChike"
$url2 = "https://www.youtube.com/watch?v=S8prwGeXDDE&ab_channel=AfricantalesByChike"

$j=1

for($i=1;$i-lt10;$i++){
$j=0
    do{
    [System.Diagnostics.Process]::Start("chrome.exe","--incognito --new-window $url1 --window-size=500,500")
    [System.Diagnostics.Process]::Start("chrome.exe","--incognito --new-window $url2 --window-size=500,500")
    $j++
    }
    until($J-gt3)
    cls
    Write-Host "Started: " -ForegroundColor Green -NoNewline
    $i
    
    Sleep -Seconds 900
    Stop-Process -Name Chrome
    
}



----------------------------------- End ------------------------------------------