Let me try
# general
e
Let me try
f
What in particular are you trying to marry between the two datasets?
e
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.
f
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)
e
yes
f
If you are trying to query user behavior you are better off querying the
userassist
table which has thing like '# of times opened', 'last opened'.