How to Bulk Export and Import of Query Definitions in CA Client Automation?

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

This article provides instructions on how to export and import multiple query definitions at once in CA Client Automation (ITCM) without using the DSM Explorer UI.

Details

The DSM Explorer interface primarily supports the export and import of individual query definitions. For bulk migrations or backups of multiple queries, the command-line utility amObjectManager.exe can be used to perform these actions more efficiently.

Prerequisites

• Administrative access to the Domain Manager server.
• Access to the CA Client Automation bin directory (typically C:\Program Files (x86)\CA\DSM\bin).

Environment

CA Client Automation - All supported versions.

Resolution

Step 1: Bulk Export of Query Definitions

1. Open a Command Prompt with administrative privileges.
2. Navigate to the Client Automation bin directory if it is not in your system PATH.
3. Execute the following command:

   amobjectmanager /EXPORTCONTENTS

4. The utility will automatically export all supported objects, including AM Queries, to a hardcoded directory: C:\test\queries Note: Ensure the C:\test directory exists or check this location for the generated .cmsobj files.

Step 2: Bulk Import to a New Server

1. Copy the generated .cmsobj files from the source server to the target Domain Manager.
2. Open an administrative Command Prompt on the target server.
3. Run the following command, replacing the path with the location of your copied files:

   amobjectmanager /IMPORTCONTENTS:"C:\Path\To\Your\Files"

Validation

1. Open the DSM Explorer on the target server.
2. Navigate to Queries -> All Queries.
3. Verify that the imported queries appear in the list and resolve correctly against the local MDB.

---

Important Considerations

• Internal Utility: The amObjectManager.exe tool is an internal feature. While highly effective for bulk operations, it is recommended to test the migration in a non-production environment first.
• Scope: The /EXPORTCONTENTS flag exports all supported objects. You may need to manually filter or select specific .cmsobj files for import if you only require specific queries.