none
Urgency and Impact Description Modification

    Question

  • I am trying to customize the urgency and impact to use simple words which will increase accuracy. I am changing Impact to (Low:Single user, Med: Department, LOB, VIP, High, Entire Facility, Group of VIPs) and similiar for Urgency. Does anyone know how to remove the original High, Medium, Low or even change their name? I can add these descriptors but can't get rid of the original junk.

     

    mardi 14 décembre 2010 22:31

Réponses

  • OK - so basically what you are going to have to do is update the LocalizedText table in the ServiceManager database.  Before I explain this though - the usual caveats:

    1) This is not supported.

    2) This could cause a major problem to all the display strings in your system if you write your query wrong and run it.

    3) There are no warranties expressed or implied here. :)

    4) Backup your database first.

    5) Run the select query first to make sure that you are going to update just the right values.

    6) Try this out on a test system first.

    7) An MP upgrade in the future will probably overwrite your changes and you'll have to do this again.

    8) Don't do this unless you absolutely have to and there is no other way.  One good example of there not being another way is when you are trying to change the display name of a EnumerationValue (aka 'list item') that we shipped in a sealed MP.

    9) Doing this will not change the behavior in reports.  That's a whole different thing that I'm not explaining how to do here.

    10) Don't call me if this doesn't work or you blow something up! :)

     

    Here's how you do it:

    1) First run a query to find the exact object you need to update:

    select * from LocalizedText where ElementName like '%Urgency%'

    This will get you back some results such as:

    System.WorkItem.TroubleTicket.UrgencyEnum.Low

    System.WorkItem.TroubleTicket.UrgencyEnum.Medium

    System.WorkItem.TroubleTicket.UrgencyEnum.High

    There will be one row for each combination of the following:

    FOR EACH MP element FOR EACH Language FOR EACH Display String AND FOR EACH Description

     

    2) Now run a query like this passing in the language code, MP element ID, and the appropriate LTStringType

    select * from LocalizedText where
    LanguageCode = 'ENU' and
    LTStringType = 1 and
    MPElementID = '2F8F0747-B6CB-7996-FD4A-84D09743F218'

     LTStringType = 1 is the Display Name of the MP element and LTStringType=2 is the description of the MP element.

    You should get back one and ONLY ONE row by using this query.

    3) Then copy the where clause of that query and do an update statement like this

    update LocalizedText set LTValue = 'Really High' where
    LanguageCode = 'ENU' and
    LTStringType = 1 and
    MPElementID = '2F8F0747-B6CB-7996-FD4A-84D09743F218'

    Specify the display string that you want in the LTVAlue ='<something here>'.

    4) Restart the System Center Data Access Service and the console to update the cache.


    Travis Wright Senior Program Manager Microsoft
    jeudi 16 décembre 2010 19:53

Toutes les réponses

  • The only way to modify those is via an unsupported database hack.  Want to know how to do it? :)
    Travis Wright Senior Program Manager Microsoft
    mardi 14 décembre 2010 23:27
  • I would if there's a similar one to alter the default asset staus list in the same way (remove/rename the original values)

    http://social.technet.microsoft.com/Forums/en-US/systemcenterservicemanager/thread/9ab0b189-2308-4879-950f-1c18cd025c42

    Cheers,
    SB


    My System Center Blog
    mercredi 15 décembre 2010 15:39
  • Yes, please share.
    mercredi 15 décembre 2010 22:25
  • OK - so basically what you are going to have to do is update the LocalizedText table in the ServiceManager database.  Before I explain this though - the usual caveats:

    1) This is not supported.

    2) This could cause a major problem to all the display strings in your system if you write your query wrong and run it.

    3) There are no warranties expressed or implied here. :)

    4) Backup your database first.

    5) Run the select query first to make sure that you are going to update just the right values.

    6) Try this out on a test system first.

    7) An MP upgrade in the future will probably overwrite your changes and you'll have to do this again.

    8) Don't do this unless you absolutely have to and there is no other way.  One good example of there not being another way is when you are trying to change the display name of a EnumerationValue (aka 'list item') that we shipped in a sealed MP.

    9) Doing this will not change the behavior in reports.  That's a whole different thing that I'm not explaining how to do here.

    10) Don't call me if this doesn't work or you blow something up! :)

     

    Here's how you do it:

    1) First run a query to find the exact object you need to update:

    select * from LocalizedText where ElementName like '%Urgency%'

    This will get you back some results such as:

    System.WorkItem.TroubleTicket.UrgencyEnum.Low

    System.WorkItem.TroubleTicket.UrgencyEnum.Medium

    System.WorkItem.TroubleTicket.UrgencyEnum.High

    There will be one row for each combination of the following:

    FOR EACH MP element FOR EACH Language FOR EACH Display String AND FOR EACH Description

     

    2) Now run a query like this passing in the language code, MP element ID, and the appropriate LTStringType

    select * from LocalizedText where
    LanguageCode = 'ENU' and
    LTStringType = 1 and
    MPElementID = '2F8F0747-B6CB-7996-FD4A-84D09743F218'

     LTStringType = 1 is the Display Name of the MP element and LTStringType=2 is the description of the MP element.

    You should get back one and ONLY ONE row by using this query.

    3) Then copy the where clause of that query and do an update statement like this

    update LocalizedText set LTValue = 'Really High' where
    LanguageCode = 'ENU' and
    LTStringType = 1 and
    MPElementID = '2F8F0747-B6CB-7996-FD4A-84D09743F218'

    Specify the display string that you want in the LTVAlue ='<something here>'.

    4) Restart the System Center Data Access Service and the console to update the cache.


    Travis Wright Senior Program Manager Microsoft
    jeudi 16 décembre 2010 19:53
  • This solution worked. I will keep testing to see if anything broke. Thank you for the help.

    vendredi 17 décembre 2010 04:44
  • Why is it always me?

    I tried this to change the Asset Status list and while I can see it's updated the database, the console still shows the old values.

    Any ideas?


    My System Center Blog
    mardi 21 décembre 2010 13:13
  • Try restarting the System Center Data Access Service and the console.  It might be a caching issue.
    Travis Wright Senior Program Manager Microsoft
    mardi 21 décembre 2010 14:50
  • Yey, works a treat, thanks Travis.


    My System Center Blog
    mardi 21 décembre 2010 15:00
  • How do I remove them, or at least make them not mandatory fields?
    mercredi 13 juin 2012 23:51