Discovery and Inventory Group

 View Only

Inventory for Network Devices 7.1 Database Schema 

Apr 10, 2013 01:06 PM

Whether you need to create a custom report, or a custom network device filter based on Inventory Data in Inventory Solution for Network Devices 7.1, knowing the database schema is important.  If you are new to Inventory Solution in version 7.1, this document provides technical details on how the data is stored.  This document also updates the previous 7.0 document with correct table names and updated column data.

Introduction

Documenting database schema is not an easy task.  SQL can provide a table-column view of all selected tables, but this does not provide any specific details on what the column might actually contain.  While Inventory 7.1 adheres to the CIM (Common Information Model), Inventory for Network Devices does not adhere to this standard.

NOTE: The data structure represented in this document may change, though at the time of publication this is believed to be the accurate information for the release of Inventory Solution for Network Devices 7.1.

Database Schema

The schema for Network Devices contains a flat table structure. There are no interdependencies between the tables beyond the data being linked to the specific Network Device Resource. A common data element provided in this document is the MIB information used to capture the associated data. This can be very useful information if you need to test a specific SysObject ID against a device. The following MIB information is provided on available data classes:

  • File – The MIB file that contains the information for the SysObject ID call.
  • OID String – This contains information for what the data string is for the associated SysObject ID.
  • Object ID – This is the actual SysObject ID used within the SNMP call to fetch the associated data.

 

Note the following when reviewing the grids:

  1. Display Name represents how the column will be labeled when working within the Symantec Management Console, including reports, Resource Manager details, Pickers, etc.
  2. Not all values have descriptions, but the label of the table and column should provide data on what’s stored therein.
  3. Qualifiers per Column/Value are provided based on applicability.
  4. The MIB details are linked by Field Name, located in a separate grid subsequent to the primary one.

 

For help in navigating through the data classes, use the following guide:

  • Inv_SNMP_Host_Devices
  • Inv_SNMP_Host_Resources
  • Inv_SNMP_Win32_Services
  • Inv_SNMP_Win32_Shares
  • Inv_SNMP_Win32_Print_Queues
  • Inv_SNMP_Software
  • Inv_SNMP_Storage
  • Inv_SNMP_Physical_Entities
  • Inv_SNMP_HP_Printer
  • Inv_SNMP_Printer_Cover
  • Inv_SNMP_Printer_Input_Tray
  • Inv_SNMP_Printer_Output_Tray
  • Inv_SNMP_Printer_Supply
  • NETWARE data classes:
    • Inv_SNMP_NW_Adapters
    • Inv_SNMP_NW_Disk_Storage
    • Inv_SNMP_NW_NLM
    • Inv_SNMP_NW_Partitions
    • Inv_SNMP_NW_Printers
    • Inv_SNMP_NW_Server
    • Inv_SNMP_NW_Settings
    • Inv_SNMP_NW_Settings_Descriptions
    • Inv_SNMP_NW_Volume

Standard Data Classes

 

Inv_SNMP_Host_Devices

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

Description

Column ID for entries in the table

_ResourceGuid

uniqueidentifier

Key

TRUE

Description

A unique value for the Network Device the data represents.

Index

int

Key

TRUE

Description

A unique value for each device contained by the host.  The value for each device must remain constant at least from one re-initialization of the agent to the next re-initialization.

Description

nvarchar(255)

Description

A textual description of this device, including the device’s manufacturer and revision, and optionally, its serial number.

Product ID

nvarchar(255)

Description

The product ID for this device.

Status

nvarchar(255)

Description

The current operational state of the device described by this row of the table.  A value unknown(1) indicates that the current state of the device is unknown.  running(2) indicates that the device is up and running and that no unusual error conditions are known.  The warning(3) state indicates that agent has been informed of an unusual error condition by the operational software(e.g., a disk device driver) but that the device Is still ''operational''.  An example would be high number of soft errors on a disk.  A value of testing(4), indicates that the device is not available for use because it is in the testing state.  The state of down(5) is used only when the agent has been informed that the device is not available for any use.

Enums

unknown(1), running(2), warning(3), testing(4), down(5)

Errors

int

Description

The number of errors detected on this device.  It should be noted that as this object has a SYNTAX of Counter, that it does not have a defined initial value.  However, it is recommended that this object be initialized to zero.

 

