This table is used to store targets. Read access to this table is done using a view (usd_v_target), the view will read these columns but also a lot of common columns from ca_agent, ca_discovered_hardware etc. This enables us to share common data. Write access to the table is done on the table itself (not using a view). An object of this table is used as a target when setting up USD jobs.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| managementtype | integer | not null | This is the management type of a target, typically managed by USD or managed by RAC etc. |
| locks | integer | not null | This column indicates that the object is locked in some kind of operation, e.g. move from one manager to another. |
| state | integer | not null | This is the state of the target. |
| calendar | nvarchar(32) | not null | This is the calendar attached to the target. |
| download_method | integer | not null | This is the chosen download method, typically NOS, NOSLESS or DTS. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | usd_v_product_procedures usd_applic |
target |
| objectid | usd_link_jc_srv | server |
| objectid | usd_link_grp_cmp | comp |
| objectid | usd_link_act_cmp | objectid |
| objectid | usd_jcappgr | jobtarget |