Export Data CSV Schema
This topic provides a better understanding of what goes into a Data Export csv, what the different columns mean, and how you can use data from the csv export to make sense of the inventory.
How export data is generated
Export reports are generated on a regular schedule according to the export configuration. At the scheduled time, JMS executes a job that queries the latest fleet inventory data and writes the results to a csv file. The report filters the data based on the duration specified in the export settings.
Understand the schema
There are three resources you can export. This section explains the columns in the export csv for each resource:
- Managed Instance
- Managed Instance and Java runtime
- Managed Instance, Java runtime, and Application
Table A-3 Managed instance schema
| Column name | Description |
|---|---|
region |
OCI region of the JMS fleet |
compartment_name |
Compartment of the JMS fleet |
compartment_ocid |
OCID (Oracle Cloud Identifier) of the compartment of the JMS fleet |
fleet_ocid |
OCID of the JMS fleet |
fleet_name |
Display name of the JMS fleet |
fleet_status |
Status of the JMS fleet. Possible values are ACTIVE, DELETED, RECLAIMED, FAILED, and CLEANED. |
agent_ocid |
OCID of the managed instance. It can be either a management agent OCID (for OMA and OCMA agents) or instance OCID (for OCA agents). A Managed Instance is a host or a Kubernetes cluster that contains deployed JMS plugin . Refer to the JMS key concepts and terminology. |
hostname |
Display name of the managed instance |
os |
Operating system the managed instance is running |
managed_instance_first_seen |
Timestamp when the managed instance was first seen in fleet |
managed_instance_last_seen |
Timestamp when the managed instance was last seen in fleet |
agent_name |
Hostname as reported by agent |
agent_type |
The type of agent. Possible values are OMA (Oracle Management Agent, OCMA (Oracle Management Agent deployed to a container) and OCA (Oracle Cloud Agent). |
agent_version |
Version of the agent installed. Applicable to OMA and OCMA only |
agent_latest_version |
Latest available version of agent |
agent_java_security_state |
Security state of the Java runtime used by agent |
agent_java_version |
Version of the Java runtime used by agent |
agent_plugin_name |
An agent can have multiple plugins and there is a specific plugin for JMS. In case of OCA, the name of the plugin to the agent is "Oracle Java Management Service". Refer to Manage plugins. For OMA and OCMA, the name of the plugin is jm or jm-container respectively.
|
agent_plugin_version |
Version of the JMS plugin to the agent |
all_ip_addresses |
All IP addresses detected by agent |
all_hostnames |
All host names detected by agent |
all_fqdns |
All Fully Qualified Domain Name detected by agent |
Table A-4 Managed instance and Java runtime schema
| Column name | Description |
|---|---|
java_version |
Version of detected Java runtime |
java_distribution |
Distribution type of detected Java runtime |
install_path |
Path where detected Java runtime is installed |
java_security_state |
Security state of detected Java runtime |
java_first_seen |
Timestamp where detected Java runtime was first seen in the managed instance |
java_last_seen |
Timestamp where detected Java runtime was last seen in the managed instance |
When these columns are empty and the row contains only data for Managed Instance, it means no Java runtimes were discovered in this managed instance.
Table A-5 Managed Instance, Java runtime, and Application
| Column name | Description |
|---|---|
application_name |
Display name of detected application |
application_install_path |
Path where detected Application is installed |
application_first_seen |
Timestamp where this Application was first run with the Java runtime in the managed instance |
application_last_seen |
Timestamp where this Application was last run with the Java runtime in the managed instance |
When these columns are empty and the row contains only data for Managed Instance and Java runtime, it means no Application usage was detected in this managed instance, for the given java runtime.
Examples Given the following row in an example Managed Instance, Java runtime, and Application export.
Table A-6 Managed Instance, Java runtime, and Application export
| Column name | Value |
|---|---|
region |
"ap-mumbai-1" |
compartment_name |
"Compartment_1234" |
compartment_ocid |
"ocid1.compartment.oc1..somerandomcompartmentocid" |
fleet_ocid |
"ocid1.fleet.oc1..ap-mumbai-1.somerandomfleetocid" |
fleet_name |
"Sample fleet name" |
fleet_status |
"Active" |
agent_ocid |
"ocid1.agent.oc1..somerandomagentocid" |
hostname |
"hostname_0" |
os |
"Linux" |
managed_instance_first_seen |
"2025-08-19T03:45:01Z" |
managed_instance_last_seen |
"2025-08-19T03:45:01Z" |
agent_name |
"hostname_0" |
agent_type |
"OMA" |
agent_version |
"1.0.0" |
agent_latest_version |
"1.0.1" |
agent_java_security_state |
"UP_TO_DATE" |
agent_java_version |
"1.8.0_281" |
agent_plugin_name |
"Oracle Java Management Service" |
agent_plugin_version |
"2.0.1" |
all_ip_addresses |
"['192.168.1.0', '192.168.2.0']" |
all_hostnames |
"['hostname_0', 'hostname_alt_0']" |
all_fqdns |
"['hostname_0.example.com', 'hostname_alt_0.example.com']" |
java_version |
"17.0.1" |
java_vendor |
"Oracle Corporation" |
java_distribution |
"OpenJDK Runtime Environment" |
install_path |
"/usr/java/jdk17.0.1" |
java_security_state |
"UPGRADE_REQUIRED" |
java_first_seen |
"2025-08-19T03:45:01Z" |
java_last_seen |
"2025-08-19T03:45:01Z" |
application_name |
"com.example.Main" |
application_install_path |
"/usr/local/com/example/Main" |
application_first_seen |
"2025-08-19T03:45:01Z" |
application_last_seen |
"2025-08-19T03:45:01Z" |