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.
We are using query like below :
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.
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?
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.
Thanks for the response.
We just want to fetch the Tcodes for which the request has been raised.
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.