Agresso – not registered indexes - Control Center

Name:	Agresso – not registered indexes
Platform:	Sqlserver
Category:	Agresso
Premium package:	Agresso application package
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:
Version:	1.3
Default schedule:	25 7 1-5 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[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.

Feedback