IFS Terms of Use

​@HilalSTS Maybe if you could help us understand what your definition of an Active user is? Is it someone who keeps on typing? Or someone logging on, gets coffee and doesn't use IFS until automatic logging off?

Most likely you will have to define an event or workflow to save the entry timestamp and for the given session what the timestamp is of logging out.

These are the individuals for whom I have set up IFS accounts and who actively use the system—searching for data, adding records, and performing updates. They are not people who step away from IFS to grab coffee or attend meetings. We are looking at how many hours they actually spend using IFS during the logged time. 

I don't know where to fetch the data from.

In IFS26R1 I'm able to prepare a quick report using the following:

select * from fnd_session_runtime

Try that and monitor it to see which fields might be useful. Once again, you most likely have to prepare an event/workflow that will fill a custom entity.