Entity Metrics Report

Overview

Entity Metrics report shows summary for all transactional Metrics for Applications, Tiers, Nodes, Business Transactions, Backends, Service Endpoints, Errors and Information Points for APM Applications.

This makes it very valuable in times when you want to rapidly assess hundreds of Applications, Tiers and Business Transactions and see which ones need your attention.

The scatter plot chart above each table provides description of Calls vs Response for each row. As the table is filtered, the data in the chart will change.

You can also watch this training video:

Entity Metrics report is produced when:

• Job file included at least one APM application Target.Type=APM
• Metadata is extracted via Input.DetectedEntities=true
• Metrics are extracted via Input.Metrics=true
• Metrics are specified via Input.MetricsSelectionCriteria
• Report is requested via Output.EntityMetrics=true

Report File Locations

Entity Metrics report has the following file name:

Report\EntityMetrics.<Job File Name>.<Start Date and Time in yyyyMMddHHmm>.<Number Of Hours Spanned By Report>.xlsx

For example:

EntityMetrics.demo2Ecommerce.2017091914.2.xlsx

Data File Locations

The data for the report is in the following files:

• Report\ENT\controllers.csv
• Report\METR\APP.entities.full.csv
• Report\METR\APP.entities.hour.csv
• Report\METR\BACK.entities.full.csv
• Report\METR\BACK.entities.hour.csv
• Report\METR\BT.entities.full.csv
• Report\METR\BT.entities.hour.csv
• Report\METR\ERR.entities.full.csv
• Report\METR\ERR.entities.hour.csv
• Report\METR\NODE.entities.full.csv
• Report\METR\NODE.entities.hour.csv
• Report\METR\SEP.entities.full.csv
• Report\METR\SEP.entities.hour.csv
• Report\METR\TIER.entities.full.csv
• Report\METR\TIER.entities.hour.csv

Data Schema

Full Size

Report Contents

Data	Pivot
1.Parameters
2.Contents
3.Controllers
4.Applications, 4.Applications.Hourly	4.Applications.Pivot
5.Tiers, 5.Tiers.Hourly	5.Tiers.Pivot, 5.Tiers.Availability
6.Nodes, 6.Nodes.Hourly	6.Nodes.Pivot, 6.Nodes.Availability
7.Backends, 7.Backends.Hourly	7.Backends.Pivot
8.BTs, 8.BTs.Hourly	8.BTs.Pivot
9.SEPs, 9.SEPs.Hourly	9.SEPs.Pivot
10.Errors, 10.Errors.Hourly	10.Errors.Pivot
11.Information Points, 11.Information Points.Hourly	11.Information Points.Pivot

1.Parameters

This sheet describes the parameters of the extraction and reporting job that produced this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
UserName	String	User that was used to retrieve data from the Controller
Application	String	Name of Application that was queried
ApplicationID	Integer	ID of Application in Controller
ApplicationType	String	Type of the Application

2.Contents

This sheet provides quick access to the contents of this report and provides at-a-glance number of rows in each of the sheet's tables.

Column	Data Type	Purpose
Sheet Name	String	Name of the sheet in the report
Num Entities	Integer	Number of Entities in that sheet
Link	Hyperlink	Link to the sheet in the report

3.Controllers

This sheet provides information about Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
Version	String	Version of the Controller
VersionDetail	String	Full version string of the Controller
NumApps	Integer	Number of all APM Applications registered in the Controller
NumAPMApps	Integer	Number of APM Applications registered in the Controller
NumWEBApps	Integer	Number of WEB Applications registered in the Controller
NumMOBILEApps	Integer	Number of MOBILE Applications registered in the Controller
NumIOTApps	Integer	Number of IoT Applications registered in the Controller
NumSIMApps	Integer	Number of SIM Applications registered in the Controller
NumBIQApps	Integer	Number of BIQ Applications registered in the Controller
NumDBApps	Integer	Number of DB Applications registered in the Controller
ControllerLink	URL	Link to Controller

4.Applications

This sheet provides Metric information about all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
Exceptions	Integer	Total Exceptions for Entity
EXCPM	Integer	Exceptions per Minute for Entity
HTTPErrors	Integer	Total HTTP Errors for Entity
HTTPEPM	Integer	HTTP Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
FlameChartLink	Hyperlink	Link to the Flame Chart report
FlameChartLink	Hyperlink	Link to the Flame Chart report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Application for this time range

