Tuesday, February 19, 2019

PowerShell Toolbox for SharePoint

Most Commonly Requested PowerShell Commands

Many SharePoint Admins ask for a list of most commonly used PowerShell commands so you ask and you receive.

More from PowerShell 101

SharePoint PowerShell
http://powershell101.blogspot.com/2012/09/sharepoint-powershell.html

More from The Cloud Engineer

Cool PowerShell for SharePoint – Start Here
https://thecloudengineer.blogspot.com/2016/10/cool-powershell-for-sharepoint-start.html

Cool PowerShell for SharePoint Online – Start Here
https://thecloudengineer.blogspot.com/2019/04/cool-powershell-for-sharepoint-online.html

General SharePoint PowerShell Page – OLD
http://thecloudengineer.blogspot.com/2011/11/sharepoint-powershell.html

Farm Commands

Reset Farm PassPhrase
Set-SPPassPhrase

ISE

Create PowerShell ISE Enabled for SharePoint
http://thecloudengineer.blogspot.com/2011/10/create-ise-enabled-for-sharepoint.html

Cool PowerShell for SharePoint – Start Here

Central point for PowerShell and SharePoint
R
eference guide of PowerShell on the web

PowerShell 101

Basic
http://powershell101.blogspot.com/2012/09/sharepoint-powershell.html

Add Online Modules
http://sharepoint-tricks.com/install-update-uninstall-cmdlets-for-sharepoint-online

LinkedIn Articles

General Scripts: (Retrieve List and Email) untested
https://www.linkedin.com/in/sachchin-annam-21517031/detail/recent-activity/posts/

Office 365

Exchange PS1
https://blogs.technet.microsoft.com/exchange/2016/10/06/tip-a-few-useful-powershell-scripts-for-exchange-and-office-365-admins/
Using PowerShell to Specify License Plans in Office 365
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=664
Multi Tenant
http://www.luisevalencia.com/2019/02/28/leveraging-office-pnp-core-to-run-multi-tenant-specific-operations

2016

Index of Windows PowerShell cmdlets for SharePoint Server 2016
https://technet.microsoft.com/en-us/library/ff678226(v=office.16).aspx
Download Index of Windows PowerShell cmdlets for SharePoint 2016
https://gallery.technet.microsoft.com/office/SharePoint-2016-Powershell-c7f8814f

DisableLoopBackCheck when routing through a Load Balancer

(PowerShell sample included) NOTE the tick is in the upper left corner of the keyboard, note the single quote used in `r`n for carriage return line feed and use iisreset to complete.

https://blogs.technet.microsoft.com/scottstewart/2014/09/15/disableloopbackcheck-when-routing-through-a-load-balancer-powershell-sample-included/

2013

How-to Enable Protocols on SQL Server with PowerShell https://technet.microsoft.com/en-us/library/dd206997(v=sql.105).aspx

SQL Alias PowerShell script https://blogs.technet.microsoft.com/sqlpfeil/2014/03/31/sql-alias-powershell-script/

Limit SharePoint Site Templates
http://briantjackett.com/2014/03/04/powershell-script-to-limit-sharepoint-site-templates-available/

SharePoint PowerShell Script Series Part 4–Gathering item count for all document libraries in a Site Collection
https://blogs.msdn.microsoft.com/russmax/2012/01/20/sharepoint-powershell-script-series-part-4gathering-item-count-for-all-document-libraries-in-a-site-collection/

Cool site with a ton of scripts
https://github.com/sharepoint

Alternate to Warm Up Scripts

http://thesharepointfarm.com/2012/06/sharepoint-warm-up-scripts-a-thing-of-the-past/

PowerShell Tips
http://secretsofsharepoint.com/cs/
http://powershell101.blogspot.com/search/label/tips

Service Application PowerShell
Search

http://blogs.technet.com/b/praveenh/archive/2013/02/07/create-a-new-search-service-application-in-sharepoint-2013-using-powershell.aspx

Copy lists in PowerShell (thx Todd)
http://www.sharepointdiary.com/2012/12/copy-list-between-sites-powershell.html
http://sharepointpsscripts.codeplex.com/releases/view/21696 Bulk Import

Tools

https://spuploader.codeplex.com/
http://spbulkdocumentimport.codeplex.com/
https://difs.codeplex.com/
http://docuploadmetadata.codeplex.com/
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html

2010

Configure a service application by using a Windows PowerShell script (SharePoint Server 2010)
https://technet.microsoft.com/en-us/library/gg983005(v=office.14).aspx

