SharePoint 2010 and 2013 Auditing and Site Content Administration using PowerShell – Courseware

This one day instructor-led 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;
• 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…

After completing this course, students will be able to:

• Use PowerShell to query just about anything inside of SharePoint.
• Understand the core SharePoint object model and object hierarchy as seen from PowerShell.
• Format PowerShell output in to reports.
• Manage resources to limit the impact on production servers.
• Create and delete Site Collections, subsites, lists, libraries and content.

Number of Days: 1

Instruction Format: Instructor-Led

To Purchase:  This course is available from the Microsoft Courseware Marketplace or directly from MAX Technical Training.

Module 1: SharePoint and PowerShell

This module provides an introduction to the topics covered in the class, introduces SharePoint PowerShell terminology and provides a review of important PowerShell features.

Lessons:

• 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

Lab: SharePoint and PowerShell

• Using PowerShell with SharePoint

After completing this module, students will be able to:

• Get started using PowerShell to inventory and update SharePoint.

Module 2: Working with SharePoint CMDLETs and Objects

This module introduces the SharePoint object model and some important terminology.

Lessons:

• GUIDs
• Sites vs. Webs
• The SharePoint Object Hierarchy

Lab: Working with SharePoint CMDLETs and Objects

• Get a list of all Site Collections and their GUIDs
• Get a list of all Webs in all Site Collections
• Given a web`s URL get its parent web and web application

After completing this module, students will be able to:

• Explore sites and webs using PowerShell.
• Retrieve important properties of common SharePoint objects

Module 3: Managing Memory and Limiting Performance Impact

This explores limiting impact on server memory usage and performance.

Lessons:

• Memory Management and Disposing Objects
• Limiting Impact on Production Servers

Lab: Managing Memory and Limiting Performance Impact

• Exploring PowerShell`s use of system memory.
• Testing the impact of scripts on server performance

After completing this module, students will be able to:

• Recognize and manage the impact of PowerShell on a SharePoint server.

Module 4: Working with Content

This module explores SharePoint using PowerShell from the Farm down to individual list items.

Lessons:

• 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

Lab: Working with Content

• Explore the farm.
• Inventory site collections.
• Create a recycle bin report.
• Finding all blog sites.
• Find all picture libraries.
• Find all PDF files over 5 MB.
• Delete all videos in a site collection.

After completing this module, students will be able to:

• Explorer, inventory and maintain SharePoint content using PowerShell.

Module 5: Users and Security

This module covers the use of PowerShell to explore and document SharePoint permissions.

Lessons:

• 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 users lists that include Active Directory groups
• Documenting Broken Inheritance / Unique Permissions: webs, lists, libraries, folders, items
• Working with Role Assignments

Lab: Users and Security

• Get a list of all users who have access to a Site Collection.
• Get a list of all groups in a Site Collection.
• Get a list of all groups a user belongs to.
• List all users who may have access to a SharePoint securable.
• Get a list of all securables with broken inheritance.

After completing this module, students will be able to:

• Explore and document users and user permissions.
• Explore and document SharePoint groups.
• Explore and document broken inheritance.

Module 6: Managing Sites

This module explorers Site Collection and Web management from PowerShell.

Lessons:

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

Lab:

• Create a report for inactive sites.
• Create a site collection and subsites.
• Delete a site.
• Delete a site collection.
• Disable SharePoint Designer in all site collections.

After completing this module, students will be able to:

• Manage SharePoint Site Collections and webs from PowerShell.

Before attending this course, students must:

• Very good knowledge of SharePoint and its features.
• Good experience using PowerShell 2 or later or recent completion of a PowerShell class such as 10961 or 50414.

• SharePoint server administrators.
• SharePoint auditors.
• Also valuable for SharePoint developers.