Need to find out the user made inactive from Last 6 months.
Need help to find out how many users were made inactive from last 6 months, I was trying to do it via DB but not getting the exact table where i can get the users history captured.
Thanks in advance.
Here’s a query showing when users were inactivated within the past six months.
select a.loginid, b.timestamp
from agileuser a
inner join item_history b on a.id = b.item
where a.enabled = 0
and b.details like ‘%was<Active>is<Inactive>%’
and b.timestamp > (sysdate – 183)