Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Load data into Name1 field

Highlighted
Envoy2064
Super Collector

Load data into Name1 field

Hi,
Anyone who can help me solve this problem will get 10 points automatically. :-) It's a tough problem from my end:

We have Configuration Items that has "user-friendly" names held in custom fields, (e.g., Configuration Item A may have the "user-friendly" name of "My Application" in the field "Application Name"), and we'd like to make a copy of these information into the Name1 field (or commonly known as "Name" field). Since HPSD database schema is very complex, does anyone know any SQL code to directly copy a custom field data into Name1 field for the SAME CI?

So before the copy a CI's record may be like this:

Application Name: "My Application"
Name1:

After the copy, it will look like this:

Application Name: "My Application"
Name1: "My Application"
1 REPLY
Envoy2064
Super Collector

Re: Load data into Name1 field

Need to close this thread -- problem has changed...
//Add this to "OnDomLoad" event