The Scoping Fields panel shows all of the GUID fields that are included in the SQL query. You need to specify the GUID fields that are used for scoping. If you create a complex SQL query that has multiple joins onto resources, and multiple applications of the scoping function, you should add all of the appropriate scoping GUIDs to the Scoping Guid Fields list.
The Data Snapshots Query panel lets you view the SQL code that is generated when the snapshot needs to be saved or loaded. Before you save the report query, you can verify that the SQL code to load snapshot data applies scoping correctly to the saved results.
To configure the scoping fields in a custom report snapshot
In the Symantec Management Console, in the Reports menu, click All Reports.
In the left pane, select the report that you want to edit.
On the Report Name page, click Edit.
On the Data Source tab, on the Data Snapshots tab, in the Scoping Fields panel, select the appropriate scoping fields.
To select a scoping field
In the Available Guid Fields list, click the field that you want to select, and then click Scope.
To deselect a scoping field
In the Scoping Guid Fields list, click the field that you want to deselect, and then click Unscope.
To verify that the generated SQL is correct, in the Data Snapshot Query panel, in the Data Snapshot Query Mode box, click the appropriate query mode:
Create Snapshot Data Table
Displays the SQL code that creates the snapshot data table structure. This structure does not depend on the scoping configuration.
Save Snapshot Data
Displays the SQL code that saves data for all fields into the snapshot data table. The scoping configuration does not affect this data.
Load Snapshot Data
Displays the SQL code that loads data from the snapshot data table and scopes it according to the user's security permissions. The SQL uses the configured scoping fields and the user's TrusteeScope memberships to extract the appropriate data. This data is then presented to the user as the report results.
The specified scoping fields scope this data.
If necessary, click Refresh to update the displayed SQL code.
The Data Snapshot Query panel is automatically refreshed each time that you modify the scoping fields or change the selection in the Data Snapshot Query Mode box. However, there may be occasions when the automatic refresh does not work correctly and you need to refresh the panel manually.
When you have verified that scoping is correctly configured for report snapshots, click Apply.
Imported Document ID: HOWTO63077
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe