I don't follow entirely if you want to report on the whole session or on individual files. Trying to combine those two can be a bit tricky. You haven't posted a search or field names you're using or stuff like that so it's hard to write something that you can take and just paste and go, but let's say you have the session ID extracted in the field "ID", the username in the login as "login", files as "file" and size as "size". You also mentioned IP but I don't see that anywhere in the log sample. One more thing I don't understand is what's special about these "trigger" files - it's just another file, no? 🙂
If you're fine with reporting individually on each item uploaded by a user, you could just do
... | table ID login file size
If you want to group all this in a session for some reason, you could do something like
... | stats list(login) as login, list(file) as file, list(size) as size by ID
From your requirements it doesn't seem like you need to use transaction at all.
... View more