Archive for May, 2013

CmEasyCloud Cmdlets read entries of a SAP table

Kategorien: cmShell @en, knowledge base @en
Comments Off on CmEasyCloud Cmdlets read entries of a SAP table

With the cmdlet ‘Get-CmSAPTable’ you have the possibility to read out the entries of a SAP table.
You have to specify the name of the table of which you want retrieve the data.
There are also two options to select the entries:

  • Fields: Represents the fields that are retrieved
  • WhereClause: SQL statement for fetching the data
PS C:Userszacharias.kopidakis> Add-PSSnapin Cmcmdlets
PS C:Userszacharias.kopidakis> $con = Get-CmSapConnect -UserName admin -Password ***** -Language EN
-Client 100 -Host ERP.REDFRUIT.CORP -SystemNumber 00
PS C:Userszacharias.kopidakis> Get-CmSapTable -CmSapConnect $con -Name RZLLITAB

CLASSNAME                               APPLSERVER                              GROUPTYPE
---------                               ----------                              ---------
Group2                                  ERPDI01_EC1_05                          S
Group2                                  ERP_EC1_03                              S
Group2                                  ERP_EC1_04                              S
SMLG                                    ERP_EC1_00
TEST                                    ERPDI01_EC1_05

CmEasyCloud installation of the Cmdlets

Kategorien: cmShell @en, knowledge base @en
Comments Off on CmEasyCloud installation of the Cmdlets

System requirements:

– 64 bit OS. For more information see EasyCloud Support Matrix
– .Net Framework 3.5

Download and install the cmdlets from our download area

After you have installed the cmdlets, run the PowerShell as administrator and register the cmdlets by executing following command:
C:WindowsMicrosoft.NETFramework64v4.0.30319installutil.exe “C:Program Files (x86)Connmove GmbHcmShell for SAPCmCmdlets.dll”
(Maybe you have to adjust the path to the insatallutil)

After that, add the cmdlets to the PS Session and enter your license key:
Add-PSSnapin cmcmdlets
Set-CmLicense –Licensekey
(You will find a demo license in the ‘licenseKey’ textfile)


You can get a list of all of our Cmdlets with the command “Get-Command -Module Cmcmdlets”

You can display the help of a cmdlet by using “Get-Help”.
Example: Get-Help Start-CmSAPJob -Full

You will find many code examples at