Need to find out the user made inactive from Last 6 months.

Hi,

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.

No Files Were Attached
KaranPurswani Agile User Asked on September 6, 2018 in Product Collaboration.
Add Comment
2 Answer(s)
Best answer

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)
;

keithrust Agile Angel Answered on September 6, 2018.

Slight correction, as what you specified didn’t work for me right away until I changed the like clause to lower case:

SELECT a.loginid, 
       b.timestamp, 
       b.details 
FROM   agile.agileuser a 
       INNER JOIN agile.item_history b 
               ON a.id = b.item 
WHERE  a.enabled = 0 
       AND b.timestamp > ( sysdate – 183 ) 
       AND Lower(b.details) LIKE ‘%was<active>is<inactive>%’ 
ORDER  BY timestamp DESC;

on September 6, 2018.

Thanks for your help too – I never thought about where Agile stores the history tab for an IUser.

on September 6, 2018.
Add Comment

Thanks guys, It works.

KaranPurswani Agile User Answered on September 7, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.