Is it possible to create campaign who have not logged into AD for the past 30 days?

[shaffusailpoint (Shafuu khan)]

Is it possible to create campaign who have not logged into AD for the past 30 days?

[RAKGDS (Rakesh Bhati)]

Hi Shafuu,
Can you try the below query and see if you are getting the correct result ?

lastLogin:<now-30d AND source.name:"Source Name"

[shaffusailpoint (Shafuu khan)]

Just now tried, getting zero

[sidharth_tarlapally (TARLAPALLY SIDHARTH)]

Hi @shaffusailpoint

Is this last login attribute mapped as Identity attribute ?

[Muhammad_Mustafa]

Hi @shaffusailpoint,

A few things to check:

Ensure the lastLogin or lastLogonTimestamp attribute from Active Directory is part of the account schema and is getting populated during aggregation.

Verify that this attribute is mapped to an identity attribute in the Identity Profile mappings.

Confirm that the values are in a proper date format so SailPoint ISC can evaluate them in queries.

After confirming the mapping, run an identity refresh or wait for the next aggregation to update the data.

Once all the above are in place, retry the query. Let me know if you need help verifying any of these.

Regards,
Muhammad