# 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 **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** identity-security-cloud, search\ **Created:** [April 23, 2025, 7:03pm UTC](https://developer.sailpoint.com/discuss/t/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/114750 "2025-04-23T19:03:06Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![RahulMekala](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@RahulMekala](https://developer.sailpoint.com/discuss/u/RahulMekala)\ **Post date:** [April 23, 2025, 7:03pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/1 "2025-04-23T19:03:06Z")
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. ---
**Author:** ![dgandhi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/dgandhi/32/28686_2.png) [@dgandhi](https://developer.sailpoint.com/discuss/u/dgandhi)\ **Post date:** [April 23, 2025, 7:35pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/2 "2025-04-23T19:35:11Z")
Have you tried below API call? ![image](https://global.discourse-cdn.com/sailpoint/original/3X/f/5/f50365f99768aa5b5e7dd4ac2cc293481dc6be08.png) > **[list-pending-approvals | SailPoint Developer Community](https://developer.sailpoint.com/docs/api/v3/list-pending-approvals/)** > > \ **Author:** ![David\_Norris](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@David\_Norris](https://developer.sailpoint.com/discuss/u/David_Norris)\ **Post date:** [April 23, 2025, 7:56pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/3 "2025-04-23T19:56:31Z") 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. ---
**Author:** ![narayanag](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/narayanag/32/25441_2.png) [@narayanag](https://developer.sailpoint.com/discuss/u/narayanag)\ **Post date:** [April 23, 2025, 8:24pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/4 "2025-04-23T20:24:22Z")
Let me try and provide one query for you. ---
**Author:** ![narayanag](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/narayanag/32/25441_2.png) [@narayanag](https://developer.sailpoint.com/discuss/u/narayanag)\ **Post date:** [April 23, 2025, 9:28pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/5 "2025-04-23T21:28:01Z")
`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://.api.identitynow.com/v2025/access-request-approvals/pending` `(Replace 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" } }] }` ---
**Author:** ![mrahulbb](https://avatars.discourse-cdn.com/v4/letter/m/96bed5/32.png) [@mrahulbb](https://developer.sailpoint.com/discuss/u/mrahulbb)\ **Post date:** [April 24, 2025, 11:20am UTC](https://developer.sailpoint.com/discuss/t/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/114750/6 "2025-04-24T11:20:29Z")
Can we get any search query ---
**Author:** ![mrahulbb](https://avatars.discourse-cdn.com/v4/letter/m/96bed5/32.png) [@mrahulbb](https://developer.sailpoint.com/discuss/u/mrahulbb)\ **Post date:** [April 24, 2025, 5:49pm UTC](https://developer.sailpoint.com/discuss/t/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/114750/7 "2025-04-24T17:49:24Z")
![image](https://global.discourse-cdn.com/sailpoint/original/3X/4/1/417204dc378fae69149037d1785f70ff8cb605ee.png) getting error ---
**Author:** ![narayanag](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/narayanag/32/25441_2.png) [@narayanag](https://developer.sailpoint.com/discuss/u/narayanag)\ **Post date:** [April 25, 2025, 6:44am UTC](https://developer.sailpoint.com/discuss/t/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/114750/8 "2025-04-25T06:44:42Z")
![ISC response](https://global.discourse-cdn.com/sailpoint/original/3X/8/e/8e412639f4eb5e89cb57cb8a1ada63b0f159231f.jpeg) `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://.api.identitynow.com/v2025/access-request-approvals/pending` `(Replace 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 ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [June 24, 2025, 6:45am UTC](https://developer.sailpoint.com/discuss/t/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/114750/9 "2025-06-24T06:45:33Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.