Hey, I'm usually good enough to feel my way through any problem I might have, but I have hit a stopping point with PowerShell. Every time I try to pull data or execute anything, I get an "Unauthorized" error. Two questions: 1) Can someone send me a simple command (soup to nuts please) that will pull all the lists of a site collection. This isn't what I'm trying to do, but it will allow me to test my setup. 2) What could possibly be wrong with my PowerShell? I've turned LegacyAuth on and off with Set-SPOTenant, to no avail. Thanks.

I mean to create a PowerShell scripts that uses Client Side Object Model and run it from ISE or PowerShell Tools for Visual Studio. As an example:############################################################################################################################################ #Script that allows to get the site collections in a SPO Tenant using CSOM # Required Parameters: # -> $sUserName: User Name to connect to the SharePoint Online Site Collection. # -> $sPassword: Password for the user. # -> $sSiteUrl: SharePoint Online Administration Url. ############################################################################################################################################ $host.Runspace.ThreadOptions = "ReuseThread" #Definition of the function that gets the list of site collections in the tenant using CSOM function Get-SPOTenantSiteCollections { param ($sSiteUrl,$sUserName,$sPassword) try { Write-Host "----------------------------------------------------------------------------" -foregroundcolor Green Write-Host "Getting the Tenant Site Collections" -foregroundcolor Green Write-Host "----------------------------------------------------------------------------" -foregroundcolor Green #Adding the Client OM Assemblies Add-Type -Path "<CSOM_Path>\Microsoft.SharePoint.Client.dll" Add-Type -Path "<CSOM_Path>\Microsoft.SharePoint.Client.Runtime.dll" Add-Type -Path "<CSOM_Path>\Microsoft.Online.SharePoint.Client.Tenant.dll" #SPO Client Object Model Context $spoCtx = New-Object Microsoft.SharePoint.Client.ClientContext($sSiteUrl) $spoCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($sUsername, $sPassword) $spoCtx.Credentials = $spoCredentials $spoTenant= New-Object Microsoft.Online.SharePoint.TenantAdministration.Tenant($spoCtx) $spoTenantSiteCollections=$spoTenant.GetSiteProperties(0,$true) $spoCtx.Load($spoTenantSiteCollections) $spoCtx.ExecuteQuery() #We need to iterate through the $spoTenantSiteCollections object to get the information of each individual Site Collection foreach($spoSiteCollection in $spoTenantSiteCollections){ Write-Host "Url: " $spoSiteCollection.Url " - Template: " $spoSiteCollection.Template " - Owner: " $spoSiteCollection.Owner } $spoCtx.Dispose() } catch [System.Exception] { write-host -f red $_.Exception.ToString() } } #Required Parameters $sSiteUrl = "https://<YourOffice365Domain>-admin.sharepoint.com/" $sUserName = "<SPO_Administration_User>" #$sPassword = Read-Host -Prompt "Enter your password: " -AsSecureString $sPassword=convertto-securestring "<User_Password>" -asplaintext -force Get-SPOTenantSiteCollections -sSiteUrl $sSiteUrl -sUserName $sUserName -sPassword $sPasswordYou need to download CSOM assemblies for SPO and reference the assemblies path in the script. Kind regards,

I did, but it was nothing different from what I was doing (I believe). Some of the old scripts I had just started working again, so I think there was a problem with my tenent for about 24 hours. Thanks all. Still learned some stuff in here.

That looks like a problem with your credentials, double check your values against the instructions in the Getting Started section of https://github.com/OfficeDev/PnP-PowerShell.If you have MFA, you need to use the UseWebLogin parameter in the connect-sponline statement

Trying to use PowerShell for SharePoint Online, failing miserably

18 Replies

Anonymous
Sep 26, 2016
Do you run the Commands under the administrator account?
Suzanne Hunt
Brass Contributor
Sep 25, 2016
Hey Joe,
When you use connect-sponline what URL are you using? In the error it would appear you are connecting to https://harmelinmedia.sharepoint.com/...can you try to connect to https://harmelinmedia-admin.sharepoint.com/? The connect-sponline needs to connect to the admin site...Sorry if you have tried this, just trying to eliminate the simple things for you
Suzanne
- Joe Fedorowicz
  Iron Contributor
  Sep 25, 2016
  I think this is 100% what I'm doing wrong. i'll update tomororw. Thanks.
  - Vipin Tyagi
    Brass Contributor
    Oct 04, 2016
    Hey,
    A simple tip for you.
    If you are using PnP PowerShell then you can use below cmdlet to connects SPO
    1.Connect-SPOnline(site Url will be https:\\abc.sharepoint.com)
    
    But if you are using SharePoint Online Management Shell,you have only one option to connect
    1.Connect-SPOService(Url will be https:\\abc-admin.sharepoint.com)
    
    Cheers!!!!
jcgonzalezmartin
MVP
Sep 23, 2016
Get-SPOSite executed in the SharePoint Online Management Shell should give you the list of site collections and it should work with no problems
- Joe Fedorowicz
  Iron Contributor
  Sep 23, 2016
  So Get-SPOSite works fine. It's anything beyond that which doesnt work.

Dean_Gross

Silver Contributor

Sep 23, 2016

Are you a Global Tenant admin?
Are you using the latest update to the SPO Management Shell?
Are you using the PnP Powershell cmdlets? https://github.com/OfficeDev/PnP-PowerShell, if so, you can just use the Get-SPOList cmdlet, see https://github.com/OfficeDev/PnP-PowerShell/blob/master/Documentation/GetSPOList.md. If you are not using these, you should, they are awesome.

Joe Fedorowicz

Iron Contributor

Sep 23, 2016

Hey,

Thanks for helping out.

1) I am a global tenant admin.

2) I am, at least according to the download page.

I want to use PnP, even though it wont do what I need done by default (editing the "required" value of a content type column). However, when I try to use Connect-SPOnline, I get the below error:

Connect-SPOnline : Cannot contact web site 'https://harmelinmedia.sharepoint.com/' or the web site does not support
SharePoint Online credentials. The response status code is 'Unauthorized'. The response headers are
'X-SharePointHealthScore=0, SPRequestGuid=589ea69d-30b4-2000-15bb-d994b5063a31,
request-id=589ea69d-30b4-2000-15bb-d994b5063a31, X-MSDAVEXT_Error=917656; Access+denied.+Before+opening+files+in+this+l
ocation%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically.,
MicrosoftSharePointTeamServices=16.0.0.5715, X-Content-Type-Options=nosniff, X-MS-InvokeApp=1; RequireReadOnly,
Content-Length=0, Content-Type=text/plain; charset=utf-8, Date=Fri, 23 Sep 2016 15:45:04 GMT, P3P=CP="ALL IND DSP COR
ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI", Server=Microsoft-IIS/8.5,
X-Powered-By=ASP.NET'.
At line:1 char:1
+ Connect-SPOnline -Url https://harmelinmedia.sharepoint.com/ -Credenti ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Connect-SPOnline], NotSupportedException
    + FullyQualifiedErrorId : System.NotSupportedException,SharePointPnP.PowerShell.Commands.Base.ConnectSPOnline

Dean_Gross
Silver Contributor
Sep 23, 2016
That looks like a problem with your credentials, double check your values against the instructions in the Getting Started section of https://github.com/OfficeDev/PnP-PowerShell.
If you have MFA, you need to use the UseWebLogin parameter in the connect-sponline statement

Forum Discussion

Trying to use PowerShell for SharePoint Online, failing miserably

18 Replies

Resources