Saving the Job results of a Query Task as a TXT file or a CSV file

If the Job that was executed contained a Query Task, you can save the results of this Task as a TXT file or a CSV file. This allows you to view the Job results outside Ivanti Automation, for example in a spreadsheet.

To save the general results of a Query for all Agents:

  1. Open the relevant Job.
  2. Click the Tasks tab, select the Query and click Details.
  3. In the Task Job window, click DBExport_16.
  4. In the window that opens, type a name for the file and select whether to save it as a TXT file or as a CSV file.

To save the detailed results of a Query for a specific Agent:

  1. Open the relevant Job.
  2. Click the Agents tab, select an Agent and click Details.
  3. In the Agent Job window, select the Query and click Details.
  4. In the Task window, click DBExport_16.
  5. In the window that opens, type a name for the file and select whether to save it as a TXT file or as a CSV file.

The regional settings of your user account determine the list separator used in the CSV file. This setting is stored in the registry value of the registry key HKEY_CURRENT_USER\Control Panel\International\sList.