I am working with the Azure AD connector and want to leverage the lastSignInDateTime and lastNonInteractiveSignInDateTime on identities, but I’m having an issue in the identity profile mappings coming up with the correct transform. It looks to be formatted correctly without a transform, but it sounds like I have to do a transform to explicitly tell IdentityNow it’s ISO8601
I wasn’t sure what you meant until you posted this last message… Yes! With the code you posted it will use implicit input which uses whatever is mapped in the UI as the input to the transform.
Hmmm, It looks like you have everything correct to me. I tried this on a source I setup in our tenant and it was filtering correctly. The only difference between the query I used and yours is I used .exact on the identityProfile.name to match my identity Profile.
To search on attributes your name must be the technical name of the attribute (the one in parentheses) in the identityProfile mappings tab, in my case below startDate. With that being said it looks like you have that correct as well…
attributes.startDate:<2023-01-01 AND identityProfile.name.exact:"CSVSourceNew"