# It is possible to list accounts that are active in some source, but without a profile

**URL:** <https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555>\
**Category:** SHF Discussion and Questions\
**Tags:** sailpoint-identity-security\
**Created:** [August 12, 2024, 7:48pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555 "2024-08-12T19:48:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![clebercarvalhoRaise](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/clebercarvalhoraise/32/17511_2.png) [@clebercarvalhoRaise](https://developer.sailpoint.com/discuss/u/clebercarvalhoRaise)\
**Post date:** [August 12, 2024, 7:48pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/1 "2024-08-12T19:48:19Z")

</div>

It is possible to list accounts that are active in some source, but without a profile.

I used this query without success

 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/d/d7d90dbe25371f851d5e89f26dbb571647fc9ffe.png)

---

<div class="post-metadata">

**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\
**Post date:** [August 12, 2024, 7:55pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/2 "2024-08-12T19:55:32Z")

</div>

Try

```auto
@accounts(source.name.exact:"Neurotech API - BR V2") AND NOT @access(source.name.exact:"Neurotech API - BR V2")

```

That should show people who have an account in a source but no access

---

<div class="post-metadata">

**Author:** ![clebercarvalhoRaise](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/clebercarvalhoraise/32/17511_2.png) [@clebercarvalhoRaise](https://developer.sailpoint.com/discuss/u/clebercarvalhoRaise)\
**Post date:** [August 12, 2024, 11:31pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/3 "2024-08-12T23:31:56Z")

</div>

Is it possible to create a routine to deactivate these accounts?

---

<div class="post-metadata">

**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\
**Post date:** [August 13, 2024, 12:49pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/4 "2024-08-13T12:49:45Z")

</div>

I don’t have workflows in my tenant but I would imagine you could create a scheduled workflow to run that search, and for each identity returned, run a [disable-account](https://developer.sailpoint.com/docs/api/v3/disable-account) API call

---

<div class="post-metadata">

**Author:** ![LiamAndrewBrowne](https://avatars.discourse-cdn.com/v4/letter/l/57b2e6/32.png) [@LiamAndrewBrowne](https://developer.sailpoint.com/discuss/u/LiamAndrewBrowne)\
**Post date:** [August 13, 2024, 1:29pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/5 "2024-08-13T13:29:39Z")

</div>

Hi,

As mentioned by Mark, you could use the Workflows module to achieve this.

Have a scheduled trigger run when you want to execute the workflow, e.g. daily at 1:00AM.

You can then get a list of Identities via the search query & input them into a loop which then gets each identities accounts & disables them. the workflow then ends once the loop is finished iterating through the identities(capped at 250).

I’ve attached a template workflow as a starter for better understanding - hope this helps.

[Disablefromsearchquery.json](https://developer.sailpoint.com/discuss/uploads/short-url/3MVGscUiyhe8rJzsmOEmpb51NGq.json) (437 Bytes)

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [October 12, 2024, 1:30pm UTC](https://developer.sailpoint.com/discuss/t/it-is-possible-to-list-accounts-that-are-active-in-some-source-but-without-a-profile/76555/6 "2024-10-12T13:30:19Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.