index=source 0oamhvpskG93fy30b297 OR amhpp7ohgExCpYDx51478
|stats count by Application
|lookup applications.csv application_id as Application
|addcoltotals labelfield=Application_name label=Total count
|fields - Application
Hello HiroshiSatoh,
My search above returns:
Error in 'lookup' command: Lookups: The lookup table 'applications.csv' does not exist or is not available.
The search job has failed due to an error. You may be able view the job in the Job Inspector.
5.3k ● 5 ● 5 ● 9
5.3k ● 5 ● 5 ● 9
... View more
index=abc123 | eval app=case(application==Application_1,"app_id_1",application==Application_2,"app_id_2") | stats count by app
This search returns: Error in 'eval' command: The expression is malformed. Expected ).
Can you let me know what's wrong with my search ? Thank you
... View more
a1,a2,a3,a4,a5 are the application id's. How do I name them as applications ?
a1 = app1
a2 = app2
a3 = app3
a4 = app4
a5 = app5
the output will be like this:
app1 23
app2 54
app3 73
app4 52
app5 56
Total 258
... View more
current search that i have below. This search only give me the total events , not categorize by application
index=source a1 OR a2 OR a3 OR a4 OR a5 | timechart span=1d count | sort -_time
... View more