Purpose

Service Management Administrators can rename their Service Management (name being displayed in the Customer Portal), which might not necessarily be obvious to which project it belongs to. If you find yourself in such a situation and you want to identify which project does a particular Service Management belong to, this article will help.

Solution

Database

• An admin can change the name of the Service Management for each project. This information is stored in the AO_54307E_VIEWPORT table in the database
  • The NAME column holds this information. You can also identify which project this Service Management is associated to by the PROJECT_ID column

• The following query will help you identify the project along with the name of the Service Management

  select p.id,p.pname,p.pkey,AO."NAME" from project p join "AO_54307E_VIEWPORT" AO on p.id=AO."PROJECT_ID";
  

  This query is written for PostgreSQL. You might have to re-write it to suit the database you are using

REST API

• First, get the link of that particular Service Management which you want to find out which project it is from. This can be done by just clicking on the Service Management in the Customer Portal. Link would be in the following format: <Base URL>/servicedesk/customer/portal/<id>
• As an admin, run the following REST call
  • GET /rest/servicedeskapi/servicedesk

• It will provide a response such as the following

  {
      "size": 2,
      "start": 0,
      "limit": 50,
      "isLastPage": true,
      "_links": {
          "base": "http://localhost:8080/jira",
          "context": "/jira",
          "self": "http://localhost:8080/jira/rest/servicedeskapi/servicedesk"
      },
      "values": [
          {
              "id": "1",
              "projectId": "10000",
              "projectName": "Service Management A",
              "projectKey": "SDA",
              "_links": {
                  "self": "http://localhost:8080/jira/rest/servicedeskapi/servicedesk/1"
              }
          },
          {
              "id": "2",
              "projectId": "10001",
              "projectName": "Service Management B",
              "projectKey": "SDB",
              "_links": {
                  "self": "http://localhost:8080/jira/rest/servicedeskapi/servicedesk/2"
              }
          }
      ]
  }

• From the response, you can compare the link from the first step to the links provided in the response to identify the project