Cisco Cisco Process Orchestrator 3.1 User Guide

Complete the appropriate information in the following tabs, as necessary, and then click the Save tool to 
complete the activity definition.

Target—Specify whether the process target should be used or overridden with a different target.

Credentials—Specify the runtime user whose credentials should be used for process execution.

Knowledge Base—Choose the appropriate knowledge base article to associate with the process.

Result Handlers—Click the appropriate buttons to manage the condition branches on the workflow.

In the Process Editor Toolbox, choose the [Database Activity] property page, then click the Select 
From [Database] tab.

Specify the information that describes the data you want to select, including:

SQL command text—The command text for the selected database. Verify that the SQL command is 
entered correctly. The data in the database is case-sensitive. 

For example, this is a sample query that selects specific columns from a table:

SELECT column1,column2 from mytable

Populate columns from query—List the columns from the SQL query directly into the Columns 
section.

Columns—Displays the columns generated by the SQL query.

Return all columns of Select statement—Return all columns of a Select statement, regardless of 
whether a column type is defined in the activity.

The returned data will be stored in a data table and will be available for use in an automation 
summary.

Row number per page—The number of rows to display per page (default=100).

Maximum number of rows—The maximum number of rows to display (default=200).

The Database Locks activity queries the locks performed in the selected database.

In the Process Editor Toolbox, choose the [Database Activity] property page, then click the [Database] 
Database Locks tab.

Enter the command text, using commas to separate the list of processes. For example, this query displays 
a list of all client processes that have locks:

xxx,yyy,zzz

Use * to generate a list of all processes.