Add-in to poll Requester inactivity

unknown

I am needing to run a report that identifies requesters that haven't placed a requisition in 6 months.  I tried running a report that showed all activity in the last 6 months and compared it to the list of active users.  This report was so large and I feel like it did not capture all activity.

Does anybody have a solution or add-in that will help me identify non-activity for requesters?

 

Thanks!

unknown

We do this with sql:



select REQUESTER,R_NAME,

from lawson.REQUESTER

where ACTIVE_STATUS = 'A' and REQUESTER not in (

select REQUESTER

from lawson.REQHEADER

where to_char(CREATION_DATE, 'YYYYMMDD') >= '20181201')



Change that last number '20181201' to the cutoff date you need in yyyy mm dd format.