How to change system/user default culture to make time format change accordingly? Such as date format in reminder.

Version 3

    Verified Product Versions

    LANDESK Service Desk 7.6LANDESK Service Desk 7.7.xLANDESK Service Desk 7.8.xLANDESK Service Desk 2016.xLANDESK Asset Central 2016.x

    Backgroud:

    The notification date format depends on the culture of system, such as US format is MM/dd/yyyy and UK format is dd/MM/yyyy.

    US format:

    1.png

    UK format:

    2.png

    How to change:

    Change system's default culture.

    Below example is to change culture from en-GB to en-US by running below script:

    update md_catalog set md_culture = 'en-US' where md_culture = 'en-GB'
    
    

     

    tps.config files located as below also need to be changed:

    C:\ProgramData\LANDesk\ServiceDesk\servicedesk.WebAccess\tps.config
    C:\ProgramData\LANDesk\ServiceDesk\servicedesk.Framework\tps.config
    
    

    Locate:

    <add key="SystemCulture" value="en-GB" />
    
    
    

    Change the value to disired such as en-US, en-GB, en-CH etc.

     

    Update all the users with culture en-GB to en-US by:

    update tps_user set tps_culture = 'en-US' where tps_culture = 'en-GB' 
    
    

     

    Update a specific user with culture en-GB to en-US by:

    update tps_user set tps_culture = 'en-US' where tps_name='XXX'
    

     

    Additionally if you want to change a user's culture in console:

    Open Console - Setting - System, Set Enable multilingual support to "True".

    Open window designer, find "Analyst9" under System - Analyst. Drag Culture to right. It should look like:

    Now when open a analyst, it should look like: