Help....TAsk scheduler asking for credentials

Hello vaibhavkaulkar,

Here's a step by step process:-

- First Open Powershell and use below cmdlet to generate an XML file with credentials:-

          Get-Credential | Export-Clixml -Path "C:\Users\UserName\Desktop\Data\Cred.xml 

When you will use this you will be prompted to enter your credentials, just enter your credentials in the pop up box that appears, once you do you will be able to see an XML file at the location provided in the above cmdlet in the -path parameter.

If you open the XML you will see that it contains your username in plain text and your password in encrypted text.

Please remember to generate the XML file with same User profile on the same Computer where you will be using them as credentials are encrypted using the Windows Data Protection API and can only be used by user who generated them and on the computer on which they were generated.

- Second step is to start you SP script with below cmdlets :-

Start-Transcript

Import-Module Microsoft.Online.SharePoint.Powershell -DisableNameChecking
Import-Module ExchangeOnlineManagement

$Cred = (Import-Clixml "C:\Users\UserName\Desktop\Data\Cred.xml")
$AdminCenterURL = "https://xyz-admin.sharepoint.com/"
Connect-SPOService -Url $AdminURL -Credential $Cred
Connect-IPPSSession -Credential $Cred

#create temp folder if it does not exist
$ReportOutput="C:\Temp\pvtSiteColl.csv"

#Get All site collections
........

Thanks