What in particular are you trying to marry between the two datasets?
09/14/2020, 3:30 PM
I try to find some application by name
And the first interested things that is to know if this process is already running..
I found 10 process matched from 116 installed app.
09/14/2020, 3:36 PM
I don't believe I understand your goal. Are you asking for a query that looks for:
1. All installed applications
2. Whether each installed application has a running process (eg. Microsoft Office Word 2020 is open and running)
09/15/2020, 7:21 AM
09/15/2020, 12:46 PM
If you are trying to query user behavior you are better off querying the
table which has thing like '# of times opened', 'last opened'.