Available reports

Install

1. Download Attached Zip File, and extract to get InstallAPMInsightReportFunctions.bat  Script
2. Copy InstallAPMInsightReportFunctions.bat into <APM home>\bin. Example: D:\tools\APM\AppManager\bin
   
3. Open a command prompt as Administrator in that folder.
4. Run the file:

InstallAPMInsightReportFunctions.bat

Install on every AppManager server whose data you want to report on. Running it again is safe.

Run a report

Run reports from the Query Tool, or save them as a Custom Query Report (see Save, schedule or monitor below). Each report is one line:

SELECT * FROM apm_txn_health('30m')

Choose the time period

The first value is how far back to look. Write a number followed by a unit, in single quotes.

• If you leave the time period out, the last 30 minutes are used.
• A number without a unit means minutes: '45' is the last 45 minutes.
• Decimals work: '1.5h' is the last 90 minutes.
• Longer periods only include data that's still stored.

Choose applications

Reports cover all applications by default. To report on specific ones, add their IDs at the end:

SELECT * FROM apm_app_error_split('1d', ARRAY[10000364])

To list your application IDs:

SELECT DISTINCT p.applicationid, mo.displayname FROM apm_partitioninfo p JOIN am_managedobject mo ON mo.resourceid = p.applicationid ORDER BY 2

Example result.

Errors per application

The number of 4xx and 5xx errors for each application.

SELECT * FROM apm_app_error_split('30m')

Result

Example: Ecommerce App had two 4xx errors and no 5xx errors.

Top error transactions

The transactions with the most 4xx and 5xx errors, per application. The second value is how many to show.

SELECT * FROM apm_txn_error_split('30m', 10)

Result

Example: one transaction, /checkout/payment, returned two 4xx errors.

Transaction health

Shows how many transactions are Critical and how many are Clear. A transaction is Critical when it's slow or has too many errors.

SELECT * FROM apm_txn_health('30m')

Settings

Add settings in this order, separated by commas. You can stop after any of them; the rest keep their defaults.

Setting 4 decides which checks count:

Examples

Slower than 2 seconds, or more than 5% errors

SELECT * FROM apm_txn_health('30m', 2000, 5)

Slower than 2 seconds, ignoring errors

SELECT * FROM apm_txn_health('30m', 2000, 1, 'rt')

With 'rt' the error value (1 here) is ignored, but it still has to be there.

Business transactions only, default limits

SELECT * FROM apm_txn_health('30m', 500, 1, 'or', true)

Result

Example: 119 transactions had traffic in the time period. 9 were Critical and 110 Clear.

SLA breaches

Shows how many transactions are slower than each limit you give.

SELECT * FROM apm_txn_sla('30m', ARRAY[2000,4000,10000])

Settings

Result

Example: one row per limit. 1 of 119 transactions was slower than 2 s, and the same one was slower than 10 s.

SLA breached transactions

Lists the transactions that are slower than a response-time limit, slowest first.

SELECT * FROM apm_txn_sla_breaches('30m', 2000)

Settings

Result

Example: one transaction averaged about 12.5 seconds over 36 requests.

Save, schedule or monitor

Save as a Custom Query Report

1. Go to Settings > Reporting > Custom Query Report and click Create New Report.
2. Fill in the fields:

3. Save the report. To see the results, open it and click Process.

Schedule it

1. Go to Settings > Schedule Report.
2. Choose Custom Query Report as the report type and select your report.
3. Under Time Settings, choose Hourly, Daily, Weekly or Monthly, and pick PDF or Excel.

Scheduled reports are sent by email.

Monitor it

Add a Database Query Monitor for the AppManager PostgreSQL database and use the same query. The results are then collected on every poll.

More details: Custom Query Report help

Good to know

Remove

Open the database console from <APM home>\bin:

DBConfiguration.bat -u dbuser

Then paste:

DROP FUNCTION IF EXISTS apm_txn_health(integer, bigint, numeric, text, boolean, bigint[]);
DROP FUNCTION IF EXISTS apm_txn_error_split(integer, integer, bigint[]);
DROP FUNCTION IF EXISTS apm_app_error_split(integer, bigint[]);
DROP FUNCTION IF EXISTS apm_txn_sla_breaches(text, bigint, boolean, bigint[]);
DROP FUNCTION IF EXISTS apm_txn_sla(text, bigint[], boolean, bigint[]);
DROP FUNCTION IF EXISTS apm_txn_health(text, bigint, numeric, text, boolean, bigint[]);
DROP FUNCTION IF EXISTS apm_txn_error_split(text, integer, bigint[]);
DROP FUNCTION IF EXISTS apm_app_error_split(text, bigint[]);
DROP FUNCTION IF EXISTS apm_union_err(bigint, bigint[], boolean);
DROP FUNCTION IF EXISTS apm_union_txn(bigint, bigint[]);
DROP FUNCTION IF EXISTS apm_window_ms(text);