ImporterRun Table

The ImporterRun table lists all previously run imports.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `ImporterRun` table
Database Column	Details
`ImporterRunID`	Type: integer. Key. Generated ID A unique identifier for the import run.
`LicenseMeasurementID`	Type: integer. Key. Nullable The LicenseMeasurementID if a license reconcile was performed. Foreign key to the `LicenseMeasurement` table.
`StartDate`	Type: datetime. Nullable The time the import was started.
`EndDate`	Type: datetime. Nullable The time the import was completed.
`ImportSourcesAppliedDate`	Type: datetime. Nullable If non-licensing writers ran and completed successfully, this field will be set to the date/time of their completion. In effect, it records the application of data from the importer staging tables in to the core tables. This is the case even if the record as a whole is marked as a failure, as the writers processing will have already completed.
`Arguments`	Type: text (max 1024 characters) The command line arguments to the import.
`RunAs`	Type: text (max 1024 characters) The user who performed the import.
`Comment`	Type: text (max 1024 characters). Nullable Comments related to the import.
`EventLogSummaryID`	Type: integer. Key. Nullable The EventLogSummaryID for the import. Foreign key to the `EventLogSummary` table.
`Success`	Type: boolean. Key. Nullable Determines whether the import completed successfully.