Uploading HDB / MSS scripts
PowerConnect has the ability to upload HANA or SQL Server scripts that can be executed regularly, and the output of the script is uploaded to Splunk.
SAP standard HANA scripts can be found attached to note 1969700 – SQL Statement Collection for SAP HANA. We have packaged these up as an .xml file that can be uploaded directly. Please contact email@example.com to obtain a copy of the .xml file.
If you want to add your own HANA script use the following instructions.
Go to Administrator -> Metric filters -> SQL Script metrics -> HDB queries
To upload the .xml
Click on Load from file
Select the provided .xml file
This will upload all the scripts embedded in the file. This is the only
To add new custom script
Click on Create icon
Enter the name of the script, and select an interval for it to execute (in seconds)
Double click on the line this will open the script editor. Copy the script contents to the window
Click on the Save icon. This will save the script. Next time the extractor runs this script will execute and the output of the script will be sent to Splunk. The record can be found in Splunk as
EVENT_TYPE = HDBSCRIPTS
FLTNAME = <SCRIPT NAME> i.e. HANA_BACKUPS_BACKUPRUNS