A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of saving storage summary data of virtualization engines.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "dsource_id": "string",
- "dependant_vdbs": 200,
- "engine_name": "My Favorite Engine",
- "unvirtualized_space": 109242677,
- "current_timeflows_unvirtualized_space": 109242677,
- "virtualized_space": 12345678,
- "name": "my-test-database",
- "estimated_savings": 109242677,
- "estimated_savings_perc": 0,
- "estimated_current_timeflows_savings": 109242677,
- "estimated_current_timeflows_savings_perc": 0
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}, - "totals": {
- "vdb_count": 0,
- "dsource_count": 0,
- "virtualized_space": 0,
- "unvirtualized_space": 0,
- "current_timeflows_unvirtualized_space": 0,
- "estimated_savings": 109242677,
- "estimated_savings_perc": 0,
- "estimated_current_timeflows_savings": 0,
- "estimated_current_timeflows_savings_perc": 0
}
}
Returns a list of inventory data of VDBs.
{- "items": [
- {
- "engine_name": "My favorite engine",
- "name": "prod01-copy01",
- "type": "Oracle",
- "version": "10.2.0.5.0",
- "parent_name": "prod01-main",
- "parent_id": "1-DB_CONTAINER-1",
- "creation_date": "2023-04-15T08:51:34.148Z",
- "last_refreshed_date": "2023-04-15T10:49:34.148Z",
- "parent_timeflow_location": "1178883",
- "parent_timeflow_timestamp": "2021-05-01T08:51:34.148Z",
- "parent_timeflow_timezone": "America/Los_Angeles",
- "enabled": true,
- "status": "RUNNING",
- "storage_size": 12345678
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of inventory data of VDBs.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "engine_name": "My favorite engine",
- "name": "prod01-copy01",
- "type": "Oracle",
- "version": "10.2.0.5.0",
- "parent_name": "prod01-main",
- "parent_id": "1-DB_CONTAINER-1",
- "creation_date": "2023-04-15T08:51:34.148Z",
- "last_refreshed_date": "2023-04-15T10:49:34.148Z",
- "parent_timeflow_location": "1178883",
- "parent_timeflow_timestamp": "2021-05-01T08:51:34.148Z",
- "parent_timeflow_timezone": "America/Los_Angeles",
- "enabled": true,
- "status": "RUNNING",
- "storage_size": 12345678
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
Returns a list of dSource usage data.
{- "items": [
- {
- "engine_name": "My favorite engine",
- "name": "prod01-main",
- "unvirtualized_space": 109242677,
- "actual_space": 339292672,
- "dependant_vdbs": 25
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of dSource usage data.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "engine_name": "My favorite engine",
- "name": "prod01-main",
- "unvirtualized_space": 109242677,
- "actual_space": 339292672,
- "dependant_vdbs": 25
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
Returns a list of dSource consumption data.
{- "items": [
- {
- "name": "prod01-main",
- "status": "Running",
- "database_type": "Oracle",
- "engine_id": "1",
- "engine_name": "My favorite engine",
- "last_consumption_date": "2019-08-24T14:15:22Z",
- "ingested_size": 12345
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of dSource consumption data.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "name": "prod01-main",
- "status": "Running",
- "database_type": "Oracle",
- "engine_id": "1",
- "engine_name": "My favorite engine",
- "last_consumption_date": "2019-08-24T14:15:22Z",
- "ingested_size": 12345
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
Returns a list of aggregated audit log entries for each account.
{- "items": [
- {
- "account_id": 0,
- "account_first_name": "string",
- "account_last_name": "string",
- "vdb_refreshes": 0,
- "masking_jobs": 0
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}, - "totals": {
- "total_vdb_refreshes": 0,
- "total_masking_jobs": 0
}
}
Returns a list of storage summary data of virtualization engines.
{- "items": [
- {
- "engine_id": "engine-123",
- "engine_name": "My Favorite Engine",
- "engine_hostname": "eng09.dev.delphix.com",
- "total_capacity": 100000000000,
- "free_storage": 99000000000,
- "used_storage": 85000000000,
- "used_percentage": 75,
- "dsource_count": 50,
- "vdb_count": 200,
- "total_object_count": 400,
- "reserved_storage": 2200000000,
- "dsource_used_storage": 890000000,
- "vdb_used_storage": 11000000
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of storage summary data of virtualization engines.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "engine_id": "engine-123",
- "engine_name": "My Favorite Engine",
- "engine_hostname": "eng09.dev.delphix.com",
- "total_capacity": 100000000000,
- "free_storage": 99000000000,
- "used_storage": 85000000000,
- "used_percentage": 75,
- "dsource_count": 50,
- "vdb_count": 200,
- "total_object_count": 400,
- "reserved_storage": 2200000000,
- "dsource_used_storage": 890000000,
- "vdb_used_storage": 11000000
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
Returns a list of API usage metrics.
{- "items": [
- {
- "api_endpoint": "/v2/management/engines",
- "api_method": "GET",
- "api_count": 4200,
- "kind": "automation",
- "client_name": "client-123",
- "user_agent": "1.0-beta",
- "dct_version": "2.2.0"
}
], - "total_automation_api_count": 4200,
- "total_governance_api_count": 4200
}
OK
{- "items": [
- {
- "report_id": 123,
- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
The parameters to create a reporting schedule.
report_type required | string Enum: "VIRTUALIZATION_STORAGE_SUMMARY" "ENGINE_PERFORMANCE_ANALYTIC" "VDB_INVENTORY_DATA" "DSOURCE_USAGE_DATA" "DSOURCE_CONSUMPTION_DATA" "MASKING_EXECUTION_METRICS" "AUDIT_LOGS_SUMMARY" "STORAGE_SAVINGS_SUMMARY" "DATA_RISK_SUMMARY" |
cron_expression required | string Standard cron expressions are supported e.g. 0 15 10 L * ? - Schedule at 10:15 AM on the last day of every month, 0 0 2 ? * Mon-Fri - Schedule at 2:00 AM every Monday, Tuesday, Wednesday, Thursday and Friday. For more details kindly refer- "http://www.quartz-scheduler.org/documentation/" |
time_zone | string Timezones are specified according to the Olson tzinfo database - "https://en.wikipedia.org/wiki/List_of_tz_database_time_zones". |
message required | string |
file_format required | string Value: "CSV" |
enabled required | boolean Default: true |
recipients required | Array of strings <email> non-empty unique |
sort_column | string Enum: "engine_id" "engine_name" "engine_hostname" "total_capacity" "free_storage" "used_storage" "used_percentage" "dsource_count" "vdb_count" "total_object_count" "name" "unvirtualized_space" "actual_space" "dependant_vdbs" "type" "version" "parent_id" "parent_name" "creation_date" "parent_timeflow_location" "parent_timeflow_timestamp" "parent_timeflow_timezone" "enabled" "status" "connector_id" "connector_name" "connector_type" "last_profiled_date" "last_masked_date" "is_profiled" "is_sensitive_data" "is_masked" "is_at_risk" "data_elements_total" "data_elements_not_sensitive" "data_elements_sensitive_masked" "data_elements_sensitive_unmasked" "records_total" "records_not_sensitive" "records_sensitive_masked" "records_sensitive_unmasked" "-engine_id" "-engine_name" "-engine_hostname" "-total_capacity" "-free_storage" "-used_storage" "-used_percentage" "-dsource_count" "-vdb_count" "-total_object_count" "-unvirtualized_space" "-actual_space" "-dependant_vdbs" "-name" "-type" "-version" "-parent_id" "-parent_name" "-creation_date" "-parent_timeflow_location" "-parent_timeflow_timestamp" "-parent_timeflow_timezone" "-enabled" "-status" "-connector_id" "-connector_name" "-connector_type" "-last_profiled_date" "-last_masked_date" "-is_profiled" "-is_sensitive_data" "-is_masked" "-is_at_risk" "-data_elements_total" "-data_elements_not_sensitive" "-data_elements_sensitive_masked" "-data_elements_sensitive_unmasked" "-records_total" "-records_not_sensitive" "-records_sensitive_masked" "-records_sensitive_unmasked" |
row_count | integer >= 1 |
make_current_account_owner | boolean Default: true Whether the account creating this reporting schedule must be configured as owner of the reporting schedule. |
Returns the newly created schedule for a report.
{- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "sort_column": "engine_name",
- "row_count": 1,
- "make_current_account_owner": true
}
{- "report_id": 123,
- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
OK
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "report_id": 123,
- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "report_id": 123,
- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
report_type required | string Enum: "VIRTUALIZATION_STORAGE_SUMMARY" "ENGINE_PERFORMANCE_ANALYTIC" "VDB_INVENTORY_DATA" "DSOURCE_USAGE_DATA" "DSOURCE_CONSUMPTION_DATA" "MASKING_EXECUTION_METRICS" "AUDIT_LOGS_SUMMARY" "STORAGE_SAVINGS_SUMMARY" "DATA_RISK_SUMMARY" |
cron_expression required | string Standard cron expressions are supported e.g. 0 15 10 L * ? - Schedule at 10:15 AM on the last day of every month, 0 0 2 ? * Mon-Fri - Schedule at 2:00 AM every Monday, Tuesday, Wednesday, Thursday and Friday. For more details kindly refer- "http://www.quartz-scheduler.org/documentation/" |
time_zone | string Timezones are specified according to the Olson tzinfo database - "https://en.wikipedia.org/wiki/List_of_tz_database_time_zones". |
message required | string |
file_format required | string Value: "CSV" |
enabled required | boolean Default: true |
recipients required | Array of strings <email> non-empty unique |
Array of objects (Tag) | |
sort_column | string Enum: "engine_id" "engine_name" "engine_hostname" "total_capacity" "free_storage" "used_storage" "used_percentage" "dsource_count" "vdb_count" "total_object_count" "name" "unvirtualized_space" "actual_space" "dependant_vdbs" "type" "version" "parent_id" "parent_name" "creation_date" "parent_timeflow_location" "parent_timeflow_timestamp" "parent_timeflow_timezone" "enabled" "status" "connector_id" "connector_name" "connector_type" "last_profiled_date" "last_masked_date" "is_profiled" "is_sensitive_data" "is_masked" "is_at_risk" "data_elements_total" "data_elements_not_sensitive" "data_elements_sensitive_masked" "data_elements_sensitive_unmasked" "records_total" "records_not_sensitive" "records_sensitive_masked" "records_sensitive_unmasked" "-engine_id" "-engine_name" "-engine_hostname" "-total_capacity" "-free_storage" "-used_storage" "-used_percentage" "-dsource_count" "-vdb_count" "-total_object_count" "-unvirtualized_space" "-actual_space" "-dependant_vdbs" "-name" "-type" "-version" "-parent_id" "-parent_name" "-creation_date" "-parent_timeflow_location" "-parent_timeflow_timestamp" "-parent_timeflow_timezone" "-enabled" "-status" "-connector_id" "-connector_name" "-connector_type" "-last_profiled_date" "-last_masked_date" "-is_profiled" "-is_sensitive_data" "-is_masked" "-is_at_risk" "-data_elements_total" "-data_elements_not_sensitive" "-data_elements_sensitive_masked" "-data_elements_sensitive_unmasked" "-records_total" "-records_not_sensitive" "-records_sensitive_masked" "-records_sensitive_unmasked" |
row_count | integer >= 1 |
OK
{- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
{- "report_id": 123,
- "report_type": "VIRTUALIZATION_STORAGE_SUMMARY",
- "cron_expression": "0 0 2 ? * Mon-Fri",
- "time_zone": "America/Los_Angeles",
- "message": "sample message",
- "file_format": "CSV",
- "enabled": true,
- "recipients": [
- "user@example.com"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "sort_column": "engine_name",
- "row_count": 1
}
The parameters to delete tags
No Content
Delete all tags for given object - No request body required
{ }
Returns a list of performance analytics data of engines.
{- "items": [
- {
- "engine_name": "string",
- "engine_id": "string",
- "engine_type": "VIRTUALIZATION",
- "aggregation_period": 0,
- "cpu_cores_count": 0,
- "cpu_utilization": 0,
- "total_memory": 0,
- "average_disk_latency_read": 0,
- "average_disk_latency_write": 0,
- "average_disk_latency_total": 0,
- "average_disk_throughput_read": 0,
- "average_disk_throughput_write": 0,
- "average_disk_throughput_total": 0,
- "average_disk_iops_read": 0,
- "average_disk_iops_write": 0,
- "average_disk_iops_total": 0,
- "average_nfs_latency_read": 0,
- "average_nfs_latency_write": 0,
- "average_nfs_latency_total": 0,
- "average_nfs_throughput_read": 0,
- "average_nfs_throughput_write": 0,
- "average_nfs_throughput_total": 0,
- "average_nfs_iops_read": 0,
- "average_nfs_iops_write": 0,
- "average_nfs_iops_total": 0,
- "average_iscsi_latency_read": 0,
- "average_iscsi_latency_write": 0,
- "average_iscsi_latency_total": 0,
- "average_iscsi_throughput_read": 0,
- "average_iscsi_throughput_write": 0,
- "average_iscsi_throughput_total": 0,
- "average_iscsi_iops_read": 0,
- "average_iscsi_iops_write": 0,
- "average_iscsi_iops_total": 0,
- "average_network_throughput_transmit": 0,
- "average_network_throughput_receive": 0
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of performance analytics data of engines.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "engine_name": "string",
- "engine_id": "string",
- "engine_type": "VIRTUALIZATION",
- "aggregation_period": 0,
- "cpu_cores_count": 0,
- "cpu_utilization": 0,
- "total_memory": 0,
- "average_disk_latency_read": 0,
- "average_disk_latency_write": 0,
- "average_disk_latency_total": 0,
- "average_disk_throughput_read": 0,
- "average_disk_throughput_write": 0,
- "average_disk_throughput_total": 0,
- "average_disk_iops_read": 0,
- "average_disk_iops_write": 0,
- "average_disk_iops_total": 0,
- "average_nfs_latency_read": 0,
- "average_nfs_latency_write": 0,
- "average_nfs_latency_total": 0,
- "average_nfs_throughput_read": 0,
- "average_nfs_throughput_write": 0,
- "average_nfs_throughput_total": 0,
- "average_nfs_iops_read": 0,
- "average_nfs_iops_write": 0,
- "average_nfs_iops_total": 0,
- "average_iscsi_latency_read": 0,
- "average_iscsi_latency_write": 0,
- "average_iscsi_latency_total": 0,
- "average_iscsi_throughput_read": 0,
- "average_iscsi_throughput_write": 0,
- "average_iscsi_throughput_total": 0,
- "average_iscsi_iops_read": 0,
- "average_iscsi_iops_write": 0,
- "average_iscsi_iops_total": 0,
- "average_network_throughput_transmit": 0,
- "average_network_throughput_receive": 0
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
Returns a list of performance analytic trends data of engines.
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "trend_type": "CPU_UTILIZATION",
- "engine_id": "string",
- "aggregation_period": 6,
- "datapoint": [
- {
- "data": 0,
- "time": "2019-08-24T14:15:22Z"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "api_version": "1.0.0",
- "product_version": "1.0.0",
- "system_uuid": "string",
- "product_upgrade_history": [
- {
- "version": "1.0.0",
- "installed_on": "2022-05-22T09:15:30.000Z"
}
], - "supported_api_versions": [
- "string"
], - "deployment_mode": "string"
}