Detected WEB Entities Report - Appdynamics/AppDynamics.DEXTER GitHub Wiki
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:
- Job file included at least one WEB application Target.Type=
WEB - Metadata is extracted via Input.DetectedEntities=
true - Report is requested via Output.DetectedEntities=
true
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
Report Contents
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:
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:
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:
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:
