Detected SIM Entities Report

Overview

Detected SIM Entities report shows information about each and every detected Entity in SIM Application (Tiers, Nodes, Machines, Network Adapters, CPUs, Disks, Containers and Processes).

Detected SIM Entities report is produced when:

• Job file included SIM application Target.Type=SIM
• Metadata is extracted via Input.DetectedEntities=true
• Report is requested via Output.DetectedEntities=true

Report File Locations

Detected SIM Entities report has the following file name:

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

For example:

Entities.SIM.demo1demo2.withSIM.201807202100-201807202111.xlsx

Data File Locations

The data for the report is in the following files:

• Report\ENT\applications.csv
• Report\ENT\controllers.csv
• Report\ENTSIM\applications.sim.csv
• Report\ENTSIM\machinecontainers.csv
• Report\ENTSIM\machinecpus.csv
• Report\ENTSIM\machinenetworks.csv
• Report\ENTSIM\machineprocesses.csv
• Report\ENTSIM\machineproperties.csv
• Report\ENTSIM\machines.csv
• Report\ENTSIM\machinevolumes.csv
• Report\ENTSIM\simnodes.csv
• Report\ENTSIM\simtiers.csv

Data Schema

Full Size

Report Contents

Data	Pivot
1.Parameters
2.Contents
3.Controllers
4.Applications.All
5.Applications.SIM
6.Tiers
7.Nodes
8.Machines	8.Machines.Type
9.Machine Properties	9.Machine Properties.Type
10.Machine Volumes	10.Machine Volumes.Type
11.Machine Networks	11.Machine Networks.Type
12.Machine CPUs	12.Machine CPUs.Type
13.Machine Containers
14.Machine Processes	14.Machine Processes.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.SIM

This sheet provides information about all SIM Applications 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
NumTiers	Integer	Number of Tiers in Application
NumNodes	Integer	Number of Nodes in Application
NumMachines	Integer	Number of Machines in Application
NumSAs	Integer	Number of Service Availability configurations. Not currently implemented
NumSAEvents	Integer	Number of Service Availability events. Not currently implemented
ControllerLink	URL	Link to Controller
ApplicationLink	URL	Link to Application in Controller

6.Tiers

