Running data administration routines

Edit online

You can run data management routines from the Data administration routines page. You can also view details for any routines that have been run.

Before you begin

You must have the admin role inasm_admin assigned to you. See the Configuring DASH user roles topic for more information.

About this task

Long-running routines that perform certain data management activities are run by the system as and when required, and you can view details for these when they have run on the Data administration routines page. You can also run some of these manually when required, for example to re-index vertices for searching, or to delete all resources for a specific provider.

You access the Data administration routines page via the Administration > Topology Configuration menu.

You can run the following routines. After defining the details specific to the routine, you specify the number of updates to be batched up, then run the routine to implement its specific function.

Deduplicate: This routine removes duplicate resources from the system.

Delete provider resources: This routine permanently deletes all the resources and resource groups supplied by a specific provider.

Encryption key change: This routine updates passwords in observer jobs after the encryption key has been changed.

Rebroadcast: This routine rebroadcasts vertices from the topology to force a re-indexing of the search database.

Resource status delete: This routine improves system performance by deleting all status for a single resource that has an excessive amount of status assigned.

Status clear: This routine clears obsolete status if there have been synchronization problems with the event management system.

Procedure

Access the Data administration routines page

Log in to the console.
From the main navigation, click Administration > Topology configuration.
The Topology configuration page is displayed.
Click Configure on the Data administration routines card.
The Data administration routines page is displayed listing existing routines that have been run. If user-defined display settings are in place, some routines may no longer be displayed. The table footer will indicate if this is the case.
Tip: To reduce the number of routines displayed in the table, use the Filter table text field. The items displayed are filtered as you enter the search text. You can further reduce the number of items displayed as described here.
You can perform the following actions on the Data administration routines page:
- Sort the table of data administration routines by column header: Routine name, type, status (ready or completed), last run, duration, operations (number), or items visited (number).
- View a routine's parameters and parameter values when run last (by clicking the routine name).
- Configure which data administration routines are displayed.
- Run a new routine.

Set routine display

Click the Routine display settings button (top right) to open the Routine display settings page.

Note: If user-defined display settings are in place, some routines that have been run may no longer be displayed. The table footer will indicate if this is the case.
Set the following options:
Age limit (days)

Set the number of days from which a routine will be considered 'old' instead of 'recent'.

The default is 30 days.

Display options
Next, select one or more of the following check-boxes to hide the selected routines based on your definitions of 'old' and 'recent':
- Hide old routines that finished successfully
- Hide recent routines that finished successfully
- Hide old routines that were aborted
- Hide recent routines that were aborted

Run a data administration routine manually

Click Run a routine (top right).
The Run a new routine window opens displaying the available routines that you can run manually.
Select the routine to be run, then click Next.
A window specific to the routine selected is displayed.
Define the details for the specific routine to be run.

Deduplicate

This routine removes the duplicate resources from the database.

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).

Delete provider resource

This routine permanently deletes all resources and groups for a specific provider.

Select the provider from a drop-down list of existing providers.

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).

Encryption key change

This routine updates the observer job passwords after the encryption key was changed.

Enter the old key to be changed.

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).

Rebroadcast

This routine rebroadcasts topology data to trigger re-indexing of the search database.

Specify whether historic resources should be rebroadcast ('true' or 'false').

Enter the broadcast IDs to be rebroadcast. You can add more than one.

Choose whether the resource status should be rebroadcast (default is 'true').

Choose whether group and composite edges for resources should to rebroadcast (default is 'true').

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).

Resource status delete

This routine deletes all status for a single resource.

Use the Search field to find the resource to be stripped of its status values.

Set the minimum age of any status to be deleted. The default is 12 hours.

Set a deletion limits (maximum). The default is 1.000 (one-thousand).

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).

Status clear

This routine clears all status for the system.

Set the minimum age of any status to be deleted. The default is 12 hours.

Set a deletion limits (maximum). The default is 1,000 (one-thousand).

Specify the number of updates to be batched up. The default is 1,000 (one-thousand).
Click Run.

Results

When the routine has completed, its details will be displayed on the Data administration routines page.