Detected SIM Entities Report
Detected SIM Entities report shows information about eac# 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
Detected SIM Entities report has the following file format
Report\Entities.SIM.<Job File Name>.<Start Date and Time>-<End Date and Time>.xlsx
For example:
Entities.SIM.demo1demo2.withSIM.201807202100-201807202111.xlsx
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
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 |
This sheet provides quick access to the contents of this report and provides at-a-glance number of rows in eac# 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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:
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 |
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:
Same report filtered to show values of all Tags starting wit# AWS in the 2 SIM Applications in 2 Controllers:
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 |
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:
Same report filtered to show values of specific Partition and it's Mount Points in the 2 SIM Applications in 2 Controllers:
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 |
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
Here are all the Network Adapters that are Up filtered to only show those at 10Gbps speed ordered by frequency of showing:
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 |
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:
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 |
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 |
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:
Here are only the processes running under "apache" user:
Here are only the processes running under "root" user:
