Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to Fetch Tcodes information from Request

AravindK
Regular Contributor
Regular Contributor

Hi Team, 
We are trying to fetch the Tcode information from the request(request type: Emergency Session request) but we are not able fetch or figure out in which table it stores this value.

AravindK_1-1693292696189.png

We are using query like below :

SELECT DISTINCT
SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID, '.', - 1) AS REQUESTNUMBER ,
AR.ENDPOINTASCSV AS 'ENDPOINT NAME',
concat(U.USERNAME,'[',U.FIRSTNAME,' ',U.LASTNAME,']') AS 'USERNAME',
A.NAME AS 'ACCOUNTNAME',
EV.ENTITLEMENT_VALUE AS 'TCODE' 
FROM ARS_REQUESTS AR LEFT JOIN REQUEST_ACCESS RA ON AR.REQUESTKEY=RA.REQUESTKEY 
LEFT JOIN USERS U ON RA.USERKEY=U.USERKEY
LEFT JOIN ACCOUNTS A ON RA.ACCESSKEY=A.ACCOUNTKEY 
LEFT JOIN ENTITLEMENT_VALUES EV ON RA.REQUESTKEY=EV.ENTITLEMENT_VALUEKEY
WHERE AR.REQUESTTYPE='23' and SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID, '.', - 1) = '24908132'

Please help us on the same.

6 REPLIES 6

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @AravindK,

Thank you for your engagement with the Saviynt forums. ,we are checking on this and we wil keep you posted.In the meantime, we kindly request you to share additional details pertaining to the query in question. Specifically, could you elaborate on the nature of the details being fetched by the query? Furthermore, have you encountered any error messages or issues while executing the above mentioned query?

AravindK
Regular Contributor
Regular Contributor

Hi @DixshantValecha ,
Above mentioned query not returning any error messages but as i mentioned it is not fetching the TCODE information. Looking for TCODE info as it is showing in the request page.
Output :

AravindK_0-1693475872754.png

 

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @AravindK,

Thank you for your recent update and for reaching out to Saviynt Support. We appreciate your inquiry concerning Tcodes. To provide you with the most accurate assistance, we would like to clarify the specific information you are seeking regarding Tcodes.

Tcodes are stored in different tables, and we want to ensure we address your query effectively. Could you please specify whether you are looking for the actual Tcodes themselves or if you are interested in the metadata associated with these Tcodes? This clarification will help us provide you with precise and relevant information to meet your requirements.

AravindK
Regular Contributor
Regular Contributor

Hi @DixshantValecha 
Thanks for the response. 

We just want to fetch the Tcodes for which the request has been raised. 
Ex: 
In the below screenshot, request has been raised for these TCODES and we are trying to pull the data including Tcode details. We are able to pull all the details but not Tcode details from request.

AravindK_0-1693827712502.png

 

IAM-Vaibhav
New Contributor III
New Contributor III

@DixshantValecha 

Any update for us?. we observed while troubleshooting Tcodes aren't stored directly in any column value. 

Is it stored as JSON in any column.

 

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @AravindK,

The above query that you are using is wrong as you are checking entitlement_value = ‘tcode’  

that is wrong as tcode is an entitlement type and entitlement value names will be eg (ME22N, ME52N ,etc).