DIrect Change of user Fullname attribute in CRM 4.0

Posted on 2010-01-07
Last Modified: 2013-11-24
Hello Experts,
Although I know it is unsupported, I need to make a small number of changes to the Fullname attribute in the users table.  Essentially, we have altered the format for the display of the users' full name form FirstName LastName to LastName, FirstName and want to alter the existing records to the new format.

All I really need to know is in  which CRM 4.0 Table is the user record stored so I can pass this info on to my SQL people to get sorted.

Cheers and thanks in advance
Question by:mevels
    LVL 29

    Accepted Solution

    The table is systemuserbase in the organization database for users.


    Author Closing Comment

    Short and sweet - Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
    Read about achieving the basic levels of HRIS security in the workplace.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now