Agresso help and temp tables

Name:	Agresso help and temp tables
Platform:	Sqlserver
Category:	Agresso
Premium package:	Agresso application package
Description:	Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Long description:	Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Version:	1.3
Default schedule:	30 6 2,6 *
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
database name	agr%	The name of the agresso database. You can specify a list of databases (separated by comma). You can use % (percent sign) to represent wild card characters.
Help tables prefix	agr%	Prefix used by the Agresso help tables created when running Agresso reports.
Temporary tables prefix	H%	Prefix used by the temporary tables in the Agresso schema.
warning threshold — total size	1000	Warning threshold, in MB, for aggregated size value for all help and tmp tables.
warning threshold — total count	1000	Warning threshold for total count value of all help and tmp tables.
history threshold	366	The number of days the statistics will be kept in the history table.
max databases per graph	5	The maximum number of databases visualized in the report graphs.

Feedback