SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

SMAT – Content Database Query

While reviewing the SharePoint Migration Assessment Tool (SMAT) I noticed the high performance data gathering. Running on a farm with thousands of sites the collection of data ran quickly.

Looking more closely we can see how Content Database SQL queries are used to collect a list of compatibility issues and populate the report. These are much faster than Server Object Model (SOM) front end techniques for collecting data.

Below are sample SQL queries that SMAT uses to check SharePoint content database and identify customizations that might not be compatible with Office 365.

Cheers!

shades_smile

SMAT Download

SMAT Report Categories

Microsoft.SharePoint.Migration.Scan.Scanner

image

AlertsScanner

AppsScanner

BrowserFileHandlingScanner

CheckedOutFilesScanner

CustomizedPagesScanner

CustomProfilePropertyMappingScanner

EmailEnabledListsScanner

FileVersionsScanner

InfoPathScanner

IRMEnabledLibraryScanner

LargeExcelFilesScanner

LargeListsScanner

LargeSitesScanner

LockedSitesScanner

LongODBUrlsScanner

NonDefaultMasterPageScanner

SandboxSolutionScanner

UnsupportedWebTemplatesScanner

WorkflowRunning2010Scanner

WorkflowRunning2013Scanner

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