Full Size

4.Applications.Hourly

The same structure as 4.Application, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file.

If only 1 hour range was specified, this sheet is identical to 4.Application.

4.Applications.Pivot

This sheet uses data in 4.Applications.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Exceptions (Sum)
		EXCPM (Average)
		HttpErrors (Sum)
		HTTPEPM (Average)

5.Tiers

This sheet provides Metric information about all Tiers in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
TierName	String	Name of Tier
TierType	String	Type of Tier
AgentType	String	Type of Agent reporting to this Tier
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
Exceptions	Integer	Total Exceptions for Entity
EXCPM	Integer	Exceptions per Minute for Entity
HTTPErrors	Integer	Total HTTP Errors for Entity
HTTPEPM	Integer	HTTP Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
NumNodes	integer	Number of APM Nodes that are in this Tier
AvailAgent	Integer	Number of APM Agents that reported during this time
AvailMachine	Integer	Number of Machine Agents that reported during this time
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
FlameGraphLink	Hyperlink	Link to the Flame Graph report
FlameChartLink	Hyperlink	Link to the Flame Chart report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
TierLink	URL	Link to Tier in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Tier for this time range

Full Size

5.Tiers.Hourly

The same structure as 5.Tiers, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 5.Tiers.

5.Tiers.Pivot

This sheet uses data in 5.Tiers.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	AgentType
	TierName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Exceptions (Sum)
		EXCPM (Average)
		HttpErrors (Sum)
		HTTPEPM (Average)
		Errors % (Average)
			HasActivity
			From

5.Tiers.Availability

This sheet uses data in 5.Tiers.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Default configuration counts agent availabiliby in all Tiers in All Applications in this Controller.

Columns	Rows	Values	Filters
Controller
Application
TierName
	From
		AvailAgent (Average)
			AvailAgent
			AgentType

Example report showing numbers of agents of Java Type that reported into the Tier over period of couple of days:

Full Size

6.Nodes

This sheet provides Metric information about all Nodes in all Tiers in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
TierName	String	Name of Tier
NodeName	String	Name of Node
AgentType	String	Type of APM Agent
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
Exceptions	Integer	Total Exceptions for Entity
EXCPM	Integer	Exceptions per Minute for Entity
HTTPErrors	Integer	Total HTTP Errors for Entity
HTTPEPM	Integer	HTTP Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
AvailAgent	Double	Percentage availability of APM Agents that reported during this time
AvailMachine	Double	Percentage availability of Machine Agents that reported during this time
HasActivity	Boolean	Whether this Entity had any activity
IsAPMAgentUsed	Boolean	Whether this Entity had APM Agent report during this time interval
IsMachineAgentUsed	Boolean	Whether this Entity had Machine Agent report during this time interval
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
NodeID	Integer	ID of APM Agent in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
FlameGraphLink	Hyperlink	Link to the Flame Graph report
FlameChartLink	Hyperlink	Link to the Flame Chart report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
TierLink	URL	Link to Tier in Controller for this time range
NodeLink	URL	Link to Node in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Node for this time range

Full Size

6.Nodes.Hourly

The same structure as 6.Tiers, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 6.Tiers.

6.Nodes.Pivot

This sheet uses data in 6.Nodes.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	AgentType
	TierName
	NodeName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Exceptions (Sum)
		EXCPM (Average)
		HttpErrors (Sum)
		HTTPEPM (Average)
		Errors % (Average)
			HasActivity
			From

6.Nodes.Availability

This sheet uses data in 6.Nodes.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Default configuration counts agent availabiliby and all Nodes in All Applications in this Controller.

Columns	Rows	Values	Filters
Controller
Application
TierName
	From
		NodeID (Count)
			IsAPMAgentUsed
			IsMachineAgentUsed
			AvailAgent
			AvailMachine
			AgentType

Example report showing numbers of agents that reported into the Tiers over period of couple of days:

Full Size

7.Backends

This sheet provides Metric information about all Backends in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
BackendName	String	Name of Backend
BackendType	String	Type of Backend
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
Exceptions	Integer	Total Exceptions for Entity
EXCPM	Integer	Exceptions per Minute for Entity
HTTPErrors	Integer	Total HTTP Errors for Entity
HTTPEPM	Integer	HTTP Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
BackendID	Integer	ID of Backend in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
BackendLink	URL	Link to Backend in Controller
MetricLink	URL	Link to Metric Browser for all Metrics in Backend for this time range

