Schema for the OMPM database

Updated: January 22, 2009

Applies To: Office Resource Kit

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

The schema for the OMPM database has three parts:

• The schema for the OMPM File Scanner, which includes all tables that have the prefix "os" in their name.

• The schema for OMPM Compatibility Report data, which includes all tables that have the prefix "om" in their name.

• The schema for Access data, which includes all tables that begin with "Access."

Schema for the OMPM File Scanner

Output from the OMPM File Scanner populates the OMPM File Scanner schema. All tables in the OMPM File Scanner schema start with the prefix "os." The tables in the OMPM File Scanner schema fall into two categories:

• Scan data

• File data

OMPM File Scanner schema: scan data

The scan data tables in the OMPM File Scanner schema include all information related to output from the OMPM File Scanner, except for file data. ScanID is the primary key.

The following table provides descriptions for each table for scan data in the OMPM File Scanner schema.

Table	Description	Fields
osScan	Descriptive information for a scan that will run, including the RunID	ScanID RunID Description DestinationPath ScanMyDocuments ScanDesktop DeepScan ComputerName UserName DNS OS LCID PhysicalMemory ScanDAO AccessScan DisableConvDialog MaxCopyFileSize TempPath
osScanSummary	Scan results	ScanID StartDateTime EndDateTime NumFilesScanned NumLogFiles Recoveries
osScanIncludedFolder	Source location for the included folders in a scan search instance	ScanID FolderPath
osScanExcludedFolder	Source location for the excluded folders in a scan search instance	ScanID FolderPath
osScanMappedDrive	Drive mappings discovered by a scan instance	ScanID DriveLetter DrivePath
osErrorText	Types of scanner failures	ErrorID ErrorDescription
osError	Errors by type, per scan instance	osErrorID ScanID ScanFileID ErrorID ErrorInfo

OMPM File Scanner schema: file data

The file data tables in the OMPM File Scanner schema include file-related information that is discovered by the OMPM File Scanner during a scan. ScanFileID is the primary key.

The following table provides descriptions for each table for file data in the OMPM File Scanner schema.

Table	Description	Fields
osScanFile	File information gathered during a light scan by the OMPM File Scanner	ScanFileID ScanID FileName FilePath ShortFilePath FileSize FileExtension FileFormatID CreatedDate ModifiedDate FileOwner IsReadOnly HashCode CSIDL
osFileFormat	The types of files found by the OMPM File Scanner	FileFormatID Description
osWordProperty	Information gathered during a deep scan by the OMPM File Scanner for potential Word issues	ScanFileID HaveVersions
osVBAProperty	Information gathered during a deep scan by the OMPM File Scanner for files that contain VBA macros	ScanFileID CertIssuedBy CertIssuedTo CertSerialNum CertValidFrom CertValidTo SigTimeStampSigningTime SigTimeStampSignerName
osPowerPointProperty	Information gathered during a deep scan by the OMPM File Scanner for potential PowerPoint issues	ScanFileID hasSendForReviewData hasEmbeddings hasVBA hasMicrosoftScriptEditorData hasPresentationBroadcastData hasDocumentRoutingSlip hasPublishandSubscribeData hasLargeNumberofOLEObjects
osExcelProperty	Information gathered during a deep scan by the OMPM File Scanner for potential Excel issues	ScanFileID FileOpenNotSupported FileSaveNotSupported WorkspaceFile HTMLSaved OWC9 OWC10 OWC11 FileFormat LastSavedVersion EmbeddedDocs WSSLinkedList MSERedcords ErrorChecking AccessDBConnection SharedWorkBook LinkedContent Charts OfficeArtShapes ELFEnabled StandardList ATP RelationalPivot OLAPPivot CondFormat
osExcelPropertyLinked	Information gathered during a deep scan by the OMPM File Scanner for Excel files that contain linked cells	ScanFileID Link

Schema for OMPM Compatibility Report data

Output from the Office File Converter and Version Extraction Tool, along with queries against scanned data from the OMPM File Scanner, populate the OMPM Compatibility Report data schema. All tables in the OMPM Compatibility Report data schema start with the prefix "om." The tables in the OMPM Compatibility Report data schema fall into two categories:

• Tools, actions, and issues data

• File location data

OMPM Compatibility Report data schema: tools, actions, and issues data

The tools, actions, and issues tables in the OMPM Compatibility Report data schema include information about the OMPM tool used, the actions that the administrator performed for a file, and the issues identified by the deep scan function of the OMPM File Scanner.

The following table provides descriptions for each table for tools, actions, and issues data in the OMPM Compatibility Report data schema.

