Splunk IT Service Intelligence

Extract list of ITSI Services and KPI's from REST

Esky73
Builder

I'm following the doco here :

http://docs.splunk.com/Documentation/ITSI/3.0.2/RESTAPI/ITSIRESTAPIreference#ITOA_Interface

i run a search :

| rest /servicesNS/nobody/SA-ITOA/itoa_interface/kpi_base_search

and i can get a json blob of data

i'd like to create a table from this of search names, base_search, etc

Is that possible ?

0 Karma

mibrown_splunk
Splunk Employee
Splunk Employee

You could try this to get the fields you're looking for:

| rest /servicesNS/nobody/SA-ITOA/itoa_interface/kpi_base_search 
| eval value=spath(value,"{}") 
| mvexpand value 
| eval base_search = spath(value, "base_search") 
| eval title = spath(value, "title") 
| eval metric_titles=spath(value, "metrics{}.title") 
| eval threshold_fields=spath(value, "metrics{}.threshold_field") 
| eval entity_calculation=spath(value, "metrics{}.entity_statop") 
| eval service_calculation=spath(value, "metrics{}.aggregate_statop") 
| eval units=spath(value, "metrics{}.unit") 
| fields title, base_search, metric_titles, threshold_fields, entity_calculation, service_calculation, units

Alternately you could rework the above search so each row contains all elements of the metric you're interested in.

Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...