Versions Compared

Old Version 4

changes.mady.by.user Vinayak Pawar

Saved on

compared with

New Version 5

changes.mady.by.user Srikanth Adiga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Via GUI, create a query with the required filters (e.g. filter by CP) and add the columns needed by the external system
  2. Save the query
  3. Schedule the query to run at required intervals (E.g. nightly, hourly etc) (For details: Scheduling Queries)
  4. In every query run, the data satisfying the filters are exported to a CSV file. The exported CSV file is stored in the directory $OS_DATA_DIR/query-exported-data using the following name format - scheduled_query_<query_id>_<job_run_id>.csv. 
  5. Write an external program to monitor the query export directory and process the required CSV files (using the filename scheduled_query_<query_id>_*.csv).

...