Essential Skills Gained

Utilize PowerShell to query and manage SharePoint environments.

Comprehend the SharePoint object model through PowerShell.

Develop PowerShell reports from formatted output.

Minimize server impact while managing resources.

Format

Instructor-led
1 days with lectures and hands-on labs.

Audience

SharePoint server administrators
SharePoint auditors
SharePoint developers

Description

This one day class is designed for SharePoint 2010 and 2013 server administrators and auditors who need to query just about anything in SharePoint. The class handout is effectively a cheat sheet with over 175 PowerShell scripts plus the general patterns to create your own scripts. These scripts cover:

using the SharePoint Management Shell and the ISE
general tips for counting, reformatting and exporting results;
understand and drilling up and down the SharePoint object model
getting lists / inventories of servers, services web applications, sites, webs, lists, libraries, items, fields, content types, users and much more
finding lists by template type, content type and types of content
finding files by user, content type, file extension, checked out status, size and age
finding inactive sites
finding and changing SharePoint Designer settings and finding and resetting customized pages
inventorying and managing features
deleting and recycling files and list items
inventorying users and user permissions and finding out “who can access what”
creating sites, lists and libraries
uploading and downloading files
and much more…

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: SharePoint and PowerShell

History of PowerShell in SharePoint
PowerShell vs. Search
PowerShell, SharePoint Management Shell and cmdlets
Security and Permissions Needed
Getting Started with PowerShell: Counting Items, Custom Columns, Reformatting Numbers, Saving Results to a File
Changing and Updating Content: Creating SharePoint Objects, Changing Objects

Module 2: Working with SharePoint CMDLETs and Objects

GUIDs
Sites vs. Webs
The SharePoint Object Hierarchy

Module 3: Managing Memory and Limiting Performance Impact

Memory Management and Disposing Objects
Limiting Impact on Production Servers

Module 4: Working with Content

Getting Farm Information: version, services, services, features
Getting Web Application information
Exploring Site Collections: retrieve Site Collections, Site Collection Administrators, quotas
Working with the Recycle Bins: finding items, getting file counts and bytes, deleted sites
Exploring Webs: web templates, finding webs, finding webs based on template, Quick Launch and Top Link Bar navigation
Exploring Lists and Libraries: finding all lists, lists by type, lists by Content Type, columns/fields, document count by web or library
Exploring Content Types
Finding documents: by a word in the title, file type, content type, size, date age, checked out status, approval status and many more
Deleting content
Downloading and uploading files

Module 5: Users and Security

Users: find a user, get a list of all users, working with Active Directory groups
SharePoint groups: Get lists of groups, get the members of a group, find all groups a user belongs to, find the groups associated with a web
Expanding user lists that include Active Directory groups
Documenting Broken Inheritance / Unique Permissions: webs, lists, libraries, folders, items
Working with Role Assignments

Module 6: Managing Sites

Finding Inactive Webs
Creating and Deleting Site Collections
Getting Site Collection Data
Creating and Deleting Subsites
Working With SharePoint Designer Settings

SharePoint 2010 and 2013 Auditing and Site Content Administration using PowerShell