Questions on - SAV role + Patch Applied Date

IAM_99
Regular Contributor II
Regular Contributor II

hi Team,

1. we created a Custom SAV role , Trying to add advanced query with logged in user as dynamic variable

"select a from Users a where a.title='Manager' and a.manager=${users.id}

but its retruning results as "select a from Users a where a.title='Manager' and a.id=${users.id}

we want to pass loggedin user but its converting to a.ID (userkey instead of manager)  tried with requestee, requestedBy it was giving error.

Can you let us know what is the dynamic variable for loggedin user ?

where to find User object - available attributes like firstname,lastname,manager etc ?

2. If we want to show some set of endpoints only to the requestor to request ( based on conditions )
Can we use SAV role - 'Access to End points' ?

3. Is there way we can know patch applied date on the Saviynt ECM instance ?

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

1. ${users.id} is logged in user. Where are trying to add query ? what is your use case?

2. Use Endpoint - Access Query Configuration

3. Considering you are on v5.5 no that's not supported


Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.

IAM_99
Regular Contributor II
Regular Contributor II

1.  ${users.id} is logged in user. 

Where are trying to add query ? 

Whom to Request 

what is your use case?

With SAV Role advanced query want to show only reportees of logged manager whose title='Manager' and cp22='Active'

You want to show user with title manager and cp22 active for requesting?


Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.

select a from Users a where a.customproperty22 ='Active' and a.statuskey <> 0 and a.title='Manager' and a.manager=${users.id}


Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.