Splunk AppDynamics

How to get the total number of items in an array

Sean_Davey
Path Finder

I am looking to get the total number of items in an array, so in the example below the data collect would display the number 9.  Does anyone know a good getter chain for this.  So far everything I have tried hasnt worked

Thanks

[<QueryResultSet>
<Metadata>
<Column name="cvcId" type="java.lang.Long"/>
<Column name="owner" type="java.lang.String"/>
<Column name="groupName" type="java.lang.String"/>
<Column name="opsName" type="java.lang.String"/>
<Column name="cvcType" type="java.lang.String"/>
<Column name="claimSystemId" type="java.lang.Long"/>
<Column name="hccClaimNumber" type="java.lang.String"/>
<Column name="receiptDate" type="java.sql.Date"/>
<Column name="claimType" type="java.lang.String"/>

Labels (1)
Tags (1)
0 Karma

Morelz
Motivator

Hi

You should be able to use the below

toString().split(Column).length

Just check the value, I will double check but I think this getter chain returns the array count+1 for some reason.

Ciao

Sean_Davey
Path Finder

Thanks Mario.

This seems to have worked...How do I get it so that it will only look at that one section of the array and not go to other data being pulled?

Thanks

0 Karma

Morelz
Motivator

Hi Sean

You will have to provide a bit more context as to what the entire data structure is that will be queried.

Is it always the same data structure, with different values?

Meaning is the array always in a certain section of the returned data, where would be the start and end pieces in the data to better answer your question.

Ciao

Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...