01.jpg

Inv_SNMP_Host_Resources

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

Description

Column ID for entries in the table

_ResourceGuid

uniqueidentifier

Key

TRUE

Description

A unique value for the Network Device the data represents.

Up Time

nvarchar(128)

Description

The amount of time since this host was last initialized.  Note that this is different from sysUpTime in MIB-II [3] because sysUpTime is the uptime of the network management portion of the system.

System Date

dateTime

Description

The host's notion of the local date and time of day.

Number of Users

int

Description

The number of user sessions for which this host is storing state information.  A session is a collection of processes requiring a single act of user authentication and possibly subject to collective job control.

Number of Processes

int

Description

The number of process contexts currently loaded or running on this system.

Memory Size

int

Description

The amount of physical main memory contained by the host.

02.jpg

Inv_SNMP_Win32_Services

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

Description

Column ID for entries in the table

_ResourceGuid

uniqueidentifier

Key

TRUE

Description

A unique value for the Network Device the data represents.

Service Name

nvarchar(255)

Key

TRUE

Description

The name of the network service described by this entry.

Installed State

nvarchar(255)

Description

The installation status of the network service specified by this entry.

Enums

uninstalled(1), install-pending(2), uninstall-pending(3), installed(4)

Operating State

nvarchar(255)

Description

The operating status of the network service specified by this entry.

Enums

active(1), continue-pending(2), pause-pending(3), paused(4)

Can Be Uninstalled

nvarchar(255)

Description

Whether or not the network service specified by this entry can be uninstalled.

Enums

cannot-be-uninstalled(1), can-be-uninstalled(2)

Can Be Paused

nvarchar(255)

Description

Whether or not the network service specified by this entry can be paused.

 

03.jpg

Inv_SNMP_Win32_Shares

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Name

nvarchar(255)

Key

TRUE

Description

The name of the share.

Path

nvarchar(255)

Description

The local name of this shared resource.

Comment

nvarchar(255)

Description

A comment associated with this share.

04.jpg

Inv_SNMP_Win32_Print_Queues

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Name

nvarchar(255)

Key

TRUE

Description

The name of the print queue.

             

05.jpg

Inv_SNMP_Software

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Index

int

Key

TRUE

Description

A unique value for each piece of software installed on the host.  This value shall be in the range from 1 to the number of pieces of software installed on the host.

Name

nvarchar(255)

Description

A textual description of this installed piece of software, including the manufacturer, revision, the name by which it is commonly known, and optionally, its serial number.

ID

nvarchar(255)

Description

The product ID of this installed piece of software.

Type

nvarchar(255)

Description

The type of this software.

Enums

unknown(1), operatingSystem(2), deviceDriver(3), application(4)

Date

dateTime

Description

The last-modification date of this application as it would appear in a directory listing.

06.jpg

Inv_SNMP_Storage

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Index

int

Key

TRUE

Description

A unique value for each logical storage area contained by the host.

Description

nvarchar(255)

Description

A description of the type and instance of the storage described by this entry.

Alloc Units

int

Description

The size, in bytes, of the data objects allocated from this pool.  If this entry is monitoring sectors, blocks, buffers, or packets, for example, this number will commonly be greater than one. Otherwise this number will typically be one.

Units

Bytes

Size

int

Description

The size of the storage represented by this entry, in units of hrStorageAllocationUnits.

Used

int

Description

The amount of the storage represented by this entry that is allocated, in units of hrStorageAllocationUnits.

07.jpg

Inv_SNMP_Physical_Entities

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Class

nvarchar(255)

Description

An indication of the general hardware type of the physical entity.An agent should set this object to the standard enumeration value which most accurately indicates the general class of the physical entity, or the primary class if there is more than one. If no appropriate standard registration identifier exists for this physical entity, then the value ''other(1)'' is returned. If the value is unknown by this agent, then the value ''unknown(2)'' is returned.

Enums

other(1), unknown(2), chassis(3), backplane(4), container(5), powerSupply(6), fan(7), sensor(8), module(9), port(10), stack(11)

IsFRU

nvarchar(255)

Description

