How to export SAP account details with associated Auth Object

[MT]

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

[rushikeshvartak]

Please share sample data with screenshot

[MT]

[MT]

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

[rushikeshvartak]

You can get this information under below tables

• entitlement_value_attrs

[vyadav]

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.

Thank you,

Varsha

[rushikeshvartak]

Join with entitlment_Values table

[vyadav]

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

[rushikeshvartak]

I am still figuring out fieldkey mapping here 

[vyadav]

Hi @rushikeshvartak 

Thanks for your input.

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

Thank you,

Varsha

[rushikeshvartak]

Yes correct 

---

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 

[vyadav]

Hi @rushikeshvartak 

Can we get tcode value also?

Thank you

[vyadav]

Hi @rushikeshvartak 

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

[rushikeshvartak]

✅👍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.