Previous Topic: View_Issue_Act_Log

Next Topic: View_Issue_to_Issue_Act_Log

View_Issue_to_Assets

The following list of fields is a basic view of issues and their assets. The issue table (issue) is indirectly joined with the owned resource table (ca_owned_resource), and other asset-related tables, to get a list of each issue’s assets. This may not list all issues, particularly those that have no assets.

Field

Remarks

View_Issue.*

The View_Issue view which defines all fields listed in the View_Issue view.

assetID

ca_owned_resource.own_resource_uuid: The binary field which serves as the internal, unchanging unique identifier for an asset record.

asset_serial_num

ca_owned_resource.serial_number: The serial number for an asset record.

asset_class

ca_resource_class.name: A short description of the class to which an asset belongs.

ca_owned_resource.resource_class = ca_resource_class.id

asset_family

ca_resource_family.name: The family of assets to which this asset belongs.

ca_owned_resource.resource_class = ca_resource_class.id AND ca_resource_class.family_id = ca_resource_family.id

asset_name

ca_owned_resource.resource_name: The network name by which this asset is known.