Query List
Applies To: System Center 2012 R2 Orchestrator, System Center 2012 SP1 - Orchestrator
The Query List activity is used in a runbook to retrieve data about the items in a Microsoft SharePoint list by using a Collaborative Application Markup Language (CAML) that you specify.
The following tables list the required properties and Published Data for this activity. Additional Published Data is generated, which is based on the SharePoint list that is retrieved when you define the activity.
Query List Required Properties
Element |
Description |
Valid values |
List Name |
The name of the SharePoint list to be searched. |
String |
CAML Query |
A CAML query to determine which items to select. Important Do not enclose the CAML XML in <Query></Query> tags. |
String |
Query List Optional Properties
There are no optional properties for this runbook activity.
Query List Published Data
Element |
Description |
Value type |
Created |
The date and time when the item was created. |
Date/Time |
Created By |
The name of the user who created the item. |
String |
ID |
The ID of the list item. |
Integer |
Item Count |
The number of items that were retrieved. |
Integer |
List Name |
The name of the SharePoint list that contains the items that were retrieved. |
String |
Modified |
The date and time when the item was last modified. |
Date/Time |
Modified By |
The name of the user who last modified the item. |
String |
SharePoint Site |
The URL of the SharePoint site. |
String |