Previous Topic: MDB Extension TablesNext Topic: Relationship Types


Common Attributes

The following attributes are common to various families.

Object Name

Description

acquire_date

Date the resource was acquired.

alarm_id

IP address. (hardware only)

asset_count

Resource quantity.

asset_num

Alternate resource identifier, for example, an alternate ID located on sticker placed on a computer.

class

In the object, this is the name of the class.

In the table, this is a foreign key to a record in the ca_resource_class table (SREL integer to grc).

company_bought_for_uuid

In the object, this is the name of the company for which the CI was bought.

In the table, this is a foreign key to the ca_company table (SREL uuid to ca_cmpny).

contact_1

In the object, this is a user-defined contact field.

In the table, this is a foreign key to the ca_contact table (SREL uuid to cnt).

contact_2

In the object, this is a user-defined contact field.

In the table, this is a foreign key to the ca_contact table (SREL uuid to cnt).

contact_3

In the object, this is a user-defined contact field.

In the table, this is a foreign key to the ca_contact table (SREL uuid to cnt).

creation_date

Timestamp (pdmtime) indicating the date and time that the CI was created.

creation_user

User ID of the contact who created the CI

delete_flag

Active|FALSE|0 (zero)|No: CI is active and displays in display lists (the default).

Inactive|TRUE|1 (one)|Yes: CI is not active and does not appear in display lists.

department

In the object, this is the name of the department.

In the table, this is a foreign key to the ca_resource_department table (SREL integer to dept).

description

Longer name or description of the resource.

dns_name

The name by which this device is know in the domain name server.

exclude_registration

Exclude Registration.

expense_code

In the object, this is the CI cost center.

In the table, this is a foreign key to the ca_resource_cost_center table (SREL integer to cost_cntr).

expiration_date

Date the license, lease, and so on, expires.

family

In the object, this is the name of the family.

In the table, this is a foreign key to a record in the ca_resource_family table (SREL integer to nrf). Used to extend at a high level, for example, hardware.server, network.router, software.database.

financial_num

Financial number.

install_date

Date resource was installed in organization or network.

is_asset

Boolean flag that can be set to categorize an Asset for filtering purposes and to control display in CA CMDB or other products such as CA Asset Portfolio Management. CA CMDB does not allow the Asset flag to be changed to NO when an asset is managed by CA Asset Portfolio Management.

is_ci

Boolean flag that can be set to categorize a CI for filtering purposes and to control display in CA CMDB or other products such as CA Asset Portfolio Management. By default, a CI created by CA CMDB is flagged as a CI but not as an Asset.

last_mod_by

User ID of the contact who last modified the CI

license_number

License Information.

loc_cabinet

Cabinet location.

loc_floor

Floor location.

loc_room

Room location.

loc_shelf

Shelf location.

loc_slot

Slot location.

location

In the object, this is the name of the location.

In the table, this is a foreign key to a record in the location table (SREL uuid to loc).

mac_address

MAC address. (hardware only)

manufacturer

In the object, this is the name of the company who manufactured the CI.

In the table, this is a foreign key to a record in the ca_company table (SREL uuid to ca_cmpny).

model

In the object, this is the model name for the CI.

In the table, this is a foreign key to the ca_model_def table (SREL uuid to mfrmod).

name

The name of the resource.

name_type

Foreign key to the ca_asset_type table to represent Hardware, Software, and so on.

org_bought_for_uuid

In the object, this is the name of the organization for which the CI was bought.

In the table, this is a foreign key to the ca_organization table (SREL uuid to org).

priority

Enumerated value for this entry, it specifies ordering in lists and relative values (SREL integer to pri).

product_version

Product release.

repair_org

In the object, this is the name of the organization responsible for maintenance of the CI.

In the table, this is a foreign key to the ca_organization table (SREL uuid to org).

resource_alias

Resource alias.

resource_contact

In the object, this is the name of the contact responsible for the CI.

In the table, this is a foreign key to the ca contact table (SREL uuid to cnt).

resource_owner_uuid

In the object, this is the name of the owner for the CI.

In the table, this is a foreign key to the ca_contact table (SREL uuid to cnt).

serial_number

Serial number.

service_org

In the object, this is the name of the organization ultimately responsible for the resource.

In the table, this is a foreign key to the ca_organization table (SREL uuid to org).

service_type

Noneditable enum (SREL string to no_contract_sdsc).

sla

The SLA value for this usp_owned_resource.

smag_1

User-defined string field.

smag_2

User-defined string field.

smag_3

User-defined string field.

smag_4

User-defined string field.

smag_5

User-defined string field.

smag_6

User-defined string field.

standard_ci

Standard configuration for comparison.

status

In the object, this is the status indicator for the CI.

In the table, this is a foreign key to the ca_resource_status table (SREL integer to rss).

supplier

In the object, this is the name of the vendor responsible for supplying the CI.

In the table, this is a foreign key to the ca_company table (SREL uuid to ca_cmpny).

system_name

Computer name. (hardware only)

tenant

Tenant assignment for the CI

vendor_repair

In the object, this is the name of the vendor providing maintenance for the CI.

In the table, this is a foreign key to the ca_company table (SREL uuid to ca_cmpny).

vendor_restore

In the object, this is the name of the company ultimately responsible for the resource.

In the table, this is a foreign key to the ca_company table (SREL uuid to ca_cmpny).

warranty_end

Warranty end date.

warranty_start

Warranty start date.