Skip to content
Assets-Databases
Vish ReddyMay 13, 2025 5:56:57 PM5 min read

Understanding JSM Assets Through a Database Lens: A Practical Guide

If you've ever struggled to wrap your head around Atlassian's JSM Assets, you're not alone. As powerful as this configuration management tool is, its unique terminology and structure can present a steep learning curve for many IT professionals. However, there's good news: if you understand relational databases, you already have a solid foundation for mastering JSM Assets.

Bridging the Knowledge Gap: JSM Assets Meets Database Concepts

Atlassian's Jira Service Management (JSM) Assets serves as a sophisticated tool for comprehensive asset and configuration management. It's designed for organizations using JSM Premium and Enterprise plans who need to track, manage, and understand the relationships between various assets—from hardware and software to personnel.

The beauty of approaching JSM Assets through a database lens is that it leverages knowledge most IT professionals already possess. By mapping JSM components to familiar database concepts, we can significantly reduce the learning curve and make this powerful tool more accessible.

The Core Mapping: JSM Assets to Database Structures

Let's break down the key parallels:

Object Schema ≈ Database

In JSM Assets, an Object Schema is the highest-level container—think of it as "the map that holds it all together." It groups related object types, objects, attributes, and configurations.

This directly mirrors a Database in the relational world. Just as a database server can host multiple distinct databases (HR_DB, Sales_DB, Inventory_DB), JSM can host multiple Object Schemas for different purposes.

Object Type ≈ Table

Within an Object Schema, Object Types classify similar items like "Computers," "Mobile Phones," or "Servers." Each Object Type defines the attributes that all objects of that type will possess.

This corresponds to a Table in a database, which stores data for a specific entity type (like 'Employees' or 'Products') and organizes it into rows and columns.

Attribute ≈ Column/Field

Attributes in JSM Assets are the specific characteristics of an Object Type—like Name, RAM, or SerialNumber for a "Computer" Object Type.

This maps directly to Columns in a database table, which represent specific pieces of information stored for every record.

Object ≈ Row/Record

Objects are the actual assets being tracked—individual, concrete instances of an Object Type. Each Object holds particular values for the attributes defined by its type.

This parallels a Row in a database table—a single instance of the entity that contains specific values for each column.

Reference Types & Object Attributes ≈ Relationships

JSM Assets uses References to connect objects through attributes. When an attribute of type 'Object' is created, it points to another specific object, establishing a relationship.

This functions similarly to Relationships in databases, primarily established using Foreign Keys that refer to the Primary Key of another table.

To summarize the parallels discussed, the following table provides an at-a-glance comparison:

JSM Assets Component

Database Equivalent

Brief Description/Purpose in JSM Assets

Brief Description/Purpose in Database

Object Schema

Database

Top-level container for related object types, objects, attributes, and configurations; defines a management and security boundary.

Main container for related tables, views, and other database objects; organizes data for a specific application or system.

Object Type

Table

Defines the structure (attributes) for a group of similar assets (objects); a blueprint for assets.

Defines the structure (columns) for a specific type of entity; organizes data into rows and columns.

Attribute

Column / Field

A specific characteristic or property of an Object Type, defining the data to be stored for each object.

A specific piece of information for each record in a table; defines a data point for an entity.

Object

Row / Record

An individual instance of an Object Type; the actual asset being tracked, holding specific attribute values.

A single instance of an entity in a table; contains specific values for each column.

Reference (via Object Attribute) & Reference Type

Relationships (Foreign Keys, Join Tables) & Semantic Meaning

Connects two objects, defining a relationship between them. Reference Type adds semantic meaning to the link (e.g., 'Depends on').

Links data between tables, typically via foreign keys. Join tables handle many-to-many links. Semantic meaning often documented externally.

Status Attribute

Dedicated Status Column with Predefined Values

A special attribute type representing an object's lifecycle state (e.g., 'Active', 'Retired'), with built-in categorization.

A column storing the state of a record, often with constraints or a lookup table to enforce predefined values.

 

JSM Assets in Action: A Practical Example

Let's visualize these concepts with a common IT asset management scenario: tracking company laptops, servers, and their assignment to employees.

  1. Creating an Object Schema: "IT Hardware & Employee Assets"
    • Similar to: CREATE DATABASE ITHardwareDB;
    • This establishes our primary container for all subsequent asset types and configurations.
  2. Defining Object Types (i.e., Tables):
    • Laptop Object Type: Blueprint for laptop records
    • Server Object Type: Template for server records
    • Employee Object Type: Structure for employee information
    • Similar to: CREATE TABLE Laptops (...); CREATE TABLE Servers (...); CREATE TABLE Employees (...);
  3. Adding Attributes (i.e., Columns):
    • For Laptops: Name, SerialNumber, Model, PurchaseDate, WarrantyExpiry, AssignedTo, Status
    • For Servers: Name, Hostname, IPAddress, OperatingSystem, RAM_GB, Location, Status
    • For Employees: FullName, EmployeeID, Email, Department
  4. Establishing Relationships:
    • The "AssignedTo" attribute in Laptops creates a relationship with Employees
    • We define Reference Types to describe the nature of this relationship:
      • Outbound: "Is Assigned To" (laptop perspective)
      • Inbound: "Uses Laptop" (employee perspective)
  5. Creating Individual Assets (i.e., Rows):
    • New Employee: Alice Wonderland, EMP001, alice.wonderland@example.com, IT Support
    • New Laptop: AW-DELL-XPS13-01, SN123ABC456, XPS 13 9310, assigned to Alice

Beyond Databases: What Makes JSM Assets Special

While the database analogy helps us understand JSM Assets' structure, it's important to recognize its unique advantages:

  1. Native Integration with Jira: Assets are seamlessly linked to incidents, service requests, problems, and changes, providing immediate context for service agents.
  2. Visualization of Relationships: Built-in tools visualize dependencies between assets, critical for understanding complex IT environments and planning changes.
  3. User-Friendly Interface: The graphical interface makes asset modeling accessible to IT staff who may not be database experts.
  4. Specialized Attribute Types: Purpose-built attribute types like 'User', 'IP Address', and 'Status' come with validation logic and direct linking to other Jira entities.
  5. Lifecycle Management: The 'Status' attribute provides a standardized framework for tracking assets from procurement to disposal.
  6. Granular Permissions: Fine-grained access controls ensure that sensitive asset information is appropriately restricted.
  7. Automated Discovery and Import: Tools to scan networks and import data significantly simplify populating and maintaining your CMDB.

Conclusion: Leveraging Your Database Knowledge

By understanding these parallels between JSM Assets and database structures, you can accelerate your learning and create more effective asset schemas. The principles of good database design—clear data definitions, well-structured relationships, and proper normalization—apply directly when configuring JSM Assets.

Rather than viewing JSM Assets as an entirely new system to master, see it as a specialized application built on familiar database principles, tailored specifically for the complex demands of modern IT asset management.

Whether you're just getting started with JSM Assets or looking to optimize your existing configuration, this database perspective provides a valuable framework for success.

Have you used JSM Assets in your organization? How does this database comparison help clarify its structure? Share your experiences in the comments below!

 

avatar
Vish Reddy
Vish is the CEO and Co-founder of Revyz Inc and leads the strategic growth of the company from the HQ in San Francisco. Over the past twenty years, Vish has worked exclusively in the IT sector with senior roles in large scale, data protection and backup firms such as Symantec and Druva. Vish is currently leader at Atlassian ACE San Francisco as well as a frequent speaker on business, data resiliency, IT security and startups.

RELATED ARTICLES