Migrator for Notes to SharePoint 7.4

Table 57. DbReportTable
Column	Value Type	Description
DB_FilePath	String	Full File System Relative Pathname to this Database
DB_FileName	String	File Name and extension of this Notes Database, excluding path
DB_Server	String	Name of the Server hosting this database. May be blank or '(Local)' if located on the current machine.
DB_TemplateBase	String	Name of the base template in the event that this database's template inherits from another template.
DB_IsTemplate	Boolean	True if this database is a Template
DB_Category	String
DB_ModifiedDate	DateTime	Date this database was last modified
DB_DatabaseSize	Int64	Size in bytes of this database on disk
DB_DesignDocs	Int64	Count of the Design Documents contained in this database
DB_ActivityDayWrites	Int64	Number of times this database was Written to today
DB_ActivityWeekReads	Int64	Number of times this database was Read from this week
DB_ActivityWeekUses	Int64	Number of times this database was Accessed this week
DB_ActivityMonthWrites	Int64	Number of times this database was Written to this Month
DB_ActivityCustomReads	Int64	Number of times this database was Read from over the custom timespan defined in DB_CustomReportingDays
DB_ActivityCustomUses	Int64	Number of times this database was Accessed over the custom timespan defined in DB_CustomReportingDays
DB_ManagerCount	Int32	Number of users with Database Manager access
DB_EditorCount	Int32	Number of users with Database Editor access
DB_ReaderCount	Int32	Number of users with Database Reader access
DB_NoAccessCount	Int32	Number of users excluded from access
DB_TechnicalClassLocked	Boolean	True if this Technical class assignment is locked
DB_BusinessClassName	String	Name of the Business Class (if any) assigned to this database
DB_DatabaseOwner	String	Name of the Database Owner
DB_BusinessOwner	String	Name of the Business Owner
DB_AnalysisPriority	Int32	Analysis Priority assigned to this database
DB_AnalysisLocked	Boolean	True if the analysis responsibility assignment property is locked
DB_MigrationResponsible	String	Name of the user responsible for migrating this database
DB_Disposition	String	Migration Disposition status of this database
DB_DispositionComments	String	Disposition comments.
DB_DesignAnalyzed	Boolean	True if the database design has been analyzed
DB_TargetsIdentified	Boolean	True if the SharePoint targets have been identified
DB_TargetsFinalized	Boolean	True if the migration targets have been finalized
DB_JobsFinalized	Boolean	True if the jobs have been finalized and ready for migration
DB_MigrationVerified	Boolean	True if the migration has been verified
DB_TargetSiteLocked	Boolean	True if the target site property is locked
DB_MapACLGroups	Boolean	True if ACL Group mapping is enabled
DB_SiteGroupPrefix	String	String containing the site group prefix
DB_AccessLevelMappingReader	String	True if Access Level is Reader
DB_AccessLevelMappingEditor	String	True if Access Level is Editor
DB_AccessLevelMappingManager	String	True if Access Level is Manager
DB_AccessLevelMappingCanDelete	String	True if Access Level Mapping allows Deleted
DB_MigrationJobsLocked	Boolean	True if the Migration Jobs property is locked.
DB_ApplicationGroup	String	Application Group name
DB_ApplicationSiblings	Int32	Number of Sibling Applications
DB_ComputedDataComplexity	Int32	Computed Data Complexity
DB_ComputedIncrementalComplexity	Int32	Computed Incremental Complexity
DB_MaxDEI	Int32	Max DEI
DB_ComplexityLocked	Boolean	True if the design complexity property is locked
DB_DesignElementCount	Int32	Number of design elements counted
DB_FormCount	Int32	Number of forms counted
DB_ViewCount	Int32	Number of views
DB_SubformCount	Int32	Total number of subforms counted
DB_ScriptLibraryCount	Int32	Number of Script Libraries counted.
DB_StyleSheetCount	Int32	Number of Style sheets counted
DB_DesignElementDeltaCount	Int32
DB_ViewDeltaCount	Int32
DB_SubformDeltaCount	Int32
DB_ScriptLibraryDeltaCount	Int32
DB_StyleSheetDeltaCount	Int32
DB_TemplateMatch	Int32	Percent Match identifies how closely this design matches the template
DB_DesignScanQuickplace	Boolean	True if this is had Design Scan performed on the Quickplace
DB_TemplateDatabaseLocked	Boolean	True if the Template database property is locked.
DB_EffortIsIncremental	Boolean	True if this is an incremental effort
DB_EffortTargets	Int32	Effort assigned for target definition
DB_EffortContent	Int32	Effort assigned for content migration
DB_EffortTotal	Int32	Total effort assigned
DB_BaseEffortTargets	Int32	Base Effort Targets
DB_BaseEffortContent	Int32	Base Effort Content
DB_BaseEffortTotal	Int32	Base Effort Total
DB_HasDatabaseActivityDetail	Boolean	True if this database has activity detail logged
DB_DataDocSize	Int64	Data Document size
DB_LastDocModified	DateTime	Timestamp of most recent document modified
DB_DocsWithReaders	Int32	Number of documents with readers defined
DB_DocsWithChildren	Int32	Number of documents with children
DB_DocsWithImages	Int32	Number of documents with images
DB_DocsWithMime	Int32	Number of documents with Mime content
DB_DocsWithSignatures	Int32	Number of documents with Signatures
DB_FormsUsed	Int32	Number of forms used in this database
DB_LastDataAnalysis	DateTime	Timestamp of the last data analysis.
DB_CatalogDate	DateTime	Timestamp of the Catalog.

