Table/attributes names needed for Analytic report

[Yogendra]

Table/attributes names needed to include RequestID , Requested Emergency Access ID, Requested Tcodes from a Fire Fighter Access ID request into an analytic report.

Request you to refer to the attached document which contains the present config along with the requirement and the issue. The sections have also been illustrated with the screenshots for your reference.

Do let me know in case anything else is needed. 

We can also connect over call at the time that suits you, if needed.

Regards,

Yogendra Shukla

[sk · Accepted solution]

You need to use

1. ars_requests to get requestid (you need to substring value of JBPMPROCESSINSTANCEID) ,
2. request_access to get access id
3. request_access_attrs to get Tcodes ( you need to use condition where attribute_name=Tcode and get attribute_value)

[Yogendra]

I am getting the error : Error : SELECT command denied to user 'ssmdau'@'100.64.180.82' for table 'request_access_attrs'

[rushikeshvartak · Accepted solution]

Raise ticket with saviynt support or

run query from analytics

analytics - create new analytics - sql query -

add any analytics name , sub type , risk

add above query click on preview 

[Yogendra]

Hi,

Request you to kindly suggest which tables/attributes can be used to fetch the  account & child entitlements association. I am using the endpoints ,accounts  ,account_entitlements1 , entitlement_values , entitlement_types tables but getting only the accounts & entitlements mapping, whereas the requirement is that along with account-entitlements mapping I should get account-child entitlements mapping as well. Basically I want to fetch associated entitlements section of an account from the schema.

Regards

Yogendra

[rushikeshvartak]

Can you help me with screenshot what you need.

it should be there in associatedentitlements table

[Yogendra]

Hi Rushikesh,

Thanks for the response. Please find the attached doc which contains screenshots of present config and requirement.

Regards,

Yogendra

[rushikeshvartak]

associatedentitlements

[Yogendra]

Hi Rushikesh,

Can you please suggest which table/attribute should I use to fetch the Business Justification which was entered while raising a request for Emergency Access IDs.

Regards,

Yogendra Shukla

[rushikeshvartak]

access_approvers

[Yogendra]

Hi Rushikesh,

Can you please let me know which table/attribute should be used to fetch the selected Allowed action (Accept, Revoke, Further Actions) or Comments from one report into a different report.

In other words,

Do you know in which table/attribute does the value of Allowed Actions (Accept,Revoke,Further Action) is stored when a user selects any of these in a actionable report.

Kindly refer the screenshots

Regards,

Yogendra Shukla