Table	Description	Fields
omIssue	Issues found by OMPM File Scanner, Office File Converter, or Version Extraction Tool.	IssueId Title Description HelpURL IssueLevelId IssueTypeId
omIssueLevel	Pre-defined issue levels (red, yellow, and green).	IssueLevelId Description
omIssueType	Pre-defined issue categories.	IssueTypeId Description IsPromoted
omFileIssue	Maps issues to files.	FileId IssueId IssueDate IsResolved
omToolIssue	Maps issues to tools.	ToolId IssueId
omTool	Tool definitions.	ToolId Title Description HelpURL Version
omAction	Action taken for a file, including whether the file was modified.	FileId ToolId ActionDate ActionOptions FileModifiedDate
omActionFile	Files that were created by an action, such as a .docx file created by the Office File Converter.	FileId ToolId ActionDate FileCategoryId Name Path ComputerName Domain
omActionIssue	Issue that was found or resolved by a tool in OMPM.	FileId ToolId ActionDate IssueId IsResolved PostStatus PostDate
omAccessRatings	Pre-defined ratings for Access issues.	FileID RatingId
omAccessIssue	Conversion and other issues that were found in Access files during the scan.	FileID IssueId
omCSIDL	The system folder identifier for a file. For more information about CSIDL values, see CSIDL (https://go.microsoft.com/fwlink?linkid=71501).	CSIDL Name
omFilter	Compatibility report filters saved from OMPM Reports.	FilterId Name SQLText Advanced
omFileCategory	The action name (for example, "Upgrade") that created a file in the omActionFile table.	FileCategoryId Description

OMPM Compatibility Report data schema: file location data

The following table provides descriptions for file location data tables in the OMPM Compatibility Report data schema. FileID is the primary key.

Table	Description	Fields
omFile	File information, including location and modifiers for actions that change the state of the file.	FileId LastScanFileId Name Path ShortPath Extension FileFormatId Size CreatedDate ModifiedDate Owner UserContent ComputerName DNS HashCode CSIDL MaxIssueLevel IsReadOnly
omFileScanFile	Maps entries in omAccessIssue from the corresponding omFile entry to osScanFile, which specifies the FileID needed to get details from the Access tables.	FileId ScanFileId

Schema for Access data

The following table provides descriptions for each Access table in the OMPM database schema.

Table	Description	Fields
AccessVersionsProperties	Contains information about the version properties in an Access file.	VersionCode Version
AccessSystemFiles	Contains information about Access system files.	Name
AccessSampleFiles	Contains information about Access sample files.	Name
AccessReservedWords	Contains information about reserved words in an Access file.	Name
AccessSettings	Contains information about the settings of an Access file.	SettingName DateValue
AccessQueriesTypeLookupProperties	Contains information about lookup properties for query types in an Access file.	TypeID TypeFriendlyName
AccessIssuesProperties	Contains information about issue properties for an Access file.	IssueId IssueText UserIntervention IssueType UserInterventionPriority
AccessBackupTokens	Contains information about backup tokens for an Access file.	Name
AccessDatabasesRatingProperties	Contains information about database rating properties for an Access file.	RatingID Rating
AccessFieldTypeLookupProperties	Contains information about lookup properties for field types in an Access file.	FieldType FieldTypeFriendlyName
AccessForms	Contains information about forms in an Access file.	FileID FormName
AccessReferences	Contains information about references in an Access file.	FileID ReferenceName GUID FullPath IsBroken Kind Major Minor
AccessMacros	Contains information about macros in an Access file.	FileID MacroName
AccessQueries	Contains information about queries in an Access file.	FileID QueryName SQL Connect Type
AccessTables	Contains information about tables in an Access file.	FileID TableName RecordCount Connect
AccessModules	Contains information about modules in an Access file.	FileID ModuleName
AccessReports	Contains information about reports in an Access file.	FileID ReportName
AccessFields	Contains information about fields in an Access file.	FileID TableName FieldName FieldType
AccessProperties	Contains information about properties in an Access file.	FileID ScanID TableCount QueryCount FormCount ReportCount MacroCount ModuleCount ReferenceCount CollatingOrder Version ReplicaID DesignMasterID ANSIQueryMODE AccessVersion Build ProjVer StartupForm NoConvertDialog DatabaseOwner IsCompiled IsSample IsBackup IsOld IsSystem

Download this book

This topic is included in the following downloadable book for easier reading and printing:

• Technical reference for the 2007 Office release

  See the full list of available books at Downloadable content for the 2007 Office Resource Kit.

See Also

Concepts

Office Migration Planning Manager reference for the 2007 Office system
Assessing your environment for the 2007 Office system
Migrating to the 2007 Office system