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.
February 12
Podcast 375 - Help Future You Out

Want to upload pictures of your employees to SharePoint 2016 but not do battle with MIM? Then you're in luck! Todd and Shane discuss that and a whole lot more this week. They discuss how to trick SharePoint into being an employee directory, how to get OneDrive for Business for free, how to HTTPS-ify your SharePoint servers, how to install Office Online Server, and why Shane's kid is good at soccer.

Audio File

Video File

Podcast 375 - Help Future You Out (Time 0_01_00;00)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 54:25

Links:

08:55 User Profile Picture Import with Active Directory Import(Dirsync)
09:00 Using PowerShell to import Profile Photos when using Active Directory Import and SharePoint Server 2013/2016/2019
12:10 How to build a great Employee Directory in Office 365 & SharePoint
13:50 Free OneDrive until your existing contract runs out
17:40 Automatically Redirect HTTP requests to HTTPS on IIS 7 using URL Rewrite 2.0
23:16 How to install Office Online Server for SharePoint 2016 (OOS)
24:20 How to Create a Windows PowerShell Profile
26:00 Video of PowerShell Profiles
53:22 Shane on another Podcast
51:10 SharePoint North America Conference
52:00 SharePoint Administration Day Camp
52:18 SPTechCon Boston
52:30 Call for speakers
52:48 PowerApps Webinar

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

February 05
Podcast 374 - Manchurian Candidate
February 02
SharePoint Conference 2018, Will you Be There? I Will!

The new year is upon us. This means the conference season is in full swing. There are a ton of great SharePoint and Office 365 conferences this year, and some of them are even letting me participate, restraining orders be damned! The first one, and maybe the biggest one, is the SharePoint Conference North America. It has been four, very long, years since the SharePoint Community has descended on Las Vegas and showed it what a tech community is really like.

If you haven’t already seen all the gooey details about the 2018 SPC, let me explain. There’s too much, let me sum up. The festivities are taking place May 21 – 23, 2018 at the MGM Grand in Las Vegas. There are also optional workshops the weekend before and a couple of days after.

SPCNA_BeThere_1012x506_KLINDT

And speaking of workshops, my sidekick and I, Shane Young, will be doing an all day workshop on Thursday May 24th. It will cover SharePoint Administration in the year 2018. We’ll cover SharePoint Server, Hybrid Scenarios, Office 365, the works. We’ve even written a few new jokes, so you know we’re serious about this thing.

We’ll also be doing a couple of sessions, so once you get registered, make sure to add them to your schedule.

We haven’t finalized it yet, but we’ll also be having some sort of a get together. Probably one of the mornings. The idea is that if you’ve seen us on YouTube, or read our blogs this is your chance to come up and say Hi and see if Shane really is as annoying in person as he appears on the Internet. (He is)

While SPC will be great, it won’t be the same without YOU there. If you haven’t already, go to https://www.sharepointna.com and get yourself registered. If you use the Promo code KLINDT, then I get $50, you get $50, and you also get a big bear hug, or a firm handshake from me. Your choice.

Join me at SPC. I’ll be there. Will you?

tk

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

January 29
Podcast 373 - Jiggled Some Wires

Pulled patches and file restores in OneDrive start out this week's podcast. Shane updates us on the latest development in the YouTube advertising wars, and Todd shows you a way to have kittens brighten your day. They end the podcast by talking about Amazon's new store, and how funny it is.

Audio File

Video File

Podcast 373 - Jiggled Some Wires (Time 0_00_36;17)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 44:57

Links:

3:00 Web site test
07:09 January 2018 Patch for Office Online Server pulled
11:30 Announcing New OneDrive for Business feature: Files Restore
16:18 YouTube going through a change
21:33 Amazon opens the supermarket with no lines
31:10 Emergency Kitten
33:45 Mine ETH
39:59 Todd's Charity drive.
41:56 SharePoint North America Conference – Promo code KLINDT
43:22 SPTechCon Boston

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

January 22
Podcast 372 - Old Bras

This week's podcast covers a lot. Todd starts things off by talking about a change he's making to his blog, and one of his favorite topics, SharePoint patches. Shane follows up with some trouble he's had with Hyper-V and the Cisco VPN client. After that they discuss the release of PowerShell Core, Microsoft's SharePoint Migration Tool, OneDrive, SnagIt, and how you can win a pass to the SharePoint Conference in May.

Audio File

Video File

Podcast 372 - Old Bras (Time 0_02_59;18)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 44:20

Links:

09:15 Introduction to PowerApps Variables
11:53 Hardware Manufacturer Statements and Guidance for Meltdown/Spectre
17:12 PowerShell Core 6.0: Generally Available (GA) and Supported!
25:09 General Availability of the SharePoint Migration Tool
26:51 Tweet Bill Baer to win a bag
29:49 SnagIt from TechSmith
35:40 Microsoft to add file restore to OneDrive for Business starting in late January
37:50 Microsoft took more cloud share from AWS
39:53 Todd's Charity drive.
41:36 SharePoint North America Conference
42:00 SharePoint Administration Day Camp

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

January 12
Podcast 371 - Nothing to See Here
January 02
Podcast 370 - Cord Cutting Special

In this special episode of the podcast, Todd and Shane talk about something that they've both started doing in 2017, cutting the cord. This episode is longer, at 1:12 because they talk about cord cutting from start to finish. They talk about why you should do it, how you should design it, and which services and hardware you should use.

If this is a topic you'd like to hear more about, let them know. You can find them at @toddklindt and @shanescows on Twitter.

Audio File

Video File

Podcast 370 - Cord Cutting Special (Time 0_00_17;09)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 1:12:16

Links:

Hardware Set Top Boxes

20:38 Roku Ultra $99 (now $89)
26:00 Roku 3600R $36.99 refurb
27:19 Fire TV Stick - $35
27:20 Fire TV with 4K - $55
19:00 Chromecast
38:40 Tablo Dual OTA DVR $195

Other hardware
31:02 Crappy antenna $25
32:00 Alarm clock - $16
34:56 Antenna I will probably buy - $35
35:00 Pole - $16
40:00 SiliconDust HDHomeRun CONNECT - $80

Services
51:09 List of channels and Services
53:00 List of STB and Services
54:46 Vue
54:30 Sling
54:34 Direct TV Now
54:40 Hulu
1:06:10 YouTube TV

Other Helpers
1:00:52 Plex
1:01:00 Tv Fool Signal locator
1:02:00 Antennaweb.org

Promotion
1:08:50 Todd's Charity drive.
1:10:18 SharePoint North America Conference
1:11:00 SharePoint Administration Day Camp

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

December 19
Podcast 369 - Festive Fedora

Shane and Todd put on their festival Christmas hats for this episode of the podcast. They talk about some changes to SharePoint 2013's TimerJobHistory table and a good document on how to enable hybrid scenarios in SharePoint. Todd talks about a couple of cheap ways to get scads of OneDrive space, and Shane talks about .kill(), and other reasons to use lots of parentheses. They also do NOT talk about Star Wars, even though they really wanted to.

Audio File

Video File

Podcast 369 - Festive Fedora (Time 0_00_20;05)

YouTube (Subscribe)

Subscribe in iTunes

Running Time: 28:47

Links:

06:28 Changes in the TimerJobHistory table maintenance introduced in November 2017 CU for SharePoint 2013
11:07 Cloud hybrid search service (CSSA)-FAQ
25:49 Todd's Charity drive.
26:49 SharePoint North America Conference Referral code KLINDT

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

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

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

 
  
  
SharePoint Conference North AmericaMay 21-25