Export (0) Print
Expand All
Expand Minimize

Prompt SQL Statement Dialog Box

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

Use the Prompt SQL Statement dialog box in Configuration Manager 2007 to specify the SQL statement for a specified prompt in the report. When the prompt displays and the user clicks Values, Configuration Manager retrieves a list of values from the site server database using the configured SQL statement for the prompt.

The Prompt SQL Statement dialog box contains the following elements:

Views
Displays the Configuration Manager SQL views that can be added to the SQL statement. To insert a view into the SQL statement, click the location to insert the SQL view within the SQL statement, select the view from the Views list, and then click Insert.

Columns
Displays the columns for a view that is highlighted in the Views list. To add a filter to the SQL statement with a column value, click the location to insert the SQL view within the SQL statement, select the view from the Views list, select the column from the Columns list, and then click Values. Choose the values from the Column Values dialog box and click OK.

SQL statement
Specifies the SQL statement for the prompt. The SQL statement can be modified within the text box, views and column values can be added to the SQL statement by using the Views and Columns lists, or the SQL statement can be modified by using Query Designer in SQL Server 2005. For more information, see How to Use Query Designer to Create or Modify Report Queries and SQL Query Statement Reference.

Insert
Specifies that the SQL view highlighted in the Views list is inserted into the SQL statement at the last position of the cursor. The SQL view is inserted at the start of the SQL statement if the cursor position was not selected.

Values
Opens the Column Values dialog box, where a value for the column highlighted in the Columns list can be selected. For more information about selecting a column value, see Column Values Dialog Box.

OK
Saves the changes, and exits the dialog box.

Cancel
Exits the dialog box without saving any changes.

Help
Opens the help topic for this tab of the dialog box.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft