Office Migration Planning Manager 2010 reports filtering reference for Office 2010


Applies to: Office 2010

Topic Last Modified: 2011-08-29

The filtering criteria that you can select on the 2010 Office Release Compatibility page in Office Migration Planning Manager (OMPM) reports are listed in the following table.

After you apply a filter, the Scanned Files and Created Files windows contain the first 1,000 files that are returned. You can sort or filter by any column by using data sheet column headers. However, the results only apply to those 1,000 files. For example, if you sort by File Format, OMPM reports returns the same 1,000 files but has sorted them by file format. To sort or filter on all files in that scanner run, click New Window i at the bottom of the Scanned Files or Created Files window.

Filtering Criteria: Office Release Compatibility Report

Field Description

Scanner Run

A list of all run descriptions and their IDs. Filters to all files that were scanned in that scanner run. Note: The data displayed for each file is from the latest scanner run.

Issue Type

Filters by type of issue, including Access Error, Scanner Error, Tool Error, and Upgrade Issue. Filters to all files that have that issue.

Select Issues of Specified Type

Shows unresolved issues filtered to the specified issue type.

Select Resolved Issues and Actions

Shows issues that have been resolved by user actions, such as converting the file.

Max Issue Level

Filters by the maximum issue level found in a file, including Red, Yellow, and Green. For example, if a file has a red issue and a green issue, it is filtered with a red issue.

File Format

Filters by file format. You can select individual programs, or you can select Excel/PowerPoint/Word to select all files that can be converted to the .xml file formats in Microsoft Office 2010.

File Extension

Filters by file name extension.

Modified Before

Shows files that have a last modified date that is before the date specified.

Modified After

Shows files together with a last modified date that is after the date specified.

File Access

Filters by the file access that the scanner had to each file. For example, if the file is located on a drive that is read-only for the scanner, the file is listed as read-only.

Min Size (KB)

Shows files that are the file size specified or bigger.


Filters by domain. The string must be an exact match.

Computer Name

Filters by computer name. The string must be an exact match.

Path Begins With

Shows files where the long path name begins with the characters specified.

Name Begins With

Shows files where the file name begins with the characters specified.

System Folders

Shows files from the selected system folders. The system folder <undefined> filters to files not found in system folders.

Selected Filter SQL

This is a read-only field that shows the most recently applied SQL clause. Click the Customize SQL button to edit the SQL clause. Click Clear SQL Filter to return to editing the filter in the form view. Advanced: When customizing SQL, you can insert filter criteria by using a field in the form view and clicking Add Selected Criteria to insert those criteria into the SQL query.