EasyCloud Report and Variant Scanner- Example

Intro

connmove EasyCloud offers a powerful Interface to scan SAP Reports and Variants for specific pattern.

This is very useful in case of OS/DB Migrations. Our solution scans the SAP ABAP System for Paths or Database commands and provide with a To Do List for you development Teams.

Major Features:

  • Scans one or multiple SAP Systems
  • Scans Reports and Variants for any text pattern
  • Reports the result as CSV

Attention: While scanning for Variants, please note they have a SAP Client dependency.

Solution

Download and install the cmShell for SAP Setup from Downloads.

Download the attached Script of this Note. Save the script on a Windows (Windows Server 2008 R2  or above) in a read/writeable Directory.

Edit the Script in These Sections:

Search configuration

 

###################################################
 Search configuration
##################################################
#Specify the reports which will be searched
# % - A substitute for zero or more characters
$reports= @("Z%","Y%","A%")
#Specify the terms which will be searched in the variants
# _ - A substitute for a single character
$VariantSearchList= @("USR")
#Specify the terms which will be searched in the source code
$ReportSrcSearchList= @("0") 

SAP Systems to scan

##################################################

# SAP Connections

##################################################

# Create new SAP connection:

# – Copy the next three comments and remove the ‘#’

# $SAPSystems[“<InstanceName>”] = New-object -TypeName PSObject

# $con = Get-CmSapConnect -UserName <Username> -Password <Password> -Language en -Client <Client> –Host <Host> -SystemNumber <SystemNumber>

# Add-Member -InputObject $SAPSystems[“<InstanceName>”] -Name Connection -Value $con -MemberType NoteProperty

# – Specify the instance name of the SAP system in the <InstanceName>placeholders.

# – Set up the SAP Connection in the Get-CmSApConnect cmdlet.

#

#Create SAP connections here:

#SAP Connection Example:

$SAPSystems[“ERP_EC1_00”] = New-object -TypeName PSObject

$con = Get-CmSapConnect -UserName admin -Password ******** -Language en -Client 100 –Host ERP.REDFRUIT.CORP -SystemNumber 00

Add-Member -InputObject $SAPSystems[“ERP_EC1_00”] -Name Connection -Value $con -MemberType NoteProperty

CSV-Output

##################################################

# Create CSV file

##################################################

$csvEnabled = $true

$csvDelimiter = “;”

$csvVariantsPath = “.\Variants.csv”

$csvReportsPath = “.\Reports.csv”