Overview
You want to update the plan name of a Product Code.
Solution
Open a support request mentioning:
- The Product Code for which the plan name needs to be changed.
- The updated text of the plan name.
<supportagent>
You should have access to the Jump server for performing the below steps:
- Login to the Jump server 10.185.40.141.
- Open Microsoft SSMS and connect to
aes.cons.com
. - Select
New Query
in the top bar. - Find the
ProductID
:
use <Client specific Database>;
select * from Product where ProductCode='<Product Code provided by the client>';
- Update the
Description
field for the product found in the previous query:
use <Client specific Database>;
update Product set Description='<client provided update text for plan name>' where ProductID=<Value of ProductID column from the results of the previous query>
</supportagent>
Priyanka Bhotika
Comments