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. |
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |