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



Type: integer. Key. Generated ID

A unique identifier for the import run.


Type: integer. Key. Nullable

The LicenseMeasurementID if a license reconcile was performed. Foreign key to the LicenseMeasurement table.


Type: datetime. Nullable

The time the import was started.


Type: datetime. Nullable

The time the import was completed.


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.


Type: text (max 1024 characters)

The command line arguments to the import.


Type: text (max 1024 characters)

The user who performed the import.


Type: text (max 1024 characters). Nullable

Comments related to the import.


Type: integer. Key. Nullable

The EventLogSummaryID for the import. Foreign key to the EventLogSummary table.


Type: boolean. Key. Nullable

Determines whether the import completed successfully.