I want to check which user record got inactive in 90 last days using script.

[SUser1234]

I want to check which user record got inactive in 90 last days using script using the history table not from user table filter.

[JenniferRah]

Hm... You can check inactive users for which ones were updated in the last 90 days, but that won't tell you specifically that the user was deactivated in the last 90 days. Is that sufficient? If so, you can build a query and/or code to do that. The query would look something like this:

active=false^sys_updated_onRELATIVEGT@dayofweek@ago@90

[SUser1234]

This query can work but do I need to check this on history table?

[JenniferRah]

The query I added above would just be on the user table. Checking the history table would be a much more involved effort.

[SUser1234]

I am targeting Hr profile table that checked if record got inactive in last 90 days