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 export SAP account details with associated Auth Object

MT
New Contributor II
New Contributor II

We have a requirement to export all the SAP accounts with below information
Auth Object
Entitlement associated
Parent Role 
Role

Any assistance is appreciated

Thanks
Mohammed Tousif

13 REPLIES 13

rushikeshvartak
All-Star
All-Star

Please share sample data with screenshot


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

MT
New Contributor II
New Contributor II

MT_0-1713507083127.png

 

MT
New Contributor II
New Contributor II

@rushikeshvartak 
Please find the below the screenshot of account details we are trying to export.

MT_0-1713525909968.png

 

You can get this information under below tables

  • entitlement_value_attrs

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

vyadav
New Contributor
New Contributor

Hi @rushikeshvartak 

We tried to fetch information from Entitlement_value_attrs table but getting a data in below format.Could you please let us know if we need to join others table as well.

vyadav_0-1713886396084.png

 

Thank you,

Varsha

Join with entitlment_Values table


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

vyadav
New Contributor
New Contributor

Hi @rushikeshvartak 

Above table we didn't get the relevant information. Could you please let us know in which table the auth object value will be store?

Thank you

Varsha

I am still figuring out fieldkey mapping here 

rushikeshvartak_0-1714103200321.pngrushikeshvartak_1-1714103217019.png

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Hi @rushikeshvartak 

Thanks for your input.

fieldkey you can map with fileds table, it will work.

Thank you,

Varsha

 

Yes correct 

rushikeshvartak_0-1714417041138.png


SELECT a.NAME,
       ev.entitlement_value,
       ev.entitlement_valuekey,
       ao.objectname              AS 'Auth Object',
       Concat('Field Name ', f.fieldname, ' Min Value ', eo.minvalue,
       ' Max Value ', eo.mxvalue) value
FROM   account_entitlements1 ae,
       accounts a,
       entitlement_values ev,
       endpoints e,
       securitysystems ss,
       entitlement_objects eo,
       access_objects ao,
       fields f
WHERE  ae.accountkey = 1085788
       AND ev.entitlement_value = 'ZP-CF1-FI271'
       AND a.accountkey = ae.accountkey
       AND ae.entitlement_valuekey = ev.entitlement_valuekey
       AND e.endpointkey = a.endpointkey
       AND e.securitysystemkey = ss.systemkey
       AND eo.entitlement_valuekey = ev.entitlement_valuekey
       AND ao.objectkey = eo.objectkey
       AND eo.field_key = f.fieldkey 

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

vyadav
New Contributor
New Contributor

Hi @rushikeshvartak 

Can we get tcode value also?

Thank you

vyadav
New Contributor
New Contributor

Hi @rushikeshvartak 

With Auth obejct we need tcode data as well. From which table we can get it ?

👍Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.

Please create new thread for new ask.


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.