Asset Discovery for z/OS to Control Desk mapping tables

These tables describe how the database columns and fields in Control Desk relate to the XML schemas from Asset Discovery for z/OS®.

TLOAMSWCATALOG mapping

To maintain information about the import, one instance is created in the TLOAMSWCATALOG table that contains the following information about Asset Discovery for z/OS source data.
Table 1. Field mapping for TLOAMSWCATALOG Table
Control Desk Asset Discovery for z/OS
Database Column Field XML Schema
TloamSwCatalogId   2
SchemaVersion Schema Version /SoftwareKnowledgeBase.schemaVersion
CreatedDate Created Date /SoftwareKnowledgeBase.creationDate
UniqueId ID /SoftwareKnowledgeBase/KbIdentity.guid
Name Software Catalog /SoftwareKnowledgeBase/KbIdentity.name
Description Description First 99 characters of /SoftwareKnowledgeBase/KbIdentity.name
Version Version /SoftwareKnowledgeBase/KbIdentity.version
LastModification Last Modification (empty)
DataVersion Data Version (empty)
ContactName Contact Name (empty)

TLOAMSOFTWARE mapping

One instance is created in the TLOAMSOFTWARE table in Control Desk for every node in Asset Discovery for z/OS with one of the following paths:

  • /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeProduct
  • /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeVersion
  • /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeFeature

Table 2 describes how the database columns and fields in Control Desk relate to the XML schema from Asset Discovery for z/OS.

Any of these nodes is referred to as SoftwareItemType below.

Table 2. Field mapping for TLOAMSOFTWARE Table
Control Desk Asset Discovery for z/OS
Database Column Field XML Schema
TloamSoftwareId   Unique identifier that is automatically generated.
UniqueID Unique ID SoftwareItemType.guid
PlatformBase Platform "MAINFRAME" (translated as needed)
Type Type If node name = "MainframeProduct", then "PRODUCT" (translated as needed).
If node name = "MainframeVersion", then VERSION" (translated as needed).
If node name = "MainframeFeature", then "RELEASE" (translated as needed).
SwName Software Name If there is an element SoftwareItemType/alias with attribute preferred='true', then use this value.
Otherwise, use SoftwareItemType.name.
Func Function SoftwareItemType.Function
Role Product Role If attribute SoftwareItemType.productRole exists and is equal to "SOFTWARE_PRODUCT", then "SOFTWAREPRODUCT" (translated as needed).
If attribute SoftwareItemType.productRole exists and is not equal to "SOFTWARE_PRODUCT", then its value (translated as needed).
If attribute SoftwareItemType.productRole does not exist, then "MAINFRAMEFEATURE" (translated as needed).
ProductId Product Id SoftwareItemType.productIds
ExternalID External ID SoftwareItemType.ExternalId
Version Version If node name = "MainframeProduct", then (empty) if node name = "MainframeVersion", then SoftwareItemType.version.
If node name = "MainframeFeature", the value of /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeVersion.version for the node that has /SoftwareKnowledgeBase/KbIdentity/SoftwareItems/MainframeVersion.guid = SoftwareItemType.version.
Release Release SoftwareItemType.release
Description Description If SoftwareItemType.description exists and is not empty, its first 99 characters.
Otherwise, the first 99 characters of SoftwareItemType.name.
Url URL SoftwareItemType.website
IsPVU Uses PVU If attribute SoftwareItemType.PVU exists and is equal to "false", then 0.
If attribute SoftwareItemType.PVU exists and is empty or not equal to "false", then 1.
If attribute SoftwareItemType.PVU does not exist, then 0.
IsIPLA Is IPLA If attribute SoftwareItemType.IPLA exists (no matter what is its value), then 1.
If attribute SoftwareItemType.IPLA does not exist, then 0.
IsSubCap Subcapacity Eligible If attribute SoftwareItemType.subCapacityLicensing exists and is empty or equal to "Not eligible", then 0.
If attribute SoftwareItemType.subCapacityLicensing exists and is not empty and not equal to "Not eligible", then 1.
If attribute SoftwareItemType.subCapacityLicensing does not exist, then 0.
ManufacturerName Manufacturer The value of /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer.name for the node that has /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer.guid = SoftwareItemType.manufacturer.
If Manufacturer.name is empty, then use the parent's manufacturer.
SwCatalogId Catalog Source 2
ActivationDate Activation Date SoftwareItemType.ActivationDate
IsDeleted Deleted If attribute SoftwareItemType.deleted exists and is equal to "true", then 1.
If attribute SoftwareItemType.deleted does not exist or is not equal to "true", then 0.
DeleteDate Delete Date If attribute SoftwareItemType.deleted exists and is equal to "true", then SoftwareItemType.modified.
If attribute SoftwareItemType.deleted does not exist or is not equal to "true", then (empty).
VulExhibitId Value Unit Table SoftwareItemType.VUE
SSPID SSID SoftwareItemType.SS
SSEID SsEnID SoftwareItemType.SSEnId
TargetSoftwareID Target Record If a /SoftwareKnowledgeBase/IdentityLinks/Link element exists with an attribute primary = SoftwareItemType.guid, then the tloamSoftwareId of the catalog record with UniqueID equal to /SoftwareKnowledgeBase/IdentityLinks/Link.descendant.
Otherwise, (empty).
Parent Parent Record If node name = "MainframeProduct", then (empty).
If node name = "MainframeVersion", then the tloamSoftwareId value of the parent product.
If node name = "MainframeFeature", then the tloamSoftwareId value of the parent version.
EID Entitlement ID SoftwareItemType.EID

