Splunk Search
Highlighted

I need to combine two results names into one

New Member

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

0 Karma
Highlighted

Re: I need to combine two results names into one

SplunkTrust
SplunkTrust

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?

0 Karma
Highlighted

Re: I need to combine two results names into one

New Member

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.

0 Karma
Highlighted

Re: I need to combine two results names into one

SplunkTrust
SplunkTrust

@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
0 Karma
Highlighted

Re: I need to combine two results names into one

Super Champion

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

0 Karma
Highlighted

Re: I need to combine two results names into one

Motivator

Try this:

eval UserCount = User.Count

View solution in original post

0 Karma
Highlighted

Re: I need to combine two results names into one

New Member

Thanks, I'll try that.

0 Karma
Highlighted

Re: I need to combine two results names into one

New Member

I'll try it. Thanks for the help.

0 Karma