All posts tagged CmEasyCloud @de

EasyCloud Cmdlets for managing SAP Users

Kategorien: Allgemein
Kommentare deaktiviert für EasyCloud Cmdlets for managing SAP Users

Intro

There is a functionality needed to manage SAP users.

Solution

There are new cmdlets added to manage SAP user data:

  • Get-CmSapUserDetails
  • Add-CmSapUser
  • Set-CmSapUserDetails
  • Get-CmSapUserAuthorizationData

Get-CmSapUserDetails

Returns detail informations of a user.

Image 1 shows the different return data:

EasyCloud_Sap_User_1

Image 2 shows how to read an information like the E-Mail:

EasyCloud_Sap_User_2

 

Add-CmSapUser

The Cmdlet creates a new SAP User. You can set properties: user name, first / last name, password and a reference user. Use Set-CmSapUserDetails to set more properties.

EasyCloud_SAP_User_5

 

Set-CmSapUserDetails

With this Cmdlet you can change a lot of data of an Sap User:

EasyCloud_Sap_User_3

Here are a few informations which can be changed by using the cmdlet:

  • Data of Person (Name, etc.)
  • Contact Informations (Address, E-Mail, etc.)
  • SNC
  • User Password
  • User Type
  • User Group
  • Validity Period
  • etc.

 

 Get-CmSapUserAuthorizationData

Checks if a user has authorization issues. The function returns the output of the TC SU53.

EasyCloud_Sap_User_4

 


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/