Skip to content

Detected WEB Entities Report

Daniel Odievich edited this page May 7, 2020 · 11 revisions

Overview

Detected WEB Entities report shows information about each and every detected Entity in WEB applications (Pages, AJAX Requests, Virtual Pages, Resources and Geolocations).

Detected WEB Entities report is produced when:

Report File Locations

Detected WEB Entities report has the following file name:

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

For example:

Entities.WEB.demo2Ecommerce.2017091914.2.xlsx

Data File Locations

The data for the report is in the following files:

  • Report\ENT\applications.csv
  • Report\ENT\controllers.csv
  • Report\ENTWEB\applications.web.csv
  • Report\ENTWEB\geolocations.csv
  • Report\ENTWEB\webpages.bts.csv
  • Report\ENTWEB\webpages.csv
  • Report\ENTWEB\webpages.resources.csv

Data Schema

Full Size

Report Contents

Data Pivot
1.Parameters
2.Contents
3.Controllers
4.Applications.All
5.Applications.WEB
6.Web Pages 6.Web Pages.Type
7.Page Resources 7.Page Resources.Type
8.Page BTs 8.Page BTs.Type
9.Geo Locations 9.Geo Locations.Type

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 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.All

This sheet lists all Applications of any Type in all Controllers covered by this report.

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
Description String Description of Application, if set
Type String Type of the Application
Types Array Types of Application in this application. Most commonly seen are APM and WEB grouped together
CreatedBy String Who created this Application
CreatedOn Datetime When the Application was created, local time
CreatedOnUtc Datetime When the Application was created, UTC time
UpdatedBy String Who updated this Application last
UpdatedOn Datetime When the Application was updated, local time
UpdatedOnUtc Datetime When the Application was updated, UTC time
ApplicationID Integer ID of Application in Controller
ParentApplicationID Integer ID of Parent Application. Used by MOBILE Applications

5.Applications.WEB

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

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
NumPages Integer Number of Pages detected
NumAJAXRequests Integer Number of AJAX Requests detected
NumVirtualPages Integer Number of Virtual Pages detected
NumIFrames Integer Number of IFrames detected
NumRealGeoLocations Integer Number of Real Geo Locations detected
NumRealGeoLocationsRegion Integer Number of Real Geo Location Regions detected
NumSynthGeoLocations Integer Number of Synthetic Geo Locations used
NumSynthGeoLocationsRegion Integer Number of Synthetic Geo Location Regions used
NumActivity Integer Number of entities with activity
NumNoActivity Integer Number of entities with no activity
ApplicationID Integer ID of Application in Controller
ControllerLink URL Link to Controller
ApplicationLink URL Link to Application in Controller

6.Web Pages

This sheet provides information about all Web Pages, Virtual Pages, AJAX and IFrame Requests in all Applications in all Controllers covered by this report.

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
PageType String Type of Page (AJAX_REQUEST, BASE_PAGE, IFRAME, VIRTUAL_PAGE)
PageName String Name of Page
FirstSegment String First segment of Page name (up until the first /)
NumNameSegments Integer Number of Page Name segments (count of items between /)
IsCorrelated Boolean Is this Page correlated to APM Application Business Transaction
IsCookie Boolean Does this Page have Cookie data
IsNavtime Boolean Does this Page have Navigation time data
IsSynthetic Boolean Is this Page invocation via Synthetic script
NumBTs Integer Number of correlated BTs for this Page
NumPages Integer Number of child Pages to this Page (typically child AJAX requests)
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
DOMReady Integer time to DOM Ready for Entity
FirstByte Integer time to First Byte for Entity
ServerConnection Integer Server Connection time for Entity
DNS Integer DNS Connection time for Entity
TCP Integer TCP Negotiation time for Entity
SSL Integer SSL Negotiation time for Entity
Server Integer Server time for Entity. Typically accounted for by APM agents.
HTMLDownload Integer time to download HTML for Entity.
DOMBuild Integer DOM Building time for Entity
ResourceFetch Integer Resource Fetch time for Entity
JSErrors Integer Number of JavaScript Errors for Entity
JSEPM Integer JavaScript Errors per Minute for Entity
AJAXErrors Integer Number of AJAX Errors for Entity
AJAXEPM Integer AJAX 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
PageID Integer ID of Page in Controller
ControllerLink URL Link to Controller
ApplicationLink URL Link to Application in Controller
PageLink URL Link to Page in Controller
MetricLink URL Link to Metric Browser for all Metrics in Page for this time range

6.Web Pages.Type

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

Default configuration provides breakdown of Web Pages by Type and Segment Name, with performance characteristics.

