Query Statement Properties: Joins Tab

Aplica-se a: 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 this tab to combine attributes from two different attribute classes with a join operation. For more information about configuring join operations, see About Configuring Attribute Class Joins.

noteNota
Join operations are configured automatically on both the General tab and the Criteria tab when you add attributes from more than one attribute class to the query. In this case, you can use the Joins tab to modify the properties of the join.

CautionAtenção
Join operations are an advanced function of Microsoft SQL Server. Before configuring or modifying a join operation, you must have a good working knowledge of the Structured Query Language (SQL) syntax that is needed to create various types of table joins. For more information about join operations, see your SQL Server documentation.

Attribute class joins
Displays the attributes and attribute classes that are part of the query and indicates whether they are joined. You can use this table to combine attribute classes by creating a new join operation or by modifying the attributes of an existing join operation.

New button
Click to open the Attribute Class Join Properties dialog box, which you can use to join a new attribute class to the selected attribute class. The selected attribute class is the base attribute class. The base attribute class is an attribute class, which you have already added to the query, to which you want to join another attribute class. The new class that is joined becomes a child of the selected attribute class in the tree.

Modify button
Click to open the Attribute Class Join Properties dialog box, which you can use to modify the join properties of a selected attribute class. The child attribute class must be selected.

Delete button
Click to remove a selected attribute class and all of its subclasses from the query criteria. If the selected class or any of its subclasses are used by any result attributes of the query criteria, you will be prompted to confirm whether you want the result attributes or criteria to be deleted from the query.

Show Query Language
Opens the Query Statements dialog box to display the query in the Query Language view. You can work in the Query Language view to compose or edit a query manually by using WBEM Query Language (WQL) commands.

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.

Conteúdo da Comunidade

Mostrar: