delete_computed_attribute

This API deletes a computed attribute.

To help prevent an SQL injection attack, the following words and characters are not allowed in computed attributes:

ALTER, CREATE, DELETE, DROP, INSERT, TRUNCATE, UPDATE, semicolon (;), double-dash (--), or slash-asterisk (/*)

For more information, see create_computed_attribute.

This API is available in Guardium V9.5 and later.

The REST API is available in Guardium V11.0 and later.

REST API syntax

This API is available as a REST service with the DELETE method. Call this API as follows: 
DELETE https://[Guardium hostname or IP address]:8443/restAPI/computed_attribute

GuardAPI syntax

delete_computed_attribute parameter=value

Parameters

Parameter Value type Description
attributeLabel String Required. The name of the computed attribute to delete.
entityLabel String Required. The name of the main entity with which the attribute is associated,
expression String Required. The SQL expression to delete.
api_target_host String

Specifies the target hosts where the API executes. Valid values:
  • all_managed: execute on all managed units but not the central manager
  • all: execute on all managed units and the central manager
  • group:<group name>: execute on all managed units identified by <group name>
  • host name or IP address of a managed unit: specified from the central manager to execute on a managed unit.  For example, api_target_host=10.0.1.123.
  • host name or IP address of the central manager: specified from a managed unit to execute on the central manager. For example, api_target_host=10.0.1.123.

IP addresses must conform to the IP mode of your network. For dual IP mode, use the same IP protocol with which the managed unit is registered with the central manager. For example, if the registration uses IPv6, specify an IPv6 address. The hostname is independent of IP mode and can be used with any mode.

Examples

To delete the app_user computed attribute:

grdapi create_computed_attribute 
attributeLabel="app_user" entityLabel="Access Period" 
expression="SUBSTRING_INDEX(APP_USER_NAME,char(59),1)