
5vwap (5vwap) asked a question.
We need a report that will show login and logout of each user. If users just close the connection will it show when their session expires?
How to create and export such report that clearly shows how much time each user spent on the given App ?

You could extract Okta System logs for a date period looking for (displayMessage eq "User single sign on to app") and then another extract looking for (eventType eq "user.session.end"). Combine the two extracts and sort via datetime and app and that sort of gives you what you want.
Keep in mind that this does not really tell you that they spent x-amount of time in an app and they may never press the logout so that would impact your results. They could also hop app to app with one Okta session. The best way to track how much time in an app is to record that activity in each app not Okta.