Service Desk Practitioners Forum
cancel

Load data into Name1 field

Highlighted
Envoy2064
Respected Contributor.

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
Respected Contributor.

Re: Load data into Name1 field

Need to close this thread -- problem has changed...