Detected SIM Entities Report

Overview

Detected SIM Entities report shows information about each and every detected Entity (Tier, Node, Machine, Network Adapter, CPU, Disk, Container and Process ) in SIM applications.

It is only generated if user requested SIM application (ApplicationType=SIM) in Target in Job File.

Report File Locations

Detected SIM Entities report is produced when Output.DetectedEntities=True and when the SIM application was queried.

Detected SIM Entities report has the following file format Report\DetectedEntities.SIM.<Job File Name>.<Start Date and Time>-<End Date and Time>.xlsx

For example, DetectedEntities.SIM.demo1demo2.withSIM.201807202100-201807202110.xlsx

Data File Locations

The data for the report is in the following files:

• "Report\SIMENT\applications.csv"
• "Report\SIMENT\machinecontainers.csv"
• "Report\SIMENT\machinecpus.csv"
• "Report\SIMENT\machinenetworks.csv"
• "Report\SIMENT\machineprocesses.csv"
• "Report\SIMENT\machineproperties.csv"
• "Report\SIMENT\machines.csv"
• "Report\SIMENT\machinevolumes.csv"
• "Report\SIMENT\nodes.csv"
• "Report\SIMENT\tiers.csv"

Report Contents

Data	Pivot
1.Parameters
2.Contents
3.Controllers
4.Appplications
5.Tiers
6.Nodes
7.Machines	7.Machines.Type
8.Machine Properties	8.Machine Properties.Type
9.Machine Volumes	9.Machine Volumes.Type
10.Machine Networks	10.Machine Networks.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

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
UserName	String	User that was used to retrieve data from the Controller
Version	String	Version of the Controller
NumApps	Integer	Number of APM Applications registered in the Controller
ControllerLink	URL	Link to Controller

4.Applications

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

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

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

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

7.Machines.Type

This sheet uses data in 7.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
			IsEnabled
			AgentVersion
BackendType
AgentVersion
	Controller
	TierName
	MachineName
		MachineID (Count)

Example report showing fairly complex application with a lot of various Machines registered:

Full Size

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

8.Machine Properties.Type

This sheet uses data in 8.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
			PropType
	PropName
	PropValue
	Controller
	TierName
	MachineName
		MachineID (Count)

Example report showing fairly complex application with a lot of various Machines registered:

Full Size

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

9.Machine Volumes.Type

This sheet uses data in 9.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 showing fairly complex application with a lot of various Machines registered:

Full Size

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

10.Machine Networks.Type

This sheet uses data in 10.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
			Enabled
			PluggedIn
			Duplex
			MTU
Speed
	State
	NetworkName
	Controller
	TierName
	MachineName
	IP4Address
		MachineID (Count)

Example report showing fairly complex application with a lot of various Machines registered:

Full Size