Previous Topic: Export Search Results to a CSV File (On Demand)Next Topic: Schedule Searches and Exports


Export Search Results to a Database View

CA APM lets you export the results of a search to a database view by scheduling a saved search and exporting the results.

To export search results to a database view

  1. Click the tab and optional subtab for the object for which you want to schedule a search and export.
  2. On the left, click Manage Searches.

    A list of saved searches appears. If there are no saved searches, define and save a search that you want to schedule and export.

  3. Click the search that you want to schedule and export.
  4. On the left, click New Export.
  5. Enter the basic information, schedule information, and security information as described in the steps to schedule the search and export.

    The search is processed and the results are exported according to the schedule. The column heading labels in the database view match the column heading labels in the search results. An email notification specifying the database view name is sent to all contacts associated with the export request.

    Note: The results for a scheduled search and export only include the results found by the current search and export. If you change the search or any part of the export criteria, you will not see the new search results until the next time the search and export process runs. For example, if you change the Export Format from CSV File with Column Headers to Database View or you change the Frequency of the Export Schedule, you do not see those changes in the current search and export.