This sheet provides information about all Tiers in all SIM 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
NumSegments	Integer	Number of segments in the TierName (Separated by `
NumNodes	Integer	Number of Nodes in this Tier
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
ControllerLink	URL	Link to Controller
ApplicationLink	URL	Link to Application in Controller
TierLink	URL	Link to Tier in Controller

7.Nodes

This sheet provides information about all Nodes in all Tiers in all SIM 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
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application
NodeID	Integer	ID of APM Agent in Application
MachineID	Integer	ID of Machine Agent in Application
ApplicationLink	URL	Link to Application in Controller

8.Machines

This sheet provides information about all Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
MachineType	String	Type of Machine (PHYSICAL, CONTAINER_AWARE, CONTAINER)
IsHistorical	Boolean	Not sure what this is
IsEnabled	Boolean	Is SIM enabled
DynamicMonitoringMode	String	Type of dynamic monitoring (KPI, UNKNOWN)
HostMachineID	String	ID of the host machine (if MachineType=CONTAINER)
DotnetCompatibilityMode	Boolean	Is .NET Compatibility mode set
ForceMachineInstanceRegistration	Boolean	Not sure what this is
AgentConfigFeatures	String	List of SIM features enabled
ControllerConfigFeatures	String	List of SIM features enabled
MemPhysical	Integer	Amount of Physical Memory
MemSwap	Integer	Amount of Swap Memory
MachineInfo	String	OS Information
JVMInfo	String	JVM Information (I think of Machine Agent)
InstallDirectory	String	Machine Agent Installation folder
AgentVersion	String	Version of Machine Agent, parsed to #.#.#.#
AgentVersionRaw	String	Version of Machine Agent as reported to Controller
AutoRegisterAgent	Boolean	Not sure what this is
AgentType	String	Type of Agent
APMApplicationName	String	Name of APM Application this Machine Agent is registered to
APMTierName	String	Name of APM Tier this Machine Agent is registered to
APMNodeName	String	Name of APM Node this Machine Agent is registered to
NumProps	Integer	Number of properties in Machine
NumTags	Integer	Number of tags in Machine
NumCPUs	Integer	Number of CPUs in Machine
NumVolumes	Integer	Number of Volumes in Machine
NumNetworks	Integer	Number of Network Adapters in Machine
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application
ApplicationLink	URL	Link to Application in Controller

8.Machines.Type

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

Default configuration provides breakdown of Machines by Type in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
BackendType
AgentVersion
	Controller
	TierName
	MachineName
		MachineID (Count)
			IsEnabled
			APMApplicationName

Example report showing Controller-level summary of SIM Machines registered by type and version:

Full Size

9.Machine Properties

This sheet provides information about Properties and Tags of Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
PropType	String	Type of property (Tag, Property)
PropName	String	Name of property
PropValue	String	Value of property
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

9.Machine Properties.Type

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

Default configuration provides breakdown of Machines Properties by Name/Value in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
	PropName
	PropValue
	Controller
	TierName
	MachineName
		MachineID (Count)
			PropType

Example report all Tags in the 2 SIM Applications in 2 Controllers:

Full Size

Same report filtered to show values of all Tags starting wit# AWS in the 2 SIM Applications in 2 Controllers:

Full Size

10.Machine Volumes

This sheet provides information about Volumes of Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
MountPoint	String	Mount point of the volume
Partition	String	Partition on the volume
PartitionMetricName	String	Metric name of the Partition
VolumeMetricName	String	Metric name of the Volume
SizeMB	Integer	Size of the Volume
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

10.Machine Volumes.Type

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

Default configuration provides breakdown of Machine Volumes by Partition/Mount/Size of Volume in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
	Partition
	MountPoint
	SizeMB
	Controller
	TierName
	MachineName
		MachineID (Count)

Example report all Partitions in the 2 SIM Applications in 2 Controllers:

Full Size

Same report filtered to show values of specific Partition and it's Mount Points in the 2 SIM Applications in 2 Controllers:

Full Size

11.Machine Networks

This sheet provides information about Network Adapters of Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
NetworkName	String	Name of the network adapter
MacAddress	String	MAC Address of the network adapter
IP4Address	String	IPv4 address
IP4Gateway	String	IPv4 default gateway address
IP6Address	String	IPv6 address
IP6Gateway	String	IPv6 default gateway address
Speed	Integer	Network speed
Enabled	String	Enabled (yes/no/blank)
PluggedIn	String	Plugged into the wire (yes/no/blank)
State	String	Link state (up/down/unknown)
Duplex	String	Duplex state (full/unknown)
MTU	Integer	MTU size
NetworkMetricName	String	Metric name of the Network
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

11.Machine Networks.Type

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

Default configuration provides breakdown of Machine Networks Speeds by State/Network Name in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
Speed
	State
	NetworkName
	Controller
	TierName
	MachineName
	IP4Address
		MachineID (Count)
			Enabled
			PluggedIn
			Duplex
			MTU

Example report showing 12K Network Adapters in various stages of reporting and wit# different speeds

Full Size

Here are all the Network Adapters that are Up filtered to only show those at 10Gbps speed ordered by frequency of showing:

Full Size

12.Machine CPUs

This sheet provides information about CPUs of Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
CPUID	String	ID of the CPU
NumCores	String	Number of physical cores in CPU
NumLogical	String	Number of logical cores in CPU
Vendor	String	CPU Vendor name
Flags	Integer	CPU feature flags (strings separated by spaces)
NumFlags	String	Number of CPU feature flags (how many of those strings are there)
Model	Integer	CPU Model
Speed	String	CPU Speed, Mhz
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

12.Machine CPUs.Type

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

Default configuration provides breakdown of Machine CPUs Physical and Logical cores by Model/Speed in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
NumCores
NumLogical
	Model
	Speed
	Controller
	TierName
	MachineName
	IP4Address
		MachineID (Count)
			Vendor

Here are 12K CPUs showing how this customer vastly prefers Intel CPUs over AMD, and how most of them are 6 or 4 physical cores:

Full Size

13.Machine Containers

This sheet provides information about Docker Containers of Machines in all Tiers in all SIM 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
MachineName	String	Name of Machine
ContainerID	String	ID of the Container
ContainerName	String	Name of the container
ImageName	String	Name of the image used to make the container
ContainerMachineID	Integer	ID of the Machine on whic# Container is running. Unreliable.
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

14.Machine Processes

This sheet provides information about Processes running on Machines in all Tiers in all SIM Applications in all Controllers in the time range 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
MachineName	String	Name of Machine
Class	String	Class of the process
ClassID	String	Class ID of the process. Appears to be identical to Class
Name	String	Name of the process
CommandLine	String	Full command line of the process
RealUser	String	User running the process
RealGroup	String	Group of user running the process
EffectiveUser	String	Effective user running the process
EffectiveGroup	String	Effective group of user running the process
State	String	State of the process (RUNNING, SLEEPING, TERMINATING, ZOMBIE)
NiceLevel	String	NICE level of the process
StartTime	String	When process was started
EndTime	String	When process was terminated, if it was
PID	Integer	Process ID
ParentPID	Integer	Parent Process ID
PGID	Integer	Don't know what this is
ApplicationID	Integer	ID of Application in Controller
TierID	Integer	ID of Tier in Application that TierName refers to
NodeID	Integer	ID of APM Agent in Application that NodeName refers to
MachineID	Integer	ID of Machine in Application

14.Machine Processes.Type

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

Default configuration provides breakdown of Processes/CommandLine by State by Model/Speed in all Controllers, Applications and Tiers.

Columns	Rows	Values	Filters
State
	Name
	CommandLine
	Controller
	TierName
	MachineName
		MachineID (Count)
			EffectiveGroup
			EffectiveUser
			RealGroup
			RealUser
			NiceLevel

Here are the most frequently running processes:

Full Size

Here are only the processes running under "apache" user:

Full Size

Here are only the processes running under "root" user:

Full Size