# Need search query to filter all the accounts for a specific source which doesnot start with E **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** identity-security-cloud\ **Created:** [April 11, 2025, 10:14am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296 "2025-04-11T10:14:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Dsinha1](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@Dsinha1](https://developer.sailpoint.com/discuss/u/Dsinha1)\ **Post date:** [April 11, 2025, 10:14am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/1 "2025-04-11T10:14:49Z")
Hello Team , I need one search query to filter all the accounts for a specific source which does not start with E. Need to save this report Trying this: @accounts(source.name:ABC AND NOT accountName:E\*) but this is not working. Please suggest ---
**Author:** ![gogubapu](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gogubapu/32/15242_2.png) [@gogubapu](https://developer.sailpoint.com/discuss/u/gogubapu)\ **Post date:** [April 11, 2025, 10:28am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/2 "2025-04-11T10:28:39Z")
Hi, In search accountName is not available, instead accountName use name, find the below screenshot other attribute we have to search inside @accounts() ![image](https://global.discourse-cdn.com/sailpoint/original/3X/9/7/970e3d69454bce5f067180f575ee507aa4aa5393.png) try below query: `@accounts(source.name:"Source Name" AND NOT name:E*)` ---
**Author:** ![Gopi2000](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gopi2000/32/21706_2.png) [@Gopi2000](https://developer.sailpoint.com/discuss/u/Gopi2000)\ **Post date:** [April 11, 2025, 10:32am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/3 "2025-04-11T10:32:07Z")
> [@Dsinha1](#): > > @accounts(source.name:ABC AND NOT accountName:E\*) Give a try with this query it works fine for me @accounts(NOT name:E\* AND source.name:ABC) ---
**Author:** ![amankumargupta](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/amankumargupta/32/29688_2.png) [@amankumargupta](https://developer.sailpoint.com/discuss/u/amankumargupta)\ **Post date:** [April 11, 2025, 10:35am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/4 "2025-04-11T10:35:14Z")
> [@Dsinha1](#): > > @accounts(s try below search query @accounts(source.name:“abc” and NOT name:e\*) ---
**Author:** ![Dsinha1](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@Dsinha1](https://developer.sailpoint.com/discuss/u/Dsinha1)\ **Post date:** [April 11, 2025, 11:08am UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/5 "2025-04-11T11:08:33Z")
This is not returning for me cz this result will return only accounts which are correlated with identities , now the machine identities are uncorrelated. basically my human user’s accoutname is getting started with EXXX , whats ever is not starting with E i need to pull up in this report ---
**Author:** ![MattUribe](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/matturibe/32/20300_2.png) [@MattUribe](https://developer.sailpoint.com/discuss/u/MattUribe)\ **Post date:** [April 11, 2025, 12:32pm UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/6 "2025-04-11T12:32:47Z")
Search only returns results for identities. It does not search data in uncorrelated accounts, because the data model is based on identity records. You can search accounts that are correlated to identities only. > **[Searchable Fields - SailPoint Identity Services](https://documentation.sailpoint.com/saas/help/search/searchable-fields.html?h=uncorrelated%20accounts)** > > SailPoint Identity Services Documentation ---
**Author:** ![MattUribe](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/matturibe/32/20300_2.png) [@MattUribe](https://developer.sailpoint.com/discuss/u/MattUribe)\ **Post date:** [April 11, 2025, 12:34pm UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/7 "2025-04-11T12:34:01Z")
The easiest thing to do may be to export an account list from your source and filter on the account column. ---
**Author:** ![jesvin90](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/jesvin90/32/5301_2.png) [@jesvin90](https://developer.sailpoint.com/discuss/u/jesvin90)\ **Post date:** [April 11, 2025, 4:17pm UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/8 "2025-04-11T16:17:20Z")
Hi @Dsinha1, You will not get the uncorrelated account details from search. It would be advisable to make use of a GET call on the accounts [API](https://developer.sailpoint.com/docs/api/v3/list-accounts) with a header as below `{{baseUrl}}/accounts?filters=sourceId eq "yourSourceId" and not name sw "EX"` ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [June 10, 2025, 4:18pm UTC](https://developer.sailpoint.com/discuss/t/need-search-query-to-filter-all-the-accounts-for-a-specific-source-which-doesnot-start-with-e/110296/9 "2025-06-10T16:18:13Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.