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.
December 15
Podcast 368 - We are Horrible Users

Todd and Shane have a lot of information to share this week. They start out by going over Todd's most recent blog post on how to download SharePoint patches without needing to use your browser. Great for those highly secure server environments. Next they cover a new web page whose sole purpose in life it so be your homepage for all things PowerShell and SharePoint related. Microsoft has renamed First Release tenants, they tell you about that next. They finish up by telling about another way to fill up your server's hard drive with log files, and how your HP laptop might be spying on you.

Audio File

Video File

Podcast 368 - We are Horrible Users (Time 0_21_00;21)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 31:42

Links:

04:55 Downloading SharePoint Patches with PowerShell
07:11 Downloading patches video on YouTube
10:11 SharePoint Server & SharePoint Online PowerShell cmdlets have a new home
13:42 Microsoft has renamed “First Release” to “Targeted Release.”
17:23 IIS Logs to SQL Database using Powershell and Log Parser
23:39 460 HP Laptops have a keylogger built in
27:10 Todd's Charity drive.
28:30 SharePoint North America Conference
29:00 SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast368

December 08
Downloading SharePoint Patches with PowerShell

I’ve been known to patch a SharePoint server here and there. Once in a while, when I’m on a customer server its Internet Explorer security settings will prevent me from being able to download a patch. I’ll go to my favorite patch list, toddklindt.com/sp2016builds or toddklindt.com/sp2013builds, and pick the patch I want. But when it comes down to getting the patch the IE security settings will prevent me from actually downloading said patch. Sadness ensues. I’ve had to do various dances to get the patches and recently I’ve started leveraging PowerShell more and more to do so. After a conversation with Jason Himmelstein I agreed to publish the PowerShell I use. Jason promised me you wouldn’t laugh. So you can’t laugh.

I also made a video of how to use it.

clip_image002

The Usage

I packaged this as a function, Get-TKMSKBDownload, and while it’s in a module, you can easily paste it into any existing module file you might already be using.

To use this function download TKDownloadFile.psm1.txt. Remove the “.txt” at the end to rename it to TKDownloadFile.psm1, Rename-Item .\TKDownloadfile.psm1.txt .\TKDownloadFile.psm1. Then Import it into your PowerShell session with Import-Module TKDownloadFile to let it know it’s there.

clip_image004

I have lovingly provided some Help and Examples to help you use it. In trying to address all of the situations where I’ve done this, I made sure the function worked with either details.aspx and confirmation.aspx URLs for the download link.

clip_image006

To use it, go to my patches page and click the Download link for the patch you want. Then copy that URL out of your browser and paste it after the function, like in the example:

Get-TKMSKBDownload -url https://www.microsoft.com/en-us/download/confirmation.aspx?id=56230

It will download the patch into your current directory. It should look like this when it runs:

clip_image008

After the file is downloaded you can run it and patch your SharePoint server.

I won’t paste all the code in this blog post, (download it here) but I do want to highlight a couple of pieces of it. First, this is the line I use to get the direct link to the patch download, where $url is the link from the patches page:

$downloadurl = ((Invoke-WebRequest -UseBasicParsing -Uri $url).links | Where-Object -Property data-bi-cN -Like -Value "click here to download manually" | select -First 1).href

Before I wrote this PowerShell I had a couple of instances where I needed the direct link to the patch. I had had to use the Developer Tools in Chrome to find the URL in the Microsoft Download web page. I was able to use that information to craft the line above. If you’re curious, you can start with the part inside of the parenthesis (Invoke-WebRequest -UseBasicParsing -Uri $url) and see how the page is loaded as an object by PowerShell. There is some interesting stuff in there.

The other part I needed was the name of the file to save. That’s part of the $downloadurl object, so I used this PowerShell to put off the file name, which is everything after the final / character, plus 1 so we don’t get the / itself:

$file = $downloadurl.Substring($downloadurl.LastIndexOf("/") + 1)

With those two pieces of information I’m able to pull the patch down and save it.

Invoke-WebRequest -UseBasicParsing -Uri $downloadurl -OutFile $file

As always, I had a couple of people look this code. Thanks to Shane Young and Jeff Hicks for all of that. Jeff had some great ideas for a v2 of this, like being able to specify a download directory, or backgrounding the download job. All good ideas, but I didn’t want to delay the publication of this blog post to implement them. If I keep using this module I may add them later. If I do, I’ll update this blog post.

Once again, if you’d like to see all of this magic in action, you can watch my HowTo video on YouTube.

tk

ShortURL: http://toddklindt.com/PSDownloadMSPatch

December 07
Podcast 367 - Elfin Sidekick

As we near Christmas, Todd and Shane show their holiday cheer. Shane has his office decorated, and Todd has his head decorated. They do find the time to talk some tech. Shane talks about the PowerApps videos he has released recently. Todd talks about SSH tunneling and how to do it with native Windows tools in Windows 10. They finish up by talking about some baby steps you can take with home automation, and how Christmas time is the perfect time to do it.

Audio File

Video File

Podcast 367 - Elfin Sidekick (Time 0_01_34;12)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 32:21

Links:

02:33 Learn about PowerApps and SharePoint Online
06:23 SSH Tunneling for Windows People: Protecting Remote Desktop
12:13 AmpliFi Teleport
16:00 Wemo Smart Plug - $45
16:00 TP-Link Smart Plug - $23
16:00 Amazon Echo Dot - $30
16:00 Etekcity Smart Plug 2 pack - $30
27:43 Todd's Charity drive.
29:15 Shane speaking at SoCal User Group
29:48 SharePoint North America Conference Registration Code KLINDT
30:00 SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast367

December 04
Podcast 366 - SharePoint 1994

Todd starts off this week's podcast with an update about his SharePoint 2016 page. During that conversation they talk about a new security precaution that is taken in recent SharePoint 2013 and SharePoint 2016 that may cause trouble for legitimate 3rd party SharePoint applications. Shane released a couple more videos on YouTube, so they talk a bit about those.

Audio File

Video File

Podcast 366 - SharePoint 1994 (Time 0_07_36;08)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 30:05

Links:

07:23 SharePoint 2013/SharePoint 2016 – Applying Cumulative Update removes all users with db_owner
14:30 Video: Export SharePoint List to Excel with PowerShell
18:08 YouTube facing more AD pressure
22:48 Microsoft Office appeared in the Google Play store
26:28 Shane speaking at SoCal User Group
27:53 SharePoint North America Conference
28:18 SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast366

November 28
Podcast 365 - Whole Bunch of Good Stuff in it

Lori's gone this week, but Shane and Todd muddle through. They cover some of the cool new features that show up in the November 2017 patches for SharePoint 2013 and 2016. They also talk about PowerApps and something new Shane built.

Audio File

Video File

Podcast 365 - Whole Bunch of Good Stuff in it (Time 0_11_57;24)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 31:11

Links:

November 2017 CU aka Feature Pack 2 is out

PowerApps Shopping Cart like functionality

The new Azure AD sign-in and “Keep me signed in” experiences rolling out now!

Shane speaking at SoCal User Group

SharePoint North America Conference

SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast365

November 20
Podcast 364 - Can't Say Enough Good Things

Todd is back from Slovenia and he's ready to go. He and Shane start off talking about Todd's love of blue shirts, as he shows off the speaker shirt from the Thrive Conference. Then they cover some good uses for the PowerShell cmdlet Test-NetConnection. In Slovenia Todd got to hang out with Erwin van Hunen, one of the big dogs behind the PnP PowerShell cmdlets that Todd and Shane love so much. Todd recalls some of the conversations he and Erwin had. They finish up by talking the new PowerShell cmdlets for Microsoft Teams, and how world changing they are.

Audio File

Video File

Podcast 364 - Can't Say Enough Good Things (Time 0_31_14;01)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 31:16

Links:

PowerShell for Teams

Pocket Casts

Bill Gates playing SimCity in Real Life

Shane speaking at SoCal User Group

SharePoint North America Conference

SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast364

November 20
Podcast 363 - It Makes No Sound

Podcast 362 - Went out with a Bang

Shane is on his own this week while Todd is enjoying Slovenia. He takes some time to talk about new things in the tech world like the iPhone X and the Xbox One X. He also tries to decode the mystery around PowerShell's foreach command. Is it an alias? Is it a separate command from ForEach-Object? Is it a furniture polish? Shane sorts it all out. Intel and AMD have formed an unholy alliance, and Shane gives you his take on that as well. It's a packed 23 minutes, so you won't want to listen to this one at 2x like you normally do.

Audio File

Video File

Podcast 363 - It Makes No Sound (Time 0_18_07;28)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 23:07

Links:

05:32 PowerShell Video: ForEach-Object
09:01 Intel and AMD team up
13:32 Azure Cloud Service map
15:21 Netflix phishing attack
20:52 Shane speaking at Cincinnati PowerShell group
33:58 SharePoint North America Conference

ShortURL: http://www.toddklindt.com/Podcast363

November 20
Podcast 362 - Went out with a Bang

Shane's cold feet make an appearance in this week's podcast. We also talk about a regression in the October 2017 SharePoint 2013 CU. Microsoft has blessed us with release notes for Azure AD, and we celebrate them. We wrap it up by talking about a couple of new product releases from Amazon.

Audio File

Video File

Podcast 362 - Went out with a Bang (Time 0_10_22;00)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 35:24

Links:

09:04 Shane's new foot warmer
13:05 SharePoint 2013 Patches
13:40 Microsoft Ends Production of Kinect
21:01 You asked, we’re delivering: Release notes for Azure Active Directory!
25:56 Roadmap for Skype for Business capabilities coming to Microsoft Teams now available
27:28 Amazon Cloud Cam
31:21 Popular New Amazon Service Just Comes To Your House And Kills You
32:42 New Kindle Oasis
3:25 Thrive Conference
33:42 Shane speaking at SoCal User Group
33:58 SharePoint North America Conference
34:00 SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast362

October 30
Podcast 361 - Nerd Colored Glasses

It's a busy week at Podcasting Central. Shane and Todd try to cover it all in 30 minutes or less, or your podcast is free. They cover some exciting changes to OneDrive, and what it means for Enterprise users and admins. They also cover the new iPhone, and Microsoft's answer to Alexa and Google Home, the Harmon Kardon Invoke.

Audio File

Video File

Podcast 361 - Nerd Colored Glasses (Time 0_01_09;28)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 30:28

Links:

03:43 OneDrive Files On-Demand For The Enterprise
5:00 Use Group Policy to control OneDrive sync client settings
14:23 Update to Sharing Emails
20:23 Hey Cortana, It’s My Harman Kardon Invoke First Impressions
25:52 Apple reduces base iPhone 8 to $399
28:28 Thrive Conference
29:00 Shane speaking at SoCal User Group
29:30 SharePoint North America Conference
29:30 SharePoint Administration Day Camp

ShortURL: http://www.toddklindt.com/Podcast361

October 23
Podcast 360 - The Deluded One

This is a big week in Microsoft technologies and Todd and Shane do their best to keep you abreast with all the excitement. The talk about using Guest Access with Teams, and a couple of tips that will help make your experience better. They also try to get you ready for the Windows 10 Fall Creators Update. They would be remiss, as tech podcasters, to not talk about the wireless KRACK exploit and what it means for you. They also talk about what a captive portal is and how you can make your interaction with them suck less.

Audio File

Video File

Podcast 360 - The Deluded One (Time 0_00_49;05)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 31:03

Links:

11:15 Portals Suck
13:24 Script to connect to Office 365/Exchange
24:32 WPA2: Broken with KRACK. What now?
26:00 What Wi-Fi Security Problem? Windows is Already Patched
29:43 Thrive Conference
30:01 Shane speaking at SoCal User Group
30:30 SharePoint North America Conference

ShortURL: http://www.toddklindt.com/Podcast360

1 - 10Next
 

 Subscribe to my Netcast

 

You can watch my SharePoint Netcast live every Monday afternoon at 4:00 Central US time at http://www.toddklindt.com/Netcast

You can subscribe to my SharePoint Netcast in the following four ways:

MP3 Audio

Windows WMV video

iOS M4V video

YouTube Channel

 

 SPDocKit

 
 

 Todd's Upcoming Events

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