TLOAMSWREL mapping

One instance is created in the TLOAMSWREL table in Control Desk for every node in Asset Discovery for z/OS with the following path:
  • /SoftwareKnowledgeBase/KbIdentity/Relationships/Relationship

Table 3 describes how the database columns and fields in Control Desk relate to the XML schema from Asset Discovery for z/OS.

Table 3. Field mapping for TLOAMSWREL Table
Control Desk Asset Discovery for z/OS
Database Column Field XML Schema
TloamSwRelid   Unique identifier that is automatically generated
ParentSw Parent Unique ID TloamSoftwareId of the catalog record with UniqueID equal to Relationship.source
ChildSw Child Unique ID TloamSoftwareId of the catalog record with UniqueID equal to Relationship.sink
Relationshiptype Relationship Relationship.type
IsDeleted Deleted If attribute Relationship.deleted exists and is equal to "true", then 1.
If attribute Relationship.deleted does not exist or is not equal to "true", then 0.
DeletedDate Delete Date If attribute Relationship.deleted exists and is equal to "true", then SoftwareItemType.modified.
If attribute Relationship.deleted does not exist or is not equal to "true", then (empty).

DPAMMANUFACTURER mapping

One instance is created in the DPAMMANUFACTURER table in Control Desk for every node inAsset Discovery for z/OS with the following path:
  • /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer

However, if a record already exists in DPAMMANUVARIANT with MANUFACTURERVAR = Manufacturer.name, then the node is skipped completely.

Table 4 describes how the database columns and fields in Control Desk relate to the XML schema from Asset Discovery for z/OS.

Table 4. Field mapping for DPAMMANUFACTURER Table
Control Desk Asset Discovery for z/OS
Control Desk Asset Discovery for z/OS
Database Column Field XML Schema
ManufacturerId Manufacturer Unique identifier that is automatically generated.
ManufacturerName Target Manufacturer Manufacturer.name

DPAMMANUVARIANT mapping

One instance is created in the DPAMMANUVARIANT table in Control Desk for every node inAsset Discovery for z/OS with the following path:
  • /SoftwareKnowledgeBase/KbIdentity/Manufacturers/Manufacturer

However, if a record already exists in DPAMMANUVARIANT with MANUFACTURERVAR = Manufacturer.name, then the node is skipped completely.

Table 5 describes how the database columns and fields in Control Desk relate to the XML schema from Asset Discovery for z/OS.

Table 5. Field mapping for DPAMMANUVARIANT Table
Control Desk Asset Discovery for z/OS
Control Desk Asset Discovery for z/OS
Database Column Field XML Schema
DpamManuVariantId Manufacturer Variant ID Unique identifier that is automatically generated.
ManufacturerName Target Manufacturer Manufacturer.Name
ManufacturerVar Manufacturer Manufacturer.Name
Parent topic: Tivoli Asset Discovery for z/OS catalog imports
Related concepts:
Data flow from Asset Discovery for z/OS

Feedback