Showing posts with label powershell. Show all posts
Showing posts with label powershell. Show all posts

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

Friday, August 24, 2018

User Profile Troubleshooting

Office 365

Info on UPSA in Office 365

https://support.microsoft.com/en-us/help/3168272/information-about-user-profile-synchronization-in-sharepoint-online

SharePoint 2010 2013 and 2016 UPSA Cleanup (Part 1 2 3 4)
https://blogs.technet.microsoft.com/spjr/2018/04/08/sharepoint-the-complete-guide-to-user-profile-cleanup-part1/
https://blogs.technet.microsoft.com/spjr/2018/04/08/sharepoint-the-complete-guide-to-user-profile-cleanup-part-2-2010/
https://blogs.technet.microsoft.com/spjr/2018/04/08/sharepoint-the-complete-guide-to-user-profile-cleanup-part-3-2013/
https://blogs.technet.microsoft.com/spjr/2018/04/08/sharepoint-the-complete-guide-to-user-profile-cleanup-part-4-2016/

2016

Update User Display Name Property – PowerShell

https://blogs.msdn.microsoft.com/rcormier/2012/09/08/how-to-update-inactive-user-profile-information-in-sharepoint/

Active Directory Photo Manager … Freeware
https://www.codetwo.com/freeware/active-directory-photos/

Show AD Photo – PowerShell - Show-ADPhoto
https://community.spiceworks.com/scripts/show/1499-powershell-function-show-adphoto

2013

User Info List

https://gallery.technet.microsoft.com/office/User-Information-List-in-8b420e8c

2010

Update User Info List

https://donalconlon.wordpress.com/2012/03/02/sharepoint-user-information-list-is-not-being-updated/

Sharepoint 2010: Double Results In People Search & Org Chart Info Is In-Complete

http://www.buchatech.com/2012/10/sharepoint-2010-double-results-in-people-search-org-chart-info-is-in-complete/

more on audiences

http://thecloudengineer.blogspot.com/2017/10/audiences.html

Monday, August 20, 2018

SharePoint Office 365 Books

Free Microsoft Tech Books

2018 Free Books

http://aka.ms/mspressfree

Free Books from MVA

https://mva.microsoft.com/ebooks

Free Books from TechNet

E-Book Gallery for Microsoft Technologies
Free books from Microsoft’s Senior Sales Excellence Manager in the past.
Over the years, Microsoft has given away millions of free Microsoft books to check out these lists on older titles!

2017 – Awesome List Once Again!

https://web.archive.org/web/20190209134103/https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/

2016 – Awesome List Once Again!
https://web.archive.org/web/20190209134056/https://blogs.msdn.microsoft.com/mssmallbiz/2016/07/10/free-thats-right-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepoint-2016-sha/

Free Books from Real Time Publishers (ads)

https://www.realtimepublishers.com/

Office 365 – Suggested

Check out SharePoint MVP Mike Smith’s latest book.  Mike Smith is a trusted SharePoint author with several great SharePoint reference books that fill the in blanks when SharePoint documentation is lacking.  Mike’s latest book is treasure trove of missing formulas that will help any SharePoint power user or administrator.  Everything from simple calculations to complex Calculated Columns and Validation formulas can be found in what will soon be considered a SharePoint must have guide.

https://www.amazon.com/dp/098289922X

SharePoint Calculated Columns and Validation Formulas: Everything you need to know about SharePoint formulas for SharePoint 2010 to 2019 and SharePoint Online / Office 365

InfoPath – Suggested

by S.Y.M. Wong-A-Ton
Product DetailsProduct Details

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
Info Path 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013


PowerShell

PowerShell.org’s Free eBooks

Suggested PowerShell Books
Best Books as Suggested by Students
http://powershell101.blogspot.com/2012/06/powershell-courses-books-and-training.html

PowerApps

Free ebook: Beginners Guide to PowerApps
http://c365.io/powerapps-ebook-v1 (2019.3)

SharePoint Hybrid

Free ebook: Configuring Microsoft SharePoint Hybrid Capabilities
https://blogs.msdn.microsoft.com/microsoft_press/2016/07/06/free-ebook-configuring-microsoft-sharepoint-hybrid-capabilities/

Free ebook: Planning and Preparing for Microsoft SharePoint Hybrid
https://blogs.msdn.microsoft.com/microsoft_press/2016/04/26/free-ebook-planning-and-preparing-for-microsoft-sharepoint-hybrid/

SharePoint 2016 – Suggested

Best Books as Suggested by Students

image

Vlad Catrinescu (Author), Trevor Seward (Author)

https://www.amazon.com/Deploying-SharePoint-2016-Configuring-Maintaining/dp/1484219988
Search


SharePoint 2016 Search Explained
https://www.amazon.com/SharePoint-2016-Search-Explained-Premises/dp/1533673624

SharePoint Lab – Suggested

Product Details
Building a SharePoint 2016 Home Lab: A How-To Reference on Simulating a Realistic SharePoint Testing Environment
https://www.amazon.com/gp/search?index=books&linkCode=qs&keywords=9781484221709

SharePoint 2013

Best Books as Suggested by Students

Admin / PowerShell


Microsoft SharePoint 2013 Pocket Guide (Other Sams)

Sep 20, 2013 – Ben Curry

PowerShell for SharePoint 2013 How-To

Feb 20, 2013 – Steven Mann
Product DetailsProduct Details
Professional SharePoint 2010 Administration and Professional SharePoint 2013 Administration by Shane Young Steve Caravajal and Todd Klindt
Note that I recommend both books since there is little overlap.
Product Details
Microsoft SharePoint 2013 Administration Inside Out by Randy Williams, CA Callahan, Chris Givens and John Milan Gross (Jan 25, 2014)

Workflow

Product Details
Beginning SharePoint 2013 Workflows by Bjoern H. Rapp

http://www.amazon.com/Beginning-SharePoint-2013-Workflows-Bjoern/dp/1430258780

Note that Microsoft Press is now Pearson – March 2014http://www.businesswire.com/news/home/20140311006202/en/Pearson-Announces-Publishing-Distribution-Agreement-Microsoft-Press#.U6mkTnInKig
O’ Reilly Media is no longer – Sept 2013http://blogs.msdn.com/b/microsoft_press/archive/2013/09/30/microsoft-press-announcement.aspx

Free Books

Books And Tutorials for SharePoint 2013 and 2010
http://www.ashokraja.me/books/

Good Guide on Client-Side Web Design – 2010

https://msdn.microsoft.com/en-us/library/hh404092.aspx

SharePoint 2010

Get this book for great Tips and Tricks for Site Owners!

Product Details
SharePoint 2007 and 2010 Customization for the Site Owner by Michael T Smith

Must read to help site owners understand security!

Product Details SharePoint 2010 Security for the Site Owner: and for Administrators and Developers! by Michael T Smith
Admin
Microsoft - SharePoint 2010 Administrator's Companion by Bill English, Brian Alderman, Mark Ferraz
http://www.amazon.com/Microsoft-SharePoint-2010-Administrators-Companion/dp/0735627207
Product Details
Professional SharePoint 2010 Administration by Todd Klindt, Shane Young and Steve Caravajal - WROX - Professional SharePoint 2010 Administration by Todd, Shane and Steve http://www.amazon.com/Professional-SharePoint-2010-Administration-Klindt/dp/0470533331
Product Details
Mastering Microsoft SharePoint Foundation 2010
Architech - Planning
Managing and Implementing Microsoft SharePoint Projects 
http://www.amazon.com/Managing-Implementing-Microsoft-SharePoint-Projects/dp/0735648700
Wrox - "Real World SharePoint 2010"... it's a number of authors each with a different topic. thx Charles
 
http://www.amazon.com/Real-World-SharePoint-2010-Indispensable/dp/0470597135/ref=pd_sim_b_1

Governance
Essential SharePoint 2010: Overview, Governance, and Planning (Addison-Wesley Microsoft Technology Series)  A recommeded governance book (for beginners like me)
http://www.amazon.com/Essential-SharePoint-2010-Governance-Addison-Wesley/dp/0321700759

Introduction
 Beginning SharePoint 2010 Administration: Windows SharePoint Foundation 2010 and Microsoft SharePoint Server 2010
http://www.amazon.com/Beginning-SharePoint-2010-Administration-Foundation/dp/0470597127/ref=sr_1_1?ie=UTF8&qid=1339606257&sr=8-1

Powershell
"The Ultimate Guide Book" for SharePoint Powershell
 http://www.amazon.com/Automating-SharePoint-2010-Windows-PowerShell/dp/0470939206
Great book written for the Windows Administrator (not a developer)
http://www.amazon.com/Automating-Microsoft-Windows-Server-PowerShell/dp/1118013867/ref=ntt_at_ep_dpt_2


Student Book Recommendations
Microsoft SharePoint Designer 2010 Step by Step (varied reviews)
http://www.amazon.com/Microsoft-SharePoint-Designer-2010-Step/dp/0735627339/ref=sr_1_2?s=books&ie=UTF8&qid=1337663155&sr=1-2
Microsoft SharePoint 2010 Administrator’s Companion - Microsoft Press
http://www.amazon.com/Microsoft-SharePoint-2010-Administrators-Companion/dp/0735627207
Excellent book for new or experienced SharePoint administrators. This book covers architecture, installation, upgrading, SQL optimization, information management, protecting content and data, external data sources, general administration tasks, and much more.

