Infogix Assure includes a exportControlData script within the Assure server's server-util directory, and within Assure client's bin directory. This script is used to export control data into a comma delimited format.
Prerequisites to using exportControlData
This script was introduced in Assure 9.1 as an add-on feature. You can check if your installation has this add-on enabled by checking your license details under Help > About Us. If this feature is enabled, you will have "Enabled" next to Export Server Utility Module. If your installation has this feature disabled, please submit a license request to have your license updated with this module enabled.
Using exportControlData script
The exportControlData script is present within the following location:
<Assure installation folder>/server-util/<jvm-name>/IA/
To use the script, specify the Control Entity to extract data from, the destination directory and the duration of data to include. The example below extracts data from the past year:
exportControlData.bat -entity ENTITY_NAME -destdir D:\destination\location -from -P1Y
If you are running the script from Assure Client, you can optionally include the "-localdest" flag to create the output file locally rather than on the Assure server. The same destination directory setting will be used, but it will be a location where Assure Client is installed instead of where the Assure Server is installed.
Available script flags
The following is a list of all available flags and usage within the script. Note that this script was enhanced in version 9.3 - some of these flags aren't available in versions 9.1 and 9.2.
Export all control data.
Result Catalog ID
Character set of the produced file.
Date value format. Optional; default is yyyy-MM-dd HH:mm:ss.SSS
Shift date values to UTC time.
Destination directory on server, or on client if -localdest is specified.
Control Entity name to export
Field delimiter. Optional. Default is comma. May specify tab or user defined value.
From date or duration period: (for example, "-P1D" or 2008-03-15 or 2008-03-15T14:23:40)
From cycle as a number or number.number for cycle and run combination.
From day as duration period with time of day set to zero.
Include a header row of field names.
The file produced is to be transmitted back to the client.
Bypass enclosing text values in double quotes.
End-of-record delimiter. Optional; defaults to single new line ("\n").
To date or period (optional): defaults to current date and time; 2008-03-15 means 2008-03-15T23:59:59 if no time is specified
To cycle as a number or number.number for cycle and run combination.