Columns Rows Values Filters
Controller
ApplicationName
PageType
FirstSegment
PageName
PageID (Count)
ART (Average)
Time (Sum)
Calls (Sum)
CPM (Average)
HasActivity
ARTRange
NumNameSegments

Example report showing EUM Application AJAX Requests to Google services:

Full Size

7.Page Resources

This sheet provides information about all resources requested by Web Pages, Virtual Pages, AJAX and IFrame Requests in all Applications in all Controllers covered by this report.

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
PageType String Type of Page (AJAX_REQUEST, BASE_PAGE, IFRAME, VIRTUAL_PAGE)
PageName String Name of Page
ChildPageType String Type of Child Page (AJAX_REQUEST, BASE_PAGE, IFRAME, VIRTUAL_PAGE)
ChildPageName String Name of Child Page
ART Integer Average Response time (ms) for Resource
ARTRange String String representing bucket into which ART fits
Calls Integer Total Calls for Resource
CPM Integer Calls per Minute for Resource
HasActivity Boolean Whether this Resource 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
PageID Integer ID of Page in Controller
ControllerLink URL Link to Controller
ApplicationLink URL Link to Application in Controller

7.Page Resources.Type

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

Default configuration provides breakdown of Web Pages and their dependencies by Type and Child Page Name, with performance characteristics.

Columns Rows Values Filters
Controller
ApplicationName
PageName
ChildPageType
ChildPageName
ChildPageID (Count)
ART (Average)
Calls (Sum)
CPM (Average)
HasActivity
ARTRange

Example report showing EUM Application AJAX Requests to Google services:

Full Size

8.Page BTs

This sheet provides information about all APM Business Transactions requested by Web Pages, Virtual Pages, AJAX and IFrame Requests in all Applications in all Controllers covered by this report.

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
PageType String Type of Page (AJAX_REQUEST, BASE_PAGE, IFRAME, VIRTUAL_PAGE)
PageName String Name of Page
TierName String Name of Tier
BTName String Name of Business Transaction
BTType String Type of Business Transaction
ART Integer Average Response time (ms) for BT
ARTRange String String representing bucket into which ART fits
Calls Integer Total Calls for BT
CPM Integer Calls per Minute for BT
HasActivity Boolean Whether this BT 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
PageID Integer ID of Page in Controller
TierID Integer ID of Tier in Application
BTID Integer ID of Business Transaction in Application
ControllerLink URL Link to Controller
ApplicationLink URL Link to Application in Controller

8.Page BTs.Type

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

Default configuration provides breakdown of Web Pages and their Business Transaction Dependencies by Type and Child Page Name, with performance characteristics.

Columns Rows Values Filters
Controller
ApplicationName
PageName
TierName
BTName
BTID (Count)
ART (Average)
Calls (Sum)
CPM (Average)
HasActivity
ARTRange

Example report showing EUM Application AJAX Requests to Google services:

Full Size

9.Geo Locations

This sheet provides information about all Geo Locations detected by Web Pages, Virtual Pages, AJAX and IFrame Requests in all Applications in all Controllers covered by this report.

Column Data Type Purpose
Controller URL Controller that was queried
ApplicationName String Name of Application
LocationType String Type of Location
LocationName String Name of Location
Country String Country
Region String Region
City String City
GeoCode String Code for this Location
Latitude String Latitude of the Location
Longitude String Longitude of the Location
ART Integer Average Response time (ms) for Entity
ARTRange String String representing bucket into which ART fits
Calls Integer Total Calls for Entity
CPM Integer Calls per Minute for Entity
DOMReady Integer time to DOM Ready for Entity
FirstByte Integer time to First Byte for Entity
ServerConnection Integer Server Connection time for Entity
HTMLDownload Integer time to download HTML for Entity.
DOMBuild Integer DOM Building time for Entity
ResourceFetch Integer Resource Fetch time for Entity
JSErrors Integer Number of JavaScript Errors for Entity
JSEPM Integer JavaScript Errors per Minute for Entity
AJAXEPM Integer AJAX 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
ControllerLink URL Link to Controller
ApplicationLink URL Link to Application in Controller

9.Geo Locations.Type

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

Default configuration provides breakdown of Geo Locations by Type and Location Name, with performance characteristics.

Columns Rows Values Filters
Controller
ApplicationName
LocationType
Country
Region
LocationName
ART (Average)
Calls (Sum)
CPM (Average)
HasActivity
ARTRange

Example report showing EUM Application AJAX Requests to Google services:

Full Size

Clone this wiki locally