tng_managedobject

Main table to store all the managed objects. e.g. device, agent, unispace etc.

Column Name Column Datatype Column Null Option Column Comment
class_name varchar(30) not null Class name
name varchar(200) not null Name of managed object
uuid byte(16) not null Object uuid
label varchar(255) with null Object label
address varchar(255) with null Address value of object
address_type integer with null Address type. All available types are in tng_address_type table.
interface_type integer with null Interface type. It must be a value from tng_interface_type table.
autoarrange_type integer with null Container folder autoarrange type when it is opened. e.g. Bus, Network, Token Ring etc.
hidden integer1 with null Hidden flag.
propagate_status integer1 with null Propagated status from its children.
status_no integer with null Status number
severity integer with null Object severity number
tng_delete_flag integer with null Delete flag
posted integer1 with null Posted flag
acknowledge integer1 with null Acknowledge flag
ip_address_hex byte(4) with null Hex value of IP address
mac_address varchar(12) with null Object Mac address
subnet_mask byte(4) with null Subnet mask
date_ins date with null Inserted date
date_modify date with null Modified date
alarmset_name varchar(40) with null Alarmset name. It must be a value from table tng_alarmset table.
code_page integer with null Code page
admin_status integer with null Admin Status. Values are: Disabled Managed Restricted Testing Unmanaged
dsm_server varchar(60) with null DSM server name
propagated_status_no integer with null Propagated status number from its children.
propagated_sev integer with null Propagated severity from its children.
dsm_address varchar(16) with null DSM address
license_machine_type varchar(64) with null License machine type
create_bpv integer1 with null Flag whether to create Business Process Views (future)
override_imagelarge varchar(64) with null Override large image file name
override_imagesmall varchar(64) with null Small image override file name
override_imagedecal varchar(64) with null Decal image override file name
override_imagetintbool integer1 with null Override flag
override_model varchar(64) with null Override model file name
background_image varchar(64) with null Backgroup image
weight integer with null Object weight
reserved varchar(32) with null Reserved
weighted_severity integer with null Weighted severity
max_sev integer with null Maximum value of severity
user_reclass integer with null Flag whether the user reclassified the object
asset_uuid byte(16) with null Asset uuid
source_repository varchar(60) with null Source respository
dnsname varchar(255) with null DNS server name
last_seen_time date with null Last seen time
amsserver varchar(60) with null AMS server
emserver varchar(60) with null EM server

Product Name: Unicenter Network and System Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
  wvcacmo_veritascluster
wvcacmo_schost
wvcacmo_hpsgservice
wvcacmo_hpsgpackage
wvcacmo_hpsghost
wvcacmo_hpsgfilesystem
wvcacmo_hpserviceguard
wvcacmo_hacmpresourcegroup
wvcacmo_hacmpresource
wvcacmo_hacmpinterface
wvcacmo_hacmphost
wvcacmo_hacmp
 


Copyright © 2006 CA. All rights reserved.