Hi @shashankk I think there are a couple of ways you could do this, one being: index=test_uat (source=*/DB*/scn0*/tool/log/scan*log "realtime update") OR source=*/DB*/scn0*/tool/log/output.log
| rex field=source "\/HSDB..\/(?<Instance>.*);\s"
| rex field=_raw ":\d\d, \d\d\d;\s.*\/(?<vuser>.*);\s"
| rex field=vuser "(?<UserId>[^/]+)$"
| eval UserId=COALESCE(UserId,user_name)
| eventstats values(cost_center) as cost_center values(first_name) as first_name, values(last_name) as last_name by UserId
| stats count by Instance, UserId, first_name, last_name, cost_center | eval {Instance}=count
| stats values(*) AS * by UserId
| addtotals labelfield=UserId
| fields - count Instance Another way would be to append the output.log later on, I usually try and avoid appends where possible though as they can have limitations if too many results are returned: index=test_uat source=*/DB*/scn0*/tool/log/scan*log "realtime update"
| rex field=source "\/HSDB..\/(?<Instance>.*);\s"
| rex field=_raw ":\d\d, \d\d\d;\s.*\/(?<vuser>.*);\s"
| rex field=vuser "(?<UserId>[^/]+)$"
| chart count over UserId by Instance
| addtotals labelfield=UserId
| fillnull value=0
| sort - Total
| fields - count Instance
| append
[ search index=test_uat source=*/DB*/scn0*/tool/log/output.log
| eval UserId=user_name
| table UserId first_name last_name cost_center]
| stats values(*) as * by UserId Here is an example of the second search using makeresults data to see it in action: | makeresults format=csv data="_time,source, _raw
2026-01-21 12:00:01,\"/HSDB01/SCN01; \", \"123; /HSDB01/SCN01; realtime update:01, 111; some/other/path/MARVEL; x\"
2026-01-21 12:00:02,\"/HSDB01/SCN01; \", \"234; /HSDB01/SCN01; realtime update:02, 222; some/other/path/MARVEL; x\"
2026-01-21 12:00:03,\"/HSDB01/SCN03; \", \"345; /HSDB03/SCN03; realtime update:03, 333; some/other/path/MARVEL; x\"
2026-01-21 12:00:04,\"/HSDB01/SCN03; \", \"456; /HSDB03/SCN03; realtime update:04, 444; some/other/path/MARVEL; x\"
2026-01-21 12:00:05,\"/HSDB01/SCN03; \", \"567; /HSDB03/SCN03; realtime update:05, 555; some/other/path/MARVEL; x\"
2026-01-21 12:00:06,\"/HSDB01/SCN03; \", \"678; /HSDB03/SCN03; realtime update:06, 666; some/other/path/MARVEL; x\"
2026-01-21 12:00:07,\"/HSDB01/SCN03; \", \"789; /HSDB03/SCN03; realtime update:07, 777; some/other/path/MARVEL; x\"
2026-01-21 12:00:08,\"/HSDB01/SCN03; \", \"890; /HSDB03/SCN03; realtime update:08, 888; some/other/path/MARVEL; x\""
```index=test_uat source=*/DB*/scn0*/tool/log/scan*log "realtime update"```
| rex field=source "\/HSDB..\/(?<Instance>.*);\s"
| rex field=_raw ":\d\d, \d\d\d;\s.*\/(?<vuser>.*);\s"
| rex field=vuser "(?<UserId>[^/]+)$"
| chart count over UserId by Instance
| addtotals labelfield=UserId
| fillnull value=0
| sort - Total
| fields - count Instance
| append
[| makeresults
| eval _raw="2026-01-21 08:26:45.014 user_id=\"2143\" user_name=\"MARVEL\" first_name=\"avenger\" last_name=\"superhero\" cost_center=\"DC\""
| extract
| eval UserId=user_name
| table UserId first_name last_name cost_center]
| stats values(*) as * by UserId 🌟 Did this answer help you? If so, please consider: Adding karma to show it was useful Marking it as the solution if it resolved your issue Commenting if you need any clarification Your feedback encourages the volunteers in this community to continue contributing
... View more