Splunk App Upgrade Guide for SAP PowerConnect App 8.3.0

Before Completing the Update

Please back up these files before upgrading, as they may be overwritten during the upgrade process and may need to be restored after the upgrade. To back up the lookups without direct access to the files, you can run a search with “| inputlookup <lookup_name>” and download the results as a CSV file. To back up the nav file without direct access to the XML, go to “Settings > User Interface > Navigation Menus” and open the “default” nav file with the app label “BNW-app-powerconnect.” You can then copy the data to a notepad and save it as default.xml.

Update

Configuration:

  1. If you want to convert your existing master_inventory_lookup to the new sap_systems lookup, please run the search below (run without the final outputlookup line to test the output):

    | makeresults count=0
    | append
        [inputlookup master_inventory_lookup
        | eval sys_type="abap"
        | rename CPU as core_count "Category Type" as level "Component Version" as comp_version "Database Host" as db_host "Database Name" as db_name "Database System" as db_type "Database Version" as db_version "File System" as file_sys "IP" as ip "Installation Number" as install_id "Instance Name" as instance_name "Kernel Release" as kernel_release "Machine Type" as machine_type "Memory" as memory_gb "Operating System" as os_type "Source" as sys_id "Unicode System" as unicode "User Preference" as user_pref]
    | append
        [inputlookup jmx_lookup
        | eval sys_type="java",sys_subtype=""
        | rename source as sys_id]
    | append
        [inputlookup cloud_api_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="api-m"
        | rename sid as sys_id]
    | append
        [inputlookup cloud_cpi_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="cpi"
        | rename sid as sys_id]
    | append
        [inputlookup cloud_ariba_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="ariba"]
    | append
        [inputlookup cloud_cp_audit_log_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="btp"]
    | append
        [inputlookup cloud_cpq_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="cpq"]
    | append
        [inputlookup cloud_success_factor_source_lookup.csv
        | eval sys_type="cloud",sys_subtype="sf"]
    | table sys_id level sys_type sys_subtype instance_name ip install_id machine_type core_count os_type comp_version kernel_release file_sys memory_gb db_name db_type db_version db_host unicode user_pref status
    | outputlookup append=true pc_sap_systems
  2. Once your SAP Systems lookup has been created, it is recommended to run the SAP Systems Lookup Generator search in the “Wizard for New SAP SIDs and Instances Discovery” to refresh your system lookup.

Optional Configuration (multi-language support):

  1. German: http://<your_splunk_instance_address>/de-DE/app/BNW-app-powerconnect/

  2. Japanese: http://<your_splunk_instance_address>/ja-JP/app/BNW-app-powerconnect/

  3. Korean (limited support): http://<your_splunk_instance_address>/ko-KR/app/BNW-app-powerconnect/

  4. American English: http://<your_splunk_instance_address>/en-US/app/BNW-app-powerconnect/

  5. British English: http://<your_splunk_instance_address>/en-GB/app/BNW-app-powerconnect/ *(Replace the placeholder in the URL)

Note: In case the dashboard is not getting shown in the expected language after going to the appropriate URL, the user should clear the browser cache and refresh the dashboard.
Reference: {*}{+}https://docs.splunk.com/Documentation/Splunk/8.0.6/Admin/Userlanguageandlocale+*