Simplify WF with PowerShell scripting

PowerShell Workflow Activity allows you to execute PowerShell scripts from within Windows Workflow Foundation workflows.

Zoom [+]

PowerShell Activities Get-Process demo in PowerShell Workflow Activity.

PowerShell Workflow Activity allows execution of PowerShell scripts from within Windows WF workflows, and remote scripts when used with PowerShell SSH Server. Each instance of the activity on a workflow can define a different PowerShell script to execute. PowerShell Workflow Activity allows you to execute scripts on remote machines using the PowerShell V2 Remoting protocol or the PowerShell Server protocol.

Features

Executing Scripts on Remote Machines
PowerShell Workflow Activity also allows you to execute scripts on remote machines using the PowerShell V2 Remoting protocol or the PowerShell Server protocol. To use PowerShell Remoting, you need to set the following options in the task properties:

• Host: The name or IP address of the remote computer.
• Protocol: set to prRemoting;.
• User and Password: Optional. If not specified, the connection will be attempted using the user the SSIS workflow is running under.
• To use PowerShell Server, you need to have PowerShell Server installed and running in the remote machine, and configure the following properties:
• Host: The name or IP address of the remote computer.
• Protocol: set to prSSH.
• SSHAuthMode: Set to amPassword for username/password authentication or to amPublicKey for public key authentication. For the latter, this option needs to have been enabled in the remote PowerShell Server, and the task needs to have access to a certificate the server will accept.
• User: The username to be used for authentication.
• Password: Optional. The host key/certificate used to authenticate the server.
• SSHCert: The certificate to use for public key authentication.

Receiver Property List
The following is the full list of the properties of the receiver activity with short descriptions.       

• Firewall - A set of properties related to firewall access.
• Host - The host where the command should be executed.
• LogFile - The file to write logging information to at runtime.
• LogMode - What information gets logged during activity execution.
• Other - Defines a set of configuration settings to be used by the activity.
• Password - The password to use when executing commands remotely.
• Port - The TCP port number to use for remote connections.
• Protocol - The protocol to use for executing remote commands.
• PSObjects - A collection of PSObject items returned by the script execution.
• PSVariables - Input variables you want to pass to the PowerShell script.
• Script - The PowerShell script to execute.
• SSHAcceptServerHostKey - Instructs the activity to accept the server host key that matches the supplied key.
• SSHAcceptServerHostKeyAcceptAny - Tells the activity to accept any server certificate.
• SSHAuthMode - The type of authentication used by the activity.
• SSHCert- The certificate to use for client authentication during the SSH handshake.
• SSHCompressionAlgorithms - A comma-separated list of compression algorithms allowed for this connection.
• Timeout - A timeout for the activity.
• User - The username to use when executing commands remotely.

Sender Property List
The following is the full list of the properties of the sender activity with short descriptions.

• Firewall - A set of properties related to firewall access.
• Host - The host where the command should be executed.
• LogFile - The file to write logging information to at runtime.
• LogMode - What information gets logged during activity execution.
• Other - Defines a set of configuration settings to be used by the activity.
• OutputText - The output of the PowerShell Script executed.
• Password - The password to use when executing commands remotely.
• Port - The TCP port number to use for remote connections.
• Protocol - The protocol to use for executing remote commands.
• Script - The PowerShell script to execute.
• SSHAcceptServerHostKey - Instructs the activity to accept the server host key that matches the supplied key.
• SSHAcceptServerHostKeyAcceptAny - Tells the activity to accept any server certificate.
• SSHAuthMode - The type of authentication used by the activity.
• SSHCert - The certificate to use for client authentication during the SSH handshake.
• SSHCompressionAlgorithms - A comma-separated list of compression algorithms allowed for this connection.
• Timeout - A timeout for the activity.
• User - The username to use when executing commands remotely.

Configuration Settings
The following is a list of configuration settings for the activity with short descriptions.

• SSHAcceptServerHostKeyFingerPrint - Instructs the activity to accept the server's host key with this fingerprint.
• SSHEncryptionAlgorithms - A comma-separated list containing all allowable compression algorithms.
• AbsoluteTimeout - Determines whether timeouts are inactivity timeouts or absolute timeouts.
• LocalHost - The name of the local host or user-assigned IP interface through which connections are initiated or accepted.
• PersistedConnectionTimeout - How long to leave a persisted connection alive.

About PowerShellInside

PowerShellInside is a division of /n software inc. (www.nsoftware.com) a leading provider of software components for communications, security, and e-business. Since 1994 /n software has established itself as a leading provider of cross-platform software components for communication, security, and e-business development.  /n software is committed to providing enterprise-class tools and components enabling developers to rapidly build robust Internet enabled Web and desktop applications.