Query Migration History

The following procedure shows how to query migration history data and filter the data shown in the History screen.

To query migration history

1. In Siebel Migration, click History in the navigation menu in the side panel to go to the History screen.

2. Click Query (the magnifying glass icon) to filter the records in the History view.

   The History Query form opens, where you can filter on the following fields: Name, Description, Status, Source, Target, Archive ID, Start Date, End Date, Package Filename. For more information about these fields, see Viewing Migration History.

3. For example, to search for all migration plan executions that were aborted:

   1. On the History Query form, enter the criteria shown in the following table.

      Field	Operation	Value
      Status	Equal (==)	Abort

   2. Click Go.

      All records that match this criteria are returned in the History screen.

4. For example, to delete all successful migration plan execution records from January 2022:

   1. On the History Query form, enter the criteria shown in the following table.

      Field	Operation	Value
      Status	== (Equal)	Successful
      Start Date	>= (Greater than or equal to)	2022-01-01 00:00:01
      End Date	<= (Less than or equal to)	2022-01-31 23:59:59

   2. Click Go.

   3. Select the check box beside the Name field of all returned records.

      • To select all visible records on the current page, click the check box beside the Name column heading.

      • Use the following navigation buttons to move to the next page or previous page: First Record Set, Previous Set, Next Record Set, Last Record Set.

   4. Click Delete and then click OK when prompted to delete the records.