DbReportTable

Migrator for Notes to SharePoint reporting data tables

This table provides access to discovered Notes Database information compiled by the Migrator Console application.

Each field in this table is prefixed: "DB_".

Table 57. DbReportTable
Column	Value Type	Description
DB_FilePath	String	Full File System Relative Pathname to this Database
DB_FileName	String	File Name and extension of this Notes Database, excluding path
DB_Server	String	Name of the Server hosting this database. May be blank or '(Local)' if located on the current machine.
DB_TemplateBase	String	Name of the base template in the event that this database's template inherits from another template.
DB_IsTemplate	Boolean	True if this database is a Template
DB_Category	String
DB_ModifiedDate	DateTime	Date this database was last modified
DB_DatabaseSize	Int64	Size in bytes of this database on disk
DB_DesignDocs	Int64	Count of the Design Documents contained in this database
DB_ActivityDayWrites	Int64	Number of times this database was Written to today
DB_ActivityWeekReads	Int64	Number of times this database was Read from this week
DB_ActivityWeekUses	Int64	Number of times this database was Accessed this week
DB_ActivityMonthWrites	Int64	Number of times this database was Written to this Month
DB_ActivityCustomReads	Int64	Number of times this database was Read from over the custom timespan defined in DB_CustomReportingDays
DB_ActivityCustomUses	Int64	Number of times this database was Accessed over the custom timespan defined in DB_CustomReportingDays
DB_ManagerCount	Int32	Number of users with Database Manager access
DB_EditorCount	Int32	Number of users with Database Editor access
DB_ReaderCount	Int32	Number of users with Database Reader access
DB_NoAccessCount	Int32	Number of users excluded from access
DB_TechnicalClassLocked	Boolean	True if this Technical class assignment is locked
DB_BusinessClassName	String	Name of the Business Class (if any) assigned to this database
DB_DatabaseOwner	String	Name of the Database Owner
DB_BusinessOwner	String	Name of the Business Owner
DB_AnalysisPriority	Int32	Analysis Priority assigned to this database
DB_AnalysisLocked	Boolean	True if the analysis responsibility assignment property is locked
DB_MigrationResponsible	String	Name of the user responsible for migrating this database
DB_Disposition	String	Migration Disposition status of this database
DB_DispositionComments	String	Disposition comments.
DB_DesignAnalyzed	Boolean	True if the database design has been analyzed
DB_TargetsIdentified	Boolean	True if the SharePoint targets have been identified
DB_TargetsFinalized	Boolean	True if the migration targets have been finalized
DB_JobsFinalized	Boolean	True if the jobs have been finalized and ready for migration
DB_MigrationVerified	Boolean	True if the migration has been verified
DB_TargetSiteLocked	Boolean	True if the target site property is locked
DB_MapACLGroups	Boolean	True if ACL Group mapping is enabled
DB_SiteGroupPrefix	String	String containing the site group prefix
DB_AccessLevelMappingReader	String	True if Access Level is Reader
DB_AccessLevelMappingEditor	String	True if Access Level is Editor
DB_AccessLevelMappingManager	String	True if Access Level is Manager
DB_AccessLevelMappingCanDelete	String	True if Access Level Mapping allows Deleted
DB_MigrationJobsLocked	Boolean	True if the Migration Jobs property is locked.
DB_ApplicationGroup	String	Application Group name
DB_ApplicationSiblings	Int32	Number of Sibling Applications
DB_ComputedDataComplexity	Int32	Computed Data Complexity
DB_ComputedIncrementalComplexity	Int32	Computed Incremental Complexity
DB_MaxDEI	Int32	Max DEI
DB_ComplexityLocked	Boolean	True if the design complexity property is locked
DB_DesignElementCount	Int32	Number of design elements counted
DB_FormCount	Int32	Number of forms counted
DB_ViewCount	Int32	Number of views
DB_SubformCount	Int32	Total number of subforms counted
DB_ScriptLibraryCount	Int32	Number of Script Libraries counted.
DB_StyleSheetCount	Int32	Number of Style sheets counted
DB_DesignElementDeltaCount	Int32
DB_ViewDeltaCount	Int32
DB_SubformDeltaCount	Int32
DB_ScriptLibraryDeltaCount	Int32
DB_StyleSheetDeltaCount	Int32
DB_TemplateMatch	Int32	Percent Match identifies how closely this design matches the template
DB_DesignScanQuickplace	Boolean	True if this is had Design Scan performed on the Quickplace
DB_TemplateDatabaseLocked	Boolean	True if the Template database property is locked.
DB_EffortIsIncremental	Boolean	True if this is an incremental effort
DB_EffortTargets	Int32	Effort assigned for target definition
DB_EffortContent	Int32	Effort assigned for content migration
DB_EffortTotal	Int32	Total effort assigned
DB_BaseEffortTargets	Int32	Base Effort Targets
DB_BaseEffortContent	Int32	Base Effort Content
DB_BaseEffortTotal	Int32	Base Effort Total
DB_HasDatabaseActivityDetail	Boolean	True if this database has activity detail logged
DB_DataDocSize	Int64	Data Document size
DB_LastDocModified	DateTime	Timestamp of most recent document modified
DB_DocsWithReaders	Int32	Number of documents with readers defined
DB_DocsWithChildren	Int32	Number of documents with children
DB_DocsWithImages	Int32	Number of documents with images
DB_DocsWithMime	Int32	Number of documents with Mime content
DB_DocsWithSignatures	Int32	Number of documents with Signatures
DB_FormsUsed	Int32	Number of forms used in this database
DB_LastDataAnalysis	DateTime	Timestamp of the last data analysis.
DB_CatalogDate	DateTime	Timestamp of the Catalog.