This object indicates whether or not this physical entity is considered a ''field replaceable unit'' by the vendor.  If this object contains the value ''true(1)'' then this entPhysicalEntry identifies a field replaceable unit.  For all entPhysicalEntries which represent components that are permanently contained within a field replaceable unit, the value ''false(2)'' should be returned for this object.

Enums

true(1), false(2)

ParentRelPos

int

Description

An indication of the relative position of this ''child'' component among all its ''sibling'' components. Sibling components are defined as entPhysicalEntries which share the same instance values of each of the entPhysicalContainedIn and entPhysicalClass objects. An NMS can use this object to identify the relative ordering for all sibling components of a particular parent(identified by the entPhysicalContainedIn instance in each sibling entry).This value should match any external labeling of the physical component if possible. For example, for a container(e.g., card slot) labeled as ''slot #3'',entPhysicalParentRelPos should have the value ''3''.  Note that the entPhysicalEntry for the module plugged in slot 3should have an entPhysicalParentRelPos value of ''1''.If the physical position of this component does not match any external numbering or clearly visible ordering, then user documentation or other external reference material should be used to determine the parent-relative position. If this is not possible, then the agent should assign a consistent (but possibly arbitrary) ordering to a given set of ''sibling'' components, perhaps based on internal representation of the components. If the agent cannot determine the parent-relative position for some reason, or if the associated value ofentPhysicalContainedIn is ''0'', then the value ''-1'' is returned. Otherwise a non-negative integer is returned, indicating the parent-relative position of this physical entity. Parent-relative ordering normally starts from ''1'' and continues to ''N'', where ''N'' represents the highest positioned child entity.  However, if the physical entities(e.g., slots) are labeled from a starting position of zero, then the first sibling should be associated with aentPhysicalParentRelPos value of ''0''.  Note that this ordering may be sparse or dense, depending on agent implementation. The actual values returned are not globally meaningful, as each ''parent'' component may use different numbering algorithms. The ordering is only meaningful among siblings of the same parent component. The agent should retain parent-relative position values across reboots, either through algorithmic assignment or use of non-volatile storage.

ContainedIn

int

Description

The value of entPhysicalIndex for the physical entity which ''contains'' this physical entity.  A value of zero indicates this physical entity is not contained in any other physical entity.  Note that the set of ''containment'' relationships define a strict hierarchy; that is, recursion is not allowed. In the event a physical entity is contained by more than one physical entity (e.g., double-wide modules), this object should identify the containing entity with the lowest value of entPhysicalIndex.

Description

nvarchar(1024)

Description

A textual description of physical entity.  This object should contain a string which identifies the manufacturer's name for the physical entity, and should be set to a distinct value for each version or model of the physical entity.

08.jpg

Inv_SNMP_HP_Printer

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Model Number

nvarchar(255)

Description

Identifies the device model number as listed in the HP corporate price list (e.g.  C2121A for DeskJet 500C).The string is as specific as possible.  Products should note in POS if the model number on the CPL changes but the device reports the previous model number.  If the model number changes based on the installed options, the POS should indicate if only the base model number is returned, or if the device senses the installed options and returns the correct model number.  If possible, encode the model number in a symbol set (like Roman-8)that matches the ASCII character set and limit the characters used to ASCII characters. Additional information: The value of this object does not change based on the installed options.  The default of this object is the same on all MoBY printers.

Model Name

nvarchar(255)

Description

