How can generate a custom report of total requests raised via Sailpoint within a particular timeframe

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

How can generate a custom report of total requests raised via Sailpoint within a particular timeframe along with request history and approvals/reject decisions made on those requests for whole entitlements & for Particular set of entitlements for our Audit purpose

2

@vsekar7 Check this post

3

Hi Theja,

Do you have any example workflow to pull the required report ?

4

i have powershell script in these format do you need
“Access Item”,“Requester”,“Recipient”,“Approvers”,“Requested Date”,“Approval Status”,“Provisioning Status”,“Access Request ID”

5

Hi Chaitanya,

Can you please share the powershell script file so that I can use it as my reference to create my own script

6

access request report within certain time.ps1 (4.7 KB)

add client id and seceret and url and date accordingly

1 Like
7

Hi @Chaithu9110 ,

The script is ending at 250 items due to pagination with below error. Can you help me to extract the complete list of requests raised.

Error Message:

PS C:\Users\admin_vsekar7> E:\Venkat\Sailpoint ISC Reports\access request report within certain time.ps1
:date: Date filter: 01-10-2025 to 24-10-2025
:locked_with_key: Getting access token…
:white_check_mark: Access token received.
:inbox_tray: Fetching access request statuses…
:page_facing_up: Retrieved 250 items… Total: 250
WARNING: :warning: Pagination stuck — duplicate ‘searchAfter’ value. Breaking loop.
:white_check_mark: Total access requests fetched: 500
:bar_chart: Removing duplicates and building report…
:soap: Deduplicated total: 250
:floppy_disk: Exporting report to: E:\Venkat\Sailpoint ISC Reports\SailPoint_Access_Report_24-10-2025.csv
:white_check_mark: Report generated successfully.

8

Hi @Chaithu9110 ,

Do you have any update for my query

9

i have not get a change look on my code these week i will look on it

Thanks,
Chaithu

1 Like