TomC.75736 (Peninsula College) asked a question.
I have created two workflows that search for Deprovisioned users and deletes them. They work great.
Now I am trying to fine tune it to only delete the users who have been deprovisioned for over 12 months. What would be the best way to filter out those users before sending to the delete flow.
Hello @TomC.75736 (Peninsula College) Thank you for posting on our Community page!
The Okta Community Questions forum isn't really meant for in-depth troubleshooting.
I would recommend opening a Support ticket, then continuing the discussion with the assigned Technical Support Engineers. They'll be able to access additional tools and resources to help you get to the bottom of it.
Thank you for reaching out to our Community and have a great day!
--
Help others in the community by liking or hitting Select as Best if this response helped you.
@TomC.75736 (Peninsula College) -- You would leverage "list users" to search for users that meet your criteria. The statusChanged attribute is one of the indexed attributes that contains an ISO 8601 format. Here is a list from the API documentation of the attributes that are indexed.
Here's an example of top level attribute values returned:
"id": "00xxxxxxxxxxxxx5d7",
"status": "STAGED",
"created": "2021-10-01T20:56:58.000Z",
"activated": "2021-10-01T20:56:59.000Z",
"statusChanged": "2021-10-01T22:42:05.000Z",
"lastLogin": null,
"lastUpdated": "2024-03-06T01:02:12.000Z",
"passwordChanged": "2021-10-01T20:56:58.000Z",
You could search for users that are DEPROVISIONED && statusChanged older than 365 days for example.
The following screenshot is an example for the query that pulled up the STAGED user above. If you notice i have a really old greater than (gt). I recommend having it be decades back. Having both lt and gt removes all "null" dates. For DEPROVISIONED I think there is "always" a statusChanged value since users can't start in that user state. However, to be safe its a good idea to account for possibilities.
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
May Okta Community Buzz
Stay ahead of the curve with Okta for AI Agents, new Okta Learning live sessions and labs, shout-outs, and top trending topics—all aimed at enriching your Okta journey.
@TomC.75736 (Peninsula College) -- You would leverage "list users" to search for users that meet your criteria. The statusChanged attribute is one of the indexed attributes that contains an ISO 8601 format. Here is a list from the API documentation of the attributes that are indexed.
https://developer.okta.com/docs/api/openapi/okta-management/management/tag/User/#tag/User/operation/listUsers
Here's an example of top level attribute values returned:
"id": "00xxxxxxxxxxxxx5d7",
"status": "STAGED",
"created": "2021-10-01T20:56:58.000Z",
"activated": "2021-10-01T20:56:59.000Z",
"statusChanged": "2021-10-01T22:42:05.000Z",
"lastLogin": null,
"lastUpdated": "2024-03-06T01:02:12.000Z",
"passwordChanged": "2021-10-01T20:56:58.000Z",
You could search for users that are DEPROVISIONED && statusChanged older than 365 days for example.
The following screenshot is an example for the query that pulled up the STAGED user above. If you notice i have a really old greater than (gt). I recommend having it be decades back. Having both lt and gt removes all "null" dates. For DEPROVISIONED I think there is "always" a statusChanged value since users can't start in that user state. However, to be safe its a good idea to account for possibilities.