This table stores all the software packages, a package consists mainly of procedures (usd_actproc) and volumes (usd_volume). The package is also linked to a common software definition (ca_software_def).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| basedon | byte(16) | with null | In case this software packa is based on an existing package, this is the link, FK to usd_rsw. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| packagesize | integer | not null | Size in bytes of this software package. |
| packagetype | integer | not null | This is the package type, typically SXP, MSI, WinCE etc. |
| itemname | nvarchar(129) | not null | This is the name of the software package. |
| itemversion | nvarchar(129) | not null | This is the version of the software package. |
| itemtype | integer | not null | This is the type of software package, typically Software, Document, Procedure etc. |
| sourcemedium | integer | not null | This is the source medium, typically CD, Floppy Harddisk etc. |
| productname | nvarchar(129) | not null | Currently same as itemName. |
| productversion | nvarchar(129) | not null | Currently same as itemVersion. |
| filedby | integer | not null | Type of administrator that registered the procedure, typically enterprise or domain or automatically during installation (autoreg). |
| supplier | nvarchar(255) | not null | Manufacturer of this software, e.g. Computer Associates. |
| comment | nvarchar(255) | not null | This is a comment. |
| creation_user | nvarchar(255) | with null | Used to store the identifier of the entity creator. The string must be a URI of a valid ca_discovered_user entity. |
| creationdate | integer | not null | Creation date of the software package. |
| creationtime | integer | not null | Creation time of the software package. |
| changedate | integer | not null | Change date of the software package. |
| changetime | integer | not null | Change time of the software package. |
| reportevents | integer | not null | Obsolete |
| activationproc | integer | not null | True if a procedure is registered. |
| recnotification | integer | not null | Obsolete |
| singlemediasourcepath | nvarchar(255) | not null | Obsolete |
| singlemediasourcepathentered | nvarchar(255) | not null | Obsolete |
| archtime | integer | not null | The time when the software package was archived. |
| addsize | integer | not null | In case an added procedure actually added more files to the software package, this represents the total size in bytes of all added procedures with added files. |
| archpath | nvarchar(255) | with null | The path to the location where the software package was archived. |
| archby | nvarchar(129) | with null | The user that archived the software package. |
| archcomment | nvarchar(255) | with null | The comment supplied when archiving the software package. |
| archflag | integer | not null | This is a flag indicating archive path on enterprise or domain manager. |
| flags | integer | not null | General purpose property flag. |
| crc32 | integer | not null | This is the checksum of the software package. |
| software_def | byte(16) | with null | This column refers to a software definition, ca_software_def. |
| deliverproc | byte(16) | with null | Procedure created internally used for delivery to scalability servers. |
| undeliverproc | byte(16) | with null | Procedure created internally used for delivery to scalability servers. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_v_product_procedures | productname packagetype productversion product_uuid |
| objectid | usd_actproc | rsw |
| objectid | usd_volume | rsw |
| objectid | usd_rsw | basedon |
| objectid | usd_link_swgrp | grpchild |
| objectid | usd_link_swg_sw | sw |
| objectid | usd_distsw | rsw |