How to update the HEAT Help Desk Employee Profile records, setting the DisplayName field to a value of LastName, FirstName

Version 1

    Details

    Is it possible to quickly update the Employee Profile records setting the DisplayName field to a value of LastName, FirstName?


    Resolution

    To set the Employee Profile records DisplayName field to a value of LastName, FirstName, ask your DBA to run the following query in Microsoft SQL Management Studio:

    UPDATE Profile

    SET DisplayName = LastName+ ', ' +FirstName

    WHERE CustType = 'Employee'