Skip Ribbon Commands
Skip to main content
 

 Follow Me

 
 
 
 
 

 SharePoint Blog List

 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
Todd Klindt's home page > Todd Klindt's SharePoint Admin Blog
What's going on with TK.
November 13
Getting a “Method not found” Error when using PnP PowerShell

This question has come up a few times so I thought I’d blog it so I had an easy place to point people. You can also go to the PnP PowerShell GitHub Comments for the same information.

If you’ve watched any of my podcasts, or seen me speak at any technical events you know I’m a big fan of the Patterns and Practices (PnP) PowerShell cmdlets. They make working with Office 365 tolerable, even enjoyable. The PnP PowerShell is a community led, Microsoft supervised, project on GitHub. If you’re not already using it, you should check it out.

Along with scads of other software running on our machines, it gets updated once a month or so. In the last couple of months a couple of clashing updates have caused PnP users some stress. Specifically when they use the Connect-PnPOnline cmdlet to connect to SharePoint Online they get a “Method not found” error message. The PnP team was on it. They published this fix:

  1. Delete all the SharePoint Components from the Control Panel (Add/Remove)
  2. Open the GAC location (C:\windows\Microsoft.NET\assembly\GAC_MSIL), search for the term SharePoint and delete all the folders. (This is required since the reference is still old which is used by the PnP commands)
  3. Re-Start the machine
  4. Install the latest version of the SharePoint PnP

That should do it. From the comments I’ve seen, and my own experience, this has a 100% success rate. Again, you can read all about it on GitHub.

Thanks to the PnP Team for all you do, and for getting this fix out so quickly.

tk

ShortURL: https://www.toddklindt.com/PoshPnPMethodNotFound

November 13
Podcast 409 - Hold Your Tongue Sideways
November 06
Connecting to Office 365 with Multiple Accounts in PowerShell without Losing Your Damned Mind

The last (and first) installment in my ever popular “Without Losing Your Damned Mind” blog series, How to Connect to with Multiple Office 365 Accounts in your Browser without Losing Your Damned Mind, was a mild success, and the series was picked up. We decided it was time for a sequel, and here it is.

As an IT Pro/Administrator in the Microsoft space you have to love PowerShell. You don’t have to be an expert in it (though that really helps, I envy those guys) but you have to be confident enough with PowerShell that you can see some PowerShell on the web and be able to understand what it’s doing before you run it yourself. The way you do that is slowly, after months and years, forcing yourself to do tasks in PowerShell no matter how much it sucks. In the context of Office 365 that can get cumbersome because you have to authenticate against cloud services all the time, with many different accounts, and that requires that cursed act of typing your password. Over and over and over again. I hate typing passwords so very much. It gets worse when sometimes I’m connecting as me, sometimes as my own tenant global admin, sometimes as a customer’s tenant admin, sometimes as a different customer’s admin, it never ends.

A while back I started using Windows’ Credential Manager to manage my PowerShell logins, and that’s what this blog post is going to be about. I will assume you already know how to connect to Office 365 and Azure with PowerShell and that you have all of the necessary modules, executables, and the like installed.

The secret sauce that makes this all bearable is a PowerShell module called PowerShell Credential Manager. This little beauty uses native PowerShell to access the Credential Manager in Windows. There are other modules that do similar things, and you can actually do all of this yourself in PowerShell without a module. I’ve found this module to be the best that works for me, but this process is the same regardless of what you use.

You can install it with this line:

Install-Module -Name CredentialManager

It installs the following cmdlets:

Get-StoredCredential
Get-StrongPassword
New-StoredCredential
Remove-StoredCredential

You can use New-StoredCredential to put a new entry in the Windows Credential Manager. You can also use the Credential Manager UI to do it. It’s all the same. To create a credential with New-StoredCredential use something like this:

New-StoredCredential –Target O365Admin –username admin@tenant1.onmicrosoft.com -password pass@word1 –Persist LocalMachine

New-StoredCredential –Target Jimmy –username Jimmy@tenant1.onmicrosoft.com -password pass@word1 –Persist LocalMachine

New-StoredCredential –Target OtherAdmin –username admin@tenant2.onmicrosoft.com -password pass@word1 –Persist LocalMachine

And so on. A couple of things of note. First, all of the passwords are in plain text. If you’re running a transcript make sure you clear those out. Also, the –Persist switch is important. If you don’t add that, the Stored Credential will vanish into the ether when you close this PowerShell window. You won’t know why it doesn’t work the next and you’ll be very confused. Maybe that’s just me. You can also add a comment for the credential with the –Comment parameter.

Running the command looks like this:

image

The entries look like this in Windows:

SNAGHTML67af9a89

You can get to this screen in Control Panel, or by typing “cred” in the Start Menu. The credentials you create in PowerShell will show up under “Generic Credentials” and you can use anything that’s already there. You can also create credentials with the cleverly named, “Add a generic credential” link at the top. It doesn’t matter how they get there, it just matters that they’re there. You can create as many credentials as you want. There’s no charge. Smile

Now that we’ve loaded the Credential Store up with some yummy Office 365 Credentials, how do we use? The magic word is Get-StoredCredential.

We can use Get-StoredCredential to securely pull credentials from the Credential Manager and pass them to a PowerShell cmdlet. You can save them in a variable, or just call it directly when you connect. Here is how you connect to Azure AD:

Connect-MsolService -Credential (Get-StoredCredential -Target O365Admin)

It looks like this:

image

No passwords were typed (Hooray!) and that means you can securely automate it. The process is the same for other Connect style cmdlets. Here are a couple of examples:

Connect-AzureAD -Credential (Get-StoredCredential -Target O365Admin)

Connect-SPOService -Url https://blogpost-admin.sharepoint.com -Credential (Get-StoredCredential -Target O365Admin)

If I wanted to sign in as the Jimmy account, I would pass that to the –Target parameter:

Connect-SPOService -Url https://blogpost-admin.sharepoint.com -Credential (Get-StoredCredential -Target Jimmy )

I’m a frequent user of the PnP PowerShell. I’d give up sliced bread before I gave them up. While you can use this same approach with them, you have another option that’s even less typing:

Connect-PnPOnline -Url https://blogpost-admin.sharepoint.com -Credential O365Admin

The Connect-PnPOnline cmdlet (and maybe others) natively know to check the Credential Manager if it’s passed a string.

That’s all there is to it. Once you create a credential it’s yours to use however you’d like, as often as you’d like. This isn’t restricted to Office 365, either. Any PowerShell cmdlets that take credentials can take advantage of this.

Enjoy.

tk

ShortURL: https://www.toddklindt.com/PoshMultipleAccounts

November 05
Podcast 408 - Never Free the Trolls (Just Be Nice)

Todd got a new job and they kick the podcast off talking about that. After they're finished gushing about that they talk about some topics Todd recently covered in classes. They also give their talk in the recent IBM purchase of Red Hat and someone that made Shane and Todd's day.

Thanks to our sponsor and the inventors of bear hugs, AppRiver.

Audio File

Video File

Podcast 408 - Never Free the Trolls (Just Be Nice) (Time 0_02_08;08)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 47:26

Links:

SysKit Insights 2.0
AppRiver
SharePoint Calculated Columns and Validation Formulas
PowerApps Save Data
North American Collab Summit

ShortURL: https://www.toddklindt.com/Podcast408

November 02
Behold! I Joined Sympraxis Consulting!

Over the few months I’ve been doing a lot of consulting projects, and some of my favorites have been with my long time friends Marc Anderson (blog|twitter) and Julie Turner (blog|twitter). I’ve known Marc since roughly the beginning of time, and met Julie a few years ago when she joined him at Sympraxis. We’ve all been old friends ever since. They’re both developery types and over the last few months they’ve brought me in to help with some projects that needed an admin’s touch. At SPTechCon a couple of months ago we were sitting around catching up and Marc suggested that we put a ring on it and make it official.

What a magnificent idea!

Yesterday I officially started at Sympraxis. I’ll be doing all the same things I’ve been doing. Blogging, podcasting, teaching, and loving on SharePoint and Office 365 every day. Now though, Julie and Marc are legally required to chat with me on Teams during the day when I’m bored. Smile 

I will also continue to be the chief Evangelist for Syskit. I’m going to be staying very busy.

If you’d like to bring Sympraxis into a project, drop us a note on our Contact Page and we’ll get a hold of you.

Thanks to Marc and Julie for bringing me onboard.

tk

ShortURL: https://www.toddklindt.com/JoinSympraxis

October 31
Podcast 407 - You Can Only Laugh

Todd kicks off the show by telling Shane the drama of his weekend. After he's done whining they get down to business and talk about fun tech stuff like SharePoint 2019, a new version of SPDocKit, improvements to the OneDrive Sync Client, and how Shane triumphed over Sling.

Thanks to our sponsor and the inventors of bear hugs, AppRiver.

Audio File

Video File

Podcast 407 - You Can Only Laugh (Time 0_17_21;11)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 55:37

Links:

SharePoint Server 2019 is RTM
SPDocKit 8.0 is also out
OneDrive will now remove offline files if they aren’t accessed for a certain period
AppRiver
Apple’s TV subscription service starts in 2019 to compete with Netflix, Amazon
PowerApps and Flow Training
Thrive Conference 2018
North American Collab Summit

