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

SQL for completed requests of a specific entitlement type under a condition

Stauber
New Contributor III
New Contributor III

Hello, 

I am trying to find help on creating a SQL query to find all completed requests on SAP role entitlements that have text in cp6 from the past three days. The endpoint name is EP1CLNT300, and the entitlement type is saprole. Most of these saprole entitlements are ordered as part of application roles, so I think I need to query for completed tasks, isn't it?

I am thankful for any help. 

Sebastian 

3 REPLIES 3

Raghu
Valued Contributor III
Valued Contributor III

@Stauber  can you provide completed task or complated request in approval page?


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

Can you share draft query you tried so far


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