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
I'll try it. Thanks for the help.
Thanks, I'll try that.
Try this:
eval UserCount = User.Count
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?
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.
@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
Is this a multi value field? Can you provide syntax that is getting you to this point ?