We are looking for a Search query for Pending Access Requests which were created, which will export the Assigned To manager name, along with the Requested For employee name, and the name of the Access Profile in the request

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

We are looking for a Search query for Pending Access Requests which were created, which will export the Assigned To manager name, along with the Requested For employee name, and the name of the Access Profile in the request. The goal is to get a list of the managers who are holding up the approval process so we can contact them directly.

1 Like
2

Have you tried below API call?

image
image801×805 72.6 KB

3

Something like this (PowerShell SDK, one line):
Get-v2024PendingApprovals | select requestCreated, @{name="Access Object Name";expression={$_.requestedObject.name}},@{name="Access Object Type";expression={$_.requestedObject.type}},@{name="Approver Name";expression={$_.owner.name}} | where "Access Object Type" -eq "ACCESS_PROFILE"

Sort it as you see fit. Add additional where conditions as required.

4

Let me try and provide one query for you.

5

If you're trying to fetch Pending Access Requests in SailPoint IdentityNow (Identity Security Cloud) along with: Requested For (employee name)
Assigned To (manager/approver name)
Access Profile name

You can do this using a Get request to the following API:

https://<your-tenant>.api.identitynow.com/v2025/access-request-approvals/pending
(Replace <your-tenant> with your actual tenant URL.)

{ "indices": ["access-request"], "query": { "query": "status:PENDING" }, "includeNested": true, "fields": [ "requestedFor.displayName", "assignedTo.displayName", "accessItems.accessProfile.displayName" ], "sort": [ { "created": { "order": "desc" } } ] }

6

Can we get any search query

7

image
image1376×813 52.4 KB

getting error

8

ISC response
ISC response1663×830 91.1 KB

If you're trying to fetch Pending Access Requests in SailPoint IdentityNow (Identity Security Cloud) along with: Requested For (employee name)
Assigned To (manager/approver name)
Access Profile name

You can do this using a Get request to the following API:

https://<your-tenant>.api.identitynow.com/v2025/access-request-approvals/pending
(Replace <your-tenant> with your actual tenant URL.)

{ "indices": ["access-request"], "query": { "query": "status:PENDING" }, "includeNested": true, "fields": [ "requestedFor.displayName", "assignedTo.displayName", "accessItems.accessProfile.displayName" ], "sort": [ { "created": { "order": "desc" } } ] } - it worked out