Licenses Report

Overview

Licenses report provides information about global account and license rule configuration and consumption for Controller.

Licenses report is produced when:

• License information is extracted via Input.Licenses=true
• Report is requested via Output.Licenses=true

Report File Locations

Licenses report has the following file name:

Report\Licenses.<Job File Name>.<Start Date and Time>-<End Date and Time>.xlsx

For example:

Licenses.demo2Ecommerce.2017091914-2017091916.xlsx

Data File Locations

The data for the report is in the following files:

• Report\LIC\account.csv
• Report\LIC\licenserules.csv
• Report\LIC\licenserulescopes.csv
• Report\LIC\licenses.csv
• Report\LIC\licenseusage.account.csv
• Report\LIC\licenseusage.rules.csv

Data Schema

Full Size

Report Contents

Data	Pivot
1.Parameters
2.Contents
3.Controllers
4.Applications.All
5.Accounts
6.Licenses	6.Licenses.Type
7.Licenses Usage	7.Licenses Usage.Timeline
8.License Rules	8.License Rules.Type
9.License Rules Usage	9.License Rules Usage.Timeline
10.License Rule Scopes	10.License Rule Scopes.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 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.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.Accounts

This sheet lists all Accounts settings in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
AccountName	String	Name of Account, short version
AccountNameGlobal	String	Name of Account, long version
AccountNameEUM	String	Name of Account, EUM version
AccessKey1	String	Access key for Account, short version
AccessKey2	String	Access key for Account, long version
LicenseKeyEUM	String	License key for EUM
ServiceKeyES	String	Events service key
ExpirationDate	DateTime	Account expiration date
AccountID	Integer	ID of the Account
LicenseLink	URL	Link to Controller License page for this time range

6.Licenses

This sheet lists all global Licenses in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
AccountName	String	Name of Account, short version
AgentType	String	Type of licensed Agent
Edition	String	License edition
Model	String	License model
Licenses	Integer	Number of Licenses associated with this agent
Units	Integer	Units of consumption associated with this License
Min	Integer	Minimum License consumption for this License in this time range
Peak	Integer	Maximum License consumption for this License in this time range
Retention	Integer	Retention period, days
StartDate	DateTime	License start date, UTC
ExpirationDate	DateTime	License expiration date, UTC
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
AccountID	Integer	ID of the Account

5.License.Type

TODO

7.Licenses Usage

This sheet lists usage for Global Licenses in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
AccountName	String	Name of Account, short version
RuleName	String	Name of the Rule. Always "Account" in this case
AgentType	String	Type of licensed Agent
LicenseEventTime	DateTime	When was license consumed, local time
LicenseEventTimeUtc	DateTime	When was license consumed, local time
Value	Integer	Duration of time range queried, in minutes
AccountID	Integer	Value of License consumption

!!!!!!!!!!!!

5.Events.Type

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

Default configuration provides breakdown of Events by Type, Subtype and summarized by Severity in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
Severity
	Controller
	ApplicationName
	Type
	SubType
	TierName
	BTName
	NodeName
		EventID (Count)

Example report showing a fairly busy Controller with lots of Event types happening:

Full Size

5.Events.Timeline

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

Default configuration provides per-minute summary of events by Severity, Type and SubType.

Columns	Rows	Values	Filters
Severity
Type
Subtype
	Occurred
		EventID (Count)
			ApplicationName
			TierName
			BTName
			TriggeredEntityName

In this example, we are showing comparisons between 6PM and 7PM for the events broken out by Severity:

Full Size

Filtering on Severity=WARN and Type=POLICY_OPEN_WARNING, we can see results per hour, seeing that 6PM has more BUSINESS_TRANSACTION events than 7PM:

Full Size

6.HR Violations

This sheet lists all Health Rule Violations that occurred in the specified time range 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
EventID	Integer	ID of the Event
Severity	String	Severity of the Event (INFO, WARN, ERROR)
Status	String	Status of the Event
Description	String	Summary of the Event
From	DateTime	Beginning of Health Rule Violation, local time
To	DateTime	Beginning of Health Rule Violation, local time
FromUtc	DateTime	Beginning of Health Rule Violation, UTC time
ToUtc	DateTime	Beginning of Health Rule Violation, UTC time
HealthRuleName	String	Name of Health Rule that caused this Event
EntityType	String	Type of Entity that this Health Rule is tied to
EntityName	String	Name of Entity that this Health Rule is tied to
EntityID	Integer	ID of Entity that this Health Rule is tied to
ApplicationID	Integer	ID of Application in Controller
HealthRuleID	String	ID of Health Rule that triggered this Health Rule Violation
ControllerLink	URL	Link to Controller for this time range
ApplicationLink	URL	Link to Application in Controller for this time range
HealthRuleLink	URL	Link to Heath Rules in Controller for this Application
EntityLink	URL	Link to Entity in Controller for this time range
EventLink	URL	Link to Event in Controller

6.HR Violations.Type

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

Default configuration provides breakdown of Health Rule Violations by Type, Subtype and summarized by Severity in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
Severity
	Controller
	ApplicationName
	Status
	HealthRuleName
	EntityType
	EntityName
		EventID (Count)

Example report showing a fairly busy Controller with lots of Health Rule Violations happening:

Full Size

Here is the drill down to one of the Health Rule Violations where we see it triggering in multiple Applications:

Full Size

7.Audit Events

This sheet lists all Health Rule Violations that occurred in the specified time range in all Applications in all Controllers covered by this report.

Column	Data Type	Purpose
Controller	URL	Controller that was queried
UserName	String	User name of the user being audited
LoginType	String	Type of login (INTERNAL, SAML, LDAP)
AccountName	String	Name of the account used by user
Action	String	Action described by this audit event
EntityName	String	Name of Entity associated with audit event
EntityType	String	Type of Entity associated with audit event
EntityID	Integer	ID of Entity associated with audit event
Occurred	DateTime	Beginning of Health Rule Violation, local time
OccurredUtc	DateTime	Beginning of Health Rule Violation, UTC time

7.Audit Events.Type

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

Default configuration provides breakdown of Health Rule Violations by Type, Subtype and summarized by Severity in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
LoginType
UserName
	Controller
	Action
	EntityType
	EntityName
		EntityID (Count)

Example report showing list of all Audit events broken down by type of Entity and types of logins:

Full Size

7.Audit Events.Timeline

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

Default configuration provides per-minute summary of events by Severity, Type and SubType.

Columns	Rows	Values	Filters
Action
EntityType
EntityName
	Occurred
		EntityID (Count)
			UserName

In this example, we are showing comparisons between various times of the report, broken down by types of Audit Events:

Full Size

8.Notifications

This sheet lists all Notifications that are currently displayed in upper-right hand corner of the Controller.

The format of the table is the same as 5.Events.