Inventory Management System Database Tables

The Inventory Management System database user has read-only access or SELECT privileges to the following Junos Scope Inventory Management System database tables:

The database user does not have access to other Junos Scope database tables that are not described in this document.

devices Table

The devices database table stores all Juniper Networks devices added in Junos Scope. For information about adding devices, see Setting Up Devices. Table 31 shows the fields and columns in the devices table.

Table 31: devices Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

name

varchar(40)

    

hostname

varchar(40)

    

model

varchar(20)

Yes

   

comment

text

Yes

   

deleted_on

timestamp(14)

Yes

   

hardware_inventory Table

The hardware_inventory database table stores information about all hardware components installed in devices added in Junos Scope. Table 32 shows the fields and columns in the hardware_inventory table.

Table 32: hardware_inventory Table

Field

Type

Null

Key

Default

Extra

id

int(11)

PRI

  

auto_increment

device_id

int(11)

  

0

 

chassis_id

varchar(20)

    

version

varchar(20)

    

part_number

varchar(20)

    

serial_number

varchar(20)

    

name

varchar(40)

    

module

varchar(40)

Yes

   

submodule

varchar(40)

Yes

   

subsubmodule

varchar(40)

Yes

   

description

varchar(40)

    

comment

text

Yes

   

last_scanned

timestamp(14)

Yes

   

last_modified

timestamp(14)

Yes

   

created_on

timestamp(14)

Yes

   

deleted_on

timestamp(14)

Yes

   

software_inventory Table

The software_inventory database table stores information about all Junos OS packages installed on devices added in Junos Scope. Table 33 shows the fields and columns in the software_inventory table.

Table 33: software_inventory Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

device_id

int(11)

  

0

 

routing_engine

varchar(10)

    

version

varchar(20)

    

last_scanned

timestamp(14)

Yes

   

last_modified

timestamp(14)

Yes

   

created_on

timestamp(14)

Yes

   

deleted_on

timestamp(14)

Yes

   

packages_inventory Table

The packages_inventory database table stores all Junos OS packages installed on devices added in Junos Scope. Table 34 shows the fields and columns in the packages_inventory table.

Table 34: packages_inventory Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

device_id

int(11)

  

0

 

routing_engine

varchar(10)

    

name

varchar(20)

    

comment

varchar(100)

    

last_scanned

timestamp(14)

Yes

   

last_modified

timestamp(14)

Yes

   

created_on

timestamp(14)

Yes

   

deleted_on

timestamp(14)

Yes

   

licensing_inventory Table

The licensing_inventory database table stores information about all licensed features installed on devices added in Junos Scope. Table 35 shows the fields and columns in the licensing_inventory table.

Table 35: licensing_inventory Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

device_id

int(11)

  

0

 

feature_name

varchar(64)

    

feature_description

varchar(64)

    

licensed_count

int(11)

  

0

 

used_count

int(11)

  

0

 

given_count

int(11)

  

0

 

given_hint

varchar(64)

    

needed_count

int(11)

  

0

 

last_scanned

timestamp(14)

Yes

   

last_modified

timestamp(14)

Yes

   

created_on

timestamp(14)

Yes

   

deleted_on

timestamp(14)

Yes

   

events_inventory Table

The events_inventory database table stores all events that occur during an inventory scan using the Inventory Management System. For more information about running an inventory scan, see Scanning Inventory Data. Table 36 shows the fields and columns in the events_inventory table.

Table 36: events_inventory Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

device_id

int(11)

  

0

 

hardware_id

int(11)

  

0

 

software_id

int(11)

  

0

 

package_id

int(11)

  

0

 

licensing_id

int(11)

  

0

 

item

varchar(40)

    

type

varchar(10)

    

description

text

Yes

   

annotation

text

Yes

   

event_time

timestamp(14)

Yes

   

deleted_on

timestamp(14)

Yes

   

inventory_events_types Table

The inventory_events_types database table stores all inventory scan event types. Table 37 shows the fields and columns in the inventory_events_types table.

Table 37: inventory_events_types Table

Field

Type

Null

Key

Default

Extra

id

int(11)

 

PRI

 

auto_increment

event_type

varchar(10)

    

module_interface_version Table

The module_interface_version database table stores and identifies the module name and version of the Inventory Management System database. Table 38 shows the fields and columns in the module_interface_version table.

Table 38: module_interface_version Table

Field

Type

Null

Key

Default

Extra

module

varchar(40)

 

PRI

  

version

int(11)

  

0

 

For example, the module field can be either:

module = core, version = 1module = ims, version = 1

The version field is incremented when an update is made to the documented SQL interface with respect to the module. An update occurs when:

The module version identifies the public subset of the Junos Scope database schema.

Table-to-Module Mapping

Two modules are currently defined: ims and core.

ims Module

Version 1 of the ims module consists of the following tables:

core Module

The core module (version 1) consists of the devices table listed in Table 31.