KB 195 - System dropdowns for database, cloud, or java dashboards not populating in Splunk App v8.0.1

Description

The source selection dropdown does not populate results on dashboards featuring database, cloud, or java data.

Cause

An error in the macro used to populate the dropdown causes no results to return.

Resolution

1. Go to “Settings”

2. Click on “Advanced search”
   

   

3. Select “Search macros”
   

   

4. Find and open the “sap-systems(2)” macro
   

   

5. Change “XOR” to “OR” as shown below:
   Before

   Splunk SPL

   inputlookup pc_sap_systems | search sys_type="*$sys_type$*" AND (sys_subtype="*$sys_subtype$*" XOR db_type="*$sys_subtype$*")
   

   After

   Splunk SPL

   inputlookup pc_sap_systems | search sys_type="*$sys_type$*" AND (sys_subtype="*$sys_subtype$*" OR db_type="*$sys_subtype$*")
   

   

6. Click “Save”