User Action table generated by the Level 1 API.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | varchar(50) | not null | 50 chars, text field, required for everything except a DEFINE, is returned on a DEFINE. This is the unique identifier for a User Action record and is generated by the Level 1 API. |
| name | varchar(80) | with null | 80 chars, text field, required for a DEFINE, read only for other operations. This is the display name of the User Action. |
| description | varchar(256) | with null | 256 chars, text field, read/write access. This is a detailed description of the User Action that will be taken. |
| targettype | integer | with null | Integer field, read/write access. This field identifies the User Action to be taken: client execution (a good start); OPR daemon; raw. |
| node | varchar(1024) | with null | 1024 chars, text field, read/write access. This is the node run the action on when TARGETTYPE is UACTION_SUPPLIED. |
| action | varchar(2048) | with null | 256 chars, text field, read/write access. This is what gets executed for this User Action. |
| useoprcmd | char(1) | with null | USEOPRCMD: Boolean, read/write access, default value is TRUE. This indicates whether AMS will use oprcmd.exe to execute the command, or invoke it directly through the native OS. This value is ignored unless the action is being run in the Smart Console client. |
| showconsole | char(1) | with null | Boolean, read/write access, default value is FALSE. This indicates whether or not the console session is displayed. This is ignored when USEOPRCMD is TRUE. |
| interactive | char(1) | with null | Boolean, read/write access, default value is TRUE. This indicates whether or not the action is run in the foreground. This is ignored when USEOPRCMD is TRUE. |
| auto | char(1) | with null | Boolean, read/write access, default value is TRUE. This indicates whether the action is run immediately or after the user is prompted. |
| created | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when a User Action record is created. |
| createdby | varchar(60) | with null | 60 chars, read only access. The Level 1 API sets this field to the ID of the user who created this User Action record. |
| modified | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when a User Action record is altered. This is the most recent change and there is no history kept of previous changes. |
| modifiedby | varchar(60) | with null | 60 chars, text field, read only access. The Level 1 API sets this field to the ID of the user who most recently modified this User Action record. |
Product Name: Unicenter Network and System Management/Alert Management
Table Type: Table