Viewing the Integration Status and History

You can view the status of your data import and cancel a running import.

This task is only available to administrators.

Viewing the Data Integration Log - File Integration

Log into the Service Desk Console as an administrator, then open the Integration Log workspace. The list of data imports appears.

Sample Integration Log

If an import was successful, one line appears under LogType: Stats.

Errors encountered are shown with two lines: Stats and ErrorStats.

Stats: Double-click to view a summary of the job.
ErrorStats: Double-click to view a summary of the errors. Open the attachmentA file or web URL reference linked to a record. to view the rows containing errors. The last column contains specific details about the error. You can modify the data (correct the errors) in the attachment file and save it to the source location for re-import. The error message will be ignored and the data will be imported into the database.

Viewing the Integration Log - SCCM

View the details of the processed job from the Integration Log workspace.

Log into the Service Desk Console as an administrator, then open the Integration Log workspace. The list of import jobs appear with the following information:

Field	Description
Log Type	Shows three log types: Queued: Indicates that the source ID from SCCM has been queued in the Inventory Management Asset Data Processor. Verified: Indicates that the source ID from SCCM has been successfully created in the HEAT database. Stats: Shows the statistics about the number of rows processed.
Source ID	SCCM root table key (Computer_System_DATA) shown on the Object Mapping page of the wizard.
Target ID	Asset ID that is derived from the asset identifier mapping function on the Field Mapping page of the wizard.
Start Time	Time when the job should run.
End Time	If applicable, the time by which the job should end.
Total Processed	Total number of records processed. If there are no new mappings added, there will probably be no records processed.
Message	Informational message, which varies according to the log type.

While the job is being processed, you can view it from the Integration Queue workspace.

Viewing Data Integration History

The Integration History page shows all jobs, including canceled jobs.

Within the Service Desk Console, open the Integration History workspace. The list of import jobs appears. Also shown is the following information for each job:

Field	Description
Connection Name Source Name	The name and source of the Integration job as defined in Configuring Data Integration.
Queue Status	Indicates the status of the job. This field is color-coded. Queued: The job has not yet run but is in the queue. This status is replaced by running when the job begins. Running : The job is currently running. This status is replaced by completed when the job end. Abort Requested: A user has canceled the job, but the cancellation has not yet taken place. This status is replaced by aborting as soon as the cancellation begins. Aborting: The job is in the cancel process. This real-time status only appears when the cancellation is running and is replaced by Aborted when the cancellation is complete. Aborted: The job has been successfully canceled. This final status remains in the History workspace. Completed: The job has been successfully run. This final status remains in the History workspace.
Batch Number	The number of the last batch processed. A batch is 200 rows of data.
Batch Processed	The total number of rows that have been processed in the last batch.
Batch Failed	The total number of rows that have failed in the last batch.
Process Row Number	The total number of rows in all batches for the current job. If the job has 10 batches, for example, this field shows the total number of rows for all batches (2000).
Batch Start Time Batch End Time	The start and end time of the last batch processed.
Display Batch Time Taken	The number of seconds to run the last batch.
Start Time	The start time of the entire job.
Display Queue Running Time	The number of seconds to run the job, including initialization and dispatching.
Created By Created On Modified By Modified On	Automatically generated by the system based on the logged in user ID.