Searching › Search Results Export › Schedule Searches and Exports

Schedule Searches and Exports

CA APM lets you schedule searches to process periodically and export the search results to a CSV file or a database view. For example, you can schedule a search to process at the end of the week and export all updated assets during that week to a CSV file. You can schedule the following types of searches:

• Predefined. Specify a recurring time for the search. For example, you can process the search at 3:00 p.m. on the 21st of every month.
• Calculated. Specify the start time and frequency for the search. For example, you can process the search at 10:00 p.m. on the 21st of September and use the search every five days thereafter.

To schedule a search and export the results

1. Click the tab and optional subtab for the object for which you want to schedule a search.
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.
4. On the left, click New Export.
5. Enter the basic export information.

   The following fields require explanation:

   Export Name

   Specify the export name.

   Export Format

   Select the format for the exported search results.

   View Name

   Specify the database view name.

   Note: The View Name is required if you select Database View for the Export Format. The name must be a valid database view name. See your database product documentation for information about database view name requirements.

   Description

   Specify a description for the exported search results.

   Retention Days

   Specify the number of days that the exported search results are retained before the results are purged.

   Folder Name

   Specify the folder for the exported CSV file search results.

   Never Expires

   Select this check box to specify that the number of days of the selected period (Period Type) that the CSV file or database view is stored before being deleted never expires (the CSV file or database view is never purged). When you select this check box, any previous value that you added to the Retention Days field is removed, and the Retention Days field is disabled.

6. Schedule the search.

   The following fields require explanation:

   Run Time

   Select the time of the day, in 24-hour format, to process the search. When you schedule searches, use the local time zone on the CA APM application server.

   Interval Type

   Select the type of interval for the search. For example, you can select Day, Month, Quarter, Week, or Year.

   Interval Day

   Specify the day during the Interval Type to process the search. For example, if the Interval Type is Month and the Interval Day is 1, the search is processed on the first day of the month.

   First Run Date

   Select the date when the first search starts to process.

   Interval

   Specify how often the search processes, based on the specified Interval Type. For example, if the Interval Type is Weekly and the Interval is 2, the search processes every two weeks.

   Last Day of Interval

   Select this check box to specify that the search processes on the last day of the selected Interval Type. When you select this check box, any previous value that you added to the Interval Day field is removed, and the Interval Day field is disabled.

7. Specify whether all roles and configurations assigned to the search receive the exported search results.
8. Click Save.

   The search is saved. The search processes at the scheduled time and the search results are exported.

   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.