Agresso – not registered indexes


Job details

Name: Agresso – not registered indexes
Platform: Sqlserver
Category: Agresso
Description: Checks if there are any indexes in the agresso database which are not registered in the dbo.asysindex or dbo.aagindex tables.
Long description: Checks if there are any indexes in the agresso database which are not registered in the dbo.asysindex or dbo.aagindex tables.
Version: 1.31
Default schedule: 25 7 1-5 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2012′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
ignore indexes List of agresso user indexes (separated by comma) which will be ignored from beeing checked.
database name agr% Name of the database where the Agresso application is installed. You can specify a list of databases (separated by comma). You can use % (percent sign) to represent wild card characters.
return status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when missing agresso user indexes.

Job Summary

SELECT name FROM sys.indexes WHERE name NOT IN (SELECT index_name FROM dbo.asysindex) AND name NOT IN (SELECT index_name FROM dbo.aagindex);

Details of Dependencies

Objects and Scripts Involved

Parameters and Configuration

Reporting and Presentation

Report Layout

Tables Included:

  1. Not registered Agresso user indexes
Database _. Table name _. Index name _. Index type _. Unique
Query used: Interrogates agresso_not_registered_idx_tab to provide a detailed list of unregistered indexes.

# Agresso databases

DB# _. DB Name _. DB Info
Lists all checked databases including those without the matching pattern; offers insights into database configuration and health status.

# Ignored Indexes

Agresso Database _. Index Name

| Details out indexes that are specifically ignored in checks, as per configuration to ensure they are deliberately excluded from regular monitoring.

Technical Details and Maintenance

Compatibility and Installation