When a query is run, the results are displayed in the results pane of the Microsoft System Center Configuration Manager 2007 Administrator console. You can modify how these results are displayed by using the General tab in the Query Statement Properties dialog box.
The General tab displays a table that includes the query attributes. You can modify how the query results are displayed by moving the query attributes up or down in the table. The order of the attributes in this table, from top to bottom, are the order in which they are displayed within the query results columns, from left to right. In other words, the first attribute listed in this table is displayed in the first column on the left and the last attribute listed in this table is displayed in the last column on the right.
You can also modify how query results are sorted. The sort order determines the order in which the results are displayed within the columns. Choose from ascending, descending, or unsorted. To modify the sort order, highlight a query attribute, and then click Properties.
Finally, after a query is run, you can re-arrange the result columns in the results pane. The re-arranged order will be saved as a user preference across sessions.