How to get userid of an user who opened any application on a date/month

there are 2 users and 2 applications

User A and User B

App A and App B

 

User A accessed/opened App A and App B on day 1

User B accessed/opened App A and App B on day 1 and day 2 

So output should be like 

Filter day : day 1 

User         App

User A      App A

User A      App B

User B      App A

User B      App B.

 

Kindly provide suggestions for fetching the user details.

Thank you.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data