Archive

Archive for April, 2011

Tool for editing Service Manager view column names

April 2, 2011 9 comments

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.