Hi DalJeanis,
I have another different question. Not sure how to ask you the question directly , hence asking in the same thread, sorry!
This is the query I am trying to use to pull memory usage %
index=ff sourcetype=metrics_tbl [|inputlookup Domains_Instances_Servers.csv | search Instance_Name="r_prod_" Domain_Name="r_prod_cache_01" OR "r_prod_cache_03” OR "r_prod_cache_05” OR "r_prod_cache_07” LOB="Digi" Domain_Layer="Cacheis” | table Server_Name | rename Server_Name as machine ] earliest=-16m@m latest=-1m@m | bin _time span=15m | eval ServerMem=if(metric_category="OsResource",Memory,0) | eventstats count(eval(metric_category="OsResource")) as OSEvents, sum(ServerCPU) as TotalCPU , sum(ServerMem) as TotalMem by machine, LOB, Domain_Layer, Domain_Name, Instance_Name, Channel | eval avgCpu=round(TotalCPU/OSEvents,2) ,avgMem=round(TotalMem/OSEvents,2) | stats values(avgCpu) as "ServerCPU%" , values(avgMem) as "ServerMem%" by machine, _time, LOB, Domain_Layer, Domain_Name, Instance_Name, Channel | rename machine as Server, process as Instance, ServerMem% as val_ServerMem% | eval ts_time = _time * 1000 | top limit=1 Server by ts_time, val_ServerMem%, LOB, Domain_Layer, Domain_Name, Instance_Name, Channel | table ts_time, Server, LOB, Domain_Layer, Channel, Domain_Name, Instance_Name, val_ServerMem%
In the output/result table values are displayed only for ts_time, Server,val_ServerMem% and remaining all columns(LOB, Domain_Layer, Channel, Domain_Name, Instance_Name) are empty. How can i get values for all these " LOB, Domain_Layer, Channel, Domain_Name, Instance_Name " as well?
Appreciate your help a lot!! I'm desperate, please help!
... View more