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"