Cisco Cisco Process Orchestrator 3.0
4-56
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Viewing Activity Instance Information
Viewing List SQL Server Running SQL Queries Activity Results
When the List SQL Server Running SQL Queries activity is launched, results are displayed from the
from the Operations Workspace activity instance view. The Result display-only page displays the results
of the running SQL queries performed in the SQL Server database.
from the Operations Workspace activity instance view. The Result display-only page displays the results
of the running SQL queries performed in the SQL Server database.
To view List SQL Server Running SQL Queries output results:
Step 1
On the Operations workspace, click the Activity Views folder.
Step 2
Use one of the following methods:
•
Highlight the List SQL Server Running SQL Queries activity instance, right-click and choose
Properties.
Properties.
-or-
•
Double-click the appropriate activity instance.
The List SQL Server Running SQL Queries dialog box displays.
Step 3
Click the Result tab to view the results of the running SQL queries performed in the SQL Server
database.
database.
Figure 4-40
List SQL Server Running SQL Queries Properties—Results Tab
The following information is displayed:
Column
Description
Session ID
Session identifier for the connected session
Status
Process ID status
Command
Command currently being executed
Program Name
Name of the application program
Login Name
User name of the person accessing the database
Host Name
Name of the workstation
SQL Text
SQL query text
CPU Time
Cumulative CPU time for the process