topic Eval Question for Table in Splunk Search

Eval Question for Table

jhayIV — Tue, 29 Sep 2020 09:03:31 GMT

Using the table below I have the following query table Server_Name,Server_TotalPhysicalMemory,Server_Cores,Server_NumberofProcessors,Server_Domain,Server_IsVirtual,Server_LastScanDate,Server_SerialNumber,Server_Site,Associated_AppliationProductName,Associated_OperatingSystem,_time | stats count() | transpose
I would like to divide each value by count(Server_Name) is there a way to do that using the EVAL function?

Re: Eval Question for Table

somesoni2 — Tue, 15 Mar 2016 20:33:37 GMT

Try something like this

table Server_Name,Server_TotalPhysicalMemory,Server_Cores, Server_NumberofProcessors, Server_Domain,Server_IsVirtual,Server_LastScanDate,Server_SerialNumber, Server_Site, Associated_AppliationProductName,Associated_OperatingSystem,_time | stats count(*) as count_*  | eval divider=count_Server_Name | untable divider column value | eval value=value/divider | fields - divider