Archive for Mai, 2013

CmEasyCloud Cmdlets read entries of a SAP table

Kategorien: cmShell, Knowledge Base
Kommentare deaktiviert für 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:\Users\zacharias.kopidakis> Add-PSSnapin Cmcmdlets
PS C:\Users\zacharias.kopidakis> $con = Get-CmSapConnect -UserName admin -Password ***** -Language EN
-Client 100 -Host ERP.REDFRUIT.CORP -SystemNumber 00
PS C:\Users\zacharias.kopidakis> Get-CmSapTable -CmSapConnect $con -Name RZLLITAB
-Fields CLASSNAME,APPLSERVER,GROUPTYPE  -WhereClause "GROUPTYPE = '' OR CLASSNAME like'%2'"

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, Knowledge Base
Kommentare deaktiviert für 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 http://connmove.eu/software/downloads/

After you have installed the cmdlets, run the PowerShell as administrator and register the cmdlets by executing following command:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\installutil.exe „C:\Program Files (x86)\Connmove GmbH\cmShell for SAP\CmCmdlets.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  http://connmove.eu/category/knowledge/easycloud/