Hi, I am trying to fetch the incomplete identity details using search query(condition is , uid is null or email is null or lastname is null) I am not getting expected result when I try with this query “((appType eq ‘identity’) AND (uid is null OR lastname is null OR email is null))” It is fetching…

Hi @harishhaleon , Have you tried something like this.? (NOT _exists_:attributes.lastname) OR (NOT _exists_:attributes.email) OR (NOT _exists_:attributes.uid)

I believe this search query might be of use: NOT attributes.email:* OR NOT attributes.lastname:* OR NOT attributes.uid:*

Hi @harishhaleon , Kindly check the documentation on building search query: Building a Search Query - SailPoint Identity Services SailPoint Identity Services Documentation You can use exists keaword for getting list of identities with specific requirements.

I have tried all these which is given below but query is not returning expected identity details @bhushan008 @jesvin90 @sauvee (NOT_exists_:attributes.lastname) OR (NOT_exists_:attributes.email) OR (NOT_exists_:attributes.uid) ((appType eq ‘identity’) AND ((NOT exists:attributes.lastname) OR (NOT e…

[image] Harish G: (NOT_exists_:attributes.lastname) OR (NOT_exists_:attributes.email) OR (NOT_exists_:attributes.uid) You seem to have missed a space after NOT ? This is the correct format : (NOT _exists_:attributes.lastname) OR (NOT _exists_:attributes.email) OR (NOT _exists_:attributes.ui…

Hi @jesvin90 - Yes, I have pasted without space here but tried with space,still not working. Actually, your solution should work, but not sure what is wrong! [image]

Hi @harishhaleon , I tested this out in my tenant and the behavior looks the same as you are seeing. And the users with missing emails does not even show up in any search results. I would be curious to know if this was something that used to work earlier as the documentation suggests using NOT _exi…

@jesvin90 - Please let me know if you have any findings! Thanks, Harish G

Search query for mandatory attribute

Identity Security Cloud (ISC) ISC Discussion and Questions

Karthikeyan_U (Karthikeyan Udhayasurian) May 24, 2024, 10:02am 8

Hi Harish,

I don’t think we can get this information using the search queries, since those are all mandatory attributes for an Identity. Those Identities will not be properly promoted unless those issues are resolved. You can get the error report from the Identity Profile mapping itself.

Thanks

Topic		Replies	Views
Incomplete Identities report ISC Discussion and Questions identity-security-cloud , identities	6	242	July 30, 2024
Identities turned out to be incomplete when it had missing lastname/email ISC Discussion and Questions identity-security-cloud	6	108	June 6, 2025
How to search identities based on account attribute ISC Discussion and Questions identity-security-cloud , search	8	1119	May 22, 2025
Searching for Email attribute using the exact value returns ALL identities in the system Bugs identity-security-cloud , search , attributes , fixed	4	299	May 30, 2024
Query on Search ISC Discussion and Questions apis , identity-security-cloud , search	3	423	April 8, 2024

Search query for mandatory attribute

Related topics