Cisco Cisco Process Orchestrator 3.1 User Guide

Use the following process to monitor and manage Microsoft SQL Server database instances. 

Create a Microsoft SQL Server database target (see 

Define a Microsoft SQL Server database activity. 

In the Process Editor Toolbox, choose Database > Microsoft SQL Server > [Microsoft SQL 
Server Database Activity], then drag and drop the activity onto the Workflow pane.

Click the General tab and enter the required information.

Click the [Activity-Specific] tabs to define the properties specific to the activity. 

Enter the information in the remaining tabs as necessary, then click Save to complete the activity 
definition.

For details about a specific activity, see 

View the activity results (see 

).

List SQL Server Running 
SQL Queries

Display the results of the running SQL queries performed in the SQL 
server database.

Specify the information that describes the query results, including:

Row Limit—The appropriate number rows to limit for the query and 
returned data (default=50).

Select from SQL Server

Query data from an SQL server database. 

For more information, see 

.

Select From Report 
Database

Query data from a report database. 

For more information, see 

.

Use a different Select activity when switching between databases.

SQL Server Lock 
Information 

Use this activity to display a list of all client processes that have locks. 

For more information, see 

.

Update SQL Server 

Use this activity to update column information in the SQL Server database 
using SQL command lines.

Enter the command text for the selected database. For example, this 
sample query updates the columns in a table:

Update mytable set column1 = 'newvalue' where column2 = 'zzz'