Detected SIM Entities Report
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
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
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 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 |
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:
