Home > Service Manager, System Center > Tool for editing Service Manager view column names

Tool for editing Service Manager view column names

I recently had to change several view column names (in multiple views), in the Service Manager console.  Travis Wright has a post on the system center blog on how to do this (http://blogs.technet.com/b/servicemanager/archive/2010/07/21/showing-the-correct-display-name-for-related-objects-in-view-columns.aspx).  The process is however tedious and error prone when you have to do it for multiple views or view columns.  Since I am lazy at repetitive tasks, I decided to write a quick tool to do the work for me.  In the tool, you specify the internal column name – e.g. ‘AffectedUser.DisplayName’ and the display string you would like to use for the column name – e.g. ‘Affected User’ (instead of the default ‘Display Name’).  The tool searches the exported management pack XML for all instances of that internal column name, and replaces the corresponding display value of the selected language with the string you specified.

Here’s how to run the tool:

  1. Export the Management Pack
  2. Launch the tool.  At startup, the tool contains two suggested (what I think are the most common) column renames.  You can delete the rows if you don’t need to rename those columns, or edit the Display String.  You can also add additional columns to rename.  Note that you must know the internal column name.  These are in each view node under ‘Presentation\Columns\mux:ColumnCollection’.
  3. You can optionally change the language pack to modify at the top right of the tool.  **Note that I have tested the tool only with ENU.
  4. Click the Open icon and open the exported Management Pack XML
  5. Click the Save icon to make the changes and save the file.  The file is first backed up to <mpFileName>.<YearMonthDateTime>.xml before being modified.
  6. Exit the tool.  If you are really paranoid (and I don’t blame you for being -:)), use windiff or another text comparer to compare the backed up and the current file.
  7. Import the modified Management Pack XML, and restart the System Center Management service.

The tool executable (in SMViewColNames.zip) and the VS2010 solution (SMViewColNames_VS2010.zip) are available here.

About these ads
  1. November 23, 2011 at 12:01 pm

    Hi, very nice solution,

    But it’s seem that the link is still not available.

    How can I have your tool ?

    Thanks for your answer

  2. Kan
    November 23, 2011 at 1:01 pm

    The link works for me even without signing into Windows Live. I will e-mail you the file.

  3. Vamshi Gupta
    May 29, 2012 at 5:18 am

    Link does not work for me neither, can you please email me the zip file ?

  4. Levi Stevens
    June 14, 2013 at 2:31 am

    I am not able to even create a view that has these columns to begin with. What am I missing?

    • Lucly
      December 16, 2013 at 11:40 am

      Levi Stevens, in the view you created, go into Criteria and instead of selecting the regular Incident view, click on the drop down menu on the right and change it from “Frequently used basic classes” to “combination classes”. Once you have down that, filter the search results to “incidents” and select the “Incident (advanced)” class. That should give you the ability to select the affected and assigned user name. Hope this helps.

  5. Ross
    September 4, 2014 at 11:49 pm

    Hi
    the link doesnt work for me
    Can you email me your tool please

  6. Kan
    September 5, 2014 at 8:28 am

    Links are now fixed. Sorry about that

  1. October 27, 2011 at 3:20 pm
  2. November 4, 2014 at 11:39 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: