CSV format reports generated via 'Scheduled Reports' shows incorrect date format.

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

CSV format reports generated via 'Scheduled Reports' shows incorrect date format.

The scheduled reports from DSM reporter that save to a CSV file output are in the US date format MM/DD/YYYY.

If I manually export the same report from DSM Explorer the Date format is in the correct format DD/MM/YYYY.

We follow the DD/MM/YYYY format and want this date format to be displayed in the report.

 

Environment

Client Automation version - 12.8, 12.9, 14.0, 14.0 SP1

Resolution

The reports are dependent on the system timezone and regional settings.

For the report to be able to display the desired date format (in this case DD/MM/YYYY - English Australia) change the 'Regional and Language Options' to the desired format under Control Panel as per the screenshots below:

1. Under the 'Formats' tab change the current format to 'English (Australia)'

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKOvAAO" alt="1.png" width="408" height="495">

 

2. Under the 'Location' tab change current location to 'Australia'

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKOwAAO" alt="2.png" width="410" height="497">

 

3. Under the 'Administrative' tab click on 'Change system locale' and change the current system locale to 'English - Australia'.

Note: You will be prompted to reboot the machine to save the changes.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKOxAAO" alt="3.png" width="406" height="493">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKOyAAO" alt="4.png" width="409" height="498">

 

4. Under the 'Administrative' tab click on the 'Copy to reserved accounts' option. Enable both the options 'Default user account (new users)' and 'System accounts'. Click OK.

Note: This is the key setting for the exported CSV report to show the correct date format. A reboot is not required.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKOzAAO" alt="5.png" width="412" height="493">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKP0AAO" alt="6.png" width="410" height="497">