ShortURL: https://www.toddklindt.com/Podcast407

October 23
SPDocKit 8.0 is Out!

I’m not sure my heart can take much more of this. First SharePoint Server 2019 RTMs and the folks at SysKit put out another amazing version of SPDocKit, 8.0! Is today my birthday or something?!

If you haven’t used SPDocKit before, you’re missing out. Luckily the folks at SysKit have you covered, before you do anything, including finishing this blog post, go out and download their free 30 day trial.

Okay, now that we’ve got that out of the way, what is SPDocKit and what’s in it for you?

I am so glad you asked!

SPDocKit is a SharePoint Documentation tool. Quite possibly the best SharePoint Documentation tool to grace the earth with its footfall. Over the years I’ve watched the product evolve into nearly a work of art. The folks at SysKit love SharePoint, almost as much as I do, and they have their finger on the pulse of what SharePoint admins want. With each successive version of SPDocKit they add new reports and functionality that scratch the collective itches we SharePoint admins have. As a SharePoint Consultant I help all kinds of organizations implement and manage SharePoint servers. In the last year or two I’ve noticed a very pronounced shift towards wanting more reporting. Companies want a better idea of how their users are using SharePoint. SPDocKit gives that to them in spades, all in an easy to use interface.

What kind of reports does it give you? There’s almost too many to name. I’ll rattle off some of my favorites though to get you started:

  • Full Farm Documentation – Servers, services, databases, sites, everything you can think of. Best of all it keeps a copy of every report you run, so you can compare them over time and see how your environment grows.
  • Best Practices – SPDocKit looks into every crack and crevice of your SharePoint farm and let you know, nicely, what things you could be doing better. This could be SharePoint Configuration, SQL Server settings, anything. SPDocKit has your back.
  • Security – Great reports on what has been changed, who has changed what. Security is a hot topic these days and SPDocKit has you covered.
  • User Permissions – You can get Permissions reports, compare users’ permissions, copy user permissions, everything you can think of.

That’s just off the top of my head. There’s so much more. Here’s a list of just what they’ve added to version 8.0.

Go out and take SPDocKit for a spin. You won’t regret it. While you’re out there check out SysKit’s other great tools like SysKit Insights, Security Manager, the free SysKit Point.

tk

ShortURL: https://www.toddklindt.com/SPDocKit8

October 22
SharePoint Server 2019 is RTM!

What a day, what a day. SharePoint Server 2019 is ready for us to download and deploy into our production farms. What’s new in SharePoint 2019 you ask? A bunch. Here’s a short list:

  • Modern Sites
  • Modern Lists and Libraries
  • Modern Pages
  • Communication Sites
  • OneDrive for Business sync client support
  • Large file, large filename, fewer character restrictions

The list goes on and on.

Here are a bunch of links to get you started:

SharePoint Team Blog Post

Download SharePoint Server 2019

Quick Start Guide

Here at the Klindt Labs we’ll be installing SharePoint Server 2019 as quickly as we can and letting you know what our experience is.

tk

ShortURL: https://www.toddklindt.com/SP2019ishere

October 18
Podcast 406 - What Time is it on Earth?

Shane is on the road, but that doesn't stop them from putting out another quality podcast. Shane starts off the podcast by telling us what's grinding his gears today. Todd then talks about a recent SharePoint event he crashed and the fun he had there. They do talk some tech, including the new SharePoint Admin Center, and a few things Todd has learned in the field in the last week. We wrap things up by mentioning some of our favorite user groups and upcoming conferences.

Thanks to our sponsor and purveyor of fine software, AppRiver.

Audio File

Video File

Podcast 406 - What Time is it on Earth (Time 0_00_16;19)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 58:18

Links:

29:06 Unleash your SharePoint admin superpowers with new admin center capabilities
46:47 PowerApps String Functions
48:41 Tampa Bay SharePoint User Group
51:00 Launch of PowerApps and Flow Cincinnati User Group
51:20 SharePoint/O365 Administration Workshop with Todd Klindt
52:38 SharePoint Saturday Cincinnati
52:50 PowerApps and Flow Training
53:40 Thrive Conference 2018
55:54 North American Collab Summit

ShortURL: https://www.toddklindt.com/Podcast406

October 17
Podcast 405 - Set Your Clocks to 10:10
1 - 10Next
 

 Subscribe to my Netcast

 

You can watch Shane and I's Cloudy Podcast live every Wednesday Morning at 10:00 am Central US time at http://www.toddklindt.com/Netcast

You can subscribe to the Podcast in the following ways:

MP3 Audio

Windows WMV video

YouTube Channel

 

 SPDocKit

 
June 2018
 

 Todd's Upcoming Events

 
  
  
There are no items to show in this view of the "Events" list.