Microsoft SharePoint 2010 Unleashed - Sams
http://www.amazon.com/Microsoft-SharePoint-2010-Unleashed-Michael/dp/0672333252/ref=sr_1_1?s=books&ie=UTF8&qid=1343247333&sr=1-1&keywords=sharepoint+2010+unleashed+sams
Learn about the new features in SharePoint 2010 and how to architect and implement a new farm. This book is for architects and SharePoint administrators. The book covers architecture, installation, disaster recovery,SQL maintenance,alternate authentication scenarios, workflows, BI solutions, and much more.

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 - Apress
http://www.amazon.com/Microsoft-SharePoint-2010-Solutions-Professionals/dp/1430228652/ref=sr_1_1?s=books&ie=UTF8&qid=1343247358&sr=1-1&keywords=building+solutions+for+sharepoint+2010+apress
This is a book for SharePoint developers to learn about creating custom solutions for SharePoint 2010. The book starts with the basics about setting up a development machine and moves through other topics such as: SharePoint basics, solution framework, web parts and pages, client object model, workflows, business intelligence, security, and much more.

Essential SharePoint 2010: Overview, Governance and Planning - Addison-Wesley Professional
http://www.amazon.com/Essential-SharePoint-2010-Governance-Addison-Wesley/dp/0321700759/ref=sr_1_1?s=books&ie=UTF8&qid=1343247391&sr=1-1&keywords=essential+sharepoint+2010
This book focuses on helping the reader learn how to maximize the business value of SharePoint 2010 solutions. From a strict business value perspective the book explains how to plan and implement SharePoint solutions. This book covers governance, information architecture, ECM, leveraging community features, making search work, making business processes work, making business intelligence work, and much more.

SharePoint 2010 How-To - Sams
http://www.amazon.com/SharePoint-2010-How--Ishai-Sagi/dp/067233335X/ref=sr_1_2?s=books&ie=UTF8&qid=1343247411&sr=1-2&keywords=sharepoint+how+to+sams
This book is a great starting point for anyone new to SharePoint. This first chapter of the book is all about “What is…?”, to help the reader understand the basic components of SharePoint such as lists, libraries, web parts, workflows, and alerts. Readers will learn how to accomplish standard SharePoint tasks such as: searching content in SharePoint, using social networking features, creating lists and libraries, and managing security.

Microsoft-SharePoint-2010-Implementing-Real-World
http://www.amazon.com/Microsoft-SharePoint-2010-Implementing-Real-World/dp/0735662827/ref=sr_1_4?s=books&ie=UTF8&qid=1348756941&sr=1-4&keywords=real+world+sharepoint
... I was very excited when this book first came out because it appeared to contain step by step instructions to create compelling business solutions using SharePoint. When I began to build out the solutions I was struck by how poorly the book was edited. Many of the steps in buildout would use completely different syntax several times in the steps to represent the same word that needed to be entered to create columns or write rules. ...

Free Books and Content


Free Book Microsoft on Upgrade to 2010
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fd2172e1-f9a7-45ce-ae5c-26714fd751f5&displaylang=en
SharePoint 2010 Products
http://technet.microsoft.com/library/ee428287(office.14).aspx
Downloadable Content - Foundation
http://technet.microsoft.com/en-us/library/cc288773.aspx
Downloadable Content - SharePoint Server
http://technet.microsoft.com/en-us/library/cc262788.aspx
How To Print a Book from TechNet
http://blogs.technet.com/b/tothesharepoint/archive/2011/07/27/export-your-own-technet-book.aspx

Friday, February 2, 2018

SharePoint Workflows Start Here

I get asked a lot about workflows.  I have yet ran across a good course.  If you have let me know.  So I am putting together a list of workflow resources here.  I hope this helps.

Office 365

It is official that Flow is the successor to SharePoint Workflows.  Note that Microsoft is saying that Flow is not the replace since it has yet to reach feature parity with SharePoint Workflows.  More to come …

https://blogs.office.com/en-us/2016/10/31/sharepoint-welcomes-powerapps-and-microsoft-flow/

“Support for InfoPath 2013 and SharePoint Designer 2013 will match the support lifecycle for SharePoint Server 2016, running until 2026.”

More from the cloud engineer

PowerApps and Flow

SharePoint Examples
https://thecloudengineer.blogspot.com/2019/04/flow-and-sharepoint.html

More on PowerApps and Flow
https://thecloudengineer.blogspot.com/2018/11/powerapps-and-flow.html

Workflows

Popular Workflows
http://thecloudengineer.blogspot.com/2017/06/popular-workflows.html
Default Workflows
http://thecloudengineer.blogspot.com/2012/09/default-workflows.html
General Info
http://thecloudengineer.blogspot.com/2011/12/workflows.html
Document Routing
http://thecloudengineer.blogspot.com/2011/08/document-routing-in-sharepoint-2010.html
Workflow Issues
http://thecloudengineer.blogspot.com/2012/08/workflow-issues.html
Workflows with Visual Studio (2010)
http://thecloudengineer.blogspot.com/2011/07/sharepoint-site-workflows.html

SharePoint 2016

Workflows on SharePoint 2016 (2010 2013)
https://technet.microsoft.com/en-us/library/jj219638(v=office.16).aspx

Working with Web Services in SharePoint 2013 Workflows using SharePoint Designer 2013
https://msdn.microsoft.com/en-us/library/office/dn567558.aspx

Overview of workflows included with SharePoint (2010)
https://support.office.com/en-us/article/Overview-of-workflows-included-with-SharePoint-d74fcceb-3a64-40fb-9904-cc33ca49da56

SharePoint Designer 2013 (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj554671.aspx?f=255&MSPPError=-2147217396

Ninetex Workflow Upgrade 2016
http://help.nintex.com/en-US/nintex2016/current/Default.htm#NW-Upgrade/aa-top-upgradeguide.htm%3FTocPath%3DGetting%2520started%7CUpgrading%2520to%2520Nintex%2520for%2520SharePoint%25202016%7C_____0

SharePoint 2013

Quick Reference 2013 Actions and Conditions

2013 Workflow Actions
https://msdn.microsoft.com/en-us/library/office/jj164026.aspx

2013 Workflow Conditions (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj822976.aspx

Missing 2010 Workflow Actions (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj163929.aspx

Infamous Workflow kicking of when File Checked Out / Just been created in document library
https://www.linkedin.com/pulse/infamous-workflow-kicking-when-file-checked-out-just-been-de-roock

Visio Shapes in SharePoint Designer 2013 (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj856990.aspx

Secondary Workflow (2007,2010,2013)
https://support.office.com/en-us/article/Create-a-secondary-workflow-6b77ffd5-9ad6-4c20-b5a4-d686e2deafc2

How To Design and Customize Workflows (2010,2013)
https://support.office.com/en-us/article/Introduction-to-designing-and-customizing-workflows-32c9c0bf-5e20-4f74-8b9c-d3ea79f2962b

Overview of Workflows (2010,2013)
https://support.office.com/en-us/article/Overview-of-workflows-included-with-SharePoint-d74fcceb-3a64-40fb-9904-cc33ca49da56
https://support.office.com/en-us/article/Introduction-to-workflows-15d0d459-cce8-4d8b-b34f-9ab6cda1075b

Introduction to Workflows (2007,2010,2013)
https://support.office.com/en-us/article/Introduction-to-workflows-ee1efda5-82d8-4bb3-aa6b-544a2102fcff

Create a Workflow (2007,2010,2013)
https://support.office.com/en-us/article/Create-a-workflow-f6a92a4b-c919-40d7-9728-2e79c524764c

SharePoint Designer 2010 Resources

https://support.office.com/en-gb/article/SharePoint-Designer-2010-Resources-98376b15-ab11-4ec0-a23f-c8e58c1465cf

Getting Started with SharePoint Designer 2010
https://support.office.com/en-us/article/Get-Started-with-SharePoint-Designer-2010-35A4AEAD-FA83-42A7-B0AF-5F152F06A16A

Workflow History Issues- Upgrade Issues

Myths and Truths
https://blogs.technet.microsoft.com/zsoltilles/2017/05/24/myths-and-truth-about-the-sharepoint-workflow-history-list/

Powershell fix after upgrade
https://exploresharepointfeatures.com/2014/05/06/sharepoint-missing-workflow-history-after-migrationresolved/

Legacy Updates

What's new in workflow in SharePoint Server 2013
http://technet.microsoft.com/en-us/library/jj219638.aspx

Start: Set up and configure SharePoint 2013 Workflow Manager
http://msdn.microsoft.com/en-us/library/office/jj163276(v=office.15).aspx

Setup 2013 Workflow Manager - This good article series by Spencer Harbar focuses on the deployment and configuration of a highly available, SSL, Workflow Manager Farm for use with SharePoint 2013
Workflow Manager Farms for SharePoint 2013 Part One
Workflow Manager Farms for SharePoint 2013 Part Two ...
Workflow Manager Farms for SharePoint 2013 Part Three ...
Workflow Manager Farms for SharePoint 2013 Part Four ...

Loops in SPD 2013 Workflow
http://www.nothingbutsharepoint.com/2012/10/24/create-sharepoint-2013-workflow-loop-by-using-sharepoint-2013-designer-preview-aspx-2/

Call Web Service via Workflow
http://spandps.com/2013/03/05/sharepoint-designer-2013-workflow-action-call-http-web-service/

CSOM Errors
https://blogs.technet.microsoft.com/sharepointdevelopersupport/2016/10/19/fixing-error-the-request-uses-too-many-resources-in-csom-rest-operation/?utm_source=twitterfeed&utm_medium=twitter&utm_campaign=SharePointDevNews

Troubleshooting Workflow Server and SharePoint
https://msdn.microsoft.com/en-us/library/jj193529(v=azure.10).aspx
https://msdn.microsoft.com/en-us/library/office/dn508412.aspx
http://www.harbar.net/articles/wfm2.aspx

Notes from a student …

Import the Workflow Manager SSL Services Certificate to the SharePoint Certificate Store.
Execute the following Windows PowerShell:1    $trustCert = Get-PfxCertificate "c:\wfm.cer"2    New-SPTrustedRootAuthority -Name "Workflow Manager Farm" -Certificate $trustCert
Watch out with this cmdlet. If the certificate file doesn’t exist it will still create a trust! Make sure to watch the output for any errors.
If there are some, you will need to delete the trust before running New-SPTrustedRootAuthority again after resolving the problem.

Register the Workflow Service connection with SharePoint by executing the following Windows PowerShell:1   
Register-SPWorkflowService -SPSite "https://intranet.fabrikam.com" -WorkflowHostUri "https://wfm.fabrikam.com:12290"
W
atch out with this cmdlet. If this command fails the Service Application Proxy will still be created but it will be effectively broken. Again monitor the output for any errors.
Clean up the connection and re-run Register-SPWorkflowService after resolving the problem.

SharePoint 2010

Quick Reference 2010 Actions and Conditions


2010 Workflow Actions (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj822977.aspx

2010 Workflow Conditions (MSDN)
https://msdn.microsoft.com/en-us/library/office/jj822976.aspx

Workflow actions in SharePoint Designer 2010 (Office)
https://support.office.com/en-us/article/Workflow-actions-in-SharePoint-Designer-2010-A-quick-reference-guide-5a7ad276-0ed7-49b0-b652-e56a77dd96c6

Workflow conditions in SharePoint Designer 2010 (Office)
https://support.office.com/en-US/Article/Workflow-conditions-in-SharePoint-Designer-2010-A-quick-reference-guide-d8e33ac7-9336-487f-a60b-388c4ea497ff?ui=en-US

Secondary Workflow (2007,2010,2013)
https://support.office.com/en-us/article/Create-a-secondary-workflow-6b77ffd5-9ad6-4c20-b5a4-d686e2deafc2

How To Design and Customize Workflows (2010,2013)
https://support.office.com/en-us/article/Introduction-to-designing-and-customizing-workflows-32c9c0bf-5e20-4f74-8b9c-d3ea79f2962b

Overview of Workflows (2010,2013)
https://support.office.com/en-us/article/Overview-of-workflows-included-with-SharePoint-d74fcceb-3a64-40fb-9904-cc33ca49da56

https://support.office.com/en-us/article/Introduction-to-workflows-15d0d459-cce8-4d8b-b34f-9ab6cda1075b

Introduction to Workflows (2007,2010,2013)
https://support.office.com/en-us/article/Introduction-to-workflows-ee1efda5-82d8-4bb3-aa6b-544a2102fcff

Create a Workflow (2007,2010,2013)
https://support.office.com/en-us/article/Create-a-workflow-f6a92a4b-c919-40d7-9728-2e79c524764c


Updates

SharePoint 2010 Workflow Limit (February 2011 CU or later build)
http://support.microsoft.com/kb/2557533

Building Effective Workflows Using SharePoint Server 2010
https://msdn.microsoft.com/en-us/library/hh237664.aspx

Workflow administration (SharePoint Server 2010)https://technet.microsoft.com/en-us/library/cc531334.aspx

Conditions in SPD 2010 Workflows: https://support.office.com/en-us/article/Workflow-actions-in-SharePoint-Designer-2010-A-quick-reference-guide-5a7ad276-0ed7-49b0-b652-e56a77dd96c6

Actions in SPD 2010 Workflows: https://support.office.com/en-us/article/Workflow-conditions-in-SharePoint-Designer-2010-A-quick-reference-guide-d8e33ac7-9336-487f-a60b-388c4ea497ff

More from The Cloud Engineer
General Workflow 
Default Workflows
Auto Site Provisioning
Start PowerShell in your Workflow using SPD
Site Workflows using Visual Studio
Issues
Vendors
PowerShell and Workflows
http://thecloudengineer.blogspot.com/2011/07/execute-powershell-with-spd-workflow.html
http://thecloudengineer.blogspot.com/2011/07/auto-site-provisioning-based-on.html

How to Use Default Workflows
Use Approval Workflow (SharePoint 2010)
http://office.microsoft.com/en-us/sharepoint-designer-help/understand-approval-workflows-in-sharepoint-2010-HA101857172.aspx
Use Three Start Workflow (SharePoint Foundation's only workflow)
http://office.microsoft.com/en-ca/sharepoint-server-help/use-a-three-state-workflow-HA101793530.aspx
Use Collect Feedback Workflow  (SharePoint 2010)
http://office.microsoft.com/en-us/sharepoint-server-help/use-a-collect-feedback-workflow-HA010154426.aspx
Use a Collect Signatures workflow
http://office.microsoft.com/en-us/sharepoint-server-help/use-a-collect-signatures-workflow-HA010154428.aspx

All about Workflows
All about Collect Workflows
http://office.microsoft.com/en-us/sharepoint-foundation-help/all-about-collect-feedback-workflows-HA102615319.aspx
All about Collect Signatures workflows
http://office.microsoft.com/en-us/sharepoint-foundation-help/all-about-collect-signatures-workflows-HA102639357.aspx

Tutorials
http://blogs.msdn.com/sharepointdesigner/archive/2009/01/27/visio-diagram-and-site-template-from-office-online-workflow-videos.aspx

Lookups
http://sharepoint.stackexchange.com/questions/108544/workflow-condition-using-a-lookup-column

Thursday, May 18, 2017

Managed Metadata Service

2016

Migrating Managed Metadata Term Stores in SharePoint Server across Farms + Without ID changing
http://mosstechnet-kk.com/migrating-managed-metadata-term-stores-in-sharepoint-server-across-farms-without-id-get-change/

See 2013
Timer Jobs for MMS
Content Hub
Content Type Subscriber
Content Type Subscriber for Publishing Site
MetadataSubscriberTimerJob

Office 365


2013

Overview
http://technet.microsoft.com/en-us/library/ee424403(v=office.15).aspx
Using XML to Export Taxonomy
https://cann0nf0dder.wordpress.com/2014/11/29/importing-taxonomy-to-sharepoint-using-powershell/
WAND – free sample
http://www.wandinc.com/wand-general-business-taxonomy.aspx
Add Languages
http://blog.wandinc.com/2013/05/how-do-you-add-language-translations-to.html
Working with Languages
https://support.office.com/en-us/article/Work-with-multi-lingual-term-sets-D04098AF-282B-45C3-97CB-59363042C1B3
Troubleshooting
http://morg.nl/2011/11/content-type-hub-not-working-possible-causes/
Updating SharePoint MMS via PowerShell
https://blogs.msdn.microsoft.com/kaevans/2012/02/15/updating-sharepoint-managed-metadata-columns-with-powershell/
Workflows missing from Content Type using Content Type Hub
https://blogs.msdn.microsoft.com/chaks/2012/05/05/workflows-and-content-type-hubswhats-the-story/
The Search Dictionaries term store group does not exist
http://www.jrjlee.com/2013/02/the-search-dictionaries-term-store.html
MMS NavigationManaged metadata navigation and friendly URLs in SharePoint 2013 (3 parts)http://sadomovalex.blogspot.com/2013/03/managed-metadata-navigation-and.html
http://sadomovalex.blogspot.com/2013/04/managed-metadata-navigation-and.html
http://sadomovalex.blogspot.in/2013/04/managed-metadata-navigation-and_21.html
SharePoint 2013 Managed Navigation Lessons Learned
http://blogs.c5insight.com/Home/tabid/40/entryid/378/SharePoint-2013-Managed-Navigation-Lessons-Learned.aspx
Building global navigation in SharePoint 2013
http://blog.mastykarz.nl/building-global-navigation-sharepoint-2013/
Faceted Navigation
https://www.nothingbutsharepoint.com/sites/eusp/Pages/SharePoint-2013-Navigation-using-Managed-Metadata-Term-Store.aspx
Troubleshooting
http://summit7systems.com/troubleshooting-sharepoints-hidden-list-and-managed-metadata-columns/

2010

MMS Setup – Good Overview of MMS Content Type Hub
http://www.sharepointdiary.com/2012/05/configuring-managed-metadata-service.html

Good Explanation of hidden taxonomy listhttp://www.wictorwilen.se/Post/Dissecting-the-SharePoint-2010-Taxonomy-fields.aspx
Managing Termshttps://support.office.com/en-ca/article/Create-and-manage-terms-within-term-sets-66b8e643-6234-4447-946e-e369112d2320
Understanding MMS

http://www.nothingbutsharepoint.com/2010/11/15/sharepoint-managed-metadata-overview-aspx/

http://summit7systems.com/mms-101-part-a-how-to-use-the-term-store-in-sharepoint-2010/
Migrating

http://msdn.microsoft.com/en-us/library/hh147179(v=office.14).aspx
https://mymemorysucks.wordpress.com/2011/01/07/invalid-terms-in-managed-metadata-field/
http://www.cleverworkarounds.com/2011/01/09/sp2010-migrating-managed-metadata-term-sets-to-another-farm-on-another-domain/
https://gallery.technet.microsoft.com/office/PowerShell-for-SharePoint-a838b5d0 (no guid)
http://termsetimporter.codeplex.com/
http://metadataexportsps.codeplex.com/
Taxonomy Update Scheduler Timer Job 

http://davidfrette.wordpress.com/2010/05/26/taxonomy-update-scheduler%C2%A0timer%C2%A0job/
MMS Gotchashttp://www.sharepointanalysthq.com/2011/06/managed-metadata-column-limitations/
http://www.cleverworkarounds.com/2010/10/28/un-managed-metadata-a-couple-of-gotchas/

MMS Limitationshttp://blogs.msdn.com/b/chaks/archive/2011/02/09/content-type-hub-limitations.aspx

Free Taxonomyhttp://www.layer2.de/en/products/Pages/SharePoint-2010-Taxonomy-Metadata.aspx

http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?ID=456
This taxonomy can be downloaded from: http://datafacet.com/signup.aspx?feat=GBT_SP2010

Hidden Listhttp://www.wictorwilen.se/Post/Dissecting-the-SharePoint-2010-Taxonomy-fields.aspx

PowershellXML import
http://www.sharepointfix.com/2011/01/creating-managed-metadata-termsets.html
SPImport
http://www.codeproject.com/Articles/72521/Using-SPExport-and-SPImport-Part-1

Content Type HubDeveloper view - great article for admins too.
http://www.sharepoint4developers.net/en-nz/post/sharepoint-2010-content-type-hub.aspx
Move Content Type Hub
http://blog.randomdust.com/index.php/2011/12/move-content-type-hub/

More from MicrosoftAdministration
http://technet.microsoft.com/en-us/library/ee530393.aspx
Metadata Services
http://msdn.microsoft.com/en-us/library/ee519603.aspx
Good example using conf room
http://technet.microsoft.com/en-us/library/ee424402.aspx
Good overview diagram
http://technet.microsoft.com/en-us/library/ee424403.aspx
Planning worksheets
http://technet.microsoft.com/en-us/library/ee519604.aspx
Good intro with detailed descriptions of icons
http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-managed-metadata-in-sharepoint-server-2010-HA101859256.aspx
Manage Permissions
http://office.microsoft.com/en-in/sharepoint-server-help/manage-permissions-and-roles-for-term-sets-HA101631579.aspx
DataSheet View Issues for 64-bit Office
http://support.microsoft.com/kb/2266203
Client Features for Office 2003 2007 or 2010 (pdf)
http://go.microsoft.com/?linkid=9690494

More from the Web

Bulk Tagging
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Bulk-Tagging-in-SharePoint-2010.aspx

Developer Custom Receiver
 http://www.sharepointnutsandbolts.com/2009/12/managed-metadata-in-sharepoint-2010-key.html

Good article on understanding
http://www.endusersharepoint.com/EUSP2010/2010/06/01/understanding-managed-metadata-in-sharepoint-2010-its-impact-on-taxonomy-navigation-and-search-part-1-focusing-on-managed-metadata-term-store-navigation-and-search/

Tuesday, May 9, 2017

SQL SharePoint PowerShell Saturdays

Community Sponsored Events Worth Your Time

PowerShell Saturdays

http://powershellsaturday.com/

Central Ohio – Random

Cincinnati PowerShell Saturday – Fall
2017 (Combined with SharePoint)
http://www.spsevents.org/city/cinci/cinci2017

SharePoint Saturdays

http://www.spsevents.org/

Cincinnati PowerShell Saturday – Fall
2017 (Combined with SharePoint)
http://www.spsevents.org/city/cinci/cinci2017

Columbus – Random

Indianapolis – Random

Louisville – Random

Nashville SharePoint Saturday – Spring

St Louis SharePoint Saturday - Winter

SQL Saturdays

http://sqlsaturday.com/

Columbus OH – Summer
2017
http://www.sqlsaturday.com/653/eventhome.aspx

Cleveland OH - Winter
2017
http://www.sqlsaturday.com/595/eventhome.aspx

Indianapolis – Summer
2017
http://www.sqlsaturday.com/629/eventhome.aspx

Louisville – Spring
2017
http://www.sqlsaturday.com/643/eventhome.aspx

Nashville - Winter
2017
http://www.sqlsaturday.com/581/eventhome.aspx

more from the cloud engineer

Wednesday, November 18, 2015

Create PowerShell ISE Enabled for SharePoint

2013

Are you tired of typing in …

Add-PSSnapin Microsoft.SharePoint.PowerShell

How to Add PowerShell cmdlets for Sharepoint to ISE

Note that if you are using SharePoint 2013 running on Server 2012 use the following updated steps

Start by making sure ISE is loaded

(HINT) Get-WindowsFeature will display entire list

image

If ISE is not added then add by

Running powershell as local administrator

import-module servermanager
add-windowsfeature powershell-ise


image
Note that in this example it is already loaded.

Create ISE Profile

Now you need to create a profile (this has changed)

image

To create a profile for the current user use:

if (!(test-path $profile ))
{new-item -type file -path $profile -force}

To edit the new profile use:

psEdit $profile

image

Then type the following in the ISE Scripting Pane and click Save.

add-pssnapin microsoft.sharepoint.powershell

Test ISE with SharePoint commands

Close/Open ISE and give it a test, now you have ISE enabled with SharePoint

image

image

Technet Reference

To create a new profile you need to decide from one of 4 scenarios listed below.

To create a new “Current user, Windows PowerShell ISE” profile, run this command:

if (!(test-path $profile ))
{new-item -type file -path $profile -force}

To create a new “All users, Windows PowerShell ISE” profile, run this command:

if (!(test-path $profile.AllUsersCurrentHost))
{new-item -type file -path $profile.AllUsersCurrentHost -force}

To create a new “Current user, All Hosts” profile, run this command:

if (!(test-path $profile.CurrentUserAllHosts))
{new-item -type file -path $profile.CurrentUserAllHosts -force}

To create a new “All users, All Hosts” profile, type:

if (!(test-path $profile.AllUsersAllHosts))
{new-item -type file -path $profile.AllUsersAllHosts-force}

To edit a profile

  1. To open the profile, run the command psedit with the variable that specifies the profile you want to edit. For example, to open the “Current user, Windows PowerShell ISE” profile, type: psEdit $profile
  2. Add some items to your profile. The following are a few examples to get you started:
    • To change the default background color of the Console Pane to blue, in the profile file type: $psISE.Options.OutputPaneBackground = 'blue' . For more information about the $psISE variable, see The ISE Scripting Object Model.
    • To change font size to 20, in the profile file type: $psISE.Options.FontSize =20
  3. To save your profile file, on the File menu, click Save. Next time you open the Windows PowerShell ISE, your customizations are applied.

 

2010

So you want to use the ISE with SharePoint.  First add ISE feature then create a new profile by completing the following steps:

ADD ISE
Running powershell as local administrator

import-module servermanager
add-windowsfeature powershell-ise

(HINT) Get-WindowsFeature will display entire list

ADD Profile
Running powershell as sharepoint administrator
Powershell_ISE
Test-Path $profile (if true jump to Open ISO Profile step below)
New-Item $profile -ItemType file –Force
 
Close current untitled ps1 and open new file created
Open ISE Profile > Open > look in documents for microsoft.powershellies_profile.ps1

add-pssnapin microsoft.sharepoint.powershell

Save File and test by closing ISE and relaunch

(HINT) get-psnapin to display that have been added
(HINT) get-psnapin -registered to display all but ...

Give access to DB use the following powershell from a privileged user shell

$spcdb = get-spcontentdatabase wss_content_intranet
Add-spshelladmin -username contoso\sp_admin -database $spcdb


Reference - Scripting Wife - ISE Profiles
http://blogs.technet.com/b/heyscriptingguy/archive/2011/09/13/the-scripting-wife-creates-a-powershell-ise-profile.aspx

http://blogs.msdn.com/b/kaevans/archive/2011/11/14/add-microsoft-sharepoint-powershell-snap-in-to-all-powershell-windows.aspx