Delete Garbage Identity from SailPoint

Hi @y_mohan_krishna

yes you can add all the links id delete commands into one file and use Source command to execute delete of all those links.

unfortunately, i didnt have any pdf of steps handy. but i think below draft steps might help:

  1. execute query SELECT id FROM [identityiq].[spt_link] where display_name like ‘garbage%’ or native_identity like ‘garbage%’
  2. copy the ids from the above query results
  3. built a text file apending delete link before every id (one command in one line) which looks like
    delete link id1
    delete link id2
    .
    .
    delete link idn
  4. open iiq console refere to this document how to use iiq console and execute source commad [https://community.sailpoint.com/t5/IdentityIQ-Product-Guides/8-4-IdentityIQ-Console-Guide/ta-p/240692]
  5. write a resource custimsation rule in all applicable applications (to avoid bringing those links back to sailpoint again) refere previous responses for examples.

hope this helps.

Thanks

1 Like