When you export search results to a database view, the export contains the SQL statement that defines the columns and data in the search. The view does not collect data until you (or an external application) access and use the view in the database.
You can schedule the export from a saved search to export to a database view.
Example: Export a Search for Expiring Assets to a Database View
In this example, a company develops an external dashboard application that monitors asset allocation. The asset manager views the dashboard daily to verify that expiring assets are allocated properly - reallocated, retired, or returned to vendor. The company wants to configure the dashboard application to display CA APM asset data.
Based on these requirements, the administrator configures the search to display the list of expiring assets and their status and exports the search results to a database view. The administrator schedules the search and export to process weekly. The external dashboard application accesses the database view to gather the asset data, and the asset manager views the data in the external dashboard.
|
Copyright © 2013 CA.
All rights reserved.
|
|