6 Replies Latest reply on Dec 17, 2010 4:00 PM by the_toilet

    Can Custom Property Names be changed?

    rgward
    rgward Jul 27, 2008 7:32 PM

      Is there a way to change the name of a node custom property after creating it with CPE?   I know I could delete it and create a new one with the new name but I don't want to loose all the populated data.  Running v8.5.1 SP3

      • 2684 Views
      • Tags:
        • Re: Can Custom Property Names be changed?
          savell
          savell Jul 27, 2008 7:45 PM (in response to rgward)

          You could create the new custom property and them use a quick SQL update to copy the data across.


          Dave.

            • Re: Can Custom Property Names be changed?
              vhcato
              vhcato Jul 30, 2008 12:48 PM (in response to savell)

              The easiest way would be to rename it through SQL Server Management Studio. Of course, you could use CPE to create the new one, select the entire column from the old one, then copy and paste the entire column to the new property.

                • Re: Can Custom Property Names be changed?
                  rgward
                  rgward Aug 2, 2008 12:54 PM (in response to vhcato)

                  you could use CPE to create the new one, select the entire column from the old one, then copy and paste the entire column to the new property.


                  Thanks for everyone's input. 


                  vhcato, I thought of doing as you suggested but we wanted to keep the same CP name. We would still need to deal with reordering the CPnames for ease of use in CPE.


                  So, here is how we ended up doing it. 


                  1. Login to the SQL machine


                  2. Open "Enterprise Manager"


                  3. Expand to the following folder in the left hand column


                      a. Microsoft SQL Servers > SQL Server Group > local (Windows NT) > Databases > NetPerfMon > Tables


                  4. Right Click on the Nodes table in the Right hand column


                  5. Select "Design Table"


                  6. Left click on the Gray box to the far left of the row you wish to move (Sorted by column name)


                  7. Rename Custom Property


                      To reorder Custom Properties - Left click and hold to drag the row to any desired location


                  8. Make any other moves necessary following steps 6 and 7 until complete.


                  9. When prompted to "Save Changes" Click "Yes"


                      a. The database does not need to be stopped or halted during these changes


                  10. Close "Enterprise Manager"


                  11. Logoff of the SQL Machine


                  12. Update Report Schemas.


                  Update Report Schemas


                  1. Login to the Orion machine running Custom Property Editor


                  2. Open Custom Property Editor


                  3. Right Click in the Gray area to the right of the icon menu bar


                  4. Choose Customize from To drop down


                  5. Click on the Commands Tab


                  6. Scroll to the bottom of the list on the right hand side of the window


                  7. Click and Drag the "Update Report Schemas" icon from the window to the same area you right clicked on in Step 3


                  *8. Double click on Update Report Schemas to update the reports with the new schemas from any changes you have made to the custom property editor or database


                  *Any reports that reference the custom properties that you have changed will need to be corrected. The original custom properties you created will have been repleced with * in any Report Writer reports.