Terminated users report

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

Hi Team,
I am currently working on generating a report of terminated users for the past seven days, which I would like to distribute to a designated group of individuals.

One approach I am considering is developing a PowerShell script that utilizes the ISC query to generate the report, convert it to JSON format, and then email it to the distribution list. I am unsure if this is feasible, but I believe it could streamline the process.

I would greatly appreciate any insights or guidance you could provide on this idea. Thank you for your assistance!

2

Hi,

You can directly leverage on search subscription and subscribe to search query for this report.

You can use:
attributes.endDate:[now-7d TO now].

Below is the documentation on search queries.

https://community.sailpoint.com/t5/IdentityNow-Articles/IdentityNow-Common-Search-Queries/ta-p/75319

Do you have any specific need for power shell script?

-Abhinov

3

Catch is user needs to have at least Report admin access to download or accessing the report, which we are trying to avoid to give to a bunch of people!

4

Hi,

In that case you can make use of powershell to make API call and using SMTP you can send the report in mail.

Another advantage of powershell is you can create custom headers according to requirement.

-Abhinov

5

Is there any sample script and steps you can share which can help in configuring this process!

6

Hi @Prashanth0707,

Just thinking if you could use Workflows instead of using a PowerShell script.

  1. Schedule a report using Saved Search Queries.
  2. Use Scheduled Search Trigger to fetch the results from the query and send it out to users using Send Email action.
7

Hi @Prashanth0707
You can achieve using any scripting language to call the respective APIs and export CSV but I personally prefer SDKs developed by @developer_relations_team.
If you are familiar with PowerShell then you can check PowerShell SDK | SailPoint Developer Community.
However, I use typescript version of it.

8

@Prashanth0707 you can write a powershell code for searching and exporting it to csv below code you can refer .if it helps you can mark it as solution.
Thanks
Shantanu
search export new.txt (2.7 KB)

1 Like