I want a search query that finds only non employee accounts with an end date and date within the next 7 days and not already expired, any idea? Have tried the below , NOT(attributes.type:“Employee”) AND attributes.endDate:<NOW+7d
NOT (attributes.type:“Employee”) AND attributes.endDate:[now TO now+7d]
NOW should be replaced with now :
(NOT (attributes.type:"Employee")) AND (attributes.endDate:[now TO now+7d])
Thank you so much!
Also, Is it possible to have the report results in the subscription email rather than clicking the link?
Yes !
You can review the template and by default there are a table to display result but based on result size i think.
Do you already modify the default template ?
No, I didn’t modify the default template, can you show me please?
yep, but the default email provided by SailPoint doesn’t show the preview cells as expected. There’s a limitation up to 20 but the report that I generated contains only a few.
You can update by replacing 20 by 1 for example
Still the identity results in the preview are not showing up. There are only 3 results in my query, I would like to show them to the email recipients but it’s not working
You can keep 20 by default and check the following option : “Add a detailed summary of results to the report”
I toggled it ON already…also I verified by sending a test email, even in that preview cells is not showing up
Test email cannot show the table. You have to schedule.
1 Like
Thank you so much, will give it a try
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.