I am having a lookup csv file, I have uploaded it in Automatic lookup's with Application=ApplicationName & ServerName=host
Application_Name & host are listed in fields.
CSV file is as below
..| append [inputlookup serverslookup] | search Application="App1" | chart count over ServerName by Status
If I use the above command, I am getting the below output
But If I run the query with host instead of Server_Name
Which is actaul count.
Could you please help me to get the correct result by using lookfield
Ooo, Worked now, Problem with the case sensitive....
View solution in original post