TasksReportTable

This Data Table provides a row for each entry in the Task History. This table contains no joined database fields. The prefix for Task Record specific fields is: "TSK_".

DbTasksReportTable

This Data Table joins all Task History Records with Database Records and produces data only for Tasks associated with a Notes Database. The prefix for Task Record specific fields is: "TSK_" and Database specific fields are prefixed: "DB_".

Table 58. DbTasksReportTable
Column	Value Type	Description
TSK_StartDateTime	DateTime	The Date and Time this task or sequence was started
TSK_Status	String	Last known State of this task. Pending, Running, Cancelled, Completed, RunningWithErrors, RunningWithWarnings, CompletedWithErrors, CompletedWithWarnings, Failed, Suspended or Other
TSK_StatusDetails	String	Detailed status message with the results of this task.
TSK_Description	String	Brief description of this task's goal.
TSK_DatabaseServer	String	Server or machine name of the database being processed (if any). May be blank or (Local) for local machine
TSK_TargetPath	String	SharePoint Site or List URL if this task is operating against SharePoint.
TSK_RecordsProcessed	Int32	Total number of records processed. The definition of a record varies by task type.
TSK_Errors	Int32	Number of errors encountered so far for this task.
TSK_LogXml	String	Detailed XML formatted log of this task. (Advanced property with format and content subject to change)
TSK_RunBy	String	Name of the user initiating this task.
TSK_CatalogUnid	String

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Migrator for Notes to SharePoint 7.4 - User Guide

Migrator for Notes to SharePoint reporting data tables

DbReportTable

TasksReportTable

DbTasksReportTable