Change Page Layout On Publishing Sites.
https://myspworld.wordpress.com/2012/08/16/powershell-script-to-change-the-page-layout/
Issues
PowerShell 3.0 Issues http://support.microsoft.com/kb/2796733
PowerShell Builder - SharePoint
http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html


Untested but look good
Warm-up Scripts
http://gallery.technet.microsoft.com/office/SharePoint-2007-2010-or-d1884b4b
Copy an entire document library from SharePoint to Disk
http://sharepointkunskap.wordpress.com/2012/12/11/powershell-copy-an-entire-document-library-from-sharepoint-2007-to-disk/
Upload File to SharePoint Library using PowerShell
http://www.sharepointdiary.com/2012/07/upload-file-to-sharepoint-library-using.html
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html
Move Content Types
http://get-spscripts.com/2011/02/export-and-importcreate-site-content.html
Duplicate Documents
http://blog.pointbeyond.com/2011/08/24/finding-duplicate-documents-in-sharepoint-using-powershell/
https://www.nothingbutsharepoint.com/sites/devwiki/articles/pages/finding-duplicate-documents-in-sharepoint-2010.aspx
Export Reports from SharePoint Reports
http://social.technet.microsoft.com/Forums/sharepoint/en-US/dc719361-50bc-40ba-bd6b-5035c5a876ca/export-report-from-sharepoint-over-powershell

Tuesday, January 15, 2019

Power BI

Download Power BI Desktop

https://www.microsoft.com/en-us/download/details.aspx?id=45331

Free Example Files

http://eforexcel.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/

User Power BI to track Flow
https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Track-Flows-using-Power-BI/ba-p/202673

Slide Library

Slide Library was removed in SharePoint 2013 however this was not a popular decision.

User Voice
https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/7081860-bring-back-or-replace-the-slide-library

Check out this support article for more details: https://support.office.com/en-us/article/Reuse-import-slides-from-another-presentation-c67671cd-386b-45dd-a1b4-1e656458bb86

Slide Library (Manual link required)
Use this link http://yourserver/sites/yoursite/_layouts/15/slnew.aspx?FeatureId={0be49fe9-9bc9-409d-abf9-702753bd878d}&ListTemplate=2100

Reference
http://techtrainingnotes.blogspot.com/2012/11/finding-missing-sharepoint-2013-slide.html

Third Party Solutions

http://www.teamsli.de/

https://www.iclickpoint.com/

https://accent-technologies.com/blog/2017/10/18/trying-find-replacement-sharepoint-slide-library/

Thursday, January 10, 2019

Search Engines Tools and Browsers

Search Engines

Archive

https://web.archive.org/ – Wayback helps find old websites!

The Rest

https://archive.org/

http://www.ask.com/

https://www.baidu.com/

https://www.bing.com/

http://www.chacha.com/

https://www.dogpile.com/

https://duckduckgo.com/

https://www.metacrawler.com/

https://www.yahoo.com/

https://www.wolframalpha.com/

The Giant

Google

https://www.google.com/

https://scholar.google.com/

Browsers

Brave

https://brave.com/

Dragon

Comodo Dragon
https://www.comodo.com/home/browsers-toolbars/internet-products.php

Ice Dragon
https://www.comodo.com/home/browsers-toolbars/icedragon-browser.php

Edge Dev

Windows 10 Insider Channel
https://www.microsoftedgeinsider.com/en-us/download
Mac Insider Channel
https://www.microsoftedgeinsider.com/en-us/download?platform=macos

Experiments
edge://flags

Sync
https://techcommunity.microsoft.com/t5/Articles/Syncing-in-Microsoft-Edge-Preview-Channels/m-p/510159/thread-id/678

Epic Privacy Browser

https://www.epicbrowser.com/

Firefox

https://www.mozilla.org/en-US/firefox/new/

Favorite Firefox Add-ons

Firefox Multi-Account Containers (Favorite *** Office 365)
https://addons.mozilla.org/en-US/firefox/addon/multi-account-containers/

Firefox Multi-Account Containers was first introduced as "Containers" available only in Firefox Nightly. It went on to be a Test Pilot Experiment, where we improved the user experience and added new features. Now it exists here as an extension that can be installed by all Firefox users.

Show your windows and tabs from last time Options > General

Opera

https://www.opera.com/

Tor

https://www.torproject.org/index.html.en

Vivaldi

Vivaldi - A Browser for Our Friends
https://vivaldi.com/

Tools

2017

DNS

Simple DNSCrypt

DNS Proxy

https://simplednscrypt.org/

https://github.com/bitbeans/SimpleDnsCrypt

IPLookup

https://community.spiceworks.com/tools/ip-lookup/results