Represents a common core agent. Used to manage DSM.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Points to either discovered_hardware, discovered_user, groupdef depending on what the value of the type field is. |
| last_run_date | integer | with null | Property last run date of an agent |
| agent_version | nvarchar(32) | with null | Version of the core agent |
| description | nvarchar(255) | with null | User defined comment |
| prev_manager | nvarchar(255) | with null | If the agent is moved then we need to move data related to the agent (installed sw, inventory etc.) |
| server_uuid | byte(16) | with null | UUID of an server instance |
| agent_area | nvarchar(64) | with null | Area concept kept? Depending on Agent/Server design |
| agent_file_id | nvarchar(32) | with null | From the UAM, recognition of the agent, will depend on the Agent/Server design |
| agent_type | integer | with null | Type of agent
0 = group definition 1 = discovered_hardware 2 = discovered user 3 = engine |
| creation_user | nvarchar(64) | with null | Creation user |
| creation_date | integer | with null | Creation date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date. |
| version_number | integer | with null | Last version number |
| class_id | integer | with null | Class id , used to define the MDB class |
| domain_id | integer | with null | ID of the domain where the agent belong to NOTE: its not the uuid , have look to the type |
| unit_id | integer | with null | Internal id |
| agent_name | nvarchar(192) | with null | Used to identify an agent by name |
| boot_server_uuid | byte(16) | with null | Dedicated to specific Boot server (optional) |
| registration_type | integer | with null | Flag indicating this in the DB (Manual/Auto)
0 = aututo 1 = manually |
| auto_server_version | integer | with null | Server version |
| auto_rep_version | date | with null | Replication version |
| agent_ref_count | integer | with null | Reference counter |
| agent_lock | integer | with null | Is agent locked |
| derived_status_am | integer | with null | Derived status of an AM agent |
| derived_status_sd | integer | with null | Derived status of an SDagent |
| derived_status_rc | integer | with null | Derived status of an RCagent |
| derived_status_babld | integer | with null | Derived status of an BABLDagent |
| ip_address | nvarchar(64) | with null | IP address |
| proc_os_id | integer | with null | ID (not an uuid) to identify the os type |
| user_def1 | nvarchar(255) | with null | User defined field |
| user_def2 | nvarchar(255) | with null | User defined field |
| user_def3 | nvarchar(255) | with null | User defined field |
| user_def4 | nvarchar(255) | with null | User defined field |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| object_uuid | ca_coapi_agent_view_v1 ca_coapi_agent_view_nosrv_v1 ca_coapi_agent_view_nodomsrv_v1 ca_coapi_agent_view_nodom_v1 usd_v_agents ca_coapi_agent_view_nosrv ca_coapi_agent_view_nodomsrv ca_coapi_agent_view_nodom dts_dtasset_view ca_agent_component |
object_uuid |