ManageEngine to CSV Utility

Note that to use the utility under a Subscription Licence, your Precision Bridge Licence must explicitly include the ManageEngine instance you will be using as the source. See Licencing Precision Bridge for more information. The utility will not be enabled if it is not licenced, and you will only be able to run the utility using connections explicitly defined in your licence.

Note that this utility must be explicitly included in your Precision Bridge licence. See Licencing Precision Bridge for more information.

The utility loads data into memory, and writes to the relevant CSV files in chunks of 1000 rows at a time.

Please note that to get all the requisite data, an API call must be performed for each individual record. Performance is therefore quite limited, at around 300 records per minute.

Generating an API Code

The ManageEngine utility requires a code be generated for each execution of the utility. For an end-user this will typically only need to be done once.

1. Go to https://api-console.zoho.com/ and log in if necessary.
2. Create a ‘Self Client’ application if you haven’t already done so.
3. Select the ‘Generate Code’ tab under ‘Self Client’.
4. Enter the following text for the ‘Scope’ input:

SDPOnDemand.requests.ALL,SDPOnDemand.problems.ALL,SDPOnDemand.changes.ALL,SDPOnDemand.projects.ALL,SDPOnDemand.assets.ALL,SDPOnDemand.cmdb.ALL,SDPOnDemand.custommodule.ALL,SDPOnDemand.setup.ALL,SDPOnDemand.solutions.ALL,SDPOnDemand.general.ALL

5. Select the maximum time duration (10 minutes)

6. Enter any scope description (e.g. ‘All’)

7. Click ‘Create’

The code is used by the utility to generate an access token which expires after 1 hour. If this happens the utility will automatically request a new token and continue.

Running the Utility

The utility takes six arguments:

1. The api root for the manage engine server to connect to, e.g. https://sdpondemand.manageengine.eu/api/v3/. The trailing slash is required. Please note there are different datacenters - see here for more details.
2. The client id to connect with. This can be found by logging in to https://api-console.zoho.com/. You will need to create a ‘Self Client’ application if you haven’t already.
3. The client secret, found in the same location as the client id.
4. The API code, found by following the instructions above.
5. The target folder in which to save CSV files. The utility will create the folder if it doesn’t exist.
6. The security key, provided by Precision Bridge.