Full Size

7.Backends.Hourly

The same structure as 7.Backends, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 7.Backends.

7.Backends.Pivot

This sheet uses data in 7.Backends.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	BackendType
	BackendName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Errors % (Average)
			HasActivity
			From

8.BTs

This sheet provides Metric information about all Business Transactions in all Tiers in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
TierName	String	Name of Tier
BTName	String	Name of Business Transaction
BTType	String	Type of Business Transaction
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
BTID	Integer	ID of Business Transaction in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
FlameGraphLink	Hyperlink	Link to the Flame Graph report
FlameChartLink	Hyperlink	Link to the Flame Chart report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
TierLink	URL	Link to Tier in Controller for this time range
BTLink	URL	Link to Business Transaction in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Business Transaction for this time range

Full Size

8.BTs.Hourly

The same structure as 8.BTs, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 8.BTs.

8.BTs.Pivot

This sheet uses data in 8.BTs.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	TierName
	BTType
	BTName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Errors % (Average)
			HasActivity
			From

9.SEPs

This sheet provides Metric information about all Service Endpoints in all Tiers in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
TierName	String	Name of Tier
SEPName	String	Name of Service Endpoint
SEPType	String	Type of Service Endpoint
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
SEPID	Integer	ID of Service Endpoint in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
TierLink	URL	Link to Tier in Controller for this time range
SEPLink	URL	Link to Service Endpoint in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Service Endpoint for this time range

Full Size

9.SEPs.Hourly

The same structure as 9.SEPs, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 9.SEPs.

9.SEPs.Pivot

This sheet uses data in 9.SEPs.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	TierName
	SEPType
	SEPName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Errors % (Average)
			HasActivity
			From

10.Errors

This sheet provides Metric information about all Errors in all Tiers in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
TierName	String	Name of Tier
ErrorName	String	Name of Error
ErrorType	String	Type of Error
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
ErrorID	Integer	ID of Error in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
TierLink	URL	Link to Tier in Controller for this time range
ErrorLink	URL	Link to Error in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Error for this time range

10.Errors.Hourly

The same structure as 10.Errors, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 10.Errors.

10.Errors.Pivot

This sheet uses data in 10.Errors.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	TierName
	ErrorType
	ErrorName
		Errors (Sum)
		EPM (Average)
			HasActivity
			From

11.Information Points

This sheet provides Metric information about all Information Points in all APM Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
ApplicationName	String	Name of Application
IPName	String	Name of Information Point
IPType	String	Type of Information Point
ART	Integer	Average Response Time (ms) for Entity
ARTRange	String	String representing bucket into which ART fits
TimeTotal	Integer	Total Response Time for Entity
Calls	Integer	Total Calls for Entity
CPM	Integer	Calls per Minute for Entity
Errors	Integer	Total Errors for Entity
EPM	Integer	Errors per Minute for Entity
ErrorsPercentage	Double	Percentage of Error transactions against the total calls
HasActivity	Boolean	Whether this Entity had any activity
From	DateTime	Beginning of time range queried, local time
To	DateTime	End of time range queried, local time
FromUtc	DateTime	Beginning of time range queried, UTC time
ToUtc	DateTime	End of time range queried, UTC time
Duration	Integer	Duration of time range queried, in minutes
ApplicationID	Integer	ID of Application in Controller
IPID	Integer	ID of Information Point in Application
DetailLink	Hyperlink	Link to the Entity Details report
MetricGraphLink	HyperLink	Link to the Entity Metric Graphs report
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
IPLink	URL	Link to Information Point in Controller for this time range
MetricLink	URL	Link to Metric Browser for all Metrics in Service Endpoint for this time range

Full Size

11.Information Points.Hourly

The same structure as 11.Information Points, except the From and To encompass 1-hour intervals between overall From and To specified in Input Job file. If only 1 hour range was specified, this sheet is identical to 11.Information Points.

11.Information Points.Pivot

This sheet uses data in 11.Information Points.Hourly sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.

Columns	Rows	Values	Filters
	Controller
	Application
	IPType
	IPName
		ART (Average)
		Time (Sum)
		Calls (Sum)
		CPM (Average)
		Errors (Sum)
		EPM (Average)
		Errors % (Average)
			HasActivity
			From