topic Re: I need to combine two results names into one in Splunk Search

I need to combine two results names into one

streetdoc123 — Thu, 31 Aug 2017 19:49:23 GMT

So search command | stats count by user | want to rename or combine the two results into same name

i.e.
User ** **Count
eid 1234abc 2
Bobbie Smith 12

Re: I need to combine two results names into one

somesoni2 — Thu, 31 Aug 2017 19:57:28 GMT

Assuming you'll not always get two rows from your stats, how do you relate a name with user_id? Do you've any lookup or any other source which contains this mapping?

Re: I need to combine two results names into one

streetdoc123 — Fri, 01 Sep 2017 12:52:22 GMT

I don't know what you are asking. The results show up as a user ID, then the user name appears in the table value as well. I have several that show up as both name and eID, which I need to combine them for alert reporting purposes. The count shows them both as well.

User Count
Bobbie Smith 12
eID 1234abc . (Also Bobbie Smith) 2
Not sure if the format for the tables and columns are showing up well enough.

Re: I need to combine two results names into one

DalJeanis — Fri, 01 Sep 2017 13:21:06 GMT

@streetdoc123 - @somesoni2 is asking, "How will the search program determine which user name goes with which id?"

Is there a table somewhere that has...

eid         Name
1234abc    Bobbie Smith
2345def    J Jonah Jamieson

Re: I need to combine two results names into one

cmerriman — Fri, 01 Sep 2017 21:43:38 GMT

Is this a multi value field? Can you provide syntax that is getting you to this point ?

Re: I need to combine two results names into one

kmaron — Tue, 05 Sep 2017 18:00:48 GMT

Try this:

eval UserCount = User.Count

Re: I need to combine two results names into one

streetdoc123 — Tue, 05 Sep 2017 18:21:11 GMT

Thanks, I'll try that.

Re: I need to combine two results names into one

streetdoc123 — Tue, 05 Sep 2017 18:21:33 GMT

I'll try it. Thanks for the help.