This Splunk application helps in visualizing and monitoring SAP systems with PowerConnect for Splunk ABAP based application for SAP. This application requires data ingestion from SAP which is facilitated by an SAP Netweaver based technology add-on called "PowerConnect for SAP & Splunk".
https://splunkbase.splunk.com/app/3153/
If you upgrade the app to 7.0.0 or above version from any lower version please run the Setup Page so that you can use the panel wise alert functionality.
https://help.powerconnect.io/powerconnectdocumentation/PowerConnect-Splunk-App-Upgrade.3040673830.html
In this section default filter values for the timerange and span can be set. These values are set to default across all the dashboards.
Note: This does not apply for "Expensive Statements (raw)" dashboards for databases.
SAP CLOUD PRODUCT SUPPORT
GERMAN OR JAPANESE LANGUAGE SUPPORT
By default, Splunk automatically uses the language that the user's browser is set to. To switch languages, either the browser's locale setting can be changed or for a given Splunk session it can be changed by modifying the URL that you use to access Splunk. For different languages use the URL as specified:
*(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.
* The language translation of description ("Wizard for New SAP SIDs and Instances Discovery" dashboard, "Data Dictionary" dashboard and "Searches, Reports, and Alerts" section) is supported for Splunk version 7.3.x and above.
* Reference: https://docs.splunk.com/Documentation/Splunk/8.0.6/Admin/Userlanguageandlocale
MACROS:
The following saved searches are used to improve the search performance for the MLTK panels by acceleration. By default this feature is disabled. Users need to manually enable the acceleration.
Users can change the acceleration option by following the below steps:
The app package uses binary files for NIPING utility (located at $SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/bin/lib/nipping)
To make "SAP Global->User Experience (Geo)" dashboard working properly, the user needs to manually insert subnet values in ip_subnets lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/ip_subnets.csv).
For example:
subnet,lat,long,text // this line is already in ip_subnets.csv file.
XXX.XXX.XXX,-10.000,20.000,"Text Value" //Sample value in ip_subnets.csv file.
.
.
.
where,
- "XXX.XXX.XXX" is subnet value.
- "-10.000" is latitude.
- "20.000" is longitude.
- "Text Value" is identical city/state/state name.
In "SAP Security->SAP Security Scorecard" and "SAP Security->SAP Security Essentials" dashboards, security_parameters_names lookup file is used for one of the security use case "Password policy parameters". On the basis of this lookup "Password policy parameters" security use case is defined.
To modify this security use case, user need to manually add/modify security_parameters_names lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/security_parameters_names.csv).
For example:
PAR_NAME,RECOMMENDED_VALUE,CONDITION // this line is already in ip_subnets.csv file.
login/min_password_lng,6,> //Sample value in security_parameters_names.csv file.
.
.
.
where,
- "login/min_password_lng" is parameter name.
- "6" is recommended value.
- ">" is one of the three possible conditions i.e ">" OR "<" OR "=".
In "SAP Security->SAP Security Scorecard" and "SAP Security->SAP Security Essentials" dashboards, sensitive_tcodes lookup file is used for one of the security use case "Execution of sensitive transactions". On the basis of this lookup "Execution of sensitive transactions" security use case is defined.
To modify this security use case, user need to manually add/modify sensitive_tcodes lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/sensitive_tcodes.csv).
For example:
TCODE // this line is already in sensitive_tcodes.csv file.
SE16 //Sample value in sensitive_tcodes.csv file.
.
.
.
where,
- "SE16" is sensitive TCODE value.
In "SAP Security->SAP Security Scorecard" and "SAP Security->SAP Security Essentials" dashboards, wide_open_auth_objects lookup file is used for one of the security use case "Users with sensitive authorization". On the basis of this lookup "Users with sensitive authorization" security use case is defined.
To modify this security use case, user need to manually add/modify wide_open_auth_objects lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/wide_open_auth_objects.csv).
For example:
OBJECT // this line is already in wide_open_auth_objects.csv file.
S_TABU_DIS //Sample value in wide_open_auth_objects.csv file.
.
.
.
where,
- "S_TABU_DIS" is object value.
In "SAP Security->SAP Security Scorecard" and "SAP Security->SAP Security Essentials" dashboards, sensitive_user_roles lookup file is used for one of the security use case "Users with sensitive role". On the basis of this lookup "Users with sensitive role" security use case is defined.
To modify this security use case, user need to manually add/modify sensitive_user_roles lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/sensitive_user_roles.csv).
For example:
AGR_NAME // this line is already in sensitive_user_roles.csv file.
Z_BNWVS_ADMIN_CHANGE //Sample value in sensitive_user_roles.csv file.
.
.
.
where,
- "Z_BNWVS_ADMIN_CHANGE" is rule name.
In "Java->NW->NetWeaver Java UME" dashboard, sensitive_user_roles_java lookup file is used for one of the security use case "Users with sensitive role". On the basis of this lookup "Users with sensitive role" security use case is defined.
For example:
role_name // this line is already in sensitive_user_roles.csv file.
Administrator //Sample value in sensitive_user_roles.csv file.
.
.
.
where,
- "Administrator" is rule name.
To modify this, user need to manually add/modify pc_landscape_ovw_source_exclude lookup file ($SPLUNK_HOME$/etc/apps/BNW-app-powerconnect/lookups/pc_landscape_ovw_source_exclude.csv).
For example:
source // this line is already in pc_landscape_ovw_source_exclude file.
.
.
.
where,
- "source" is rule name.
Look ups can be rebuilt by the following steps:
NOTE: Run the saved searches one by one to avoid concurrency issue.
Copyright (c) 2022 SoftwareONE. All Rights Reserved.
Find the release notes for version 8.1.0 here: https://help.powerconnect.io/powerconnectdocumentation/release-notes-for-splunk-app-v8-1-0
Please see our release notes at https://help.powerconnect.io/powerconnectdocumentation/release-notes-for-splunk-app-v8-0-0
Please see our release notes at https://help.powerconnect.io/powerconnectdocumentation/release-notes-for-splunk-app-v7-3-0
Please see our release notes at https://help.powerconnect.io/powerconnectdocumentation/release-notes-for-splunk-app-v7-2-0
This release contains new content, updates to existing content, and bug fixes. For more detail, see our documentation here: https://help.powerconnect.io/powerconnectdocumentation/release-notes-for-splunk-app-v7-1-0
Version 7.0.0 (July 2022)
New! System Overview (7.x)
New! SAP Fiori: ODATA Metering Trace
New! SAP Fiori: SAP Gateway Statistics
New! Sensitive Authorization
New! File System
New! Audit Integrity Check
New! Spool Content
New! Output Device Status
New! Alert Details
New! User Change Log
New! Event Analytics
New! Smart Business KPI
New! HANA: Backup Overview Dashboard
New! Event type, Dashboard, Menu Mapping
New! PowerConnect Resource Utilization
New! PI/PO Adapter Engine Queues
New! HANA: Large Table Details
New! HANA: Large Table Overview
New! Capacity Management Information System
New! Spool Information
New! HANA: SQL Plan Statistics
New! Authorization Data Overview (SU53)
New! Login Failure
New! HANA: Disk Overview
New! Weekly Usage Statistics
New! SMLG Details
New! STATS Details
New! STATS Overview
New! Fiori Statistics Overview
New! Fiori Statistics Details
Updated! Spool Monitoring
Updated! Alert Definition
Updated! User Password Status
Updated! System Overview
Updated! Authorization Data Details (SU53)
Version 6.9.1 (June 2022)
New! Added support for replication of Setup Page in the distributed environment
• New! SAP Change Documents
• New! AIF Error Monitoring
• New! PowerConnect Audit
• New! PowerConnect Extractor Schedule
• Updated! PowerConnect Health
• Updated! SAP Landscape Analysis
• Updated! SAP Security Essentials
• Updated! Locks
• Updated! SAP RZ10 Profile Parameters
• Updated! IDOC Status for WE02
• Updated! Monitor for Processed XML Messages (SXMB_MONI)
• Updated! SAP Cloud - CPI Message Monitoring
• Updated! Success Factor Monitoring Dashboard
• Updated! SAP Cloud - API Management Monitoring
• Fixed! Wizard for System Role
• Other minor improvements
• New! SAP Landscape Analysis
• New! Wizard for System Role
• New! Business Process Monitoring KPIs
• New! HANA: Active Statements
• New! SAP Fiori: Summary
• New! SAP Fiori: Details
• New! SAP Fiori: Gateway Error Log
• New! Troubleshooting Dashboard
• Updated! Weekly Usage Statistics
• Updated! Landscape Overview
• Updated! Landscape Last Event Received
• Updated! SAP Security Scorecard
• Updated! Users Logged In
• Updated! User Password Status
• Updated! Authorization Data (SU53)
• Updated! Audit Logs
• Updated! Disk
• Updated! SAP OS Memory (ST06)
• Updated! SAP Network
• Updated! CPU All Instances
• Updated! SAP Buffers
• Updated! SAP Instance Memory (ST02)
• Updated! SM51 - Request Queue Information
• Updated! ICM Monitoring dashboard
• Updated! Work Processes
• Updated! SAP Global STAD
• Updated! SAP Global Transactions
• Updated! DIA Steps (Total)
• Updated! SAP RZ10 Profile Parameters
• Updated! Batch jobs
• Updated! Transport Dashboard
• Updated! Java Agent Health
• Updated! Basis Health Checks
Its a minor release on top of v6.6.0
• New! NIPING Utility
• Updated! Landscape Last Event Received
• Updated! Mapping: Event Types (SAP Group Definition) with Dashboards
• Updated! Extractor Status
• Updated! PI/PO Messages
• Updated! SAP Security Scorecard
• Embedded third-party JS libraries in the app package
• Other minor improvements
• New! Work Process Detailed Analysis
• New! BPM IDOC To Business Object Relationship
• New! Outbound Delivery Monitor
• New! UME for ABAP
• New! SAP Read Access Login (SRAL)
• New! SAP RZ10 Profile Parameters
• New! ST22 Dump Details
• New! NetWeaver Java: DB Connection Statistics
• New! NetWeaver Java: Distributed Trace
• New! NetWeaver Java: Locks
• New! NetWeaver Java: Process Information
• New! NetWeaver Java: User Sessions
• New! NetWeaver Java: Web Sessions
• Updated! System Overview
• Updated! Landscape Overview
• Updated! Extractor Status
• Updated! Time Machine Dashboard
• Updated! SAP Buffers by Instance
• Updated! CPU vs. Work Processes
• Updated! SM13 Updates
• Updated! Abap Dumps
• Updated! Batch jobs
• Updated! NetWeaver Java: UME
• Updated! SAP CPI Message Monitoring
• Updated! HANA: Configuration Mini-checks
• Updated! ICM Monitoring dashboard
Upgrade steps: https://help.powerconnect.io/powerconnectdocumentation/PowerConnect-Splunk-App-Upgrade.3040673830.html
New! ICM Monitoring dashboard
New! SAP Gateway Monitoring
New! SAP ITS Memory Statistics
New! Workflow Event Queue
New! SAP Connect: Send Requests
New! SAP License Information
New! Audit Logs under SAP Security
New! HANA: Diagnostic Files
New! HANA: Custom Scripts
New! Wizard for SAP Security Scorecard
Updated! Extractor Status for ABAP dashboards
Updated! Landscape Overview
Updated! Wizard for New SAP SIDs and Instances Discovery
Updated! SAP Security Essentials
Updated! SAP Security Scorecard
Updated! SAP Logs Search
Updated! CPU vs. Work Processes
Updated! Batch Jobs
Updated! Transport Dashboard
Updated! PI Messages
Updated! NetWeaver Java UME
Updated! HANA: Overview
Updated! HANA: Space
Fixed! System Overview
Fixed! Mapping: Event Types (SAP Group Definition) with Dashboards
UPGRADE STEPS: https://www.powerconnect.io/wiki/splunk-app-upgrade-guide-for-sap-powerconnect-app-6-x/
Now supports German and Japanese languages!
New! Authorization Data (SU53)
New! SM51 - Request Queue Information
New! SM51 - RFC Communication Block
New! Transport Dashboard
New! NetWeaver Java Config Changes Monitoring
New! NetWeaver Java Security Audit Logs
New! NetWeaver Java Security Logs
New! NetWeaver Java Certificate Monitoring
New! NetWeaver Java UME
New! NetWeaver Java Component Information
New! NetWeaver Java Disk Monitoring
New! NetWeaver Java Network Monitoring
New! HANA Trace
New! DB/2 Activities
New! Panels for Audit log deletion, User unlocked, New client created, Security Audit Log Parameter ( Security Essentials and Security Scorecard)
Improved! Extractor Status for ABAP dashboards
Improved! Added version update details to each dashboard
Improved! Security Essentials and Scorecard
Improved! SAP Cloud - CPI Message Monitoring
Other Minor Improvements
UPGRADE STEPS: https://www.powerconnect.io/wiki/splunk-app-upgrade-guide-for-sap-powerconnect-app-6-x/
• New! Extractor Status for ABAP dashboards
• New! Landscape Component Information
• New! Landscape Last Event Received
• New! Wizard for New SAP SIDs and Instances Discovery
• New! HANA Audits
• New! HANA Memory Usage
• New! HANA Services
• New! HANA Threads
• New! SAP Cloud - CPI Messages
• New! SAP Process Chain Dashboard
• Improved! Mapping: Dashboards with Event Types (SAP Group Definition)
• Improved! SAP Security Scorecard
• Improved! Extractor Status
• Improved! Batch Jobs
• Improved! ABAP Dumps
• Improved! PI Messages
• Improved! Channel Monitoring
• Improved! HANA Alert Details
• Fixed! System Overview : Updated “CPU(%), Memory(%), Availability(%), WP-BTC(%), WP-DIA(%)”panels
• Fixed! SAP Security Essentials: Updated "Users with sensitive roles" title drill-down link and “Password expiration policy” panel
• Other minor improvements
UPGRADE INSTRUCTIONS: https://www.powerconnect.io/wiki/kb-093-splunk-app-upgrade-guide-for-sap-powerconnect-app-6-x/
New! SAP User User Behavior Analysis with MLTK
New! Login permissions and change events
New! Risk Assessment Dashboard
Updated! System Overview
Updated! Mapping : Dashboards with SAP Group Definition (with live extractor status)
Updated! ABAP Dumps (now with MLTK)
Updated ! Batch Jobs (with new UI)
New! Weekly Usage Statistics
New! Extractor Status
New! Certificate Status
New! SAP Logs Search
Other minor improvements on Landscape Overview, SAP Security Scorecard, Users Logged in, Audited Logins, User Experience (Geo), Batch Jobs Analysis by Instance, Help menu links and others.
Upgrade instructions: https://www.powerconnect.io/wiki/kb-093-splunk-app-upgrade-guide-for-sap-powerconnect-app-6-x/
Now supports Splunk 8.0 and Python 3.
New! Application Logs (SLG1).
New! SAP Directories (AL11).
New! Workload monitor stats for ST03 - RFC and Web Services
New! Workload monitor stats for ST03 - User Profile
New! Mapping - Event Types :: SAP Group Definition
New! Oracle - Tablespace Growth
Updated! Time Machine Dashboard
Updated! Batch Jobs
Updated! User Experience (Geo)
Updated! ABAP Dumps
Updated! CPU vs. Work Processes
Added! Additional use cases for System Overview, SAP Security Essentials and SAP Security Scorecard dashboards
Upgrade instructions: https://www.powerconnect.io/wiki/kb-093-install-upgrade-guide-for-sap-powerconnect-for-splunk-6-1-0/
Biggest splunk app update ever for PowerConnect.
• New! SAP Security Essentials (with out-of-the-box audit reports)
• New! System Overview Dashboard (new landing page, view current status with last 24 hours history at the same time).
• New! Dark Theme and Intuitive Navigation Bar (re-categorized menu options).
• New! Thread Hotspots (SAP Java).
• New! Expensive Statements (Database)
• New! Segments (Database)
• New! MyDashboard – with Drag and Drop function (Beta).
• New! Data Dictionary Dashboard.
• Updated! Number Range Monitoring.
• Updated! IDOC for WE02.
• Fixed! Landscape overview – capacity utilization.
• New! Audit and Security Checks dashboard (added under SAP Global.)
• New! Time Machine Dashboard (added under SAP Global).
• New! Background Job Analysis dashboard (added under SAP Instance).
• New! Number Range Monitoring dashboard (added under SAP Global).
• New! SAP CCMS dashboard (added under SAP Global).
• Updated! Batch Jobs dashboard (under SAP Global )
- Added "Jobs Runtime", "Job Steps and Logs for JOBNAME", "Runtime for JOBNAME over last 7 days", "SM50 Logs for INSTANCENAME" and "Job Log Data for JOBLOG"
- Added drilldowns in "Jobs Runtime" and "Active Jobs Runtime"
• Updated! Added timerange and source filters in Channel Monitoring dashboard.
• Updated! Renamed macro jmx
to sap-java
across all java dashboards for consistency.
• Improved! "Page Hit Rate", "Page Response Time", "Channel Monitoring" dashboards.
• Improved! App improvements made for better cloud vetting score.
Setup page for Time range and Span filter.
Setup page for all database related dashboard. User can hide particular dashboard, if needed.
Top navigation menu changes
Added a panel for Check for "Old" locks inside dashboard Locks and Updates under SAP Global.
Added a dashboard for System Logs under SAP Global.
Added a dashboard for Spool Monitoring under SAP Global.
Added a dashboard for System Settings under SAP Global.
Added a dashboard for SAP Connect under SAP Global.
All SAP System and SAP Instance form input dropdown will use Saved Search
Added a pre-configured role "pc-admin"
Added a new dashboard "IDOC Status" under SAP Global Navigation Menu
Added description in app.conf
Removed usage of deprecated <seed> option in Simple XML forms.
Cleanup of savedsearches.conf and minor fixes
As a Splunkbase app developer, you will have access to all Splunk development resources and receive a 10GB license to build an app that will help solve use cases for customers all over the world. Splunkbase has 1000+ apps from Splunk, our partners and our community. Find an app for most any data source and user need, or simply create your own with help from our developer portal.