How to change priority value and impact value

[Bakhtawar Butt]

Hi,

I want to change priority and impact dropdown value.

Impact:

 

• Individual (Default value)
• Branch / Building / Department
• Region / City
• Bank Wide

Pic is attached for reference. i want to change drop down with the above points

Same is the case with priority 

Priority:

 

• Critical
• High
• Moderate (Default)

 

[Brian Mathato]

Hi 

This can be done in two ways by changing the sym field of the relevant tables (pri and imp), either directly in the database or via internal tools (pdm_extract-->update values-->pdm_load) and making some records inactive if you do not want to see them in the list

------------------------------
Kind Regards,
Brian
------------------------------

[Bakhtawar Butt]

How can we do that by using database?

 

 

Regards,

 

Bakhtawar Butt

Officer Technical Service Desk | ITSM Division

Information Technology Group | MCB Bank Limited

3^rd Floor, MCB Building, Nila Gunmbad , Lahore

 

Landline: [phone] | IPT: 042-4610

 

[Brian Mathato]

Hi Bakhtawar,

Are you really asking how to update a table/record in the database? Excuse my ignorance or harshness, but is this not supposed to be basic database-101 that can be searched on Google?

Rather use the OOTB provided utilities. All you'll need to do is the following

1. Extract the records to a file (pdm_extract),
2. Make a copy of the file for backup
3. Modify the records in the file
4. Load back the records (pdm_load/pdm_userload)

You'll find some examples of how to use these utilities in the Tech Docs:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/administering/configure-ca-service-desk-manager/managing-your-database.html



------------------------------
Kind Regards,
Brian
------------------------------

[Bakhtawar Butt]

I am just saying it to u because I am beginner and new to this application that's the reason I am asking about how to update it using database so that u could provide me some idea or steps about how to do it.

 

It's Fine.. I will open a support case for this .

 

Thank you very much for helping me

 

 

Regards,

 

Bakhtawar Butt

Officer Technical Service Desk | ITSM Division

Information Technology Group | MCB Bank Limited

3^rd Floor, MCB Building, Nila Gunmbad , Lahore

 

Landline: [phone] | IPT: 042-4610

 

[Aamir Khan]

export Impact via pdm_extract utility and see the format and load a new file with new entry using -i argument.

for priority, ill advise to use whereclause to achieve your desire list.

Wish you best with the support case.