Skip navigation
2595 Views 2 Replies Latest reply: Sep 8, 2010 2:45 AM by Waldy RSS
murraymint Rookie 7 posts since
Dec 17, 2007

Has received 1 of 9 achievements.
Currently Being Moderated

Aug 16, 2010 1:54 AM

Edit User ID

Hi Guys

 

We are running an old version of Helpdesk 7.2.6 so hope fully someone can help.

 

We have a requirement to change the User ID field from LASTNAME_FIRSTNAME to employee number.

 

Thanks for looking

 

Murray

  • Mroche SupportEmployee 49 posts since
    Oct 13, 2008

    Has received 4 of 9 achievements.
    Currently Being Moderated
    1. Aug 17, 2010 2:50 PM (in response to murraymint)
    Re: Edit User ID

    Hi Murray,

     

    What is the element ID of the User ID field?  To find this out you will need to login to Designer as a super analyst, click File | Windows | Views, Highlight the Default view and click 'Open' and then highlight the details window and click Modify.  Double click on the User ID element and make a note of the element ID.

     

    If the Element ID is CUSTID, you will need to replace the existing CustID with the employee number in a large number of tables.

     

    To identify the tables you would need to update, run the Change Data utility (Start | Programs | Touchpaper Software | Helpdesk | Utilities) on the server and Highlight the CUSTID Element ID in the list.  The list box below will then give you all the table ID's which contain the CUSTID field.  You will need to make a note of these tables and then generate an SQL script to update the CUSTID in all the tables listed with the new employee number.

     

    If you are using ServicePortal then I would advise against making these changes on your own and instead would advise you to contact Support for assistance.

     

    Make sure you take a backup before making any changes to the database and restore immediately if you have any issues.

     

    Regards,

     

    Martyn

  • Waldy Employee 353 posts since
    Feb 20, 2009

    Has received 3 of 9 achievements.
    Currently Being Moderated
    2. Sep 8, 2010 2:45 AM (in response to murraymint)
    Re: Edit User ID

    Hi Murray,

                   LANDesk Professional Services can create the required script for you if you do not have the skills in house.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software