https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542489#M153672 <P>In what way did spath not help? Did you specify the paths you wanted or did you just get everything in the JSON? Can you share what you have tried and say why it didn't give you what you wanted?</P> Fri, 05 Mar 2021 08:10:39 GMT ITWhisperer 2021-03-05T08:10:39Z https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542418#M153653 <P>I have the below JSON feed that I can see from a straight search. I'm trying to get some stats especially for pools-availabilityState by name and pools-status.statusReason by name. Tried spath but it didnt not help. How I do this. TIA</P><P>&nbsp;</P><P>{ [-]<BR />clientSslProfiles: { [+]<BR />}<BR />deviceGroups: { [+]<BR />}<BR />httpProfiles: { [+]<BR />}<BR />iRules: { [+]<BR />}<BR />ltmPolicies: { [+]<BR />}<BR />networkTunnels: { [+]<BR />}<BR />pools: { [-]<BR />/Common/Ex-pool: { [-]<BR />activeMemberCnt: 0<BR />availabilityState: offline<BR />curPriogrp: 0<BR />enabledState: enabled<BR />highestPriogrp: 0<BR />lowestPriogrp: 0<BR />members: { [+]<BR />}<BR />mr.msgIn: 0<BR />mr.msgOut: 0<BR />mr.reqIn: 0<BR />mr.reqOut: 0<BR />mr.respIn: 0<BR />mr.respOut: 0<BR />name: /Common/Ex-pool<BR />serverside.bitsIn: 0<BR />serverside.bitsOut: 0<BR />serverside.curConns: 0<BR />serverside.maxConns: 0<BR />serverside.pktsIn: 0<BR />serverside.pktsOut: 0<BR />serverside.totConns: 0<BR />status.statusReason: The children pool member(s) are down<BR />tenant: Common<BR />totRequests: 0<BR />}<BR />/Common/F2F3: { [-]<BR />activeMemberCnt: 1<BR />availabilityState: available<BR />curPriogrp: 0<BR />enabledState: enabled<BR />highestPriogrp: 0<BR />lowestPriogrp: 0<BR />members: { [+]<BR />}<BR />mr.msgIn: 0<BR />mr.msgOut: 0<BR />mr.reqIn: 0<BR />mr.reqOut: 0<BR />mr.respIn: 0<BR />mr.respOut: 0<BR />name: /Common/F2F3<BR />serverside.bitsIn: 0<BR />serverside.bitsOut: 0<BR />serverside.curConns: 0<BR />serverside.maxConns: 0<BR />serverside.pktsIn: 0<BR />serverside.pktsOut: 0<BR />serverside.totConns: 0<BR />status.statusReason: The pool is available<BR />tenant: Common<BR />totRequests: 0<BR />}<BR />/Common/2F2F: { [-]<BR />activeMemberCnt: 1<BR />availabilityState: available<BR />curPriogrp: 0<BR />description:<BR />enabledState: enabled<BR />highestPriogrp: 0<BR />lowestPriogrp: 0<BR />members: { [+]<BR />}<BR />mr.msgIn: 0<BR />mr.msgOut: 0<BR />mr.reqIn: 0<BR />mr.reqOut: 0<BR />mr.respIn: 0<BR />mr.respOut: 0<BR />name: /Common/2F2F<BR />serverside.bitsIn: 0<BR />serverside.bitsOut: 0<BR />serverside.curConns: 0<BR />serverside.maxConns: 0<BR />serverside.pktsIn: 0<BR />serverside.pktsOut: 0<BR />serverside.totConns: 0<BR />status.statusReason: The pool is available<BR />tenant: Common<BR />totRequests: 0<BR />}<BR />}<BR />serverSslProfiles: { [+]<BR />}<BR />sslCerts: { [+]<BR />}<BR />system: { [+]<BR />}<BR />telemetryEventCategory: systemInfo<BR />telemetryServiceInfo: { [+]<BR />}<BR />virtualServers: { [+]<BR />}<BR />}</P> Thu, 04 Mar 2021 21:39:42 GMT https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542418#M153653 ThyAbode 2021-03-04T21:39:42Z https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542489#M153672 <P>In what way did spath not help? Did you specify the paths you wanted or did you just get everything in the JSON? Can you share what you have tried and say why it didn't give you what you wanted?</P> Fri, 05 Mar 2021 08:10:39 GMT https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542489#M153672 ITWhisperer 2021-03-05T08:10:39Z https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542530#M153684 <P>The spath is giving me everything and I do not know how we can specify certain key-value pair for a table view for stats.</P> Fri, 05 Mar 2021 10:40:02 GMT https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542530#M153684 ThyAbode 2021-03-05T10:40:02Z https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542540#M153689 <LI-CODE lang="markup">| spath pools.enabledState output=enabledState</LI-CODE><P>This should work for enabledState. The issue might be if your key has a dot in it. Although you could extract pools first, then run spath on that</P><LI-CODE lang="markup">| spath pools output=pools | spath input=pools</LI-CODE> Fri, 05 Mar 2021 11:31:40 GMT https://community.splunk.com/t5/Splunk-Search/JSON-formatting/m-p/542540#M153689 ITWhisperer 2021-03-05T11:31:40Z