Identifies the device model name (e.g.  ''''DeskJet1200C'''').  The string is as specific as possible. Capitalization and spacing should match family naming conventions.  Products should note in POS if the model name on the HP corporate price list changes but the device reports the previous device name.  If the model name changes based on the installed options, the POS should indicate if only the base model name is returned, or if the device senses the installed options and returns the correct model name.  If possible, encode the model name in a symbol set (like Roman-8) that matches the ASCII character set and limit the characters used to ASCII characters. Additional information: Since the value of this object is frequently used in displaying a list of printers, it is kept relatively short in case systems have limited width for their display area.  The model name does not change based on sensing of installed options.

Serial Number

nvarchar(255)

Description

A recorded serial number for this device that indexes some type device catalog or inventory. This value is usually set by the device manufacturer but the MIB supports the option of write ability for this object for site-specific administration of device inventory or tracking. Refer to ftp://ftp.pwg.org/pub/pwg/pmp/drafts/pmib_031698.txt, for more details in the Standard Printer MIB.

Device Name

nvarchar(255)

Description

An administrator-specified name for this printer. Depending upon implementation of this printer, the value of this object may or may not be same as the value for the MIB-II ''SysName'' object. Refer to ftp://ftp.pwg.org/pub/pwg/pmp/drafts/pmib_031698.txt, for more details in the Standard Printer MIB. Additional information: The maximum supported string length is 32 characters.  Length of 32 was chosen so a phone number could be included with the name.  If the user-entered string is too long, the device will store as much as possible and will return the “noError” status. The value of this object is saved over a power cycle.

Device Location

nvarchar(255)

Description

User defined device location.  The POS should indicate the maximum supported string length.  If the user entered string is too long, the device will store as much as possible and will return the “noError”. Additional information: The maximum supported string length is 16 characters.  If the user entered string is too long, the device will store the first 16 characters and will return the “noError” status.

Asset Number

nvarchar(255)

Description

User defined asset number.  The POS should indicate the maximum supported string length.  If the user entered string is too long, the device will store as much as possible and will return the “noError”. Additional information: The maximum supported string length is 8 characters.  If the user entered string is too long, the device will store the first 8 characters and will return the <noError> status.

Total PCL Page Count

int

Description

Total number of PCL pages printed by the device. Additional information: In MoBY the PCL page count is kept in NVRAM, and the NVRAM value is updated at least every10 pages.  NOTE: The value returned by this object will be incremented every page but if power is lost between NVRAM updates, up to 9 pages of the page count may be lost.  The page count counter will be reset to zero after 16,777,215 (2^24-1) pages.  The page count is incremented when a sheet of media is pulled from an input tray. A duplex printed sheet will cause this counter to be incremented by two.

Total PS Page Count

int

Description

Total number of PostScript pages printed by the device. Additional information: This object is only supported if the PostScript option is installed.  In MoBY the count is kept in NVRAM, and the NVRAM value is updated at least every 10 sheets.  NOTE: The value returned by this object will be incremented every sheet but if power is lost between NVRAM updates up to 9 sheets of the count may be lost.  The counter will be reset to zero after 16,777,215 (2^24-1) pages.

             

09.jpg

Inv_SNMP_Printer_Cover

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Description

nvarchar(255)

Description

The manufacturer provided cover sub-mechanism name in the localization specified by prtGeneralCurrentLocalization.

Status

nvarchar(255)

Description

The status of this cover sub-unit.

Enums

other(1), coverOpen(3), coverClosed(4), interlockOpen(5), interlockClosed(6)

             

10.jpg

Inv_SNMP_Printer_Input_Tray

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Name

nvarchar(255)

Description

The name assigned to this input sub-unit.

Vendor Name

nvarchar(255)

Description

The vendor name of this input sub-unit.

Model

nvarchar(255)

Description

The model name of this input sub-unit.

Description

nvarchar(255)

Description

A free-form text description of this input sub-unit in the localization specified by  prtGeneralCurrentLocalization.

Max Capacity

int

Description

The maximum capacity of the input sub-unit in input sub-unit capacity units (PrtCapacityUnitTC).  There is no convention associated with the media itself so this value reflects claimed capacity.  If this input sub-unit can reliably sense this value, the value is sensed by the printer and may not be changed by management requests; otherwise, the value may be written (by a Remote Control Panel or a Management Application). The value(-1) means other and specifically indicates that the sub-unit places no restrictions on this parameter.  The value (-2) means unknown.

           

11.jpg

Inv_SNMP_Printer_Output_Tray

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Name

nvarchar(255)

Description

The name assigned to this output sub-unit.

Vendor Name

nvarchar(255)

Description

The vendor name of this output sub-unit.

Model

nvarchar(255)

Description

The model name assigned to this output sub-unit.NOTE: The above description has been modified from RFC 1759for clarification.

Description

nvarchar(255)

Description

A description of the media contained in this input sub-unit; This description is to be used by a client to format and Localize a string for display to a human operator.  This description is not processed by the printer.  It is used to provide information not expressible in terms of the other media attributes (e.g., prtInputMediaDimFeedDirChosen, prtInputMediaDimXFeedDirChosen, prtInputMediaWeight, prtInputMediaType).

Max Capacity

int

Description

The maximum capacity of this output sub-unit in output sub-unit capacity units (PrtCapacityUnitTC).  There is no convention associated with the media itself so this value essentially reflects claimed capacity.  If this output sub-unit can reliably sense this value, the value is sensed by the printer and may not be changed by management requests; otherwise, the value maybe written (by a Remote Control Panel or a Management Application).  The value (-1) means other and specifically indicates that the sub-unit places no restrictions on this parameter.  The value (-2) means unknown.

             

12.jpg

Inv_SNMP_Printer_Supply

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Description

nvarchar(255)

Description

The description of this supply container/receptacle in the localization specified by prtGeneralCurrentLocalization.

Type

nvarchar(255)

Description

The type of this supply.

Level

nvarchar(255)

Description

The current level if this supply is a container; the remaining space if this supply is a receptacle.  If this supply container/receptacle can reliably sense this value, the value is reported by the printer and is read-only; otherwise, the value may be written (by a Remote Control Panel or a Management Application).  The value (-1) means other and specifically indicates that the sub-unit places no restrictions on this parameter.  The value (-2) means unknown.  A value of (-3) means that the printer knows that there is some supply/remaining space, respectively.

Enums

Remaining Supply(-3), Unknown(-2), Other(-1)

Max Capacity

int

Description

The maximum capacity of this supply container/receptacle expressed in prtMarkerSuppliesSupplyUnit.  If this supply container/receptacle can reliably sense this value, the value is reported by the printer and is read-only; otherwise, the value may be written (by a Remote Control Panel or a Management Application).  The value (-1) means other and specifically indicates that the sub-unit places no restrictions on this parameter.  The value (-2) means unknown.

           

13.jpg

 

NetWare Data Classes

 

Inv_SNMP_NW_Adapters

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Index

nvarchar(255)

Key

TRUE

Description

A unique value for each adapter contained in the host. The value for each adapter must remain constant at least from one re-initialization of the agent to the next re-initialization.

Description

nvarchar(255)

Description

A description the hardware for this adapter.  This will usually include manufacturer, model, and version information.  For LAN adapters, this could include the short board name and the boards burnt-in MAC address.

Driver Description

nvarchar(255)

Description

A textual description of the driver for this adapter

Driver Major Version

int

Description

The major version number of the adapter driver.

Driver Minor Version

int

Description

The minor version number of the adapter driver.

Port1

int

Description

The primary I/O port block.  This is the base address of a block of I/O addresses decoded by the adapter. The value will be zero if there is no I/O address associated with this adapter.

Port1 Len

int

Description

The number of I/O ports in the block starting atnwhrAdapterPort1.  This value is used in conjunction with nwhrAdapterPort1 to determine the I/O block used by the adapter.  The value will be zero if there is no I/O address associated with this adapter.

Port2

int

Description

The secondary I/O port block.  This is the base address of a block of I/O addresses decoded by the adapter.  The value will be zero if there is no secondary I/O address associated with this adapter.

Port2 Len

int

Description

The number of I/O ports in the block starting atnwhrAdapterPort2.  This value is used in conjunction with nwhrAdapterPort2 to determine the secondary I/O block used by the adapter.  The value will be zero if there is no I/O address associated with this adapter.

Mem1

int

Description

The primary Memory Address.  This is the base address of the primary block of memory space decoded by the adapter. The value will be zero if there is no memory address associated with this adapter.

Mem1 Len

int

Description

The length, in bytes, of the primary memory address block. From this value and nwhrAdapterMem1, a determination can be made as to which memory address ranges are in use by the adapter.

Mem2

int

Description

The secondary Memory Address.  This is the address of the secondary block of memory space decoded by the adapter. The value will be zero if there is no secondary memory address associated with this adapter.

Mem2 Len

int

Description

The length, in bytes, of the secondary memory address block. From this value and nwhrAdapterMem2, a determination can be made as to which memory address ranges are in use by the adapter.

DMA1

int

Description

The primary DMA channel used by the adapter. The value will be 255 if this adapter does not use any DMA channel.

DMA2

int

Description

The secondary DMA channel used by the adapter. The value will be 255 if this adapter does not use a secondary DMA channel.

Interrupt1

int

Description

The primary interrupt vector used by the adapter. The value will be 255 if this adapter does not use any Interrupt.

Interrupt2

int

Description

The secondary interrupt vector used by the adapter. The value will be 255 if this adapter does not use a secondary Interrupt.

Slot

int

Description

The slot in which the adapter resides.  The value will be zero if the slot information is not available on the platform, such as an ISA based PC, otherwise the value will be the slot number the adapter resides.  The slot number starts from 1.

Devices

int

Description

The number of devices associated with this adapter. For instance, the number of drives attached to a disk controller.

             

14a.jpg

14b.jpg

Inv_SNMP_NW_Disk_Storage

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Heads

int

Description

The number of read/write heads on the drive

Cyls

int

Description

The number of cylinders on the drive.

Sectors

int

Description

The number of sectors per track on the drive.

Sector Size

int

Description

The size of a sector in bytes.

Block Size

int

Description

The driver maximum I/O request size in bytes.

15.jpg

Inv_SNMP_NW_NLM

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Index

int

Key

TRUE

Description

A number that uniquely identifies an NLM.  The value of this object for a particular NLM has the same value as the hrSWRunIndex object, defined in the HOST-RESOURCES-MIB, for the same NLM.

Name

nvarchar(255)

Description

The name of the NLM.

Description

nvarchar(255)

Description

A text string that describes this NLM.

Total Memory

int

Description

The total memory, in bytes, used by this NLM.  This is a composite total of Short Term Memory, Semi-Permanent Memory, and Non-movable Cache Memory allocated by the NLM, plus the sizes of the code and data sections of this instance of an NLM.

Major Version

int

Description

The major version number of this NLM.

Minor Version

int

Description

The minor version number of this NLM.

Revision

int

Description

The revision level of this NLM.

Release Date

nvarchar(255)

Description

The date and time this NLM was released

             

16.jpg

Inv_SNMP_NW_Partitions

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Index

int

Key

TRUE

Description

A unique value for each physical partition on this long-term storage device.  The value for each long-term storage device must remain constant from one re-initialization of the agent to the next re-initialization.

Type

nvarchar(255)

Description

The type of this physical partition.

Enums

other(1), netWare(2), dos(3), inwDos(4)

Description

nvarchar(255)

Description

A textual description of this partition.

Size

int

Description

The size (in Kilobytes) of this physical partition.

             

17.jpg

Inv_SNMP_NW_Printers

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

ID

int

Key

TRUE

Description

A unique value for each accessible printer.  This value will be constant for the lifetime of the mapping.

Local Name

nvarchar(255)

Description

The local name for the printer.

Queue Name

nvarchar(255)

Description

The name of the print queue associated with this printer.  Zero length string if printer is local.

Server Name

nvarchar(255)

Description

The name of the server containing the print queue. Zero length string if printer is local.

Transport Domain

nvarchar(255)

Description

The transport domain associated with the printer(print queue).

Enums

noAddress(1), ipx(2), ip(3), appleTalkDDP(4)

Transport Address

nvarchar(255)

Description

The transport address associated with this printer(print queue).  Zero length string if printer is local.

             

18.jpg

 

Inv_SNMP_NW_Server

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Server Name

nvarchar(255)

Key

TRUE

Description

The physical name of this NetWare server.

Serial Number

nvarchar(255)

Description

The serial number of the instance of the NetWare Operating System running on this server.

Internal Net Number

nvarchar(255)

Description

The internal IPX network number of this server.

SFT Level

nvarchar(255)

Description

The System Fault Tolerance Level of the NetWare Operating System running on this server.

Enums

other(1), sftI(2), sftII(3), sftIII(4)

Major Version

int

Description

The major version number of the NetWare Operating System running on this server.

Minor Version

int

Description

The minor version number of the NetWare Operating System running on this server.

Release Date

nvarchar(255)

Description

The release date of the NetWare Operating System running on this server.

Description

nvarchar(255)

Description

 

NDS Tree

nvarchar(255)

Description

The name of the NetWare directory services tree containing this server. Or, a zero-length string if not applicable.

NDS Name

nvarchar(255)

Description

The Directory Services full distinguished name of this NetWare server, or the zero-length string if not applicable.

19.jpg

 

Inv_SNMP_NW_Settings

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Category Index

int

Key

TRUE

Description

A number that uniquely identifies a Set parameter category.  The value of this object for a particular category has the same value as the nwSetCategoryIndexobject for the same category.

Index

int

Key

TRUE

Description

An index which uniquely identifies this set parameter within the category

Name

nvarchar(255)

Description

The name of the settable parameter

Type

nvarchar(255)

Description

The type of the parameter.  All types are integer-valued except ''string'', which is string-valued. number:     integerboolean:    0 == FALSE, non-zero == TRUE ticks:      1 tick == 3600/65535 == approx 55 millisecsblockShift: integertimeOffset: [+|-]hh:mm:ss converted to seconds string:     character string trigger:    integer

Enums

number(1), boolean(2), ticks(3), blockShift(4), timeOffset(5), string(6), trigger(7)

ValueInt

int

Description

The current value of the parameter if integer-valued. Zero otherwise.

ValueString

nvarchar(255)

Description

The current value of the parameter if string-valued. The zero-length string otherwise.

20.jpg

 

Inv_SNMP_NW_Settings­_Descriptions

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

Category Index

int

Key

TRUE

Description

A number that uniquely identifies a Set parameter category.  The value of this object for a particular category has the same value as the nwSetCategoryIndexobject for the same category.

Param Index

int

Key

TRUE

Description

A number that uniquely identifies a Set parameter. The value of this object for a particular parameter has the same value as the nwSetParamIndex object for the same parameter.

Index

int

Key

TRUE

Description

An ordinal that indicates this segment's relative position in the complete description string for this NetWare SET Parameter.

Description

nvarchar(255)

Description

A segment of the description string for this NetWare SET parameter.

21.jpg

 

Inv_SNMP_NW_Volume

Field Name

 

Data Type

 

Qualifiers

Name

Value

_id

bigint

Key

TRUE

 

Description

Column ID for entries in the table

 

_ResourceGuid

uniqueidentifier

Key

TRUE

 

Description

A unique value for the Network Device the data represents.

 

ID

int

Key

TRUE

Description

A unique value for each NetWare volume on the server. The value for each volume must remain constant at least from one re-initialization of the agent to the next re-initialization.

Physical Name

nvarchar(255)

Description

The name of the physical volume (as opposed to any Directory Services (DS) name.

Size

int

Description

The size of the volume in KBytes.

Free Space

int

Description

The free space on the volume in KBytes.  As this number approaches zero, the volume is running out of space for new or expanding files.

Freeable Space

int

Description

The amount of freeable space (in KBytes) being used by previously deleted files on this volume. The freeable space can be reclaimed as free space by purging deleted files.

Block Size

int

Description

The block size on the volume in bytes.

Mounted

nvarchar(255)

Description

The mount state of the volume.  Note that if the volume is not mounted, all the other values in the table, except nwVolName, are invalid. Writing a value of mounted(1) to this object will cause the volume to be mounted if it is currently dismounted. Writing a value of dismounted(2) to this object will cause the volume to be dismounted if the volume is currently mounted.

Enums

mounted(1), dismounted(2)

Namespaces

int

Description

A value representing all the name spaces supported by this volume. The value is a sum.  This value initially takes the value zero, then for each name space that is supported by the volume, 2 raised to a power is added to the sum. The powers are according to the following table: Name Space     PowerDOS            0MAC            1NFS            2FTAM           3OS/2           4NT             5For example, a volume supporting both the DOS and MACname spaces would have a value of 3 (2**0 + 2**1).

DS Name

nvarchar(255)

Description

The full Directory Services  distinguished name for the volume, or the zero-length string if not applicable.

Filesystem

nvarchar(255)

Description

If remote, the remote mount point; e.g. va:/usr/xIf local, the zero length string.

22.jpg

 

Conclusion

I hope this information is useful when working with Network Devices for Inventory. Note that this will not include any custom data class created for Inventory Solution for Network Devices.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
doc file
Inventory Solution for Network Devices Database Schema 7.1.doc   453 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Related Entries and Links

No Related Resource entered.