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

book

Article ID: 5094

calendar_today

Updated On:

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">

 

 

 

 

 

Attachments

1558707264623000005094_sktwi1f5rjvs16qmj.png get_app
1558707262847000005094_sktwi1f5rjvs16qmi.png get_app
1558707261068000005094_sktwi1f5rjvs16qmh.png get_app
1558707259150000005094_sktwi1f5rjvs16qmg.png get_app
1558707257400000005094_sktwi1f5rjvs16qmf.png get_app
1558707255317000005094_sktwi1f5rjvs16qme.png get_app