Migrator for Notes to SharePoint 6.15

Table 56. Results View data columns
Column	Category	Description	Source of Information
ACL Map Author	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Author access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Create	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Create access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Delete	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Delete access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Designer	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Designer access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Editor	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Editor access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Manager	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Manager access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
ACL Map Reader	Migration Targets	Defines what SharePoint permission level or group will be assigned to the Notes Reader access level. Defined in the Advanced Security Mapping dialog of the Migration Targets tab.	Classification rules or Manual Entry
Active Users	Usage Analysis	The number of users who have accessed the database.	Database Header scan
Active Users All Replicas	Usage Analysis	The number of users who have accessed the database across all known replicas.	Database Header scan
Activity Custom Reads	Usage Analysis	The number or database reads in the activity log’s custom reporting days interval (for example, “last 301 days”).	Database Header scan
Activity Custom Uses	Usage Analysis	The number or database uses in the activity log’s custom reporting days interval (for example, “last 301 days”).	Database Header scan
Activity Custom Writes	Usage Analysis	The number or database writes in the activity log’s custom reporting days interval (for example, “last 301 days”).	Database Header scan
Activity Day Reads	Usage Analysis	The number of database reads in the last 24 hours.	Database Header scan
Activity Day Uses	Usage Analysis	The number of database uses in the last 24 hours.	Database Header scan
Activity Day Writes	Usage Analysis	The number of database writes in the last 24 hours.	Database Header scan
Activity Month Reads	Usage Analysis	The number of database reads in the last month.	Database Header scan
Activity Month Uses	Usage Analysis	The number of database uses in the last month.	Database Header scan
Activity Month Writes	Usage Analysis	The number of database writes in the last month.	Database Header scan
Activity Week Reads	Usage Analysis	The number of database reads in the last week.	Database Header scan
Activity Week Uses	Usage Analysis	The number of database uses in the last week.	Database Header scan
Activity Week Writes	Usage Analysis	The number of database writes in the last week.	Database Header scan
Agent Count	Design Analysis	The number of agents in the database.	Design scan
Agent Delta	Design Analysis	The difference between the number of agents in the database, and the number of agents in the reference database or template from which deviations are being computed.	Design scan
Analysis Priority	Migration Status	The number that represents the analysis priority. This is set manually in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Analysis Responsible	Migration Status	The user that is the responsible for conducting the analysis of the database. This is set manually in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Application Children	Application Tree Node	The name of the Quickr, QuickPlace or Domino.Doc application’s children. Application children are “discovered” by running the Discover Quickr/QuickPlace/Domino.Doc Organization actions.	Discover Organization
Application Name	Application Tree Node	The name of the Quickr, QuickPlace or Domino.Doc application. Applications are “discovered” by running the Discover Quickr/QuickPlace/Domino.Doc Organization actions.	Discover Organization
Application Siblings	Application Tree Node	The name of the Quickr, QuickPlace or Domino.Doc application’s siblings. Application siblings are “discovered” by running the Discover Quickr/QuickPlace/Domino.Doc Organization actions.	Discover Organization
Application Type	Application Tree Node	The name of the Quickr, QuickPlace or Domino.Doc application type. Application types are “discovered” by running the Discover Quickr/QuickPlace/Domino.Doc Organization actions.	Discover Organization
Attachments Count	Data Analysis	Total number of attachments in the database	Data scan w/Document Analysis
Attachments KB	Data Analysis	Total size of the attachments	Data scan w/Document Analysis
Author Count	Database Access	Number of users or groups with Author access in the database.	Database Header scan
Average DEI	Complexity	Average number of the Microsoft Design Element Index	Design scan
Base Effort Analysis	Migration Effort	The number that represents the analysis work effort for the reference database.	Classification rules or Manual Entry
Base Effort Jobs	Migration Effort	The number that represents the development and content migration effort for the reference database.	Classification rules or Manual Entry
Base Effort Targets	Migration Effort	The number that represents the development of new targets effort for the reference database.	Classification rules or Manual Entry
Base Effort Testing	Migration Effort	The number that represents the testing and verification effort for the reference database.	Classification rules or Manual Entry
Base Effort Total	Migration Effort	Estimated total effort for the reference database.	Classification rules or Manual Entry
Base Effort Content	Migration Effort	The number that represents the provisioning and content migration effort for the reference database.	Classification rules or Manual Entry
Blocked Attachments Count	Data Analysis	Number of attachments that will be disallowed by SharePoint because of file extensions and therefore will not be included in the migration.	Data scan w/Document Analysis
Blocked Attachments KB	Data Analysis	Total size of attachments that will be disallowed by SharePoint because of file extensions and therefore will not be included in the migration.	Data scan w/Document Analysis
Business Class	Classification	The business classification of the given database. This is automatically populated by the Classification Rules engine. You can change this value manually by selecting a different class in the Classification tab of the database properties sheet.	Classification rules or Manual Entry
Business Class Locked	Classification	Indicates if the Business Class value is locked which keeps a manual Business Class change from being over-ridden in future design scans.	Set when data is manually changed
Business Owner	Migration Status	The user that is the business owner of the database. This is manually set in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Business Owner Locked	Migration Status	Indicates if the Business Owner is locked which keeps a manual Business Owner change from being over-ridden in future design scans.	Set when data is manually changed
Category	General	Name of the database’s category in the Database Catalog. This can be used in classification rules to assign the database to a business or technical class.	Database Header scan
Complexity	Complexity	The overall complexity of the design of the database. This is a weighted average of other complexity numbers based on the settings defined in the Analysis tab of the Global Options.	Design scan or Manual Entry
Complexity Assigned	Complexity	Indication that the overall Complexity was assigned by a class rule rather than a Design Scan.	Classification rules
Complexity Locked	Complexity	Indicates if the Complexity value is locked which keeps a manual Complexity change from being over-ridden in future design scans.	Set when data is manually changed
Computed Data Complexity	Complexity	Overall data complexity recommendation of the database using the algorithms defined in the Analysis tab of the Global Options.	Design scan
Computed Design Complexity	Complexity	Overall design complexity recommendation of the database using the algorithms defined in the Analysis tab of the Global Options.	Design scan
Computed Incremental Complexity	Complexity	The computed difference between the complexity of the database design, and the complexity of the design of the reference database or template from which deviations are being computed.	Design scan
Content Migrated	Migration Status	Indicates that the content migration task has been completed.	Automatic setting or Manual entry
Convert ACL Groups	Migration Targets	When provisioning site members, this option causes a new SharePoint site collection group to be created for each Domino Directory group defined in the Notes database ACL. (Now “Expand Notes Groups to SharePoint Groups” in the User Interface.)	Classification rules or Manual Entry
Convert ACL Roles	Migration Targets	When provisioning site members, this option causes a new SharePoint site collection group to be created for each Role defined in the Notes database ACL. (Now “Expand Notes Roles to SharePoint Groups” in the User Interface.)	Classification rules or Manual Entry
Creation Date	General	Date the database was created.	Database Discovery
Custom Reporting Days	Usage Analysis	The number of days in the activity log’s custom reporting days interval (for example, “last 301 days”).	Database Header scan
Data Analyzed	Migration Status	Indicates that the data analysis task has been completed.	Automatic setting or Manual entry
Data Doc Size	Data Analysis	Total size of all documents stored in the database (excluding design elements, deleted documents and unused database space)	Data scan w/Document Analysis
Data Docs	Data Analysis	Number of data documents	Data scan (any level)
Database Key	General	A string that uniquely identifies an instance of a database.	Database Discovery
Database Owner	Migration Status	The user that is the database owner of the database. This is manually set in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Database Owner Locked	Migration Status	Indicates if the Database Owner value is locked which keeps a manual Database Owner change from being over-ridden in future design scans.	Set when data is manually changed
Database Script Count	Design Analysis	Indicates whether or not the Database Script has been defined in the database. (This value will be set to 1 if the Databases Script has been defined.)	Design scan
Database Script Delta	Design Analysis	The difference between the Database Script Count in the database, and the Database Script Count in the reference database or template from which deviations are being computed.	Design scan
Database Size	Data Analysis	Size of the database	Database Header scan
Depositor Count	Database Access	The number of users or groups with Depositor access to the database.	Database Header scan
Design Analyzed	Migration Status	Indicates that the design analysis task has been completed.	Automatic setting or Manual entry
Design Docs	Design Analysis	Number of design documents in the database.	Data Scan
Design Element Count	Design Analysis	Number of design elements in the database	Design scan
Design Element Delta	Design Analysis	The difference between the Design Element Count in the database, and the Design Element Count in the reference database or template from which deviations are being computed.	Design scan
Design Modified	Design Analysis	Date the design was last modified in the database.	Database Discovery
Designer Count	Database Access	Number of users or groups with Designer access in the database.	Database Header scan
Disposition	Migration Status	The action that you want to do with this database (for example, ‘Migrate to customized SharePoint targets’, and ‘End of life’).	Classification rules or Manual Entry
Disposition Comments	Migration Status	Any comments on the disposition.	Manual Entry
Disposition Locked	Migration Status	Indicates if the Disposition value is locked which keeps the manual selection from being over-ridden every time a scan is run.	Set when data is manually changed
Disposition Type	Migration Status	The type of action (for example, ‘Migrate to SharePoint’, ‘Delete’) that you want to do with the database. This value corresponds to the user-defined Disposition, and is automatically assigned when the Disposition is assigned.	Classification rules or Manual Entry
Doc Authors	Data Analysis	The number of unique authors of documents in the database.	Data scan w/Document Analysis
Docs With Attachments	Data Analysis	Number of documents with attachments	Data scan w/Document Analysis
Docs With Children	Data Analysis	Number of documents with children (for example, responses).	Data scan w/Document Analysis
Docs With Composite	Data Analysis	Number of documents with Notes Rich Text fields	Data scan w/Rich Text Analysis
Docs With Doc Links	Data Analysis	Number of documents with Doc links	Data scan w/Rich Text Analysis
Docs With Encryption	Data Analysis	Number of documents with encryption	Data scan w/Document Analysis
Docs With Form	Data Analysis	Number of documents with embedded forms	Data scan w/Document Analysis
Docs With Images	Data Analysis	Number of documents with embedded images	Data scan w/Rich Text Analysis
Docs With Mime	Data Analysis	Number of documents with MIME/HTML	Data scan w/Rich Text Analysis
Docs With Objects	Data Analysis	Number of documents with OLE objects	Data scan w/Document Analysis
Docs With Readers	Data Analysis	Number of documents with reader security	Data scan w/Document Analysis
Docs With Signatures	Data Analysis	Number of documents that are digitally signed	Data scan w/Document Analysis
Docs With Writers	Data Analysis	Number of documents with writer security	Data scan w/Document Analysis
Editor Count	Database Access	Number of users or groups with Editor access in the database.	Database Header scan
Effort Analysis	Migration Effort	The number that represents the analysis work effort.	Classification rules or Manual Entry
Effort Content	Migration Effort	The number that represents the provisioning and content migration effort.	Classification rules or Manual Entry
Effort Is Incremental	Migration Effort	Indicates if a reference database is used in the effort comparison.	Classification rules or Manual Entry
Effort Jobs	Migration Effort	The number that represents the development and content migration effort.	Classification rules or Manual Entry
Effort Locked	Migration Effort	Indicates if the effort values are locked which keeps the manual numbers from being over-ridden every time a scan is run.	Set when data is manually changed
Effort Targets	Migration Effort	The number that represents the development of new targets effort.	Classification rules or Manual Entry
Effort Testing	Migration Effort	The number that represents the testing and verification effort.	Classification rules or Manual Entry
Effort Total	Migration Effort	Estimated total effort.	Classification rules or Manual Entry
Embedded Forms	Design Analysis	Number of embedded forms in the database.	Design scan
Excluded Element Count	Design Analysis	Number of miscellaneous design elements not tabulated in this tool.	Design scan
Excluded Users	Usage Analysis	Number of users omitted from usage information because the were listed in the Excluded Users List in Advanced Configuration Options.	Database Header scan
Excluded Users All Replicas	Usage Analysis	Number of users omitted from usage information across all known replicas because the were listed in the Excluded Users List in Advanced Configuration Options.	Database Header scan
File Name	General	Database file name, excluding the folder components.	Database Discovery
File Path	General	Database file name, including path relative to the Notes/Domino data directory.	Database Discovery
Folder	General	The folder in which the database file is located, relative to the Notes/Domino data directory.	Database Discovery
Folder Count	Design Analysis	Number of folders used in the database.	Design scan
Folder Delta	Design Analysis	The difference between the Folder Count in the database, and the Folder Count in the reference database or template from which deviations are being computed.	Design scan
Form Count	Design Analysis	Number of forms used in the database.	Design scan
Form Delta	Design Analysis	The difference between the Form Count in the database, and the Form Count in the reference database or template from which deviations are being computed.	Design scan
Forms Used	Data Analysis	The number of unique forms names associated with the data documents in the database.	Data scan w/Document Analysis
Is Template	General	Indicated if the database is a design template.	Database Discovery
Jobs Assigned	Migration Status	Indicates that the migration job assignment task has been completed.	Automatic setting or Manual entry
Jobs Finalized	Migration Status	Indicates that the migration job finalization task has been completed.	Manual Entry
Last Data Analysis	Data Analysis	Date the last data analysis was run against the database.	Data scan (any level)
Last Design Analysis	Design Analysis	Date the last design analysis was run against the database.	Design scan
Last Doc Accessed	Usage Analysis	Date a document was last accessed from within the database.	Data scan w/Document Analysis
Last Doc Created	Usage Analysis	Date of the last document that was created in the database.	Data scan w/Document Analysis
Last Doc Modified	Usage Analysis	Date the last document was modified in the database.	Data scan w/Document Analysis
Last Usage Analysis	Usage Analysis	Date the last usage analysis was run against the database.	Database Header scan
Last Used	Usage Analysis	Date the database was last used.	Database Header scan, Data scan (if needed)
Last Used All Replicas	Usage Analysis	Date the database was last used, across all known replicas.	Database Header scan, Data scan (if needed)
Mail Description	General	Mail description if the database is a Mail-in database.	Domino Directory scan
Mail Domain	General	Mail Domain if the database is a Mail-in database.	Domino Directory scan
Mail Name	General	Mail Name if the database is a Mail-in database.	Domino Directory scan
Mail Type	General	Mail Type if the database is a Mail-in database (that is, Mail, Resource).	Domino Directory scan
Manager Count	Database Access	Number of users or groups with Manager access in the database.	Database Header scan
Map ACL Groups	Migration Targets	When provisioning site members, this option causes any Notes groups listed in the source database ACL to be added to the target SharePoint site. (Now “Map Notes Groups” in the User Interface.)	Classification rules or Manual Entry
Map ACL Users	Migration Targets	When provisioning site members, this option causes any Notes users listed in the database ACL to be added to the target SharePoint list or library. (Now “Map Notes Users” in the User Interface.)	Classification rules or Manual Entry
Max DEI	Complexity	Maximum or “worst case” ranking of design element types according to Microsoft’s Design Element Index specification	Design scan
Migration Jobs Count	Migration Jobs	The number of migration jobs that have been associated with this database.	Classification rules or Manual Entry
Migration Jobs Locked	Migration Jobs	Indicates if the migration jobs associated with this database are locked which keeps manual changes from being changed by future scans.	Set when data is manually changed
Migration Locked	Migration Status	Indicates if the Migration Priority value is locked which keeps a manual Migration Priority change from being over-ridden in future design scans.	Set when data is manually changed
Migration Priority	Migration Status	The number that represents the migration priority. This is set manually in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Migration Responsible	Migration Status	The user that is the responsible for conducting the migration of the database. This is set manually in the Migration Status tab of the db properties sheet.	Classification rules or Manual Entry
Migration Verified	Migration Status	Indicates that the verification of the migration jobs task has been completed.	Manual Entry
Modified Date	General	Date the database was last modified.	Discovery, Header Scan, or Data Scan
No Access Count	Database Access	Number of users or groups explicitly denied access to the database.	Database Header scan
Oversized Attachments Count	Data Analysis	Number of attachments that are larger than allowed and therefore will not be included in the migration.	Data scan w/Document Analysis
Oversized Attachments KB	Data Analysis	Total size of the oversized attachments.	Data scan w/Document Analysis
Page Count	Design Analysis	Number of pages used in the database	Design scan
Page Delta	Design Analysis	The difference between the Page Count in the database, and the Page Count in the reference database or template from which deviations are being computed.	Design scan
Profile Docs	Data Analysis	Number of profile documents in the database.	Data scan (any level)
Reader Count	Database Access	Number of users or groups with Reader access in the database.	Database Header scan
Recording Activity	Usage Analysis	Indicates if Activity Logging is enabled on the database.	Database Header scan
Replica	General	A globally unique identifier shared by all replicas of the same database	Database Discovery
Replica Count	General	Number of databases that are replicas of the current database.	Database Discovery
Script Library Count	Design Analysis	Number of script libraries used in the database	Design scan
Script Library Delta	Design Analysis	The difference between the Script Library Count in the database, and the Script Library Count in the reference database or template from which deviations are being computed.	Design scan
Server	General	The server the database resides on.	Database Discovery
Site Group Prefix	Migration Targets	When provisioning site members, this option will cause any roles names mapped to SharePoint groups to be prefixed with this name.	Classification rules or Manual Entry
Style Sheet Count	Design Analysis	Number of style sheets used in the database	Design scan
Style Sheet Delta	Design Analysis	The difference between the Style Sheet Count in the database, and the Style Sheet Count in the reference database or template from which deviations are being computed.	Design scan
Subform Count	Design Analysis	Number of subforms used in the database	Design scan
Subform Delta	Design Analysis	The difference between the Subform Count in the database, and the Subform Count in the reference database or template from which deviations are being computed.	Design scan
Target Site	Migration Targets	The Url of the SharePoint site you intend to migrate to. This target site will override the site that may be specified in the individual migration jobs.	Classification rules or Manual Entry
Target Site Locked	Migration Targets	Indicates if the Target Site value is locked.	Set when data is manually changed
Targets Finalized	Migration Status	Indicates that the finalization of the migration targets task has been completed.	Manual Entry
Targets Identified	Migration Status	Indicates that the identification of the migration targets task has been completed.	Automatic setting or Manual entry
Targets Provisioned	Migration Status	Indicates that the provisioning of the migration targets task has been completed.	Automatic setting or Manual entry
Technical Class	Classification	The technical classification of the given database. This is automatically populated by the Classification Rules engine. You can change this value manually by selecting a different class in the Classification tab of the database properties sheet.	Classification rules or Manual Entry
Technical Class Comments	Classification	Comments made in the Comments field of the Classification tab of the database properties sheet.	Manual Entry
Technical Class Locked	Classification	Indicates if the Technical Class value is locked which keeps a manual Technical Class change from being over-ridden in future design scans.	Set when data is manually changed
Template	General	The Design Template the database is based on.	Database Discovery
Template Database Key	General	The location of the Reference Database or Template that this database should be compared to during design analysis.	Classification rules or Manual Entry
Template Database Locked	General	Indicates if the Template Database Key value is locked which keeps a manual Template Change change from being over-ridden in future design scans.	Set when data is manually changed
Template Match	Design Analysis	Percentage the database matches the template database.	Design scan
Title	General	Name of the database. This is a required column for the results view.	Database Discovery
Uri	General	Link to original Notes database	Database Discovery
Use Security Groups	Migration Targets	When provisioning site members, map database ACL levels to predefined SharePoint groups instead of setting explicit permissions. Defined in the Advanced Security Mapping dialog of the MigrationTargets tab.	Classification rules or Manual Entry
View Count	Design Analysis	Number of views used in the database	Design scan
View Delta	Design Analysis	The difference between the View Count in the database, and the View Count in the reference database or template from which deviations are being computed.	Design scan

Migrator for Notes to SharePoint reporting data tables

DbReportTable

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.

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_".

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 6.15 - User Guide

Results View data columns

Migrator for Notes to SharePoint reporting data tables

DbReportTable

TasksReportTable